For IndividualsFor Analysts & FinanceFor Students & LearnersFor Teams & Automation
MENU
TUTORIALS

Free Excel articles & tutorials | 62 worked guides

Step-by-step tutorials written and worked through here, with real formulas, screenshots, and side-by-side software comparisons.

Start with XLOOKUP vs INDEX MATCH

Want longer, book-length Excel field guides?

Read our 16 illustrated ebooks online for free — or download the printable PDF editions.

Browse 16 free ebooks
=TOPICSJump to any topic roadmap or filter articles below

Original tutorials & comparisons

Written and worked through here, with example formulas, screenshots, and practical templates.

Showing 62 of 62

The Excel =COPILOT function changed in 2026: what to use now

The Excel =COPILOT worksheet function is no longer available from September 2026. Learn what changed and which Copilot, Power Query, and formula workflows to use instead.

Read guide →

Excel Copilot skills in 2026: Clean Data, Skill Builder, and Get Data explained

Learn when to use Excel Copilot's new Clean Data, Skill Builder, Skill Recorder, and Get Data workflows — and how to verify the result.

Read guide →

What's new in Excel: October 2026 update

A practical guide to the October 2026 Excel update, including Clean Data, Copilot skills, Get Data, and naming tables as you create them.

Read guide →

Ablebits vs Kutools: which Excel add-in suite should you buy?

Two add-in suites that look interchangeable on a feature list and are not. One is a set of deep data tools; the other is 300 shortcuts for things Excel makes tedious. How to tell which one your week actually calls for.

Read guide →

Claude for Excel vs Microsoft Copilot: which AI tool should you use?

One sits inside the workbook and can read your rows; the other sits outside it and reasons about formula logic. That single difference decides which questions each can answer — and which answers you still have to check.

Read guide →

Combo charts and dynamic chart ranges in Excel

Two chart techniques that come up in almost every real report: combining two chart types on a secondary axis, and building a chart that grows on its own as new data arrives.

Read guide →

Coursera vs Udemy for Excel courses: what's the difference?

The real split is not price or quality — it is whether you need deadlines and a credential, or a cheap fix for one specific gap. How each platform's Excel catalogue actually works, and the failure mode of each.

Read guide →

DataCamp vs LinkedIn Learning for Excel: which is worth the subscription?

One makes you type formulas into a browser and marks them; the other is a very large video library you watch while following along. They suit different learners, and one of them is probably already paid for.

Read guide →

Excel Campus vs Chandoo: which learning site is right for you?

Two long-running independent Excel sites with genuinely different centres of gravity — automation and reusable systems versus analysis and dashboard thinking. Which suits the work you actually do.

Read guide →

Excel Copilot vs Formula Bot: which AI formula tool is worth it?

Both turn plain English into a formula. One costs a licence and can read your workbook; the other is cheap and reasons from what you tell it. What that difference means for the formulas you get back.

Read guide →

Excel desktop vs Excel Online: key differences that matter in practice

What Excel for the web can and cannot do compared with the desktop app — the gaps that break a shared workbook, the file-size ceiling, and what changes when a colleague opens your file in a browser.

=XLOOKUP()=FILTER()=LAMBDA()
Read guide →

Excel Tables vs named ranges: which should you use?

What each one actually is, the five jobs only a named range can do, why dynamic named ranges are mostly obsolete, and the layered pattern most well-built workbooks end up using.

=OFFSET()=INDEX()=INDIRECT()+2
Read guide →

Excel vs Google Sheets formulas: what actually translates?

The core hundred functions are identical. What breaks when a file crosses over is rarely a missing function — it is locale, array behaviour, and the handful of genuinely one-sided features worth knowing by name.

=XLOOKUP()=FILTER()=LET()
Read guide →

Excel vs Google Sheets for small teams: which one to use?

The row limits, the collaboration difference that is smaller than it used to be, what each one does that the other genuinely cannot, and the migration costs nobody budgets for.

=XLOOKUP()=FILTER()=UNIQUE()+1
Read guide →

