CPD Standards Office accreditedMicrosoft Excel Course
A spreadsheet of names, pay or health details is personal data under UK GDPR, so it must be accurate, kept secure and shared only with people who should see it. Lift College's 3 hour online course gives you a CPD Standards Office accredited certificate on the day you pass, which employers can verify, plus a free refresher every 3 years.
- £19.99, pay once
- CPD certificate the day you pass
- Free refresher when it is due
- 14-day money back
Accredited CPD activityThe CPD Standards Office, provider 51289. Verify accreditation
14-day money back · Pay once, no subscription
Microsoft Excel Course
You can do Microsoft Excel training online in the UK with Lift College's Microsoft Excel Course. It is 3 hours of learning in 6 short modules, covering the workbook and the ribbon, entering and formatting data, formulas and cell references, the functions people use most (SUM, AVERAGE, COUNT, IF, ROUND and dates), sorting, filtering and tables, charts, lookups with XLOOKUP and VLOOKUP, pivot tables, and checking, protecting and sharing a workbook. It costs £19.99, pay once, and your accredited CPD certificate is ready the same day you pass. Lift College recommends a refresh every 3 years, and the refresher is free.
Most spreadsheet problems at work are not advanced problems. They are a total that does not include the last row, a formula copied with the wrong reference, dates typed as text, a filter left on, a chart that shows the wrong series, or a workbook nobody can follow. This course starts from the spreadsheets people actually build, rotas, budgets, registers, stock lists, trackers and reports, and teaches the skills in the order you need them, with a worked example in each module and a short exercise to try.
By the end you will be able to build a clean, well-labelled workbook from scratch, write and copy formulas with confidence, turn a list into a table that sorts and filters properly, summarise thousands of rows with a pivot table in minutes, chart the result, and share it without breaking it. It is written for Excel in Microsoft 365 on Windows and Mac, and the ideas carry over to Excel Online and Google Sheets. It is not a programming or macro course.
- Navigate a workbook, enter and format data, and use number, date and text formats correctly
- Write formulas with relative, absolute and mixed references and copy them without errors
- Use SUM, AVERAGE, COUNT, COUNTA, MIN, MAX, ROUND, IF, SUMIF and COUNTIF, and basic date arithmetic
- Sort and filter data, convert a range to a table and use structured references
- Build and format column, bar, line and pie charts that show the right message
- Look up values with XLOOKUP and VLOOKUP and combine data from two sheets
- Summarise data with a pivot table and refresh it when the data changes
- Check a workbook for errors, protect cells and sheets, and share and version a file safely
6 short modules, 3 hours in total.
Workbooks, data entry and formatting
Sheets, cells and the ribbon, entering text, numbers and dates, fill and series, number and date formats, column widths, freeze panes, and laying out a sheet other people can read.
Knowledge checkFormulas and references
How a formula is built, the order of operations, relative and absolute references, copying formulas, common errors such as #REF!, #VALUE! and #DIV/0! and what they mean, and naming cells.
Knowledge checkThe functions people use most
SUM, AVERAGE, COUNT and COUNTA, MIN and MAX, ROUND, IF and nested IF, SUMIF and COUNTIF, TODAY and date differences, and TEXT for tidy labels.
Knowledge checkSorting, filtering, tables and charts
Single and multi-level sorts, filters and the traps they set, converting a range to a table, structured references and totals rows, and building column, bar, line and pie charts that tell the truth.
Knowledge checkLookups and pivot tables
XLOOKUP and VLOOKUP, exact and approximate matches, combining data from two sheets, building a pivot table from a list, grouping, filtering and refreshing it, and reading the result.
Knowledge checkChecking, protecting and sharing
Error checking and trace precedents, data validation and drop-down lists, protecting cells and sheets, comments and notes, saving and versions, sharing in OneDrive and Teams, and what not to put in a spreadsheet.
Knowledge checkFinal test and your certificate
Multiple choice, 80% to pass, unlimited attempts. Your CPD Standards Office accredited certificate is issued the day you pass.
This course is for you if
- Your job involves spreadsheets and you have never been taught Excel properly
- You are applying for admin, finance or office roles that ask for Excel
- You build rotas, budgets, registers, stock lists or reports
- You inherit other people's spreadsheets and need to understand and fix them
- You manage a team and want everyone working from reliable workbooks
Your CPD accredited certificate, issued the day you pass.
Your certificate records that you completed Microsoft Excel Course with Lift College. It shows 3 hours of learning, your completion date and a recommended refresh date 3 years on.
- One price, £19.99. One payment, one learner, no subscription.
- Short modules with a knowledge check after each one and a final test. Instant results.
- 80% to pass, with unlimited free retakes.
- A CPD accredited certificate as a PDF the same day you pass, carrying the CPD Standards Office mark, our provider number 51289, a unique number and a verification link.
- Access for as long as Lift College offers the course, and never less than 3 years from the day you buy.
- A free refresher when your recommended refresh date arrives. Changed your mind? Ask within 14 days of paying and we refund you in full.
LC-CPD-SAMPLECertificate numberAccredited continuing professional developmentCertificate of CompletionThis is to certify thatAlex Johnsonhas successfully completed the CPD course
Dr Kate StrohmManaging Director, Lift CollegeSample certificateAn example only. It has no numberand cannot be verified.LC-CPD-SAMPLELift College Limited is a CPD Standards Office accredited provider (number 51289). This course is an accredited CPD activity.This certificate confirms completion of a Continuing Professional Development (CPD) course. It is not an Ofqual-regulated qualification.Lift College Ltd · Registered in England and Wales, Company No. 17337303 · Unit 3 E/F Suffolk House Business Park, Ashwells Road, Brentwood, Essex, CM15 9SG · liftcollege.co.ukA sample. Yours carries your name, the date you pass and a unique certificate number with a QR code anyone can scan to check it, or check a certificate at liftcollege.co.uk/verify.
The law this course supports
UK GDPR and the Data Protection Act 2018
A spreadsheet of names, addresses, pay, health or pupil data is personal data. It must be accurate, kept only as long as needed, protected against loss and unauthorised access, and not emailed to people who should not see it. Module 6 covers protection, sharing and what to leave out.
Read the legislation →HMRC: Making Tax Digital record-keeping
Businesses and landlords within Making Tax Digital must keep digital records and send updates from compatible software. Spreadsheets can be part of that record-keeping when linked through bridging software, so the data has to be structured and accurate.
Read the legislation →ICO guidance on data security
The Information Commissioner's expectation that organisations take appropriate technical and organisational measures to protect personal data, which includes how spreadsheets containing personal data are stored, shared and protected.
Read the legislation →£19.99. Pay once, nothing added.
One payment for one learner. You keep access for as long as Lift College offers the course, and never less than 3 years. Changed your mind? Ask within 14 days and we refund you in full.
- PaySecure card payment, one time only.
- Sign inYour learner account is ready straight away.
- StartBegin module 1 the same minute.
Free refresher when it is due
We recommend a refresh every 3 years. We email you 30 days before, and from the refresh date you can retake the latest version free and download a new certificate.
Buying Microsoft Excel Course for a team?
Open a free organisation account, buy places and give each person their own login. The price falls the more places you buy.
Multiple enrolment discounts
The price of a place is set by the places in one order, on this course or any mix of our CPD courses. Saving against the £19.99 single place.
| Places in one order | Price a place | Saving |
|---|---|---|
| 1 to 9 places | £16.99 | 15% off |
| 10 to 49 | £14.99 | 25% off |
| 50 to 99 | £12.99 | 35% off |
| 100 to 249 | £10.99 | 45% off |
| 250 or more | £9.99 | 50% off |
What would your team cost?
Training each person on several courses? A sector pack or the annual plan can cost less. Your quote compares all three for you.
Prefer to talk first? Request a call back
- 1
Your own training portal in 2 minutes
Open a free account with your work email. No sales call, and no minimum order.
- 2
See where everyone stands
A progress dashboard, a training matrix and an Excel progress report for your records.
- 3
Reminders sent for you
Welcome emails, nudges for anyone who stalls, and refresher dates so nobody goes out of date.
- 4
Pay by card or invoice
Card, or invoice on 30-day terms with your PO. Places stay valid for 3 years.
- 5
A human tutor with every course
Real tutor support for your staff, unlimited free retakes and a certificate the day they pass.
- 6
Accredited by the CPD Standards Office
Provider 51289. Every CPD course is an accredited CPD activity.
Check any learner's certificate in our register →
What our learners say
Stories from Lift College learners on our qualifications, in their own words.
“I had been a care assistant for four years without a formal qualification. Lift College made the whole process straightforward, my assessor visited regularly and I completed my Level 3 Diploma in Adult Care in just over a year. I was promoted to senior care worker the month after I qualified.”
“My employer was clear, I needed GCSE English to move into a supervisory role. Lift College helped me find the right exam board and an exam centre five minutes from home. Passed grade 4. Got the promotion.”
“My employer needed me to have Level 2 maths before they could register me on the Level 3 apprenticeship programme. Lift College was fast, the tutor was brilliant, and I resit my maths once after a near-miss and passed the second time. The whole thing took twelve weeks.”
Questions about Microsoft Excel Course
Which version of Excel does the course use?
Excel in Microsoft 365 on Windows, with notes where the Mac version or Excel Online differs. Everything in modules 1 to 4 works in any version from Excel 2016 onwards; XLOOKUP in module 5 needs Microsoft 365 or Excel 2021, and the course shows VLOOKUP for older versions.
Is this course CPD accredited?
Yes. Microsoft Excel Course is an accredited CPD activity with the CPD Standards Office, the UK's research-led CPD accreditation body. Lift College Limited is a CPD Standards Office accredited provider (provider number 51289), and your certificate carries the CPD Standards Office mark and our provider number so an employer or professional body can check it.
Is this a beginner's course?
It starts at the beginning, so a complete beginner can follow it, and it goes as far as lookups and pivot tables, which is where most working spreadsheets stop. If you already use pivot tables and lookups confidently, the course will be revision.
Does it cover macros, VBA or Power Query?
No. It covers the Excel most jobs need, and it stops before programming. Power Query, Power Pivot and VBA are not included.
Can I practise as I go?
Yes. Each module has a worked example and a short exercise to try in your own copy of Excel. You do not need to submit the exercises; the knowledge checks and the final test are in the course.
What does this course not cover?
Macros, VBA, Power Query, Power Pivot, financial modelling and statistics. It is a practical course for everyday work spreadsheets, not an analyst's course.
How long do I keep access?
You keep your access for as long as Lift College offers the course, and never less than 3 years from the day you buy. Your certificate PDF is yours to keep.
What is the free refresher?
Lift College recommends refreshing this course every 3 years. When your date comes round, you can retake the latest version free and get a new certificate. We email you 30 days before.
Does it count towards my CPD?
Yes. The course is 3 hours of learning, shown on your CPD Standards Office accredited certificate, so you can log the hours in your CPD record.
Can I get my money back?
Yes. Ask within 14 days of paying and we refund you in full.
Can my employer pay?
Yes. Your receipt shows the course, the date and the amount paid, and you can pass it to your employer. Buying for a team? Open a free organisation account: every course is £16.99, and you can pay by card or invoice with your PO.
Can my team do this course in another language?
Yes, on an organisation account with 10 or more places. Your team can study Microsoft Excel Course in Polish, Romanian, Punjabi, Urdu or Welsh, prepared within 1 working day of your order. The final test and the certificate stay in the English course name, so the certificate is the one every employer recognises. Tell us the languages you need when you order or ask for a quote.
Where can I do Microsoft Excel training online in the UK?
Lift College offers Microsoft Excel Course online for £19.99, pay once. It is 3 hours of learning in 6 short modules, written for Excel users in workplaces across the UK. Your accredited CPD certificate is ready the same day you pass.
How long does online Microsoft Excel training take?
Microsoft Excel Course is 3 hours of learning in 6 short modules, each with a knowledge check. You can finish it in one sitting or across several and pick up where you left off on any device. The final test needs 80% to pass, with unlimited free retakes.
How much does Microsoft Excel Course cost online?
Lift College's Microsoft Excel Course is £19.99, pay once, with no subscription. Training a team? It is £16.99 a course on a free organisation account.
How is Microsoft Excel Course assessed?
By a short knowledge check after each of the 6 modules and a final test. You need 80% to pass, with unlimited free retakes, and your accredited CPD certificate is ready the same day you pass.
Can I start Microsoft Excel Course today?
Yes. You start the moment you pay, on any device, and you can finish the 3 hours of learning in one sitting or across several. Your accredited CPD certificate is ready the same day you pass. Buying for a team? Open a free organisation account.
Microsoft Copilot Training
Use Copilot for the everyday jobs: drafting, summarising, meeting notes, spreadsheets and slides. Write prompts that work, check what comes back, and keep work data where it belongs. 2 hours, £19.99.
Bookkeeping Basics
The essentials of keeping a small business's books: records, double entry, VAT, the bank and software, in about 6 hours.
Time Management Course
Decide what matters, plan your week, protect your focus and build a system you will keep using. 2 hours, £19.99.