Tabellab
Excel Mastery 4
The Big, Comprehensive Workbook: 220+ Lessons on Loan Schedules, Scoring Models, Combining Tables and List Comparison – Hands-On Labs with Full Solutions
- 603pages
- 220lessons
- 11courses
- 220exam questions
$14.99PDF · instant download
- Secure checkout with Stripe (cards, Apple Pay, Google Pay)
- Download link by email — valid 12 months
- Full solutions appendix included
What's inside
Excel Mastery 4: 11 courses, 220 hands-on lessons, with a full solutions appendix.
Learn by doing. Every lesson starts with a clear goal and a short explanation, shows the worksheet cell by cell, and gives you tasks to solve on your own computer in Excel, LibreOffice Calc or Google Sheets. When you are done, check your formulas against the solutions and hints in the appendix and correct your sheet.
- 11 complete courses, 220 lessons, 220 exam questions with answers
- Worksheets with row and column labels – easy to type in
- Tasks with exact solutions and hints in the appendix
- All figures are fictional practice data
Every course is also available as an interactive course on tabellab.com, where each cell is checked instantly.
Courses in this book
- 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
- Allocation & Matching in Excel: FIFO Payments to Invoices, Stock to Orders, Fair-Share Rationing, Capacity Allocation & Matching Two Lists
- Averages Done Right in Excel: Weighted Means, Averages of Rates & Ratios, Geometric Growth, Time-Weighted Balances & the Average-of-Averages Trap
Details
| Format | PDF, US Letter (8.5 × 11 in) |
|---|---|
| Language | English |
| Pages | 603 |
| Series | The Tabellab Workbook, volume 4 |
| Author | Babala Özdemir |
| Delivery | Instant download after payment |
