Free ebooks
Read offline with our free ebooks
Structured, chapter-length guides on formulas, beginner skills, intermediate techniques, and lookups — read online or download the PDF for offline learning.
Browse free ebooksOriginal tutorials & comparisons
Written and worked through here, with example formulas, screenshots, and practical templates.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
No tutorials matched your search.
Clear your search filter or switch back to all skill levels.











































