One book focuses on Office Scripts for the online version of Excel and teaches TypeScript-based automation, while the other books focus on VBA for desktop Excel, covering the Visual Basic Editor, writing macros, and troubleshooting VBA code.
They teach TypeScript for Office Scripts (online Excel) and Visual Basic for Applications (VBA) for desktop Excel automation.
Commonly automated tasks include table formatting, data cleaning and sorting, creating dynamic charts and enhanced PivotTables, automating reporting tasks, sending emails from Excel, and assigning macros to buttons.
The books target a range of readers from beginners new to VBA up to advanced users, with specific appeal to students, professionals, business users, data analysts, and advanced Excel users.
They emphasize practical, hands-on learning with step-by-step instructions, practical exercises, examples, and code samples to help you write and run scripts.
They include guidance on keeping macros secure, fixing errors, troubleshooting common problems, and controlling macro security settings across files and apps.
