Advanced Excel

Start date: 26 March 2019

Location: Boyle Enterprise Centre

Cost: €40

Programme overview

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.