Excel Training Course Level 2 UK Wide - On-site and Online

Intermediate Microsoft Excel Training Course

This intermediate Excel training course is a closed event and offers a flexible range of subjects enabling you to focus upon the particular skill-sets you need the most for using Excel in the workplace. The duration of the course ranges from one to two days depending upon the learning needs of your staff.

On this Microsoft Excel course you can learn some of the more powerful features of Excel such as statistical functions, conditional formatting, logical IF functions and the VLOOKUP function (or XLOOKUP for 365 users), and working with references, ranges and Excel workbook security.

Our private Excel courses cost £450.00 plus VAT p/d inclusive up to 3 learners. Add more people at £50.00 plus VAT p/d up to a limit of 10. Trainer mileage costs apply for on-site courses.

For Excel 365 you can even learn about AI enhancements to Excel spreadsheets, creating data from photos with image recognition, using Excel for intuitive insights and forecasting and even using Copilot to help create your formulas. You will be able to decide upon the exact topics taught in liaison with your trainer and even opt to incorporate a few subjects from the beginners or advanced level for a more blended learning solution.

Our expert trainers come to you and can deliver this Microsoft Excel Intermediate course at your premises across most regions of mainland UK (including East Midlands and West Midlands, Greater Manchester and the North West, Yorkshire, Greater London, East Anglia, Bristol area, South East and South West of England etc.), or virtually from anywhere.

Microsoft Excel versions available for training include: Excel 365, Excel 2024, Excel 2021 and Excel 2019.

Microsoft Excel Intermediate Training Course Prerequisites

In order to attend this course you should already have basic Microsoft Excel skills and knowledge equivalent to our Microsoft Excel Beginners training course.

On-site Microsoft Excel Intermediate Courses in the United Kingdom

Our closed courses for Microsoft Excel are delivered as private classes for your learners offering more flexibility than off-the-shelf courses and topics can often be tailored to meet your particular learning needs.

Excel is one of the most powerful and useful traditional Microsoft Office apps, but also often one with which people can struggle most, and that they find the most frustrating to work with. In fact, having staff who are confident and proficient with MS Excel doesn't only increase productivity and efficiency, it can even be good for morale.

Our trainers know that helping students to work more effectively isn't just a business goal, it's also empowering. They aren't just educators, they're also software champions who promote enthusiastic adoption of Excel amongst their trainees. Before the start date they'll discuss your team's training goals with you, whether they're setting off as novice, intermediate or advanced users.

Our Regional Trainers Come to You

With our on-site Microsoft Excel Intermediate courses our regional Excel trainers come to your workplace throughout England, bringing the training to you whether you're in a major city such as London, Manchester, Birmingham or Leeds, or anywhere else.

This offers a cost-effective way to train small groups and entire departments in the comfort of familiar surroundings from the Capital City of London to The Cotswolds, from Nottinghamshire to Northamptonshire, West Midlands to West Yorkshire, Sussex to South Yorkshire, Norfolk to Northumberland, Lancashire to Lincolnshire, Cambridgeshire to Gloucestershire, Bristol to Berkshire, Essex to the East Riding of Yorkshire and everywhere inbetween.

Virtual Classroom Training Excel Intermediate Courses - UK & Beyond

If you'd rather that your team learns remotely, these small-group Microsoft Excel courses are also available as live virtual, interactive sessions from the comfort of your own office or workplace. These instructor-led courses are taught via MS Teams video conferencing.

Why choose virtual learning? As we've all become used to Online learning (and live virtual meetings) it is clear that virtual classroom delivery has some advantages over traditional face-to-face learning.

If you're looking for local training, then you can't get closer to your doorstep than you can with virtual learning.

Our virtual learning Microsoft Excel courses cater for classes of up to 10 and your learners benefit from full and immersive interaction with the trainer just as if they were in the classroom with you, with engaging hands-on training via advanced live video conferencing that is enriched by features such as live chat, private chat, and sharing screens and documents.

Our virtual classroom Microsoft Excel courses cost £550.00 plus VAT p/day inclusive up to 5 delegates. More learners can be added up to a limit of 10 charged at £50.00 plus VAT per person p/day. Courseware will be provided electronically.

Do you Record your Live Virtual Microsoft Excel Intermediate Courses?

