Seven books · One complete Excel education

Master Excel.
One lesson at a time.

Start with your very first cell, build practical workplace skills, and finish with dashboards and automation. A clear, project-driven series by John S. Purkey.

Explore all seven books See the reading path

THE EXCEL MASTERY SERIES

Master Excel — one book, one skill at a time.

The Excel Mastery Series takes you from absolute beginner to dashboard builder and beyond. Start with The Excel Book if you've never opened a spreadsheet, then conquer Excel's most useful function (IF), its most powerful lookup (XLOOKUP), bulletproof forms, PivotTables, and dashboards — and finish with VBA automation for those ready to make Excel do the work for them.

Every book is illustrated, hands-on, and built around real projects you'll actually use. No fluff, no filler — just one lesson at a time until the skill is yours.

The complete shelf: The Excel Book (prequel) · The IF Book (Vol. 1) · The XLOOKUP Book (Vol. 2) · The Forms Book (Vol. 3) · The PivotTables Book (Vol. 4) · The Dashboard Book (Vol. 5) · The VBA Book (spin-off)

01 / THE COMPLETE SHELF

A book for every stage.

Each volume focuses tightly on one essential skill, with illustrated instruction, complete buildable projects, answer keys, quick-reference material, and a clear path to the next level.

The prequel · Start here

The Excel Book

For the absolute beginner who has never used Excel. Learn the ribbon, cells, formatting, sorting, first formulas and charts—then bring it all together in a personal-budget capstone.

19 chapters · 95 pages

Volume 1

The IF Book

Master Excel's most useful decision-making function, from simple true-or-false logic through nested rules, dashboards, VBA, and practical business patterns.

22 chapters · 100 pages

Volume 2

The XLOOKUP Book

Find anything in Excel with exact, approximate, reverse, multi-criteria, and two-way lookups—plus a practical translation guide for readers coming from VLOOKUP.

87 pages

Volume 3

The Forms Book

Build spreadsheets people can't break with validation, controls, protection, VBA UserForms, and a complete order-entry system.

18 chapters · 100 pages

Volume 4

The PivotTables Book

Turn thousands of rows into answers using grouping, slicers, calculated fields, PivotCharts, GETPIVOTDATA, and a finished sales dashboard.

18 chapters · 89 pages

Volume 5 · The finale

The Dashboard Book

Bring every skill together across five complete dashboard builds: sales, project health, financial performance, HR, and personal finance.

18 chapters · 104 pages

The spin-off

The VBA Book

Go from recording a macro to building real automation with the object model, events, UserForms, error handling, Outlook, add-ins, and a Report Automator capstone.

20 chapters · 111 pages

02 / READING PATH

From first cell to full automation.

Read straight through for the complete journey, or enter at the volume that matches the work in front of you.

0
ExcelCore confidence
1
IFDecision logic
2
XLOOKUPFind anything
3
FormsSafer input
4
PivotTablesFast analysis
5
DashboardsBring it together
+
VBAAutomate it
← Back to the series

03 / FREE COMPANION FILES

Build it yourself. Then check your work.

Choose Starter for the blank workbook you begin with, then open Answer when you are ready to compare your finished project.

95 free downloads · 43 starters · 43 answers · 9 supporting files

The Excel Book cover The prequel · Start hereThe Excel Book1 project · 2 files
The IF Book cover Volume 1The IF Book8 projects · 16 files
The XLOOKUP Book cover Volume 2The XLOOKUP Book6 projects · 12 files
The Forms Book cover Volume 3The Forms Book6 projects · 12 files
The PivotTables Book cover Volume 4The PivotTables Book6 projects · 12 files
The Dashboard Book cover Volume 5 · The finaleThe Dashboard Book10 projects · 20 files
The VBA Book cover The spin-offThe VBA Book6 projects · 21 files

Using the VBA files: Download the workbook and its matching code module, then import the .bas file in Excel’s Visual Basic Editor. The Folder Consolidator also includes three sample workbooks.

04 / PRICING

Choose your next skill.

Buy one focused title, save with the core bundle, or get the complete seven-book collection.

Volumes 1–5 bundle

$42 / core series

The complete journey from IF to polished dashboards.

  • Five core volumes
  • Save versus individual books
Buy Volumes 1–5

All seven books

$51 / complete series

The beginner prequel, all five core volumes, and the VBA spin-off.

  • Full learning path
  • Seven illustrated books
  • 95 practice files included
Buy Complete Collection

Seven focused books. One practical way forward.

Whether you're opening Excel for the first time or ready to automate the work you repeat every week, the next lesson is waiting.