# ExcelBack (excelback.com)

> Practical Microsoft Excel learning library: 143+ free ExcelBack-authored .xlsx practice datasets, searchable 131-function reference, 10 client-side browser tools, 30+ downloadable .xlsx templates, 26 free ebooks, 27 structured topic paths, 13 course paths (including the interactive Beginners Focus Classroom), and a curated directory.

ExcelBack organizes spreadsheet knowledge around real business workflows: practice datasets, lookup formulas, data cleaning, Power Query, PivotTables, VBA automation, financial modeling, and KPI dashboards. Every practice dataset, browser tool, individual template, function reference page, and online ebook is free to use with no account required.

## Core Sections & Hubs

- [Free Excel Practice Datasets (143+ .XLSX Workbooks)](https://excelback.com/datasets/): Download 143 realistic practice datasets authored by ExcelBack across Accounting, Finance, Healthcare, HR & Operations, Marketing, Sales & CRM, E-commerce, Retail, Lookup Formulas (XLOOKUP/VLOOKUP), PivotTables, SUMIFS & COUNTIFS, Data Cleaning, Text Functions, Financial Modeling, Power Query & ETL, Date & Time, Charts & Dashboards, and Conditional Formatting — each with an HTML sample preview and an ExcelBack_Guide challenge sheet at https://excelback.com/datasets/<slug>/.
- [Function Reference (131 Functions)](https://excelback.com/functions/): Syntax, arguments, worked examples, error tables, and playbooks for VLOOKUP, XLOOKUP, INDEX, MATCH, SUMIFS, FILTER, UNIQUE, and 124 more functions.
- [Free Browser Tools (10 Interactive Utilities)](https://excelback.com/tools/): Client-side Formula Builder, Formula Explainer, CSV Cleaner, Duplicate Finder, Column Splitter, Date Calculator, Percentage Calculator, Practice Data Generator, Text Case Converter, and Reference Converter.
- [Free Excel Templates (30+ .xlsx Workbooks)](https://excelback.com/templates/): Ready-to-use .xlsx workbooks including Monthly Budget Tracker, Invoice Template, Project Tracker, Gantt Timeline, CRM Contact Tracker, Inventory Tracker, and Debt Payoff Calculator.
- [Free Excel Ebooks (26 Full-Length Guides)](https://excelback.com/ebooks/): Read free online in the browser or download the printable PDF via free Google sign-in.
- [Excel Topics (27 Learning Paths)](https://excelback.com/topics/): Structured subtopics, real Excel screenshots, and curated YouTube tutorials from basics to Power Pivot and VBA.
- [Course Paths (13 Guided Curricula)](https://excelback.com/courses/): Step-by-step video lesson sequences organized by skill level, plus the interactive Beginners Focus Classroom at https://excelback.com/classroom/beginners-in-excel/.
- [Tutorials & Comparison Articles (62 Deep Dives)](https://excelback.com/articles/): Practical how-to guides, checklists, and side-by-side software comparisons.
- [Curated Resource Directory](https://excelback.com/directory/): Official Microsoft documentation, add-ins, templates, communities, and training sites.

## Popular Practice Dataset Tracks (/datasets/)

- Lookup & Formula Practice: [VLOOKUP & XLOOKUP Product Lookup](https://excelback.com/datasets/vlookup-xlookup-practice-dataset/), [SUMIFS / COUNTIFS Multi-Condition Sales](https://excelback.com/datasets/sumifs-countifs-practice-dataset/), [Dynamic Arrays FILTER & LAMBDA](https://excelback.com/datasets/lambda-dynamic-arrays-practice/)
- Data Cleaning & Power Query: [Messy Data Cleanup Lab](https://excelback.com/datasets/messy-data-cleanup-practice/), [Unpivot 6-Month Budget Cross-Tab](https://excelback.com/datasets/pq-unpivot-six-month-budget-matrix/), [Messy Contact Text Functions](https://excelback.com/datasets/text-functions-practice-dataset/)
- PivotTables, Charts & Dashboards: [Sales Transactions Pivot Dataset](https://excelback.com/datasets/pivot-table-practice-sales-data/), [Global Store Transactions](https://excelback.com/datasets/pivot-global-store-transactions/), [Charts & KPI Trend Series](https://excelback.com/datasets/charts-visualization-practice-data/)
- Finance, AR & Operations: [Loan Amortization Financial Model](https://excelback.com/datasets/financial-modeling-loan-amortization/), [Corporate FP&A Budget Variance](https://excelback.com/datasets/fpa-monthly-budget-variance-pack/), [AR Aging 30/60/90+ Heatmap](https://excelback.com/datasets/cf-ar-aging-heatmap-buckets/)

## Interactive Browser Tools

- [Formula Builder](https://excelback.com/tools/formula-builder/): Build XLOOKUP, VLOOKUP, IF, SUMIFS, and INDEX/MATCH formulas step by step.
- [Formula Explainer](https://excelback.com/tools/formula-explainer/): Paste any nested Excel formula for a plain-English explanation.
- [CSV Cleaner](https://excelback.com/tools/csv-cleaner/): Trim whitespace, strip non-breaking spaces, remove blank rows, and deduplicate CSV data locally in the browser.
- [Duplicate Finder](https://excelback.com/tools/duplicate-finder/): Highlight and extract unique or duplicate values from any pasted column.
- [Column Splitter](https://excelback.com/tools/column-splitter/): Split delimited or fixed-width text into spreadsheet columns.
- [Date Calculator](https://excelback.com/tools/date-calculator/): Calculate calendar days or business workdays between dates.
- [Percentage Calculator](https://excelback.com/tools/percentage-calculator/): Compute percentage change, margin, markup, and share of total.
- [Practice Data Generator](https://excelback.com/tools/data-generator/): Generate realistic synthetic CSV/Excel datasets for testing formulas and PivotTables.
- [Text Case Converter](https://excelback.com/tools/text-case-converter/): Convert text between UPPERCASE, lowercase, Proper Case, and Sentence case.
- [Reference Converter](https://excelback.com/tools/reference-converter/): Convert between A1 and R1C1 notation and toggle $ absolute/relative locks.

## Popular Function Reference Pages

- [XLOOKUP()](https://excelback.com/functions/xlookup/): Modern left/right lookup with built-in if_not_found, tier match modes, and reverse search.
- [VLOOKUP()](https://excelback.com/functions/vlookup/): Classic vertical table lookup with exact and approximate matching.
- [INDEX()](https://excelback.com/functions/index-fn/): Non-volatile 2D coordinate lookup and dynamic range builder.
- [MATCH()](https://excelback.com/functions/match/): Relative row or column position lookup.
- [SUMIFS()](https://excelback.com/functions/sumifs/): Multi-criteria conditional sum across date windows, regions, and categories.
- [FILTER()](https://excelback.com/functions/filter/): Dynamic array filtering with AND (*) and OR (+) boolean criteria.
- [UNIQUE()](https://excelback.com/functions/unique/): Dynamic distinct value extraction for dropdowns and summary tables.
- [IF()](https://excelback.com/functions/if/) & [IFS()](https://excelback.com/functions/ifs/): Conditional branching logic.
- [SUBTOTAL()](https://excelback.com/functions/subtotal/): Filter-aware aggregation that prevents double-counting nested subtotals.

## Pricing

- **Individual Tools, Templates, Articles & Web Ebooks**: **$0.00 USD (Free)** — no login or credit card required. Downloading an ebook's PDF needs a free Google sign-in.

## Machine-Readable Endpoints & Agent Interfaces

- Search Index JSON: [https://excelback.com/search-index.json](https://excelback.com/search-index.json)
- Directory Index JSON: [https://excelback.com/directory-index.json](https://excelback.com/directory-index.json)
- Sitemap Index: [https://excelback.com/sitemap-index.xml](https://excelback.com/sitemap-index.xml)
- MCP Server Card (SEP-1649): [https://excelback.com/.well-known/mcp/server-card.json](https://excelback.com/.well-known/mcp/server-card.json)
- MCP HTTP Endpoint: [https://excelback.com/api/mcp](https://excelback.com/api/mcp)
- Contact & Support: mailto:support@excelback.com | [https://excelback.com/contact/](https://excelback.com/contact/)
- Legal & Disclosures: [https://excelback.com/legal/](https://excelback.com/legal/)
