Course Details

1. Identify and examine the basic functionality of Microsoft Excel.
2. Use and apply functions from Microsoft Excel to solve accounting-related problems.
3. Use and apply functions from Microsoft Excel to predict financial scenarios.
4. Construct data tables and analyze data.
5. Construct pivot tables and consolidate data.
6. Design and develop charts and graphs for data presentation.

Introduction to Microsoft Excel and the concept of spreadsheets

Explain basic functionality of Microsoft Excel

Basic Functions in Microsoft Excel

Use basic functions in Microsoft Excel

SUM, AVERAGE, MIN, MAX

Formatting cells & creating charts in Microsoft Excel

Use cell formatting

Create charts

Advanced Functions in Microsoft Excel

Use advanced functions in Microsoft Excel

IF, LOOKUP

Working with Multiple Excel Worksheets

Consolidation of data

Pivot Tables

Cash Budgets

Conduct Excel exercises for calculating cash budgets

Forecast Trading

Conduct Excel exercises for forecast trading

PV, FV, NPV

Final Accounts

Conduct Excel exercises for profit and loss statement and balance sheet and other financial reports

              PMT, IPMT, PPMT

• Winston, W.L. (2008). Microsoft Excel 2010 Data Analysis & Business Modelling. Microsoft.

• Tutorials on Excel on the Internet: http://office.microsoft.com/training/training.aspx?AssetID=RC100620751032