Excel for office and data jobs

What you will be able to do

Skills you add to your Herizon profile when you finish: Microsoft Excel, Data Cleaning, Data Visualization.

• 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.

What is inside

1. What Excel is for
2. Tables and the export
3. Core formulas
4. XLOOKUP
5. FILTER, UNIQUE and LET
6. PivotTables

and 6 more pages

Finish with a short quiz to earn your certificate.