Best Excel & Power Query Books for Accountants (2026)

The accountant who's fluent in modern Excel is faster than one who isn't — not by a little, by hours every month. Most of those hours hide in two places: building models and what-if analyses that answer client questions, and the repetitive import-and-clean ritual that Power Query automates away. These books target exactly that gap. They're a reference you keep on the desk, not a one-and-done read, and the skills compound for years.

How we evaluated#

For a working accountant, the right Excel book is practical (scenario-driven, not feature tours), current (covers modern Excel — dynamic arrays, Power Query — not Excel 2010), and a usable reference you can search later. We also weighted hands-on materials: every pick includes downloadable example files so you practice on real data, not screenshots.

1. Microsoft Excel Data Analysis and Business Modeling — best overall#

Wayne Winston's book is the one that turns Excel from a calculator into an analysis tool. It's organized around real questions — how do I forecast this, model that scenario, find this answer — rather than a tour of menus, which is why it reads like consulting rather than a manual. The current edition covers modern Excel including dynamic arrays and a Power Query on-ramp. It's dense and works better as a desk reference you dip into than a cover-to-cover read, and a few chapters lean analytics over pure accounting — but as the single book to level up your Excel, it's the pick.

2. Master Your Data with Power Query — best for Power Query#

This is the comprehensive Power Query book, and Power Query is the highest-ROI Excel skill most accountants haven't learned. It walks you through automating the monthly import-clean-reshape grind — the work you currently do by hand — into reusable, refreshable queries, with downloadable real-world files and coverage that applies to both Excel and Power BI. It assumes you have a data-cleanup problem worth solving (most accountants do), and it's Power Query only rather than general Excel — by design.

3. M Is for (Data) Monkey — best starter#

From the same authors, this is the gentler on-ramp: a beginner-friendly, step-by-step intro that gets you quick Power Query wins before you commit to the comprehensive reference. If "Power Query" sounds intimidating, start here and graduate to Master Your Data. It's the older 2015 edition and lighter on depth, so think of it as the friendly first chapter rather than the whole story.

What we left off#

We skipped the encyclopedic "Excel Bible"-style books — they're fine references but too broad for an accountant who wants targeted modeling and data skills, not 1,000 pages on every feature. We also passed on VBA/macro-heavy titles: for most firms, Power Query has quietly replaced the need to learn VBA for data work. And single-purpose financial-modeling-for-investment-banking books aim at a different reader than a practicing accountant.

Pairing these with the rest of your shelf#

Excel skill compounds with the rest of the modern-accounting toolkit. See our best AI books for accountants guide for where the field is heading, and — if the goal is faster spreadsheet work at the desk — the best mechanical keyboards for spreadsheet work guide.

Verdict#

For most accountants: start with Microsoft Excel Data Analysis and Business Modeling for modeling and analysis, then learn Master Your Data to automate the monthly data grind with Power Query (use M Is for Data Monkey first if you want a gentler intro). The Power Query investment in particular pays back fast — the first time a five-click refresh replaces an hour of manual cleanup, the book has paid for itself many times over.