+44 (0) 2080 049141info@londonittraining.co.uk

LONDON IT TRAINING

Find your next course

Explore our training courses by subject, skill or certification.

All courses

Classroom · Live online · Training for teamsFind the right course for your next step.
  1. Home
  2. »
  3. Microsoft Excel Advanced
Instructor-led training
Microsoft Excel Advanced Training in London and Live Online

Microsoft Excel Advanced

Develop robust Excel models and repeatable analytical workflows. Explore advanced formulas, Power Query, data modelling, scenario analysis and dashboard quality controls.

Request Course Information
Price:
Price on request

Contact us for current fees, dates and exam arrangements.

Advanced

Intermediate Excel skills, including lookups, tables and PivotTables.

5 days to complete
Available online
& in class

Select your preferred method

Course overview
Course dates
  • In Classroom
  • Live Virtual
  • 1 - 1 Training
  • Corporate Training
  • Onsite Training
Introduction
Develop robust Excel models and repeatable analytical workflows. Explore advanced formulas, Power Query, data modelling, scenario analysis and dashboard quality controls.


This instructor-led course combines clear explanations with guided exercises and practical scenarios. Work through examples relevant to the subject, review alternative approaches and practise checking your results rather than relying on a demonstration alone.
You will develop a structured approach to implementation, troubleshooting and documentation. The trainer can adapt examples to the agreed learning needs and available training environment. Confirm the course duration, software or lab requirements, delivery arrangements and fees with London IT Training before booking.
This is professional development training. It does not automatically award a third-party vendor certification.
What the course covers
Flexible Ways to Learn

Study your way with flexible learning options designed to fit around your schedule.

Small Groups

With small groups of students, our instructors can work closely with each student

Flexible Class Schedules

Our class schedules are flexible on weekdays, weekend or evening to suit your schedule.

Experienced Instructors

Our instructors follow a modified and personalised approach to engage students during class

Hi-Tech lab Facilities

Lab arrangements vary by course. Confirm access and equipment requirements before booking.

Prerequisites
What you’ll gain

Apply advanced formula design in a practical course exercise.

Apply power query transformations in a practical course exercise.

Apply data models and relationships in a practical course exercise.

Apply scenario and sensitivity analysis in a practical course exercise.

Develop skills for your next step
Relevant career pathways
Business Support Professional:

Create accurate documents, reports and communications for workplace tasks.

Team Coordinator:

Organise information and support consistent collaboration across a team.

Syllabus

Course context and practical foundations
Review the course objectives and relevant concepts. Set up a suitable training environment, identify a realistic example and agree how to validate the results.

Use dynamic arrays and reusable formula structures where supported. Reduce fragile calculations and make dependencies easier to audit.

Import, clean, merge and reshape sample data. Document refresh requirements and handle schema or data-quality changes.

Build a small relational model, distinguish dimensions from measures and validate relationships before reporting.

Separate assumptions from calculations. Compare scenarios and test how changes affect model outputs.

Create focused interactive summaries with suitable charts and controls. Keep context, units and filter state visible.

Trace errors, reconcile results and document refresh and ownership. Assess when a database or BI tool is more appropriate.

Complete an integrated exercise using sample data or an isolated training environment. Test the result, document decisions and troubleshooting steps, and identify improvements and next learning objectives.

1
2
3
4
5
6
7

FAQs

Who is this course for?
Develop robust Excel models and repeatable analytical workflows. Explore advanced formulas, Power Query, data modelling, scenario analysis and dashboard quality controls.

Intermediate Excel skills, including lookups, tables and PivotTables.

Advanced formula design; Power Query transformations; Data models and relationships; Scenario and sensitivity analysis; Dashboard design; Model auditing and maintenance.

No. This is professional development training. It does not automatically award a third-party vendor certification.

Contact London IT Training to discuss classroom, live online and corporate delivery arrangements.

Contact the training team for current duration, available dates, fees and software or lab requirements. Do not assume that licences, materials or examination fees are included.

Need help choosing the right course?

Talk to one of our advisers about dates, delivery options and certification routes. We’ll call you back within 1 working day.

LONDON IT TRAINING

Let’s plan
your next step.

Tell us what you would like to learn.

  • Course guidance
  • Dates and delivery
  • Training for teams

Your details are used to respond to your enquiry. Privacy Policy