EX-101 · Microsoft Official Course

Microsoft Excel Essentials

One day to stop guessing your way around Excel. You will leave knowing how the thing is actually put together, why your formulas do what they do, and how to hand someone a spreadsheet you are not embarrassed by.
1 day
Level: Beginner
No Prerequisites
Online · in person · onsite
Hands-on throughout
5.0 out of 5 stars (based on 4 reviews)

From £249 (ex VAT)

per person, online. From £349 in person.
See dates & book
Ask a question
Klarna & Clearpay available. Pay in 3 or spread the cost.

WHAT IS INCLUDED
One day with an experienced Excel trainer
Vantage 365 courseware and exercise files
Hands-on practice in every module
A quick reference guide to take away
Certificate of completion for your LinkedIn profile

What you will be able to do afterwards

Almost nobody is taught Excel. They are handed a spreadsheet on their second week in a job, told what to click, and everything after that is guesswork and colleagues. It works, in the sense that the numbers usually come out, but it leaves people quietly nervous about a program they use every day.

This day fixes that. Not by making you an expert, but by giving you the underlying picture, so that when Excel does something unexpected you have a reasonable idea why.

Move confidently around workbooks, worksheets, rows, columns and cells, with the keyboard as well as the mouse
Enter and edit text, numbers and dates so that Excel treats them as what they are, rather than turning them into something else
Format a spreadsheet so it looks professional, without changing the data underneath it
Write your own formulas using arithmetic operators, and understand what a cell reference actually is
Use SUM, AVERAGE, MIN, MAX and COUNT, and copy formulas without breaking them
Recognise and fix the errors Excel shows you, rather than deleting the cell and starting again
Lay data out so it can be sorted and filtered, and know why some spreadsheets refuse to behave
Print a spreadsheet that fits on the page, and export a clean PDF to send to someone
Bring a spreadsheet you actually use. One of the most useful parts of the day tends to be the point where someone opens their own file and the trainer explains why it has been misbehaving for two years. It is usually one of four things, and it is usually fixable in about a minute. If you would rather not share anything real, that is entirely fine, and the exercise files cover the same ground.

Why learn it with us rather than free

There is a great deal of free Excel content and some of it is very good. What it cannot do is watch you work. Most beginners are not held back by not knowing a feature exists, they are held back by one or two small misunderstandings that quietly break everything downstream, and those are almost impossible to diagnose on your own. A day in a small group with a trainer looking over your shoulder catches those in the first hour.

It also gives you a person to ask a fortnight later, when the spreadsheet you built at work does something you did not expect.

What the day covers

Five modules across one day, with hands-on practice in every one. The order matters: each module leans on the one before it, which is why we do not start with formulas even though that is what most people came for.

Teaching accounts for roughly half the day. The other half is you working in Excel, with the trainer available.

MODULE 1

Getting to know Excel

This module focuses on orientation and confidence. You will learn how Excel is structured and how to move around it efficiently.

Module 2 · lab

Formatting spreadsheets

Here you will focus on making spreadsheets readable and professional without damaging the underlying data.

Module 3

Formulas and functions

This module removes the fear around formulas by explaining how they work and how to use them safely.

Module 4 · lab

Working with data

You will learn how to organise data so it is easy to work with and analyse.

Module 5 · lab

Printing and sharing

The final module ensures you can share your work confidently.

Who this course is for

A good fit if you are

New to Excel, or you have avoided it successfully until now and can no longer avoid it
Self-taught, and aware there are gaps you cannot quite name
Able to type into cells and add things up, but nervous the moment a formula is involved
Returning to work, or moving into a role where spreadsheets are suddenly part of the job
Being handed spreadsheets built by someone who has left, and expected to keep them running
Part of a team where everyone does Excel slightly differently and nobody agrees on the right way
Managing people who use Excel, and want to understand what you are asking of them

Not the right course if

