Learn Excel Through a Task You Need to Complete
People usually look for Excel training because a real task has become difficult: a monthly report takes too long, formulas keep breaking, a job advert asks for pivot tables, or an interview includes a spreadsheet test. One-to-one training starts with that task and works backwards to the skills needed to complete it reliably.
Sessions are taught by Kevin Johal, a qualified teacher with an MEd in Educational Technology and Learning Design. The aim is not to memorise a long list of functions. It is to understand how tables, references, formulas and checks work together so the method transfers to the next workbook.
What the training covers, level by level
- Foundations — navigating confidently, entering and formatting data, simple formulas, printing and sharing without chaos
- Everyday working Excel — SUM, AVERAGE and IF families, absolute references, sorting and filtering, tables, basic charts
- Intermediate — VLOOKUP/XLOOKUP, conditional formatting, data validation, working across sheets, cleaning messy data
- Advanced — pivot tables and pivot charts, dashboards, named ranges, and an introduction to automating repetitive work
What Happens in the Excel Skills Check
The free trial uses a small practical workbook rather than a multiple-choice test. It checks whether you can organise data, choose a formula, copy it safely and explain what the answer means.
- Foundations: entering data, formatting dates and numbers, saving, printing and finding your way around a worksheet.
- Formula control: relative and absolute references, SUM, AVERAGE, IF and error checking.
- Data tasks: tables, sorting, filtering, validation, lookups and cleaning inconsistent entries.
- Reporting: choosing a useful chart or pivot table and explaining the decision it supports.
The result is a short training plan based on the first missing skill needed for your goal. A beginner is not rushed into advanced formulas, and an experienced user does not spend a lesson repeating formatting they already understand.
Built around your actual job
Where possible, sessions use the spreadsheets you actually face - the monthly report, stock tracker, rota, budget or mark sheet. Remove personal, customer or confidential information before sharing a file. If the original cannot be used, a practice workbook can reproduce the same structure with fictional data.
Who books Excel training
Working adults upgrading their role or preparing for one; jobseekers who keep seeing "strong Excel skills" in adverts; small business owners doing their own numbers; and complete beginners, including older adults, who want patient teaching that never assumes knowledge. Sixth-form and university students preparing for placements are regulars too.
Late August 2026: Build One Useful September Workbook
The fastest way to make Excel training stick is to build something needed for work or study. A budget, mark tracker, rota or simple report can introduce clean data, formulas and charts without learning features in isolation.
- Start with tidy data: Use one header row, consistent formats and no decorative blank rows inside the table.
- Choose three formulas: Practise relative and absolute references through SUM, IF and a suitable lookup.
- Make errors visible: Use validation and simple checks before adding elaborate formatting.
- Finish with a decision: Create a pivot table or chart that answers a real question from the workbook.
Beginner Excel training or advanced Excel support?
Beginners start with clean tables, references, formulas, formatting and charts before moving into IF statements and lookups. More experienced users can bring a real workbook for help with pivot tables, dashboards, validation or error checking. Function availability differs between Excel editions, so the course checks your software version before choosing methods; Microsoft documents current availability on pages such as its XLOOKUP guidance.
If your goal also includes presentations, documents or email, compare the broader Microsoft Office training plan. For a presentation-specific task, use the PowerPoint course in Birmingham.
A Four-Session Excel Improvement Plan
- Session 1 - diagnose: inspect the real task, establish the starting level and tidy the source data.
- Session 2 - calculate: build the formulas and references needed for accurate repeatable results.
- Session 3 - analyse: use filters, lookups, pivot tables or charts to answer a practical question.
- Session 4 - repeat: rebuild the process with less support and add checks that reveal errors early.
The plan can stop after the immediate goal is met or continue into more advanced reporting. Progress is measured by whether the learner can repeat the workflow, not by how many features were demonstrated.
Excel Training FAQs
What level does the Excel training start at?
Wherever you are. Some learners begin with entering data and simple sums, while others need lookups, pivot tables or reporting dashboards.
Can the training use my real work spreadsheets?
Yes, once personal and confidential information has been removed. A practice version with fictional data can be created when the original file cannot be shared.
How is the right Excel course level chosen?
The free trial checks navigation, tables, references, formulas and data interpretation, then starts at the first missing skill needed for your task.
Is Excel training available online?
Yes. Screen sharing lets you learn in your own copy of Excel and work directly on your own computer from anywhere in the UK.
Does my version of Excel affect the training?
Yes. Function availability and menus differ, so the first session checks whether you use Microsoft 365, Excel for the web or an older desktop edition.
Next Step
Call 07909 274901 or book a free trial session. Bring a spreadsheet you wrestle with — the first session will make it visibly easier.