Microsoft Excel Intermediate Courses
One-day Instructor Excel Training Course.svg/250px-Microsoft_Office_Excel_(2025%E2%80%93present).svg.png)
Instructor-Led Excel Training
Excel Intermediate
Training with an expert
A hands-on, one-day Excel course for existing users: delivered at your premises, remotely or at our UK classrooms, and tailored to how your team works.
20+ yearsTraining experience
Level 2 of 3Improvers
UK-wideOn-site, remote or classroom
Meet Aedan, a member of the Marketing Team
Take your Excel skills further
This one-day instructor-led course is designed to develop the practical skills of existing Excel users.
By the end of the course delegates will be able to use a much greater range of Excel functions and tools to produce more effective spreadsheets, and to work confidently with large sets of data.
- Use advanced formulas and functions
- Define names for cells and ranges
- Use Excel’s database tools
- Work effectively with large spreadsheets
ƒx
IF & XLOOKUP
Master IF functions, XLOOKUP and nested functions.
🔍
Sorting & Filtering
Sort, filter and subtotal large sets of data.
🔗
Linking & Protecting
Link workbooks and apps, name ranges and protect cells.
🎨
Smart Formatting
Conditional formatting, grouping and hiding data.
Courses & Fees
One day, two ways to book
Have our trainer visit your premises, or book individual places on a scheduled public course.
Most Popular
In-House
At Your Premises
£545 + VAT
One-day onsite · up to 4 people
- Instructor-led at your location
- Additional attendees £35 + VAT each
- Printed materials & trainer travel included
- About £75 + VAT per person when 10 attend
Public Course
Classroom Place
£225 + VAT
One-day classroom · per delegate
- Preston, Liverpool, Manchester & London
- Small groups with 1-to-1 support
- Reference manual & certificate included
Before you attend
This course is designed for delegates who have completed the Excel Introduction course or have equivalent knowledge. Attendees should already be able to create formulas, use basic functions such as SUM, MIN, MAX and COUNT, and know the difference between relative and absolute references.
*Public course prices are per delegate. Book 2 or more delegates on the same course and receive significant discounts. Course tailoring for onsite courses is available for a small additional fee.
What’s covered
A practical day, step by step
This one-day course develops the practical skills of Excel users across four modules.
1. Functions
- IF functions
- XLOOKUP (replaces VLOOKUP & HLOOKUP)
- Combining data from multiple cells
- Data & nested functions
2. Tools
- Naming cells and ranges
- Protecting cells
- Linking workbooks
- Linking Excel with Word or PowerPoint
3. Database Tools
- Sorting, including custom sequences
- AutoFilter & advanced filters
- Data forms to enter, delete & search
- Subtotals for sub sets of data
4. Formatting
- Hiding columns, rows and formulas
- Grouping columns and rows
- Conditional number formatting
Every course includes
More than just a training day
Tailored Content
Built around your team’s real workplace scenarios
Expert Trainers
Instructor-led, at the pace of your attendees
Reference Materials
Handouts and supporting materials for every attendee
Certificates
Course completion certificate for each attendee
Free Aftercare
Post-course telephone & email support
Course levels
Not sure this is the right level?
Download our free pre-course evaluation form (PDF) and a member of our team will recommend the right level for each attendee, or explore the other levels below.
Ready to get your team Excel-confident?
View upcoming scheduled dates, or speak with a training advisor to arrange a tailored course for your team.
Or call us on 0345 450 0051 to speak with a training advisor today.