Microsoft Excel Intermediate

Microsoft Applications

Find out more

Download PDF copy

Course Code: XL19L2

Duration: 1 Day


This Microsoft Excel Intermediate course is aimed at people who want to expand their knowledge of Microsoft Excel to work with larger spreadsheets, create formulas across multiple worksheets and workbooks, manage tables of data, and use advanced formatting techniques.


Students who wish to attend this course must have knowledge of Excel and feel comfortable with creating, formatting, and editing spreadsheets. They should be able to write formulas using multiplication, addition, subtraction, division and use the basic functions, sum, average, max, min and count.


On completion of this course delegates will be able to:


Introduction and Objectives

Working with Multiple Worksheets

Using Multiple Workbooks

Using Paste Special Flash Fill

Custom Views

Using Conditional & Custom Formatting

Manipulating Text

Working with Excel Data Tables

Working with Advanced Filters

Creating Subtotals in a List

Working with Outlines

Action Planning

Review of Programme

Download PDF copy

Excel Frequently Asked Questions


Dedicated Courses

Virtual - £645 per day for up to 8 delegates

Onsite - £695 per day for up to 10 delegates

Public Schedule Courses - £150 per delegate


Onsite prices are for courses in London. For other locations, trainer expenses will apply.

All prices displayed are exclusive of VAT.

Apply for this course

Leave us your email address and phone number and one of our team will be in touch to find out a bit more about you and discuss next steps.

Thank you, we'll get in touch
Oops! Something went wrong while submitting the form. Please try again or give us a call.