Excel & Business Workbooks (PDF)

What you will learn

These workbooks cover 921 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.