Google Apps Script vs Excel VBA: the Sheets-side equivalent to VBA

Apps Script does VBA's job for Google Sheets, but it runs on Google's servers under quotas, speaks JavaScript, and punishes cell-by-cell code far harder than VBA does. What to unlearn when you cross over.

Read guide →

Build a one-page KPI dashboard in Excel

A worked layout for a scannable, one-page Excel dashboard — headline KPI cards, a supporting trend chart, and the design decisions that keep it readable instead of busy.

=SUMIFS()=IF()
Read guide →

MrExcel vs ExcelJet: which reference site should you use?

Two very different things that both call themselves Excel references — a curated function library and a 25-year forum archive. Which one answers which kind of question, and how to search each properly.

=XLOOKUP()=SUMPRODUCT()
Read guide →

Notion vs Excel for databases: which fits your tracker or CRM?

Trackers, light CRMs and content calendars fit awkwardly in both tools. The decision comes down to four tests — who edits it, what gets calculated, how many rows, and how you get out — and most people get the last one wrong.

Read guide →

Pivot tables vs formulas for summarising data: which to use?

The exploring-versus-reporting distinction that decides it, what each one can express that the other cannot, why GETPIVOTDATA keeps appearing in your formulas, and the hybrid pattern most workbooks end up with.

=SUMIFS()=COUNTIFS()=SUMPRODUCT()+1
Read guide →

Power BI vs Excel dashboards: has your workbook outgrown Excel?

Not a tool comparison — a diagnosis. Five concrete symptoms that mean a dashboard workbook has hit a limit Excel was never built to solve, and what moving actually costs you.

Read guide →

Power Query vs Excel formulas for data cleaning: when to use each

They work at different layers, so the real question is not which is better but where the boundary sits. Five tests that place any cleaning job on one side or the other, and the hybrid most workbooks should use.

=TRIM()=TEXTSPLIT()=FILTER()
Read guide →

Power Query vs VBA for data cleanup: how to choose

What Power Query genuinely cannot do, what VBA costs you in maintenance and trust prompts, the folder-import case that decides it most often, and the hybrid split that works in practice.

Read guide →

Preparing Excel data for a clean Power BI handoff

You don't need to learn Power BI to make your Excel data ready for it. The shape your data needs to be in, and what to fix in Excel before anyone connects a report to it.

Read guide →

SUMIFS vs SUMPRODUCT: when each formula is the right choice

Where SUMIFS runs out — partial matches, OR logic, calculated criteria, and weighted sums — what SUMPRODUCT costs you in speed and readability, and what FILTER changes on modern Excel.

=SUMIFS()=SUMPRODUCT()=COUNTIFS()+2
Read guide →

VBA snippets you'll reuse constantly

Copy-pasteable VBA for the things every macro needs — finding the last row, looping a folder, handling errors, and the array pattern that makes a slow macro fast.

Read guide →

VBA editor basics: modules, Subs, and the Immediate window

A tour of the VBA editor for anyone past recorded macros — Project Explorer, modules, Sub vs Function, running code, and Option Explicit.

Read guide →

VBA error handling and debugging

On Error Goto vs Resume Next, using breakpoints and Step Into to watch code run, and a clean pattern for handling errors without leaving a mess behind.

Read guide →

VBA loops and conditions: For Each, Do While, and If/Select Case

Which loop to reach for and why, how If and Select Case differ in practice, and the three mistakes — deleting forward, looping cells one at a time, and the infinite Do While — that cause most loop bugs.

Read guide →

VBA vs Power Automate: which one should automate your Excel task?

The deciding question is not which is more powerful — it is what starts the work. If a person starts it, VBA. If an event or a clock starts it, Power Automate. Plus the pattern for when the answer is both.

Read guide →

Workbook and worksheet events in VBA

How to run code automatically on Workbook_Open, Worksheet_Change, and Worksheet_SelectionChange, where that code has to live, and the infinite-loop gotcha that trips up nearly every beginner.

Read guide →

