Home

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.

  1. 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 read
  2. Free 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 read
  3. VLOOKUP 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 read
  4. Pivot 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 read
  5. Excel 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 read
  6. Excel 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 read
  7. Dates 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 read
  8. How 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 read
  9. Excel 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 read
  10. Google 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 read
  11. Conditional 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 read
  12. How 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 read
  13. How 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 read
  14. How 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 read
  15. How 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 read
  16. How 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 read
  17. Excel 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 read
  18. Excel 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 read
  19. Pivot 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 read
  20. Line 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 read
  21. Excel 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 read
  22. Excel 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 read
  23. Excel 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 read
  24. Excel 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 read
  25. Excel 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 read
  26. Best 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 read
  27. Best 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 read
  28. Udemy 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.