Microsoft Excel VBA and macros (Office 2021 and Microsoft 365)

Unleashing the power of Excel with VBA

This sounds like BASIC, so why doesn't it look familiar?

Referring to ranges

Looping and flow control

R1C1-style formulas

Creating and manipulating names in VBA

Event programming

Arrays

Creating classes and collections

Userforms: an introduction

Data mining with Advanced Filter

Using VBA to create pivot tables

Excel power

Sample user-defined functions

Creating charts

Data visualizations and conditional formatting

Dashboarding with sparklines in Excel

Reading from the web using M and VBA

Text file processing

Automating Word

Using Access as a back end to enhance multiuser access to data

Advanced userform techniques

The Windows Application Programming Interface (API)

Handling errors

Customizing the ribbon to run macros

Creating Excel add-ins

An introduction to creating Office add-ins

What's new in Excel 365 and what's changed.