This is an 8 hour course, delivered online @ 4 hours / day across 2 days. Participants will learn the workng of MS Excel, application in day-to-day work life and how they can improve their productivity by using MS Excel.

• You'll acquire a highly impressive data analysis skills, including What-If Scenarios, PivotTables, PivotCharts, HLOOKUPs, VLOOKUPs and basic Macros
• What-If Analysis - Exploring Scenarios - Goal Seek and Data Tables - Using Solver
• Grouping & Outlining and Subtotals - Outlining and Grouping Data - Using the Subtotals Tool
• PivotTables - Getting Started with PivotTables - Displaying Data in a PivotTable - Formatting a PivotTable - Using the Classic PivotTable Layout
• Charting Pivoted Data - Getting Started with PivotCharts - Using the PivotChart Tools Tabs - Formatting a PivotChart
• Advanced Excel Tasks - Excel and Hyperlinks - Using Custom AutoFill Lists
• HLOOKUP and VLOOKUP Functions - Using the VLOOKUP Function - Using the many other Excel Functions
• Introduction to Macros in Excel - Recording and Playing Macros - Copying and Deleting Macros - Visual Basic and Macros