Excel - Masterclass - Data Analysis

This course is for those who are familiar with Excel and wish to develop their use of the powerful data analysis features of the software to produce useful information for the business or home environment.

The course covers: Using Goal seek to perform what-if? analysis;Using the Scenario Manager to evaluate the impact of different situations; Structuring data for PivotTable analysis; Creating & formatting PivotTables & PivotChart; Techniques for summarising data

Course requirements: Participants should be familiar with Excel and be a able to use some of the basic functions - Sum, Average, Count, Min and Max.