In our experience recording live Excel courses delivered via MS Teams isn't necessarily a great idea. Problems include recordings failing due to live Teams updates and also client bandwidth issues caused by streaming meetings and recording simultaneously. In order to avoid disruptions, our instructors do not record our live virtual Microsoft Excel Intermediate courses.

We really ❤ helping UK organisations to master Microsoft Excel. Our only question is: Will it be yours?

Commercial and Corporate Excel Courses for the Public and Private Sectors

How Many People Should Attend Our Private Microsoft Excel Intermediate Courses?

Whilst the number of people who attend our private Microsoft Excel courses is essentially up to you and depends on the number of learners you have (up to our ten per course limit), we encourage clients to keep class sizes small. This provides a more personable and effective learning experience and allows the trainer to give individual attention to every student.

What is the Teaching Method for Our Microsoft Excel Intermediate Courses?

The teaching methodology for our Excel courses is Instructor-led training (ILT), meaning that our courses are engaging, immersive, hands-on and interactive. With this participatory learning method your staff will retain information better, whether they're studying Excel in-person or via live virtual classroom.

And, whilst we're happy to provide lectures, show-and-tells and drop-in surgeries, the ILT approach is by far the most reliable way to bring your Excel know-how to life in a small-class-size setting.

How Long are Our Microsoft Excel Intermediate Courses?

Usual teaching hours are 9.30AM to 4.30PM with a lunch hour and short breaks morning and afternoon. This timetable is fairly standard across the industry and gives six hours of hands-on Excel learning, which is an optimal day's training for comfortably absorbing and retaining information and completing practice exercises.

If you want a different start time for your course please let us know.

Courses are run week days, during normal business hours.

Why Choose Our Excel Courses?

• Step-by-Step Courses: Instructor-led Intermediate Excel training provided in-person with engaging step-by-step demos, lessons and hands-on exercises.
  
  
• Q&A Courses: Dynamic and interactive Excel courses with ample time for questions and answers.
  
  
• Flexible Courses: Expert tuition, tailored to your team's knowledge level and learning needs, and covering the Excel skills that your trainees need most.
  
  
• Small Class Sizes: Private, corporate Intermediate Excel training with a limit of 10 participants to ensure personalised attention.
  
  
• Scalable Courses: Can be run as one or more courses, or as a training rollout bringing entire departments and organisations up to the benchmark of Excel knowledge and confidence needed.

Intermediate Excel Training Course Outline

You can combine Beginners, Intermediate and Advanced Excel topics for a blended training programme of up to four days in duration.

Actual course content may vary, depending upon your learning requirements.

Note: For Excel 365 Users VLOOKUP topics (Day 2, Module 1) can be replaced with XLOOKUP.

Day One

• Module 1: Creating Custom Number and Date Formats
  1. Applying Conditional Formatting
  2. Using Paste Special
  3. Naming Cells and Cell Ranges
  4. Defining Named Cell Ranges
  5. Editing and Deleting Named Ranges
  6. Using Named Ranges in your Formulas
     
     
• Module 2: Working with Excel Worksheets
  1. Inserting and Deleting Excel Worksheets
  2. Renaming Excel Worksheets
  3. Moving and Copying Excel Worksheets
  4. Using Grouped Excel Worksheets
     
     
• Module 3: Linking and Consolidating your Data
  1. Linking Cells and Formulas between Sheets and Workbooks
  2. Consolidating Multi-Worksheet Excel Data
     
     
• Module 4: Working with Formulas and Functions
  1. Locking your Formulas with Absolute Cell Referencing
  2. Statistical Functions (Max, Min, Average, and Count Functions)
  3. Common Date and Time Functions (Time, Timevalue, Today and Weekday Functions)
  4. Introduction to Logical (IF) Functions (SumIF, CountIF and AverageIF Functions)
     
     
• Module 5: Introduction to Database Features
  1. Setting out a Database List
  2. Using the Data Form
  3. Sorting Data
  4. Filter Data Using AutoFilter
  5. Using Find and Replace
     
     
• Module 6: Introduction to Charting and Drawing
  1. Creating Charts using the Excel Chart Wizard
  2. Editing and Formatting Excel Charts
  3. Printing Excel Charts
  4. Using the Drawing Toolbar
     
     

