Excel Masterclass Training Course UK Wide - On-site or Online

Masterclass Microsoft Excel Training Course

This three-day intensive learning Excel Masterclass course takes students from 'zero to hero' with Microsoft Excel and incorporates our beginners, intermediate and advanced courses.

Day One takes you through the basics of the Excel environment and navigating, editing and formatting, then moving on to subjects such as charts, functions and formulas, IF and VLOOKUPs and sorting and filtering on Day Two. During Day Three we move to to more advanced topics including SparkLines, PivotCharts, PivotTables, What-IF analysis and Goal Seek.

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.

With this Excel Masterclass there is still plenty of room for manoeuvre if you want the course topics tailoring or adjusting to your staff's particular learning needs and there is no requirement to take each day consecutively if you would prefer not to undertake the course as a three-day bootcamp. This gives you the flexibility needed to fit the courses around your business priorities and staff availability. Moreover, if you have any colleagues who are already confident using Excel up to a beginners level then they can join on day two, so nobody misses out and no one has to sit through material they already know and you only pay for the number of people that attend on each day.

With our Excel Masterclass course you can opt to have one of our Excel instructors come out to your premises on-site (in most parts of mainland UK) or we can deliver the course Online as live virtual classroom from anywhere.

Excel Masterclass Training Course Prerequisites

No previous knowledge of Microsoft Excel is needed to attend this power user course. Learners should be able to navigate their way around Windows and/or the Microsoft 365 environment and be able to open, close and save files and folders. If learners already have some self-taught experience with Excel but feel more comfortable starting from scratch, or with a refresher, that's fine too.

Excel Masterclass Training Course Highlights

• Master the basics of Excel
• Master Excel's most popular functions
• Master Excel's most useful formulas
• Master time-saving techniques in Excel
• Master Excel data analysis and visualisation
• Master charts, LookUps, pivot tables, data mapping and forecasting, automation and auditing

On-site Microsoft Excel Masterclass 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 courses can be taught on the following versions: Excel 365, 2024, 2021 and 2019.

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

Live Virtual Classroom Microsoft Excel Masterclass Course - 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.

Commercial and Corporate Microsoft Excel Masterclass Courses for the Public and Private Sectors

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

Whilst the number of people who attend our private Microsoft Excel Masterclass 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 Masterclass Courses?

The teaching methodology for our Microsoft Excel Masterclass 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 Microsoft Excel Masterclass 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, tried-and-tested way to bring your Microsoft Excel Masterclass know-how to life in a small-class-size setting.

How Long are Our Microsoft Excel Masterclass Courses?

Usual teaching hours for this three-day course 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.

More About the Microsoft Excel Masterclass Training Delivery Method for Closed Courses for Businesses

• Step-by-Step Courses: Instructor-led Masterclass 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 Masterclass 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.

Microsoft Excel Masterclass Course Outline

Day 1

• Module 1: Introducing Microsoft Excel
  1. What are Worksheets?
  2. What are Workbooks?
  3. What are columns and rows?
     
     
• Module 2: Mouse Pointer Functions in Excel
  1. The Different Mouse Cursor Symbols
  2. Select Cell Cursor
  3. Extend and fill Cells Cursor
  4. Insertion Point Cursor
  5. Drag Selection Cursor
  6. Change Row and Column Dimensions Cursor
     
     
• Module 3: Selecting Cells in Excel
  1. Cut Cells
  2. Copy Cells
  3. Format Cells
  4. Move Cells
     
     
• Module 4: Navigating the Excel Screen
  1. Introduction to Menus, Sheets and Views
  2. Add, Insert, Rename and Move Worksheets
  3. Scroll Bars, View Buttons and Magnification
  4. Menus and Sub-Menus
  5. Quick Access Toolbar
  6. Customising the Toolbar
  7. The Options Button and Global Settings
     
     
• Module 5: Entering and Editing Excel Data
  1. Text, Values and Dates
  2. Formulas, Values and Operators
  3. Active Cells
  4. Content Spill
  5. Adjust Column Width
  6. Editing Cells
  7. AutoFill
     
     
• Module 6: Copying and Pasting Excel Data
  1. Menu, Mouse or Keyboard Copy and Paste?
  2. Drag Cells to Copy
     
     
• Module 7: Save, Close and Open Excel Files
  1. Save, Save As
  2. Disk Drive, Network Drive, OneDrive
  3. File Names and Renaming
  4. Opening and Closing a File
  5. Adjust Column Width
  6. Editing Cells
  7. AutoFill
     
     
• Module 8: The File Tab
  1. Open, Save, Print
  2. Info, Recent and Options
     
     
• Module 9: Create a New Excel Workbook
  1. Create a New Workbook from Scratch
  2. Excel Workbook Templates
     
     
• Module 10: Formulas and Functions
  1. What are Formulas and Functions?
  2. Operators, Cell References and Constants
  3. Cell Referencing
  4. Operators and Operator Order
  5. The SUM function and Values
     
     