You already write formulas comfortably and want lookups, tables and conditional logic. That is Excel Intermediate
You want PivotTables, Power Query, macros or advanced functions. That is Excel Advanced
You have outgrown spreadsheets and need proper reporting and dashboards. Look at PL-300 Power BI Data Analyst
You need someone to build or rescue a specific spreadsheet for you. That is consultancy, not training, and we can help with that separately

Prerequisites: none. You need to be comfortable using a computer, a keyboard and a mouse, and able to open and save files. No Excel experience is assumed at all, and no maths beyond adding and dividing. If you are not sure whether you should be on Essentials or Intermediate, tell us what you can already do and we will tell you honestly. Booking the wrong level wastes your day, and we would rather move you than take the money.

What is included

One full day of instructor-led training, online, in person or onsite at your offices
Vantage 365 courseware, written for this course rather than adapted from a generic manual
Exercise files to work in during the day, which are yours to keep and practise with afterwards
A quick reference guide covering the shortcuts, formats and functions the course uses
A certificate of completion for your LinkedIn profile and your training record

About the hands-on time

Roughly half the day is you working in Excel rather than watching someone else work in Excel. That ratio is deliberate for a beginner course. Watching a formula being written is not the same skill as writing one, and the gap between the two only shows up when you are back at your desk on your own.

Online delegates need a second screen or a device to watch the session on while working in Excel. One laptop screen split between the trainer’s demonstration and your own workbook makes for a frustrating day, and we would rather tell you that in advance than on the morning.

Three ways to take it

Online

Live with a real trainer and a small group, scheduled regularly. Same trainer, same exercises and same courseware as the classroom. £249 per person excluding VAT, or three interest-free instalments of £99.60 with Klarna.

In person

Small cohorts at our UK training venues, on machines set up and ready, which suits people who would rather not wrestle with their own laptop while learning something new. Price on request confirm before publishing

Onsite / closed

At your offices, using your own version of Excel and, if you want, your own spreadsheets as the examples. For a beginner course this is often the strongest option, because a team that learns the same habits on the same day stops producing five different versions of the same report. Best value for four or more. Ask for a quote.

Self-paced (Launching soon)

On-demand modules to work through at your own pace. Register your interest and we will let you know when it goes live.

What it costs to not do it

Excel is the piece of software almost every organisation depends on and almost none of them train anyone in. It is treated as a thing people simply have, like the ability to use a phone, and so the cost of people not really having it never appears on anyone’s budget line.

It appears everywhere else. Someone spends an afternoon retyping figures that could have been sorted in ten seconds, because the data is laid out in a way that will not sort. A report goes to a client with the columns cut off, because nobody knew about print areas. A number is wrong for three months because a formula was copied down and the reference moved, and nobody could read the formula well enough to notice. A capable person avoids a task, or a promotion, because it involves spreadsheets and they have decided they are not a spreadsheet person.

None of that is a technology problem, and buying anything new will not fix it. One day and a couple of hundred pounds per person will, and for a skill somebody will use every working day for the rest of their career, that tends to pay for itself within the first month.

The honest version

Most people are not bad at Excel. They were never shown it.

Here is what we see arriving on the morning of a beginner course, and what tends to have changed by the end of the day. If the left-hand column looks familiar, you are in exactly the right place, and you are in the majority.

Before

How it usually looks

Everything by mouse. Scrolling through thousands of rows to get to the bottom of a list
Dates that will not behave, numbers stored as text, and postcodes that Excel has helpfully turned into something else
Formatting done by hand, cell by cell, and undone again the next time the data refreshes
Formulas copied from a colleague and pasted in hope, with no real idea what the dollar signs are doing
Data laid out for reading, with merged cells, blank rows and headings halfway down, so nothing will sort or filter
Printing by trial and error, and eight pages of nonsense in the printer tray
After

How it looks by five o’clock

