---
title: "Excel guides | ExcelSavvy"
description: "Long, practical Excel guides on job interviews, IF formulas, dates, lookups, pivot tables, clean data, shortcuts and more, each linked to graded exercises."
canonical_url: "https://excelsavvy.com/learn"
meta:
  "og:description": "Long, practical Excel guides on job interviews, IF formulas, dates, lookups, pivot tables, clean data, shortcuts and more, each linked to graded exercises."
  "og:image": "https://excelsavvy.com/_og/d/c_Page%2Ctitle_Excel%2Bguides%2Cdescription_~TG9uZywgcHJhY3RpY2FsIEV4Y2VsIGd1aWRlcyBvbiBqb2IgaW50ZXJ2aWV3cywgSUYgZm9ybXVsYXMsIGRhdGVzLCBsb29rdXBzLCBwaXZvdCB0YWJsZXMsIGNsZWFuIGRhdGEsIHNob3J0Y3V0cyBhbmQgbW9yZSwgZWFjaCBsaW5rZWQgdG8gZ3JhZGVkIGV4ZXJjaXNlcy4%2Csite_practiceexcel%2Cp_Ii9sZWFybiI%2Cs_d06MgmASuCGgEns3.png"
  "og:image:height": "600"
  "og:image:type": image/png
  "og:image:width": "1200"
  "og:title": "Excel guides | ExcelSavvy"
  "twitter:image": "https://excelsavvy.com/_og/d/c_Page%2Ctitle_Excel%2Bguides%2Cdescription_~TG9uZywgcHJhY3RpY2FsIEV4Y2VsIGd1aWRlcyBvbiBqb2IgaW50ZXJ2aWV3cywgSUYgZm9ybXVsYXMsIGRhdGVzLCBsb29rdXBzLCBwaXZvdCB0YWJsZXMsIGNsZWFuIGRhdGEsIHNob3J0Y3V0cyBhbmQgbW9yZSwgZWFjaCBsaW5rZWQgdG8gZ3JhZGVkIGV4ZXJjaXNlcy4%2Csite_practiceexcel%2Cp_Ii9sZWFybiI%2Cs_d06MgmASuCGgEns3.png"
---

