Microsoft Excel | Advanced – Full Day Online Course (Perth, Scotland)

This advanced course is ideal for confident Excel users who want to unlock its full potential.

Learn powerful tools to clean, transform, and analyse large datasets efficiently.

What You’ll Learn

· Advanced functions like XLOOKUP and nested IF statements

· Creating and customising Pivot Tables

· Getting started with Power Query for data transformation

· Using named ranges and dynamic arrays

· Tips for troubleshooting and efficiency

Who Should Attend?

· Experienced Excel users who want to deepen their skills

· Analysts, finance staff, and managers working with complex or large datasets

· Professionals who prefer online learning or live outside the Perthshire area

Venue

· Not applicable for online course

What’s Included

· Live expert-led training

· Digital workbook and example exercises

· Certificate of attendance

· Free post-course support by email

Your Trainer

Your session is led by an experienced IT trainer who specialises in making Microsoft applications clear, friendly, and relevant – whether you're a complete beginner or ready to advance your skills.