Keyboard navigation for the things you do fifty times a day, which is where the time actually goes
Data entered as the right type, so Excel calculates and sorts it properly first time
Number formats applied properly, so the presentation changes and the underlying value does not
Formulas you wrote yourself, that you can read back and explain to someone else
Data structured so it works, and sorted and filtered in seconds rather than retyped
A clean PDF that fits the page and has your headings on every sheet

If you recognise the left-hand column but you also already use PivotTables and VLOOKUP, you are probably an Intermediate delegate with a couple of gaps rather than a beginner. Ask us, and we will help you pick.

5.0
5.0 out of 5 stars (based on 4 reviews)

Julie’s passion for Excel shone through with humour and practical approaches for ‘real life’ use.

Claire W
After the course

The course ends. The support does not.

Fundamentals courses have a particular afterlife. You go back to work, someone asks you a question because you are now the person who did the training, and you need a second opinion fast.

After the course

Trainer email support

Email our support team with the questions that come up as you apply it to your own reports. Not a ticket queue, and not a chatbot. The people who teach you, answering the thing you are actually stuck on.

Then, for as long as you want it

The learner community

Where this fits

The Excel learning pathway

Three courses, in order. Most people take Essentials and Intermediate a few weeks apart, then come back for Advanced when they have a reason to.

Start Here

Excel Essentials

This Course
Then go further

Excel Intermediate

Where Excel starts to save you real time: lookups, logical functions, named ranges, tables and charts that update themselves.

Then go deeper

Excel Advanced

PivotTables, Power Query, advanced functions and automation. The point at which colleagues start asking you how you did that.

See the whole Excel pathway →

Related courses

Others in Microsoft Office

See all Power BI courses
Not sure it is the right fit?

Ask before you book

Tell us what you are actually trying to work out. If PL-900 is right we will say so, and if you would get more from a hands-on course or from a conversation with our consultancy team, we will say that instead.

Training a team?

Onsite & closed courses

Ask us

Not sure which Excel course is right, or want it for your team?

No hard sell · A real trainer replies · We will tell you if you do not need us

Prefer to talk? Call +44 121 269 8660

Why train with us

What you get that you will not get everywhere

01

Small groups, real practice

Half the day is you in Excel, not watching a screen share. Beginner Excel is a doing skill, and it does not transfer from watching.

02

Trainers who use it for real

Our trainers spend the rest of the week building and fixing spreadsheets for clients. When you ask why yours is broken, you get an answer from experience.

03

Real prices, published

Every course shows its price and what is included. No “contact us for pricing”, no surprises.

04

We say when not to book

If you are past this level, we will move you to Intermediate rather than take your money for a day you will find slow.

Reviews
5.0
5.0 out of 5 stars (based on 4 reviews)
What delegates said after taking Excel Essentials with us.
October 10, 2025

Julie’s passion for Excel shone through with humour and practical approaches for ‘real life’ use.

Claire W
October 10, 2025

Julie made sure that she took time to explain things over and over until we understood.

Laura
October 10, 2025

Good pace, clear explanations and delivery style, very knowledgeable and personable too.

Sophie
October 10, 2025

I came away from this course with new knowledge of useful short cuts to basic functions and a renewed liking of Excel!

Melanie
Our clients

Teams we have trained

book your course

Upcoming dates

Oct
20

Microsoft Excel Essentials

Live Online

09:00 – 17:00

Book Course

£249.00

Nov
10

Microsoft Excel Essentials

Live Online

09:00 – 17:00

Book Course

£249.00

Dec
01

Microsoft Excel Essentials

Live Online

09:00 – 17:00

Book Course

£249.00

Oct
20

Microsoft Excel Essentials

Live Online

09:00 – 17:00

Book Course

£249.00

Nov
10

Microsoft Excel Essentials

Live Online

09:00 – 17:00

Book Course

£249.00

Dec
01

Microsoft Excel Essentials

Live Online

09:00 – 17:00

Book Course

£249.00

No events found.

Shopping Basket