Best Books on Excel Vba Programming: 15 Top Picks

Disclosure: As an Amazon Associate, Bookish Wisdom earns from qualifying purchases. This doesn't change our picks or your price.

Quick answer: The best books on Excel Vba Programming include Excel VBA Programming For Dummies by Michael Alexander and Dick Kusleika, Excel Power Programming with VBA by Michael Alexander and Dick Kusleika and Microsoft Excel VBA and Macros by Bill Jelen and Tracy Syrstad, plus twelve more strong picks. Each one below has a short description and who it suits best, with a quick table to compare them.

Excel VBA lets you automate repetitive spreadsheet work and build powerful tools inside Excel. These books range from beginner guides to advanced development, plus a few on related tools like Power Query and Python for Excel. Pick one that matches the version of Excel you use.

Quick Picks at a Glance

Book Author Best for
Excel VBA Programming For Dummies Michael Alexander and Dick Kusleika absolute beginners
Excel Power Programming with VBA Michael Alexander and Dick Kusleika in-depth reference
Microsoft Excel VBA and Macros Bill Jelen and Tracy Syrstad practical examples
Mastering VBA for Microsoft Office 365 Richard Mansfield Office-wide automation
Writing Excel Macros with VBA Steven Roman concise references
Excel VBA in Easy Steps Mike McGrath visual learners
Professional Excel Development Stephen Bullen, Rob Bovey and John Green advanced developers
Financial Modeling Using Excel and VBA Chandan Sengupta finance professionals
Excel Dashboards and Reports Michael Alexander and Dick Kusleika reporting
Excel Power Pivot and Power Query For Dummies Michael Alexander data tools
M Is for (Data) Monkey Ken Puls and Miguel Escobar Power Query
Advanced Excel Essentials Jordan Goldmeier power users
Data Analysis with Microsoft Excel Kenneth N. Berk and Patrick Carey statistics
Python for Excel Felix Zumstein modern alternatives
Automate the Boring Stuff with Python Al Sweigart general automation

1. Excel VBA Programming For Dummies by Michael Alexander and Dick Kusleika

Excel VBA Programming For Dummies by Michael Alexander and Dick Kusleika book cover

A friendly introduction to writing macros.

Check price on Amazon

2. Excel Power Programming with VBA by Michael Alexander and Dick Kusleika

A thorough guide to building VBA applications.

Check price on Amazon

3. Microsoft Excel VBA and Macros by Bill Jelen and Tracy Syrstad

Microsoft Excel VBA and Macros by Bill Jelen and Tracy Syrstad book cover

Real-world macros you can adapt.

Check price on Amazon

4. Mastering VBA for Microsoft Office 365 by Richard Mansfield

Mastering VBA for Microsoft Office 365 by Richard Mansfield book cover

VBA across Excel, Word and other Office apps.

Check price on Amazon

5. Writing Excel Macros with VBA by Steven Roman

Writing Excel Macros with VBA by Steven Roman book cover

A compact guide to the Excel object model.

Check price on Amazon

6. Excel VBA in Easy Steps by Mike McGrath

Excel VBA in Easy Steps by Mike McGrath book cover

Short, illustrated lessons.

Check price on Amazon

7. Professional Excel Development by Stephen Bullen, Rob Bovey and John Green

Building professional Excel applications.

Check price on Amazon

8. Financial Modeling Using Excel and VBA by Chandan Sengupta

Financial Modeling Using Excel and VBA by Chandan Sengupta book cover

Building financial models with VBA.

Check price on Amazon

9. Excel Dashboards and Reports by Michael Alexander and Dick Kusleika

Excel Dashboards and Reports by Michael Alexander and Dick Kusleika book cover

Turning data into clear dashboards.

Check price on Amazon

10. Excel Power Pivot and Power Query For Dummies by Michael Alexander

Modern data tools inside Excel.

Check price on Amazon

11. M Is for (Data) Monkey by Ken Puls and Miguel Escobar

Cleaning and shaping data automatically.

Check price on Amazon

12. Advanced Excel Essentials by Jordan Goldmeier

Techniques for advanced spreadsheets.

Check price on Amazon

13. Data Analysis with Microsoft Excel by Kenneth N. Berk and Patrick Carey

Data Analysis with Microsoft Excel by Kenneth N. Berk and Patrick Carey book cover

Analyzing data in Excel.

Check price on Amazon

14. Python for Excel by Felix Zumstein

Python for Excel by Felix Zumstein book cover

Automating Excel with Python.

Check price on Amazon

15. Automate the Boring Stuff with Python by Al Sweigart

Automate the Boring Stuff with Python by Al Sweigart book cover

Includes chapters on working with spreadsheets.

Check price on Amazon

How to Choose

Beginners should start with Excel VBA Programming For Dummies. For practical examples, use Jelen and Syrstad, and for modern options, try Python for Excel.

How We Chose These Books

Every pick is a real, widely available book with strong reviews from readers, teachers or librarians. We mixed well-known favourites with a few less obvious titles and noted who each one suits best. Check the description and the table before you buy, and borrow a copy from the library first if you are unsure.

Tips for Getting the Most From These Books

  • Start with one. Pick the title that matches your goal today, not the longest one on the list.
  • Sample first. Read the opening chapter in a library copy or ebook preview before you buy.
  • Try audio. Many of these work well as audiobooks on a commute or walk.

Frequently Asked Questions

Which book should I start with?

Excel VBA Programming For Dummies by Michael Alexander and Dick Kusleika is a strong first pick, and every book on this list is worth a look.

Where can I find these books?

Most of these titles are easy to find at public libraries and bookshops, and many are also available as ebooks or audiobooks.

Related: Best Books for R Programming Beginners: 15 Top Picks · Best Books for C Programming Beginners: 15 Top Picks

Leave a Comment