Day Two

• Module 1: Working with IF() and VLOOKUP()¹
  1. What is the IF() Function in Excel?
  2. Multiple IFs - The Lookup Functions
  3. Working with multiple Column lookups in VLOOKUP()
  4. Using the Lookup Wizard
  5. Finishing the Lookup Wizard
  6. Rounding up or down for Calculations
     
     
• Module 2: Understanding Cell Reference Types
  1. Relative versus Absolute Cell Referencing
  2. Using Mixed Cell References for Columns and Rows
     
     
• Module 3: Managing Excel Formulas with Ranges
  1. Applying names to Ranges of Cells
  2. Using Range Labels
  3. Creating Range Names
  4. Creating Multiple Names
  5. Using Range Names
  6. Movement and Selection
  7. Defining Names for your Formulas
  8. Applying Names
  9. Deleting Range Names
     
     
• Module 4: Working with Spreadsheet Security and Data Integrity
  1. Protecting your Excel Worksheets
  2. Validating data by applying input restrictions
  3. Creating Input Error Messages
  4. Specifying the Error Alert
  5. Protecting Cells
  6. Locking the Excel Worksheet
  7. Unprotecting the Excel Worksheet:
  8. Protecting the Excel Workbook
  9. Hiding Areas of the Worksheet
     
     
• Module 5: Advanced Spreadsheet Navigation
  1. Controlling the Screen
  2. Clearing Windows
  3. Working with Multiple Windows
  4. Freezing Row/Column Titles
  5. Using the Zooming feature
  6. Creating Custom Views
  7. Showing Views
  8. Deleting Views
  9. Full Screen View
     
     

1) What is VLOOKUP and what does it do?

Now that you've reached intermediate level, there's a good chance that VLOOKUP is the first named Excel function you've encountered which isn't totally self explanatory.

Perhaps the simplest way of explaining VLOOKUP would be as a means of cross-referencing data in one column with that found in another column and then displaying the result.

So, for instance, if you had a column of unique product IDs you might want to be able to input one of those ID's into a cell and from that retrieve a monthly sales figure for that product from a cell in a different column. That's where VLOOKUP comes in and it is an incredibly handy way of retrieving targetted data whether from within the same worksheet or from a centralised dashboard.

Because VLOOKUP cross-references (or looks up) information in columns we can say that it is a vertical lookup function, hence the name. And, if you happen to be using a newer version of Excel which has XLOOKUP available, then its worth knowing that this function can look up both columns and rows meaning it can search both horizontally and vertically.

MS Excel Course Levels

Our Excel training courses are available for beginners, intermediate, and advanced users of Microsoft Excel

Microsoft Excel Training Reviews

Very Informative - FANTASTIC - Thank you - Very Helpful

Course was great. Very Informative - Very useful, learnt more than expected.

Presents the course in a clear and concise manner, she makes learning enjoyable.

Various attendees, Microsoft Excel 365 Intermediate course, Greater Manchester

Delivery and pace was great and John took the time to explain again if needed.
S Da Costa, Wulfrun Building (Excel 365 Beginners course Wolverhampton, West Midlands)

A great teacher, went back stages if we were stuck, ensured we were all engaged and modified the course for our requirements and took the time out so we could ask questions, thoroughly enjoyed the course.
Ainscough Industrial (Online Excel 365 Advanced course (virtual classroom))

An excellent, clear and patient tutor who guided me through the course seamlessly.
M Menzies (Online Excel training 365 (virtual classroom))

Can I just pass on my thanks to your team for the training you provided in York. I've had lots of positive feedback from the staff involved.
J Whiley, NHS York and Selby (Excel training York, North Yorkshire)

Really useful. Really knowledgeable trainer.
A Ward, Aeromet (Advanced Excel Training Worcester, Worcestershire)

The trainer explained everything really well. I found the course easy to follow.
V Broxham, Baywa-re Operational Services (Intermediate Excel training Milton Keynes, Buckinghamshire)

Happy with everything.
M Aston, Bierce Surveying Ltd (Advanced Excel Training Aylesbury, Buckinghamshire)

We have had a few people over the years but the way the trainer picked up our business and requirements so quickly – all I can is you have a diamond there.
S Jenkins, Concorde Glass (Intermediate Excel Training Grimsby, Lincolnshire)

