Special Notices

To view upcoming sessions and book click here >

Shorter bite-size virtual sessions are available on key topics from this course. Please contact us for further details.


In this course you will you will extend your knowledge using some of the more specialised and advanced capabilities of Excel by automating some common tasks, applying advanced analysis techniques to more complex data sets such as PivotTables and collaborating on worksheets with others.

Target Audience

This course is aimed at end users who want to develop their skills so they can use advanced techniques to manipulate Excel data. Delegates should have attended QA's Excel 2016 Intermediate course or have equivalent knowledge.


  • Create, edit and format spreadsheets
  • Navigate within worksheets and books
  • Use Insert Function to create built-in functions
  • Work with absolute references
  • Create named ranges
  • Create Tables within Excel
  • Sort and filter data

Learning Outcomes

  • Create macros to automate common tasks
  • Collaborate with others by tracking changes in workbooks
  • Create and manipulate PivotTables and Pivot Charts
  • Use advanced techniques to analyse data
  • Work with data validation tools

Course Outline

Module 1: Creating a Macro

  • Creating a Macro
  • Comparing Relative and Absolute Macros
  • Running a Macro
  • Editing a Macro
  • Assigning Shortcuts to Macros

Module 2 - Collaborating With Others

  • Protection
  • Track Changes

Module 3 - Creating PivotTables, PivotCharts and Slicers

  • Creating a PivotTable
  • Amending and Updating Fields
  • Adding Calculations and Grouping
  • Creating a PivotChart
  • Using Slicers and Timelines

Module 4 - Analysing Data

  • Creating Scenarios
  • Using Goal Seek
  • Linking to External Workbooks

Module 5 - Data Validation

  • Number Validation
  • Message Prompts and Alerts

Sorry, we don't have any available dates! Please complete this form to be notified about new dates

Hide form
Please type in a preferred location or region...

Your course has been added to your basket

Proceed to checkout Continue shopping