STUDIVANA
Home / Business admin / Microsoft Excel Masterclass

Microsoft Excel Masterclass: Beginner to Advanced

Go from the first cell to confident analysis: formulas, XLOOKUP, SUMIFS, tables, PivotTables, charts and simple dashboards, with Copilot tips.

All levels1 hr 14 min6 modulesCertificate included

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.

AdministratorData entry clerkFinance assistantSales coordinatorOffice managerOperations assistant

Curriculum

6 modules, a final assessment and your certificate. About 1 hr 14 min in total.

1Excel basics and moving fastFree preview
Excel is one of the most requested skills in UK job adverts, from admin to finance to marketing. This masterclass takes you from the basics to the tools that impress managers.
2Formulas, references and essential functions
Formulas turn a list into answers. Understanding references is the key to formulas that work when you copy them.
3Lookups and cleaning data
Lookups connect information across lists. Clean data makes every formula and report reliable.
4Tables, sorting, filtering and conditional formatting
Turning data into a proper Excel Table unlocks automatic formatting, filters and formulas that grow with your data.
5PivotTables and charts
PivotTables summarise thousands of rows in seconds. Charts turn the numbers into a story managers understand.
6Working smarter: dashboards, protection and AI
The final module brings everything together into professional, shareable workbooks.
✓Final assessment and certificate
15 questions drawn from a bank of 16. Score 12 or more to pass and download your 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.

CERTIFICATE OF COMPLETION
This certifies that
Your Name
has completed Microsoft Excel Masterclass

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.

You might also like