The books I recommend for learning Excel, VBA, Power Query and Power BI, plus my own courses and the free guides on this site.
Disclosure: some links on this page are affiliate links. If you buy through them, you pay nothing extra, and I earn a small commission that helps keep this site free. Thank you for your support!
Table of Contents
Books on Excel and VBA
Started by John Walkenbach, now by Michael Alexander and Dick Kusleika
The most complete Excel reference for beginners and intermediate users, covering every essential part of Excel.
Greg Harvey
A friendly guide that covers everything you need to get started, from a bestselling author with millions of copies sold.
John Walkenbach; later editions by Michael Alexander and Dick Kusleika
The classic book for mastering VBA and macros in Excel.
Books on Power Query, Power Pivot and Power BI
Matt Allington
Explains the key concepts clearly, with hands-on practice that helps new skills stick.
Ken Puls and Miguel Escobar
Shows how to use Power Query to bring difficult data into Excel and Power Pivot. The authors’ newer book, Master Your Data with Power Query in Excel and Power BI, covers the latest features.
Rob Collie and Avi Singh
The first book to teach DAX formulas, the heart of Power Pivot and Power BI, from an Excel user’s point of view.
My courses
| Course | Language |
|---|---|
| Excel: Beginner to Confident User | English |
| Microsoft Excel Beginner to Professional | Malayalam |
| AutoCAD Scripting | English |
| Programming in AutoCAD (VBA) | English |