Information workers using Excel in daily work processes. Basic experience with Excel including creating workbooks, navigating worksheets, columns and rows and using basic functions such as SUM, AVERAGE will be expected from the audience.
Participants will have the knowledge and application skills in using a spreadsheet application at an advanced level. The skills include maintaining complex spreadsheets, using complicated functions of various types, and using auditing techniques to check for errors.
Module 1: Advanced Formatting
Module 2: Advanced Functions and Formulas
Module 3: Data Analysis using Pivot Tables and Business Intelligence
Module 4: Workbook Management Features
Module 5: Advanced Charts, Functions and What-If Analysis
Module 6: Data Filtering, Macros and Forms