Microsoft Office Series:

Business Analysis Using Advanced Microsoft Excel (ADVEXCEL)

Business Analysis Using Advanced Microsoft Excel is a 16-hour course that teaches participants how to use the Microsoft Excel at advanced level. Participants will gain the necessary practical experience by using hands-on exercises simulating real life business analysis scenarios.

Target Audience

All professionals required to use Microsoft Excel for Accounting and Business Analysis in their daily job functions.

 

Prerequisites

Participants must have a basic understanding of computers and using Excel in Microsoft Windows environment.

 

 

Topics

 

  • Cash Budget.
  • Cash Forecasting.
  • Loan Payment Schedule.
  • Break-even Analysis and Charts.

 

 

  • What-if Problems.
  • Solving Simple Problems.
  • Using Goal Seek.
  • Solving Complex Problems.

 

 

  • Scenario Manager.
  • Worksheet Functions.
  • Analysis Functions.
  • Simple Macros.