Advanced Excel

Start date: 24 June 2019

Location: Boyle Enterprise Centre

Cost: €40

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.