Free tools
Try our free browser tools too
Formula builder, formula explainer, CSV cleaner, and 7 more interactive tools — no upload, no sign-up. Practice what you read.
Browse free toolsLonger, structured guides you can read right here in the browser with no account at all. Want the PDF? That needs a free, one-click Google sign-in — no payment, no paywall.
Everything you need to know about Excel's conditional formatting: highlight rules, top/bottom rules, data bars, color scales, icon sets, formula-based rules, managing and debugging rules, and real-world use cases. Hands-on examples throughout.
A hands-on guide to creating clear, effective Excel charts: choosing the right chart type, formatting for readability, combo charts with dual axes, sparklines, and building dashboard-ready visuals. Real worked examples throughout.
A complete beginner walkthrough for building your first PivotTable: rows, columns, values, and filters, grouping dates, changing how values summarize, slicers, sorting, and keeping it fresh when your data changes. Real practice data throughout.
Every keyboard shortcut worth memorizing, organized by what you're trying to do - navigation, selection, editing, formatting, and formulas - not an alphabetical wall of keys. Windows shortcuts throughout, with the Mac equivalent noted wherever it genuinely differs.
Fix messy imported data fast — remove duplicates, strip extra spaces, split columns, repair dates, and turn raw exports into analysis-ready tables.
Every Excel date and time function explained with practical examples — from TODAY() and NETWORKDAYS to custom date arithmetic.
Build clean, interactive Excel dashboards from scratch — KPI tiles, dynamic charts, slicers, and a layout that impresses.
Master the Excel skills that matter most in finance: financial functions, variance analysis, budget models, and professional workbook design.
Master INDEX and MATCH individually, then combine them for left lookups, two-way lookups, multi-criteria matches, and patterns XLOOKUP still can't do.
Unlock modern Excel: write reusable custom functions with LAMBDA, LET, and the dynamic array functions that replace complex old formulas.
Record, edit, and write simple VBA macros to automate repetitive Excel work — no programming background needed.
A genuine quick-reference across every function category on this site - lookup, logical, math, statistical, text, date, financial, and information - condensed to syntax and a one-line purpose, each linked to its full explanation.
Every practical lookup pattern in one place - exact match, approximate match, multi-criteria, two-way lookups, wildcards, and graceful error handling for XLOOKUP, VLOOKUP, and INDEX/MATCH. Copy-paste-ready syntax, verified correct.
A complete starting point for Excel: the screen, entering and formatting data, how formulas work, the functions everyone should know, and a gentle introduction to charts and PivotTables.
The paid-tier upgrade from Excel for Beginners: one continuous small-business scenario carried through lookups, data validation, named ranges, dynamic arrays, PivotTables, dashboards, Power Query, and your first macro.
No ebooks match your filters.
26 places we cite for accuracy. We link to them; none has reviewed, endorsed, or collaborated on this site.
Official documentation
Educators and channels
ExcelJet (opens in a new tab)
MyOnlineTrainingHub (opens in a new tab)
XelPlus (opens in a new tab)
Excel Campus (opens in a new tab)
Wise Owl (opens in a new tab)
Teacher's Tech (opens in a new tab)
YouTube (opens in a new tab)Course platforms
