Learn advanced Excel skills to make you an Excel Superhero

Become an Excel superhero. Learn the skills to find the solution to any Excel problem.

This course starts with the basics of formulas and managing spreadsheets and quickly moves to advanced Excel techniques required for creating powerful, dynamic and visually appealing spreadsheets.

It covers;

New Excel 2013 features such as Flash Fill, chart filters and the internal data model.
Using PivotTables to summarise large amounts of data.
Over 30 different Excel functions to handle any problem including INDEX, VLOOKUP, LEN, MID, IF, MATCH, and INDIRECT.
Visualising results with charts.
Conditional Formatting to highlight data comparisons, progress and issues.
An introduction to the PowerPivot, DAX formulas and Power View features of Excel 2013.