Overview 

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

Course Contains 

• 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 .  

Learning Method 

• Self-paced / Online course, online Assignments based on real life scenarios.  

Certification 

• On successful completion, participants will receive a certificate from Acecom Skills