Excel guides
These are the long reads: what employers test, how finance teams use Excel, which lookup to pick, how IF formulas and dates work, how to clean up messy data and which shortcuts are worth learning. Every guide ends with the exercises and tests that drill what it explains, so you can read a section and then prove you can do it.
Excel test for a job interview: what it looks like and how to practice
What employer Excel tests ask, the formulas that come up again and again, how the big test platforms work, and a free timed practice test to see where you stand.14 min readFree Excel course online: learn Excel from your first formula to job-ready
An Excel course for beginners in nine modules, from cells and SUM to lookups and summary tables. You practice in the browser, and the first part is free with no account.15 min readVLOOKUP vs XLOOKUP vs INDEX MATCH: which lookup to use
How VLOOKUP, XLOOKUP and INDEX with MATCH work, where each one breaks, and which to use in a test, an old workbook or a sheet you are building today.12 min readPivot tables explained, and the formulas that do the same job
What a pivot table computes, how to build one step by step, the problems that trip people up, and how to get the same summaries with SUMIF, COUNTIF and SUMIFS.12 min readExcel for finance and accounting: the skills you actually use
The Excel skills finance and accounting teams use every day, from SUMIFS on a ledger and budget variances to rounding, month-end dates, PMT, NPV and check totals.12 min readExcel IF formulas: from one condition to many
How IF works, how to combine conditions with AND and OR, when to nest IFs or switch to IFS, and how to fix the IF mistakes that give wrong answers without an error.13 min readDates in Excel: how they work and the formulas you need
Why Excel stores dates as numbers, how to add days and months, find month-ends and working days, work out ages, and fix dates that arrive as text.12 min readHow to clean data in Excel with formulas
Fix messy exports with formulas. Remove extra spaces, fix capitals, split names and codes, join columns, find duplicates and turn text into real numbers.12 min readExcel keyboard shortcuts worth learning, and how to make them stick
The Excel shortcuts that save real time, for Windows and Mac, in the order to learn them, and a short daily drill that makes them automatic.12 min readGoogle Sheets vs Excel: what is the same, what is different, and how to switch
Where Google Sheets and Excel work the same, where they differ, from QUERY and ARRAYFORMULA to sharing and limits, and what to learn when you switch.12 min readConditional formatting in Excel: highlight cells and rows with rules and formulas
How conditional formatting works, the built-in rules worth knowing, and the formulas that highlight whole rows, overdue dates, duplicates and anything a menu can't do.13 min readHow to create a drop-down list in Excel, and make it update itself
Create a drop-down list in Excel from typed options, a range or another sheet, keep it up to date, make one list depend on another and write custom validation rules.12 min readHow to lock cells in Excel: freeze rows, protect cells and lock formulas
The three ways to lock in Excel. Freeze the top row or first column, protect cells so nobody changes them, and lock a cell in a formula with $.12 min readHow to merge cells in Excel, and what to use instead
Merge & Center and its three siblings, why merged cells break sorting and filtering, Center Across Selection, unmerging without gaps and combining text with a formula.11 min readHow to make a graph in Excel: column, line and pie charts step by step
Make a chart in Excel in three steps, pick the right type for your data, and fix the usual problems, with the formulas that build the table behind the chart.14 min readHow to calculate percentages in Excel: percent of a number, change, discount and VAT
Every percentage formula you need in Excel, from percent of a number and percent change to discounts, margins and adding or removing VAT, with the usual mistakes.12 min readExcel budget template: free download and the formulas behind it
Get a free Excel budget template and learn the formulas behind it: money left over, yearly bills per month, spending by category, balance and savings goals.15 min readExcel practice data: free datasets with tasks and answers
Two free Excel files to practice on: 240 sales orders and 60 employees. With 29 tasks on SUMIF, COUNTIF, lookups and dates, and answers you can check.13 min readPivot table practice: 15 exercises with answers on real sales data
Practice pivot tables in Excel on 240 sales orders. 15 exercises from a first total to quarters, % of total and filters, with answers and the field layout.12 min readLine breaks in Excel: a new line in a cell, with a formula and gone again
How to start a new line in an Excel cell with Alt+Enter, join lines with CHAR(10), remove line breaks with SUBSTITUTE or Find and Replace, and count the lines.12 min readExcel calendar 2026: build your own with week numbers and holidays
Build a 2026 calendar in Excel with formulas: dates that update themselves, week numbers, weekends and holidays highlighted, and the working days in every month.12 min readExcel inventory data: free practice file with tasks and answers
A free inventory file with 80 products to practice on: stock, reorder points, cost and price. With 12 tasks on XLOOKUP, SUMPRODUCT and COUNTIFS, and the answers.12 min readExcel customer data: free practice file with tasks and answers
A free customer list with 150 customers to practice on: names, emails, cities, orders and spend. With 13 tasks on COUNTIFS, XLOOKUP, text functions and dates.12 min readExcel data cleaning practice: a messy file with tasks and answers
A free messy Excel file to practice cleanup on: extra spaces, wrong case, text numbers, text dates, mixed phone formats and duplicates. With 14 tasks and answers.11 min readExcel finance data: free practice file with tasks and answers
A free finance file with a year of bank transactions for a small firm. With 14 tasks on income, expenses, results, SUMIFS by month and percentages, and answers.11 min readBest Excel courses online in 2026: 10 places to learn Excel, ranked
A fair, ranked list of the best places to learn Excel online in 2026, free and paid, with prices checked Nov 14, 2026 and who each one suits.10 min readBest advanced Excel courses in 2026: what to learn and where
What an advanced Excel course should cover, a quick check of whether you are ready, and eight advanced courses compared on price, format and who each one suits.9 min readUdemy vs Coursera vs LinkedIn Learning for Excel: which to pick
Udemy, Coursera and LinkedIn Learning compared for learning Excel: how each one charges, what the courses and certificates are like, and who each platform suits.7 min read
Good to know
How to use the guides
Read a guide once from top to bottom, then go back to the sections you need. The worked examples show real sheets with the result in place, and every formula is checked against Excel's behavior before it goes on the page.
Reading alone does not make you fast. When a guide mentions a function or a skill, it links to the exercise that drills it, and the practice block at the end lists them in order. Do those exercises the same day, while the idea is fresh.
Who they are for
Job seekers with an Excel test coming up, people starting in finance, accounting or admin roles, and anyone who uses Excel every day but learned it by trial and error.
The guides assume you can open a workbook and type into a cell. If you have never written a formula, start with the free Getting started section of the exercises and come back.