Excel for office and data jobs
Excel for office and data jobs is a free, beginner online course from Herizon.
Learn the Excel skills office and data jobs ask for, starting free in Excel for the web. Covers tables, core formulas, XLOOKUP, FILTER, UNIQUE and LET, PivotTables, charts, Power Query basics, cleaning data, Finnish-language Excel, Copilot in Excel and the Excel exams.
You finish with Microsoft Excel, Data Cleaning and Data Visualization added to your Herizon profile.
Free · 30 min read · certificate when you pass the quiz · part of Data analyst · last updated 9 November 2026
Free account, about two minutes. You can join if you live in the EU, EEA, UK or Switzerland, or a partner organisation invited you.
Already have an account? Open it in the portalA look inside the course
Noora has just started as an office assistant at a small office-supplies wholesaler in Jyväskylä. Noora and the wholesaler are a scenario, not real people or a real company. Her manager sends her a sales export with 42 rows and says: "Clean this up and give me a monthly summary by region."
It takes about 30 min of reading, plus exercises, a short quiz and a practice task. It teaches Microsoft Excel, Data Cleaning and Data Visualization. Pass the short quiz at the end to get a certificate.
What you will be able to do
- Which free and paid ways in exist, and what Excel for the web cannot do
- How to turn an export into a table that formulas and PivotTables can use
- Core formulas, then XLOOKUP, FILTER, UNIQUE and LET
- PivotTables, charts, Power Query basics and cleaning habits
- How Finnish-language Excel changes function names and separators
- What Copilot in Excel needs, and why you check its numbers
- The Excel Associate and Expert exams, and what you can put on a CV
The situation you work through
Noora is in her first office assistant job at a small wholesaler in Jyväskylä. She cleans a 42-row sales export, looks up product names with XLOOKUP, builds a PivotTable and a chart of sales by region, and writes her formulas in English and Finnish syntax.
Your practice task
Make a sample sales dataset of at least 30 rows with made-up data and no real customer details, in the columns A Order, B Date, C Region, D Product code and E Amount. Add a blank row, a repeated order and an amount typed as text on purpose, then clean a copy and format it as a table. Add one XLOOKUP that returns a product name from a small Products sheet and test it with a missing code. Build one PivotTable with total amount by region, then one chart from it. Write each formula in both English and Finnish syntax. Submit the three problems you added and how you fixed each, your XLOOKUP in English and in Finnish syntax, the PivotTable fields you used, the chart title and type, and one check that caught a mistake.
Key topics
- What Excel is for
- Tables and the export
- Core formulas
- XLOOKUP
- FILTER, UNIQUE and LET
- PivotTables
and 6 more pages
What you get when you pass
A certificate with your name, the course and the date. Sharing it is your choice. If you share it, it has a public link that anyone can open to check it, and you can add it to LinkedIn.
Common questions about Excel for office and data jobs
- Is Excel for office and data jobs free?
- Yes. The course is free with a Herizon account, and the account is free too.
- How long does Excel for office and data jobs take?
- It takes about 30 min of reading, plus exercises, a short quiz and a practice task. You can stop and continue later, because the portal keeps your place.
- Do I get a certificate?
- Yes. Pass the short quiz at the end to get a certificate you can share, for example on LinkedIn.
- What do I need to start?
- A free Herizon account. The course is written at beginner level.
- Who can join Herizon?
- You can join if you live in the EU, EEA, UK or Switzerland, or a partner organisation invited you.
Start Excel for office and data jobs free
Start this course freeCommon questions about Excel for office and data jobs
- Is Excel for office and data jobs free?
- Yes. The course is free with a Herizon account, and the account is free too.
- How long does Excel for office and data jobs take?
- It takes about 30 min of reading, plus exercises, a short quiz and a practice task. You can stop and continue later, because the portal keeps your place.
- Do I get a certificate?
- Yes. Pass the short quiz at the end to get a certificate you can share, for example on LinkedIn.
- What do I need to start?
- A free Herizon account. The course is written at beginner level.
- Who can join Herizon?
- You can join if you live in the EU, EEA, UK or Switzerland, or a partner organisation invited you.
More in Data analyst
- Data analytics fundamentals42 min · 11 pages
- SQL & data analysis49 min · 10 pages
- Data analyst portfolio project37 min · 14 pages
- Python for beginners53 min · 11 pages
- Desk research that actually informs decisions28 min · 11 pages
- Machine learning fundamentals36 min · 11 pages
- Power BI basics for data roles27 min · 12 pages
- Data science fundamentals29 min · 10 pages
- Data engineering fundamentals26 min · 10 pages