Master In Excel (For Finance Professionals)
Microsoft Excel is the most commonly used office application in accounting and finance.
From financial projections to financial reporting almost all the essential functions are now a days excel based.
Who should Attend
Commerce Graduates / PG, MBA etc. who are perusing for career in Accounting & Finance.
Finance & Accounts executives working in the industry at executive or managerial levels seeking career advancement through skills development.
Course Duration- 5Hrs
- Basic Concepts- Formulas, Relative & Absolute References.
- Most commonly used Functions- Financial, Data & Time, Logical, Lookup etc.
- Importing or Connecting Data from various sources.
- Data manipulation- Filter, Sort, Group etc.
- Data Presentation & Visualization- Charts, Conditional Formatting, Pivot Tables.
- Practical cases studies- Financial Modeling, Payroll Processing, Dashboards .
The course will help you:-
- To gain learn all the basic features of Excel that are essential for accounting & Finance Professionals.
- To get practical hand on experience of real life usage of Excel .
- Self-paced / Online course, online Assignments based on real life scenarios.
- On successful completion, participants will receive a certificate from Acecom Skills