Advanced Excel

Start date: 15 June 2021

Location: Online Webinar

Cost: FREE

Course Aim

This course is designed for those with a strong working knowledge of Excel who wish to become more proficient.

Course Content

  • Conditional Formatting
  • Advanced Formulae & Functions
  • Auditing Formulae
  • What-If Analysis
  • Working with Advanced Filters
  • Consolidating Data
  • Working with Pivot Tables
  • Data Entry Validation
  • Macros
  • Power Query

Course Objective

To create complex models involving multiple linked Excel spreadsheets and files, analysing data using what ifs and scenarios, validating and auditing data and automating commonly used features with macros.