XLOOKUP vs INDEX/MATCH: which lookup formula should you use?

What XLOOKUP's six arguments actually buy you, the three jobs INDEX/MATCH still does better, how each behaves on large models, and a decision rule you can apply without thinking about it.

=XLOOKUP()=INDEX()=MATCH()+2
Read guide →

Zapier vs Power Automate: which one should automate your Excel workflow?

Both move data in and out of Excel without code. The choice turns on where your other tools live, how Excel-aware the actions need to be, and a pricing model that behaves very differently as volume grows.

Read guide →

AI extensions for Excel and what each one actually does

Sidebar assistants, worksheet functions that call a model, and formula generators — what each kind is for, and where each one fails.

Read guide →

Make an Excel workbook easier to read and use

Contrast ratios that survive a cheap monitor, never coding by colour alone, tab order and named cells for keyboard and screen-reader users, alt text that says something, and the Accessibility Checker's real limits.

Read guide →

How to clean a customer list in Excel

Turn a messy customer export into something you can safely import — backup discipline, TRIM and CLEAN, name and email normalisation, finding near-duplicates that exact matching misses, and the validation pass before handover.

=TRIM()=CLEAN()=PROPER()+5
Read guide →

Use conditional formatting for KPI flags

Build red/amber/green KPI signals that stay readable — thresholds in cells not rules, one helper column driving the format, text alongside colour, and the edge cases that make flags lie.

=IF()=IFS()=IFERROR()+2
Read guide →

Clean data before building a pivot table

The seven checks that stop a pivot table reporting the wrong number — headers, blanks, text dates, duplicates, mixed types, stray totals, and the grand-total tie-out.

=ISNUMBER()=COUNTIF()=TRIM()+1
Read guide →

Create better dropdown lists in Excel

Build data validation dropdowns that grow on their own, show a useful prompt, cascade from a first choice, and survive the lists changing — plus how to find the entries that were typed before you added the rule.

=INDIRECT()=COUNTIF()=FILTER()+1
Read guide →

Excel Copilot prompt ideas for spreadsheet work

Prompts that work for formulas, cleanup, and summaries — why naming your Table and columns changes the answers, how to verify what you get back, and what to keep out of the prompt box entirely.

=XLOOKUP()=SUMIFS()=IFERROR()
Read guide →

Workbook review checklist before sending an Excel file

The ten-minute pass before you attach a workbook — filters, hidden sheets, broken links, errors, personal metadata, cached pivot data, and the recipient test that catches the rest.

=IFERROR()
Read guide →

Excel Table vs normal range

What converting a range to an Excel Table actually changes — auto-expansion, structured references, the total row, pivot and Power Query behaviour — and the four layouts where a Table is the wrong choice.

=SUMIFS()=SUBTOTAL()=COUNTIFS()
Read guide →

Excel formula audit checklist

A working checklist for reviewing a model before it goes out — consistency breaks, hardcoded values, the errors that are hidden rather than fixed, circular references, volatile functions, and control totals that actually catch things.

=IFERROR()=SUMIFS()=COUNTIF()+2
Read guide →

Clean a bank statement export in Excel

Import a bank CSV without destroying account numbers or dates, normalise debit/credit columns into one signed amount, parse the description field, and add the columns reconciliation actually needs.

=TRIM()=LEFT()=RIGHT()+3
Read guide →

Inventory reorder point tracker in Excel

Turn a stock list into an action list — reorder point from usage and lead time, safety stock that reflects variability, days-of-cover, the movement log that keeps stock figures honest, and the exception view the team actually uses.

=IF()=SUMIFS()=IFERROR()+3
Read guide →

Build a simple invoice tracker in Excel

An invoice tracker that answers who owes you money, when it was due, and what to chase — with the two-table structure that handles part payments and an ageing summary built from SUMIFS.

=SUMIFS()=TODAY()=MAX()+3
Read guide →

Monthly sales report checklist for Excel

