Overview
Excel is still the most requested software skill in UK office job adverts, and most people only use a fraction of it. A few core techniques can save hours every week.
This course starts with the basics, cell references and simple formulas, then builds to the functions employers actually ask about: IF, SUMIFS, COUNTIFS, XLOOKUP, text and date functions. You will also learn tables, conditional formatting, data cleaning, charts, PivotTables, a simple dashboard and how to use Copilot in Excel.
Hands on tasks walk you through real spreadsheets step by step. Works with Excel for Microsoft 365, Excel 2021 and most features in Excel for the web.
What you will be able to do
- Build formulas with relative and absolute references
- Use IF, SUMIFS, COUNTIFS and XLOOKUP with confidence
- Clean and organise messy data with tables and text functions
- Highlight what matters with conditional formatting
- Summarise thousands of rows with PivotTables
- Build clear charts and a simple dashboard
- Use Copilot in Excel safely to speed up analysis
Who this course is for
- Office and admin staff
- Job seekers adding a core skill
- Small business owners
- Finance, sales and HR teams
- Students and graduates
- Anyone who wants to stop copying and pasting
No experience needed. You just need a phone, tablet or computer and an internet connection.
How you are assessed
Every module has short interactive activities: quick checks, sorting games, ordering tasks and scenarios. At the end there is a 15 question final assessment drawn from a bank of 16 questions. You need 12 or more to pass, and you can retake it as many times as you like with new questions each time.
Where this can help your career
These skills are useful in many roles. The course supports your development, but it does not guarantee a job or promotion.
Curriculum
6 modules, a final assessment and your certificate. About 1 hr 14 min in total.
1Excel basics and moving fastFree preview
2Formulas, references and essential functions
3Lookups and cleaning data
4Tables, sorting, filtering and conditional formatting
5PivotTables and charts
6Working smarter: dashboards, protection and AI
✓Final assessment and certificate
Certificate
When you pass the final assessment you get a Studivana certificate of completion with your name, the course title, your score, the date and a unique certificate ID. Download it as an image or PDF and add it to your CV, LinkedIn or training record.
This is a certificate of completion, not a regulated or accredited qualification. Some employers ask for specific accredited training, so check what your role needs.
Frequently asked questions
Is this course accredited?
No. You get a Studivana certificate of completion, which shows you studied the course and passed the final assessment. It is not a regulated or accredited qualification, so if your employer needs a specific accredited certificate, check with them first.
Which version of Excel do I need?
Excel for Microsoft 365 or Excel 2021 is best. XLOOKUP is not available in Excel 2016 or 2019, and the course shows the older alternative.
Is this a Microsoft certification?
No. It is our own course with a Certificate of Completion. It is good preparation if you later want to take the Microsoft Office Specialist exam.
Can I study at my own pace?
Yes. You get lifetime access, your progress is saved as you go, and you can study on a phone, tablet or computer.
Can I train my whole team?
Yes. Choose For my team in the price box and tell us how many learners you have. We will send a quote with team pricing.
What if the course is not right for me?
You can get a full refund within 14 days of buying it, no questions asked. See our Refund Policy for how to ask.


