LONDON IT TRAINING

Find your next course

Explore our training courses by subject, skill or certification.

All courses

  1. Home
  2. »
  3. Microsoft Excel Intermediate
Instructor-led training
Microsoft Excel Intermediate Training in London and Live Online

Microsoft Excel Intermediate

Analyse and manage workplace data with Microsoft Excel. Develop reliable formulas, lookups, tables, PivotTables and charts while improving spreadsheet accuracy.

Request Course Information
Price:
Price on request

Contact us for current fees, dates and exam arrangements.

Intermediate

Comfort with basic Excel formulas, formatting, sorting and filtering.

5 days to complete
Available online
& in class

Select your preferred method

Course dates
Introduction
Analyse and manage workplace data with Microsoft Excel. Develop reliable formulas, lookups, tables, PivotTables and charts while improving spreadsheet accuracy.


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.
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.

What you’ll gain

Apply logical and conditional formulas in a practical course exercise.

Apply lookups and reference handling in a practical course exercise.

Apply tables and data validation in a practical course exercise.

Apply data cleaning and preparation 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 conditional calculations and aggregations. Test formula behaviour on missing, unexpected and boundary values.

Retrieve related information with suitable lookup functions. Check matching behaviour and handle missing records explicitly.

Build structured tables, constrain inputs and maintain consistent column definitions as data grows.

Standardise text, dates and categories. Identify duplicates and document assumptions before analysing a dataset.

Summarise data by meaningful categories, group results and compare trends. Refresh and validate the source range.

Combine formulas, PivotTables and charts in a readable report. Check totals, filters and interpretations before distribution.

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.

FAQs

Who is this course for?
Analyse and manage workplace data with Microsoft Excel. Develop reliable formulas, lookups, tables, PivotTables and charts while improving spreadsheet accuracy.

Comfort with basic Excel formulas, formatting, sorting and filtering.

Logical and conditional formulas; Lookups and reference handling; Tables and data validation; Data cleaning and preparation; PivotTables and analysis; Charts and reporting.

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.

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