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

Master advanced Excel features like Pivot Tables, Power Query, and advanced formulas.

By Build Your Skill I.T Training

Date and time

Location

Build Your Skill I.T Training - Perth Airport

62A Buccaneer Way Perth PH2 6PL United Kingdom

Refund Policy

Refunds up to 7 days before event.

About this event

Event lasts 6 hours 30 minutes

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.

Frequently asked questions

Do I need a laptop?

Yes. You’ll need your own laptop or PC with Microsoft 365 Excel installed and up to date.

Will I receive course materials?

Yes. You’ll receive a digital workbook and example exercises to download and keep.

How do I join the session?

The course will be delivered via Microsoft Teams. You’ll receive a joining link by email before the session.

Do I need a webcam or microphone?

A microphone is recommended so you can ask questions. A webcam is optional.

What if I have questions after the course?

You’ll receive free email support after the course for any follow-up queries.

Organized by

Build Your Skill I.T Training

Build Your Skill provides expert-led IT training in Microsoft 365, Excel, and Power BI. We deliver practical, hands-on courses in-person at Perth Airport or online via Teams.

£165Oct 15 · 9:30 AM GMT+1