> Index of every page on this site: [llms.txt](https://excelsavvy.com/llms.txt)

# **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.

12 min readIFXLOOKUP

1. [**01**<h2>**Excel test for a job interview: what it looks like and how to practice**</h2>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**](https://excelsavvy.com/learn/excel-for-job-interviews)
2. [**02**<h2>**Free Excel course online: learn Excel from your first formula to job-ready**</h2>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**](https://excelsavvy.com/learn/how-to-learn-excel)
3. [**03**<h2>**VLOOKUP vs XLOOKUP vs INDEX MATCH: which lookup to use**</h2>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**](https://excelsavvy.com/learn/vlookup-vs-xlookup-vs-index-match)
4. [**04**<h2>**Pivot tables explained, and the formulas that do the same job**</h2>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**](https://excelsavvy.com/learn/pivot-tables)
5. [**05**<h2>**Excel for finance and accounting: the skills you actually use**</h2>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**](https://excelsavvy.com/learn/excel-for-finance)
6. [**06**<h2>**Excel IF formulas: from one condition to many**</h2>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**](https://excelsavvy.com/learn/excel-if-function)
7. [**07**<h2>**Dates in Excel: how they work and the formulas you need**</h2>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**](https://excelsavvy.com/learn/excel-dates)
8. [**08**<h2>**How to clean data in Excel with formulas**</h2>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**](https://excelsavvy.com/learn/clean-data-in-excel)
9. [**09**<h2>**Excel keyboard shortcuts worth learning, and how to make them stick**</h2>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**](https://excelsavvy.com/learn/excel-keyboard-shortcuts)
10. [**10**<h2>**Google Sheets vs Excel: what is the same, what is different, and how to switch**</h2>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**](https://excelsavvy.com/learn/google-sheets-vs-excel)
11. [**11**<h2>**Conditional formatting in Excel: highlight cells and rows with rules and formulas**</h2>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**](https://excelsavvy.com/learn/conditional-formatting-excel)
12. [**12**<h2>**How to create a drop-down list in Excel, and make it update itself**</h2>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**](https://excelsavvy.com/learn/drop-down-list-excel)
13. [**13**<h2>**How to lock cells in Excel: freeze rows, protect cells and lock formulas**</h2>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**](https://excelsavvy.com/learn/lock-cells-excel)
14. [**14**<h2>**How to merge cells in Excel, and what to use instead**</h2>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**](https://excelsavvy.com/learn/merge-cells-excel)
15. [**15**<h2>**How to make a graph in Excel: column, line and pie charts step by step**</h2>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**](https://excelsavvy.com/learn/excel-charts)
16. [**16**<h2>**How to calculate percentages in Excel: percent of a number, change, discount and VAT**</h2>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**](https://excelsavvy.com/learn/calculate-percentage-excel)
17. [**17**<h2>**Excel budget template: free download and the formulas behind it**</h2>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**](https://excelsavvy.com/learn/excel-budget-template)
18. [**18**<h2>**Excel practice data: free datasets with tasks and answers**</h2>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**](https://excelsavvy.com/learn/excel-practice-data)
19. [**19**<h2>**Pivot table practice: 15 exercises with answers on real sales data**</h2>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**](https://excelsavvy.com/learn/pivot-table-practice)
20. [**20**<h2>**Line breaks in Excel: a new line in a cell, with a formula and gone again**</h2>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**](https://excelsavvy.com/learn/line-break-in-excel)
21. [**21**<h2>**Excel calendar 2026: build your own with week numbers and holidays**</h2>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**](https://excelsavvy.com/learn/excel-calendar-2026)
22. [**22**<h2>**Excel inventory data: free practice file with tasks and answers**</h2>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**](https://excelsavvy.com/learn/excel-inventory-data)
23. [**23**<h2>**Excel customer data: free practice file with tasks and answers**</h2>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**](https://excelsavvy.com/learn/excel-customer-data)
24. [**24**<h2>**Excel data cleaning practice: a messy file with tasks and answers**</h2>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**](https://excelsavvy.com/learn/excel-data-cleaning-practice)
25. [**25**<h2>**Excel finance data: free practice file with tasks and answers**</h2>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**](https://excelsavvy.com/learn/excel-finance-practice-data)
26. [**26**<h2>**Best Excel courses online in 2026: 10 places to learn Excel, ranked**</h2>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**](https://excelsavvy.com/learn/best-places-to-learn-excel)
27. [**27**<h2>**Best advanced Excel courses in 2026: what to learn and where**</h2>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**](https://excelsavvy.com/learn/best-advanced-excel-courses)
28. [**28**<h2>**Udemy vs Coursera vs LinkedIn Learning for Excel: which to pick**</h2>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**](https://excelsavvy.com/learn/udemy-vs-coursera-vs-linkedin-learning-excel)

## **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.

```json
{"@context":"https://schema.org","@graph":[{"@id":"https://excelsavvy.com/#identity","@type":"Organization","name":"ExcelSavvy","url":"https://excelsavvy.com/","logo":{"@id":"https://excelsavvy.com/#logo"}},{"@id":"https://excelsavvy.com/#website","@type":"WebSite","inLanguage":"en-US","name":"ExcelSavvy","url":"https://excelsavvy.com/","alternateName":["Excel Savvy","ExcelSavvy.com","PracticeExcel","Practice Excel Online"],"publisher":{"@id":"https://excelsavvy.com/#identity"},"workTranslation":[{"@id":"https://excelopgaver.dk/#website"},{"@id":"https://excelpraxis.de/#website"}]},{"@id":"https://excelsavvy.com/learn#webpage","description":"Long, practical Excel guides on job interviews, IF formulas, dates, lookups, pivot tables, clean data, shortcuts and more, each linked to graded exercises.","name":"Excel guides","url":"https://excelsavvy.com/learn","@type":["WebPage","CollectionPage"],"breadcrumb":{"@id":"https://excelsavvy.com/learn#breadcrumb"},"isPartOf":{"@id":"https://excelsavvy.com/#website"},"potentialAction":[{"@type":"ReadAction","target":["https://excelsavvy.com/learn"]}],"primaryImageOfPage":{"@id":"https://excelsavvy.com/#logo"}},{"@id":"https://excelsavvy.com/learn#breadcrumb","@type":"BreadcrumbList","itemListElement":[{"@type":"ListItem","name":"Home","item":"https://excelsavvy.com","position":1},{"@type":"ListItem","name":"Excel guides","position":2}]},{"@id":"https://excelsavvy.com/#logo","@type":"ImageObject","caption":"ExcelSavvy","contentUrl":"https://excelsavvy.com/brand/practiceexcel/icon-512.png?v=3","inLanguage":"en-US","url":"https://excelsavvy.com/brand/practiceexcel/icon-512.png?v=3"}]}
```

## Sitemap

See the full [sitemap](https://excelsavvy.com/sitemap.md) for all pages.
