Microsoft Excel 2013 – Advanced


1 day

Pre Requisites

Delegates should first attend the Microsoft Excel Intermediate course or have attained a similar level of expertise.


By the end of this one day course delegates will feel confident in their ability to use the more advanced features of Excel including lookup tables, advanced formulae, PivotTables and macros.

Other Versions Available

2007, 2010

Further Learning

Excel with PowerPivot

Excel VBA

Course Content

Advanced Functions

  • Multiple conditions
  • Lookup Tables
  • Text Functions

Outlining and Views

  • Outlining a Worksheet
  • Creating Custom Views

Controlling Data Input

  • Data Validation

Advanced Filtering

  • Text to Columns
  • Advanced Filtering


  • Creating PivotTables
  • Formatting the Pivot Table
  • Using Slicers
  • Adding a Timeline
  • Calculations in PivotTables
  • Grouping & Ungrouping
  • Creating a PivotChart
  • Create PivotTables based on Multiple Tables


  • Recording a Macro
  • Viewing Macros
  • Adding a Macro to the Ribbon
  • Assigning a Macros to an Object
  • Accessing the Developer Tab
  • Macro Security Settings

What-If Analysis (time permitting)

  • Goal Seek
  • Data Tables
  • Scenarios