A build order for a monthly sales report that refreshes instead of being rebuilt — the five sheets, the checks that run before the charts, the comparisons that make a number mean something, and the half-hour close routine.

=SUMIFS()=XLOOKUP()=COUNTIFS()+2
Read guide →

When to use named ranges in Excel models

Where named ranges earn their place in a model, where they cost more than they save, scope and naming conventions, the dynamic-name trap, and how to audit the Name Manager before sharing.

=INDIRECT()=OFFSET()=INDEX()+1
Read guide →

Pivot table report for managers

Design a pivot table report that answers one manager question clearly — field choices, value formatting, Show Values As, slicers that match how people think, and the layout settings that stop a pivot looking like a data dump.

Read guide →

Power Query refresh checklist

What to check before and after a Power Query refresh — source paths, renamed columns, the Changed Type trap, error rows, and the row-count tie-out that catches silent data loss.

Read guide →

Prepare an Excel dashboard for PDF export

Print areas, page breaks, scaling that stays legible, headers that give a forwarded PDF its context, and the chart and slicer problems that only appear once you open the exported file.

Read guide →

Create a simple project tracker in Excel

A task tracker that stays current — one row per task, calculated status instead of typed, a conditional-formatting Gantt that needs no add-in, and the weekly view that makes the file worth updating.

=IF()=IFS()=TODAY()+4
Read guide →

Design a reusable Excel budget template

Build a budget template that survives next year — separated inputs, a flat entry table, SUMIFS-driven summaries, version-proof categories, built-in checks, and protection that guides rather than blocks.

=SUMIFS()=COUNTIFS()=IF()+1
Read guide →

Variance analysis in Excel for budget reviews

Compare actuals to budget with variance amount, variance percent, comments, and simple management flags — plus the SUMIFS layout that keeps the whole thing refreshable.

=SUMIFS()=IF()=IFERROR()+1
Read guide →

Create a simple formatting system for Excel workbooks

A colour convention, a number-format standard, and a sheet-naming scheme that make a workbook readable to someone who has never opened it — saved as Cell Styles so it actually sticks.

Read guide →

How to create a chart in Excel (and pick the right one)

Inserting a chart takes one click. Choosing the type that answers the question, and stripping the default clutter back to something readable, is the part that decides whether anyone understands it.

Read guide →

20 Excel keyboard shortcuts that actually save time

Grouped by the job they do, with the Mac equivalents and the three that are worth learning before any of the others. Plus the Alt-key system that gives you every ribbon command without memorising anything.

Read guide →

How to create a pivot table in Excel (step-by-step)

Build your first pivot table: the data shape it requires, the four drop zones and what each does, how to change the summary, and the handful of failures that catch everyone the first month.

Read guide →

Getting started with Power Query: import and clean data automatically

Pull data into Excel, reshape it through recorded steps, and load the result — then do next month's version with one click. The transforms worth learning first and the two that cause most refresh failures.

Read guide →

Excel's Quick Analysis tool: instant totals, charts, and formatting

What each of the five Quick Analysis tabs actually produces, the Totals tab's row-versus-column trap, why the icon sometimes doesn't appear, and where it stops being the right tool.

=SUM()=AVERAGE()=SUBTOTAL()
Read guide →

Record your first macro in Excel (no coding required)

Turn on the Developer tab, record a repetitive task, and replay it with one click — plus the relative-references setting, why recorded macros break, and how to read what Excel wrote.

Read guide →

3 ways to remove duplicates in Excel

Remove Duplicates, UNIQUE, and Power Query compared — what each one keeps, what it silently discards, how to find duplicates before deleting them, and the near-duplicates none of the three will catch.

=UNIQUE()=COUNTIF()=COUNTIFS()+2
Read guide →

How to use VLOOKUP in Excel (with examples)

A plain-English guide to VLOOKUP — the syntax, a worked example, why the fourth argument causes most VLOOKUP bugs, how to fix #N/A for real, and when XLOOKUP or INDEX/MATCH is the better answer.

=VLOOKUP()=XLOOKUP()=INDEX()+3
Read guide →