
Microsoft Excel VBA and Macros for Office 2021 and Microsoft 365
Microsoft Excel VBA and Macros is a practical guide to automating Excel tasks with VBA and related tools. Its coverage ranges from cells, formulas and PivotTables to UserForms, data connections, Office add-ins and TypeScript applications for Excel Online.
At a glance
- Explains Excel macro development alongside work with ranges, cells and formulas.
- Covers automated reports and PivotTables, plus advanced VBA topics such as classes, collections and Advanced Filter.
- Includes User-Defined Functions, including LAMBDA, and custom UserForms for collecting data.
- Describes connecting to external data sources, creating charts and Word documents, and controlling other Office programs.
- The listing says the book includes 50 workbooks with examples and solutions.
Reference price: $56.24
Price checked: Nov 19, 2026
View offerBlack Friday weekExplore the selectionOften bought together
Pros and cons
Pros
- Broad scope connects everyday spreadsheet automation with reporting, data connections and Office integration.
- Topics include both VBA and newer Excel-related work such as LAMBDA functions and TypeScript applications for Excel Online.
- The listing describes step-by-step instructions and real-world case studies, which may help readers apply concepts to tasks.
Cons
- At 640 pages, it is a substantial reference rather than a brief introduction.
Technical specifications
8 specifications| Publisher | Microsoft Press |
|---|---|
| Publication date | April 11 2022 |
| Edition | 1st |
| Language | English |
| Print length | 640 pages |
| ISBN-13 | 978-0137521524 |
| Weight listed | 1.05 kg |
|---|---|
| Dimensions | 18.54 x 3.56 x 23.11 cm |
Who is it for?
A good fit for
- Excel users who want to automate repetitive tasks with VBA.
- Business and finance professionals, entrepreneurs, students and others who manage or analyse data.
- Readers interested in automated reports, PivotTables, UserForms or connecting Excel to other data sources.
Less suited to
- Readers looking only for a short, basic introduction to using Excel.
- Readers seeking a general guide to Microsoft Office rather than Excel automation.
Customer reviews on Amazon
- 5 stars
69% 69% - 4 stars
21% 21% - 3 stars
7% 7% - 2 stars
1% 1% - 1 star
2% 2%
Customer feedback is described as positive about the book's content and informative reference value. That may matter to readers looking for a substantial learning resource, while aggregate ratings are generally favourable but cannot establish how well its examples fit a particular Excel version or skill level.
Positive themes
- Feedback describes the content as informative.
- Feedback characterises the book as a useful reference.
Frequently asked questions
Which Excel versions does the title name?
The title specifies Office 2021 and Microsoft 365.
What topics does the book cover?
The listing describes VBA macros, formulas, reports, PivotTables, UserForms, data integrations, charts, Office add-ins and TypeScript applications for Excel Online.
Does the listing say workbooks are included?
Yes. It claims 50 workbooks with examples and adaptable solutions, but the supplied package details do not separately confirm their format or delivery method.
Alternative options

Ultimate Microsoft Excel Formula & Function Reference Guide: 500+ Practical Tips for Beginners to Experts including AI prompts for ChatGPT
$51.99

Excel for Beginners: Learn the Excel Skills You Actually Use at Work, One Real Task a Day for 7 Days, with the Task Ladder Method, 200+ Screenshots and Downloadable Practice Files
$27.09

Data Analysis in Microsoft Excel: Deliver Awesome Analytics in 3 Easy Steps Using VLOOKUPS, Pivot Tables, Charts And More
$27.99

MICROSOFT 365 COPILOT AI USER GUIDE: The Complete and Up-to-Date User Guide to Excel, Word, PowerPoint, Outlook, OneNote, OneDrive, Teams, Access, and Publisher From Beginner to Advanced
$23.15

Microsoft Office 365 For Beginners: The 1# Crash Course From Beginners To Advanced. Easy Way to Master The Whole Suite in no Time | Excel, Word, PowerPoint, OneNote, OneDrive, Outlook, Teams & Access
$27.96

Microsoft Excel Mastery: From Beginners to Experts – The Complete Guide to Formulas, Functions, and Real-World Applications
$26.35

The Copilot Profit Formula: How to Generate Massive Income Online with Microsoft's AI
$29.22

MICROSOFT 365 COPILOT AI USER GUIDE: The Complete and Up-to-Date User Guide to Excel, Word, PowerPoint, Outlook, OneNote, OneDrive, Teams, Access, and Publisher From Beginner to Advanced
$9.99

Microsoft Copilot User Guide for Beginners to Pro: Master AI productivity, boost workflow efficiency, unlock smart automation, accelerate learning, enhance collaboration and transform your tech world
$26.41

Microsoft Copilot User Guide: Manual for Mastering the Features of this AI for Efficiency
$23.86

























