AI summary of reviews

Practical, interactive learning stands out: attendees value clear, approachable trainers who break down complex formulas and adapt explanations to different abilities and questions. The course combines demonstrations, realistic examples and independent exercises, with a well-organised structure and generally manageable pace. Reviewers say the skills, shortcuts and functions build confidence and transfer directly to everyday work. Some would welcome more time for advanced topics, but the training leaves them keen to continue developing their Excel skills.

Practical exercisesClear explanationsWorkplace application

Generated from recent reviews; may not reflect every review

About this course

This Advanced Excel Skills course provides Excel users with advance spreadsheet solutions to common data analysis challenges. Providing users with hands-on practise analysing and automating useful spreadsheet tasks. Nesting functions is a significant part of this training day where you will get significant practise in nesting Excel functions.

What you will learn

  • Performing spreadsheet calculations using Date & Time
  • Using Data Validation to control the input of data
  • Finding data using VLOOKUP and INDEX & MATCH
  • Nesting Logical Functions – IF, AND, OR, ISERROR
  • Analysing data with advance use of Pivot Tables
  • Automating repetitive tasks with macros – VBA

Course video

Recent reviews

View all 766 reviews →

Further information

Enquire about this course