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.
Table of Contents
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

A friendly introduction to writing macros.
2. Excel Power Programming with VBA by Michael Alexander and Dick Kusleika
A thorough guide to building VBA applications.
3. Microsoft Excel VBA and Macros by Bill Jelen and Tracy Syrstad

Real-world macros you can adapt.
4. Mastering VBA for Microsoft Office 365 by Richard Mansfield

VBA across Excel, Word and other Office apps.
5. Writing Excel Macros with VBA by Steven Roman

A compact guide to the Excel object model.
6. Excel VBA in Easy Steps by Mike McGrath

Short, illustrated lessons.
7. Professional Excel Development by Stephen Bullen, Rob Bovey and John Green
Building professional Excel applications.
8. Financial Modeling Using Excel and VBA by Chandan Sengupta

Building financial models with VBA.
9. Excel Dashboards and Reports by Michael Alexander and Dick Kusleika

Turning data into clear dashboards.
10. Excel Power Pivot and Power Query For Dummies by Michael Alexander
Modern data tools inside Excel.
11. M Is for (Data) Monkey by Ken Puls and Miguel Escobar
Cleaning and shaping data automatically.
12. Advanced Excel Essentials by Jordan Goldmeier
Techniques for advanced spreadsheets.
13. Data Analysis with Microsoft Excel by Kenneth N. Berk and Patrick Carey

Analyzing data in Excel.
14. Python for Excel by Felix Zumstein

Automating Excel with Python.
15. Automate the Boring Stuff with Python by Al Sweigart

Includes chapters on working with spreadsheets.
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