Excel Mastery – PDF Workbooks
Excel Mastery as 4 hands-on PDF workbook volumes (2,154 pages, 844 lessons). Every volume has worked labs, quizzes and a full solutions appendix — instant download, free sample in every book.
More: Excel & Business Workbooks · all books
All 4 volumes
What you will learn in Excel Mastery
These workbooks cover 42 complete courses (selection below):
- Excel for Beginners: Your First Real Spreadsheet
- Excel for Finance
- Excel Essentials: Beginner to Advanced
- Advanced Excel Formulas & Functions Masterclass
- Excel Charts & Data Visualization
- What-If Analysis: Scenarios, Data Tables & Goal Seek
- Excel Dashboards & Reports
- Excel Basics: From Your First Formula to a Savings Tracker
- Google Sheets for Business
- Excel for Accountants: Reconciliations, Ledgers & Month-End
- Excel IF & Logical Functions: From Simple IF to IFS, SWITCH & Nested Logic
- Excel Dates & Times: DATE, EOMONTH, NETWORKDAYS, Time Math & Schedules
- Excel Lookup Masterclass: XLOOKUP, INDEX/MATCH, VLOOKUP & Two-Way Lookups
- Excel Text Functions: LEFT, MID, FIND, SUBSTITUTE & Clean Data
- Excel Data Validation & Error-Proof Templates
- Excel Conditional Formatting: Highlight Rules, Data Bars & Heat Maps
- Excel Financial Functions: PMT, IPMT, NPV, XNPV, IRR, XIRR & RATE
- Excel Statistical Functions: AVERAGEIFS, MEDIAN, PERCENTILE, RANK & FREQUENCY
- SUMPRODUCT & Array Formulas: Multi-Condition Sums, Counts and Lookups
- Excel Formula Errors & Auditing: #N/A, #VALUE!, #REF! and How to Fix Them
- Excel Rounding & Precision: ROUND, MROUND, CEILING, Currency & Floating-Point Traps
- Excel Invoice & Quote Templates: Line Items, Tax, Numbering & Payment Tracking
- Sorting & Filtering with Formulas: Top-N Lists, Dynamic Rankings & Extracts (No FILTER Needed)
- Excel Time Intelligence: MTD, YTD, YoY, Rolling 12 Months & Fiscal Years
- Excel Named Ranges & Readable Models: Constants, Names and the Name Box
- Excel Trackers: Habit, Task, Expense & Goal Trackers with Formulas
- Excel Dynamic Arrays: FILTER, SORT, UNIQUE, SEQUENCE & Spill Ranges
- Excel LET & LAMBDA: Readable Formulas, Custom Functions & MAP/REDUCE
- Pivot-Style Summary Reports with Formulas: UNIQUE, SUMIFS, Cross-Tabs & Subtotals
- Percentages in Excel: Percent Change, % of Total, Markup vs Margin & CAGR
- Excel Calendars & Schedules: Dynamic Monthly Calendar, Shift Rota & Gantt with Formulas
- Loan Amortization Schedules in Excel: PMT, IPMT, PPMT, Extra Payments & Balloons
- Weighted Scoring Models in Excel: Decision Matrices, Normalisation & Sensitivity
- Combining Tables in Excel: VSTACK, HSTACK, Lookups, GROUPBY & Reconciliation
- Comparing Two Lists in Excel: Matches, Missing Records, Changed Values, Tolerances & Exception Reports
- Scoring Competitions & Awards in Excel: Judges' Panels, Dropping High & Low, Weighted Criteria, Judge Normalisation & Tie-Breaks
- Engineering Calculation Sheets in Excel: Units, Interpolation in Design Tables, Iteration, Tolerance Stack-Ups & Design Checks
- Pro-Rata Calculations in Excel: Daily Rates, Partial Months, Joiners & Leavers, Mid-Cycle Plan Changes & Splitting Amounts by Period
- Retail & 4-4-5 Fiscal Calendars in Excel: Fiscal Weeks, Periods, 53-Week Years, Comparable Weeks & Weekly Sales Reports
- Tiered & Banded Calculations in Excel: All-Units vs Incremental Tiers, Block Tariffs, Volume Rebates, Stepped Costs & Band Lookups
Prices are $14.99 per PDF workbook. One-time payment, no subscription.