• Module 11: Formatting Excel Worksheets
  1. Number Formatting
  2. Fonts
  3. Borders
  4. Fill Colour
     
     
• Module 12: Printing Excel Worksheets
  1. Print Settings
  2. Print Preview
  3. Borders
  4. Print Ranges and Print Selection
  5. Create a Print Area
  6. Print Titles
     
     

Day 2

• 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 Range
  5. Editing and Deleting Named Ranges
  6. Using Named Ranges in your Formulas
     
     
• Module 2: Linking and Consolidating your Data
  1. Linking Cells and Formulas between Sheets and Workbooks
  2. Consolidating Multi-Worksheet Excel Data
     
     
• Module 3: Working with Formulas and Functions
  1. Absolute Cell Referencing
  2. Statistical Functions (including Max/Min/Average/Count Functions)
  3. Date and Time Functions
  4. Introduction to Logical (IF) Functions
     
     
• Module 4: 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 5: 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
     
     
• Module 6: Working with IF() and VLOOKUP()
  1. Introducing the IF() Function in Excel
  2. Multiple If's - 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 7: Understanding Cell References
  1. Using Absolute Cell Referencing
  2. Using Mixed Cell References
     
     
• Module 8: Working 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 9: 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
     
     

Day 3

• Module 1: Working with What-If
  1. What-If Analysis: One-Input Table
  2. What-If Analysis: Two-Input Table
     
     
• Module 2: Working with Goal Seek
  1. What-If Analysis: Goal Seek Formulas
  2. What-If Analysis: Goal Seek Functions
     
     
• Module 3: Pivot Tables
  1. Introduction to Field Lists, Report Filters, Row and Column Labels)
  2. Creating and Designing a PivotTable Report
  3. Manipulating PivotTables and Pivoting your Data
  4. Working with Dynamic Ranges
  5. PivotTable Slicers
     
     
• Module 4: Pivot Charts
  1. Creating a PivotChart from your PivotTable
  2. Filtering a PivotChart
     
     
• Module 5: Sparklines
  1. What Are Sparklines?
  2. Create Sparklines
     
     
• Module 6: The Subtotal Tab
  1. Create Subtotals
  2. Create Multiple Subtotals
  3. Subtotal Outline Levels
     
     
• Module 7: Protecting Worksheets
  1. Protecting part of a Worksheet
  2. Unprotecting a Worksheet
  3. Setting Worksheet Permissions
     
     
• Module 8: Protecting Workbooks
  1. When to Protect a Workbook
  2. Protecting workbook structure
  3. Protecting the Window Size
     
     
• Module 9: Formula Auditing
  1. Trace Precedents
  2. Trace Dependants
  3. Trace Errors
     
     

Excel Course Levels: training courses are available for beginners, intermediate, and advanced users of Microsoft Excel.

Excel Training Reviews from our UK Clients

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)

Very informative, easy to follow. Trainer was clear with his explanations
S Nottingham, Denney O'Hara (Microsoft Excel training Leeds, West Yorkshire)

Excellent day!
L McLachlan, Grange School (Excel training Rochdale, Greater Manchester)

Brilliant Training, went at the right speed [and] was made relevant to work
Kathryn Strong, Tennants Distribution (Excel training Manchester, North West)

Fantastic course, not too much information overload. Explained simple. Exactly what I needed. Many thanks.
K Stobbs, Depuy Spine - A Jonson and Jonson Company (Introductory Excel training Leeds, West Yorkshire)

The flexibility of the course was ideal.
S Walsh, Progress Rail (Advanced Excel training Edinburgh, Midlothian)

The guys who came to the course this week were very impressed with the whole set up and are now eager to attend the next level up.
E Dixon, Connaught PLC (Beginners Excel training Leeds, West Yorkshire)

The course has improved my knowledge of Microsoft Excel and was a good pace so easily understandable. Gerry was very patient and helped each of us where we needed it.
L Muir, Filtronic Broadband (Microsoft Excel training Newcastle Upon Tyne)

Although a total beginner on Excel, I found the course to be extremely helpful.
S Antonie, Filtronic (Excel training Shipley)

Made what I thought was going to be completely foreign to me easy to understand. I can actually see where I can use Excel in my day job now. Max was very good and took the time to make sure we understood. [...] Nothing could be improved.
C Elsmore, Elmwood Design (Excel training Leeds, West Yorkshire)

Very Useful.
J Collins, Cooper Research Technology Ltd (Advanced MS Excel Training Ripley, Derbyshire)

Enjoyable and informative.
N. Bell, Cosalt PLC (Excel advanced training Grimsby, Lincolnshire)

The training session went very well and I have had a lot of good feedback from the participants.
P Ogden, InterfaceFLOR (Microsoft Excel Training Halifax West Yorkshire)

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 complete 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)

The course in Edinburgh was incredible
C. Rowley (Beginners Microsoft Excel Training Edinburgh, Midlothian)

Back to top

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