Excel Level 2


One Day

Suitable for

This course is for anyone who wants to gain an advanced skill set necessary for calculating data using functions and formulas, sorting and filtering data, creating PivotTables to analyse data and customising workbooks.


You will use advanced formulas and work with various tools to analyse data in spreadsheets. You will also organise table data, present data as charts and enhance the look and appeal of workbooks by adding graphical objects.


Lesson One – Calculating Data with Advanced Formulas

  • Apply Cell and Range Names
  • Calculate Data across Worksheets
  • Use Specialised Functions
    • Concatenate, Proper, Left and Right
  • Analyse Data with Logical and Lookup Functions
    • If, SumIf, CountIf and Vlookup

Lesson Two – Organising Worksheet and Table Data

  • Create and Modify Tables
  • Format Tables
  • Sort and or Filter Data
  • Use Functions to Calculate Data

Lesson Three – Presenting Data using Charts

  • Create a Chart
  • Modify a Chart
  • Format a Chart

Lesson Four - Analysing Data using PivotTables, Slicers and PivotCharts

  • Create a PivotTable Report
  • Filter Data using Slicers
  • Analyse Data using PivotCharts

Lesson Five – Inserting Graphical Objects

  • Insert and Modify Images
  • Draw and Modify Shapes
  • Illustrate Workflow using SmartArt Graphics
  • Layer and Group Graphical Objects

Lesson Six – Customising and Enhancing the Excel Environment

  • Customise the Excel Environment
  • Customise Workbooks
  • Manage Themes
  • Create and Use a Template

Duration (in days)


Show the next months in

Location Dates Price exc. VAT   Status
Please call us for the next available date for this course. Dates are added regularly and may not appear on this list. Tel: 020 7256 6668