Loonie PerksDeals for Canada
BlogSearch
Product guide

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.
Price
$47.70Save 15%

Reference price: $56.24

Price checked: Nov 19, 2026

View offerBlack Friday weekExplore the selection

Often 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
Publication details
PublisherMicrosoft Press
Publication dateApril 11 2022
Edition1st
LanguageEnglish
Print length640 pages
ISBN-13978-0137521524
Dimensions and installation
Weight listed1.05 kg
Dimensions18.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

4.5 / 5 · 217 ratings
  • 5 stars69%69%
  • 4 stars21%21%
  • 3 stars7%7%
  • 2 stars1%1%
  • 1 star2%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

Products with discounts that might interest you

4.7
&And Per Se RE-01 Blank Recipe Book, 152 Pages
&And Per Se RE-01 Blank Recipe Book, 152 Pages

C$14.99

C$13.19

-12%
-12%
Product details in Markdown