We all thoroughly enjoyed the course, we learned a great deal and thought Sara was a brilliant trainer, very patient with a fantastic way of teaching us, so thank you for that.
C Waldock, Darlington Borough Council (Intermediate Excel training Darlington, County Durham)

The content covered the exact content required after the beginners course. The information will allow me to improve the spreadsheets currently in use.
L Powell, Dudley Building Society (Intermediate Excel Training Dudley, West Midlands)

Great course!
V Franklin, E-Leather (Excel Beginners Training Peterborough, Cambridgeshire)

The training approach and style was great. Incredibly informative and supportive.
L Shier, One YMCA (Introduction to Excel Training Watford, Hertfordshire)

Great teacher!
J Smith, Fisher German (Intermediate Excel Training Canterbury, Kent)

Its an excellent course. I was impressed by the discovery of so many tools that will facilitate our working life. The trainer is excellent, everything was perfect.
S Green, HW Martin (Beginners Excel Training Cambridgeshire)

Very happy to learn so much.
O Chawishly, LM Information Delivery (Intermediate Excel Training Oxfordshire)

Covered all objectives. Wish We'd had two days.
B Hough, Homebase (VBA for Excel Training Milton Keynes, Buckinghamshire)

The course was excellent, covering more in a single day of training than I anticipated would be possible with a high degree of clarity.
Unsigned, New Economy, (VBA for Excel training Manchester, North West)

First class training
B Cook, Plumbworld (Excel training Evesham, Worcestershire)

Extremely useful.
G Reece, Faiveley Transport (Intermediate Microsoft Excel training Tamworth, Staffordshire)

Very well presented, very easy to understand, day was made interesting by doing exercises as well as listening.
C Burke, CheckPrint Ltd (Excel training Hinckley, Leicestershire)

Very easy to follow and well explained
A Cresswell, Nottingham Rehab Supplies (Excel intermediate/advanced training Ashby-de-la-Zouch, Leicestershire)

Tied up perfectly with previous training to produce documents and data that were previously unknown
H Metcalfe, Vecoplan Ltd (Excel training Birmingham, West Midlands)

Very informative and interesting
D Badzilay, Apollo Group (Intermediate Excel training Nuneaton (Nuneaton and Bedworth), Warwickshire)

Many thanks for your help in organising the session last Tuesday at such short notice. I’ve had great feedback ref the session and trainer.
B West, Wolseley (Intermediate Excel training Royal Leamington Spa, Warwickshire)

Course exceeded expectations.
K. Richards, Ashfield Homes (Microsoft Excel Training Sutton-in-Ashfield, Nottinghamshire)

The day was very well constructed and presented.
D. Coulthand, Crossgates Shopping Centre, Leeds (Intermediate Microsoft Excel Training Leeds, West Yorkshire)

Training very clear. Never felt rushed or pressured to comlete tasks. Each item explained and demonstrated very well. Easy to follow
S. Hope, Lear Corporation (Advanced Microsoft Excel Training Coventry, West Midlands)

Good course, good information, good trainer and at a nice tempo
A. Webster, BE Aerospace (Advanced Microsoft Excel Training Hinckley, Leicestershire)

Excellent, the best Excel course I have ever been on. Trainer gave time and patience to us all.
D. Gill, Persimmon Homes (Beginners Microsoft Excel Training Malmesbury, Wiltshire)

A very robust day's training.
T. Camp, Ideal Shopping (Beginners Microsoft Excel Training Peterborough, Cambridgeshire)

MS Excel Course Levels

Beginners Excel

- introductory topics for working with Excel spreadsheets

Intermediate Excel

- conditional formatting, VLOOKUP, IF, apply formulas across worksheets, database features, security and conditional formatting etc.

Advanced Excel

- What-If Analysis, PivotTables, PivotCharts, Goal Seek, Sparklines, protecting workbooks, formula auditing etc.

Masterclass Excel

- 'zero to hero' three-day intensive Excel course

Excel for VBA beginners

- one or two day introduction to programming with VBA

Excel Power Query course

- Introduction to using Excel Power Query along with Pivot Tables, Power Pivot and Power Pivot Measures

Back to top