Excel 2021 / Microsoft 365 Programming By Example

  • 14h 38m
  • Julitta Korol
  • Mercury Learning
  • 2022

Updated for Excel 2021 and based on the bestselling editions from previous versions, Excel 2021 / Microsoft 365 Programming by Example is a practical, how-to book on Excel programming, suitable for readers already proficient with the Excel user interface. If you are looking to automate Excel routine tasks, this book will progressively introduce you to programming concepts via numerous illustrated hands-on exercises. More advanced topics are demonstrated via custom projects. From recording and editing a macro and writing VBA code from scratch to programming the Ribbon interface and working with XML documents, this book takes you on a programming journey that will change the way you work with Excel. The book provides information on performing automatic operations on files, folders, and other Microsoft Office applications. It also covers proper use of eventprocedures, testing and debugging, and guides you through programming more advanced Excel features, such as working with VBA classes and raising your own events in standalone class modules. Includes companion files with source code, hands-on projects, and figures.

FEATURES:

  • Updated for Excel 2021 / Microsoft 365 and previous versions
  • Includes 29 chapters and more than 275 applied examples and 10 projects
  • Provides a practical coverage of using Web queries, HTML, XML, and VBScript
  • Companion files with color screen captures, source code, and projects in the text

About the Author

Since 1993, Julitta Korol (Long Island, NY) has published two dozen computer books on using and programming Microsoft Excel and Microsoft Access. She has completed professional certifications by Microsoft Corporation and the Computing Technology Industry Association (CompTIA).

In this Book

  • Excel Macros—A Quick Start in Excel VBA Programming
  • Excel Programming Environment—A Quick Overview of Its Tools and Features (VBE)
  • Excel VBA Fundamentals—A Quick Reference to Writing VBA Code
  • Excel VBA Procedures—A Quick Guide to Writing Function Procedures
  • Adding Decisions to Excel VBA Programs—A Quick Introduction to Conditional Statements
  • Adding Repeating Actions to Excel VBA Programs—A Quick Introduction to Looping Statements
  • Storing Multiple Values in Excel VBA Programs—A Quick Introduction to Working with Arrays
  • Keeping Track of Multiple Values in Excel VBA Programs—A Quick Introduction to Creating and Using Collections
  • Excel Tools for Testing and Debugging—A Quick Introduction to Testing VBA Programs
  • File and Folder Manipulation with VBA
  • File and Folder Manipulation with Windows Script Host (WSH)
  • Using Low-Level File Access
  • Using Excel VBA to Interact with other Applications
  • Using Excel with Microsoft Access
  • Event-Driven Programming
  • Using Dialog Boxes
  • Creating Custom Forms
  • Formatting Worksheets with VBA
  • Context Menu Programming and Ribbon Customizations
  • Printing and Sending Email from Excel
  • Using and Programming Excel Tables
  • Programming PivotTables and PivotCharts
  • Getting and Transforming Data in Excel
  • Programming the Visual Basic Editor (VBE)
  • Calling Windows API Functions from VBA
  • Creating Classes in VBA
  • HTML Programming and Web Queries
  • Using XML in Excel 2021
  • Excel and Rest API
SHOW MORE
FREE ACCESS

YOU MIGHT ALSO LIKE

Course Exploring essential functions in Excel 365 (2023)
Rating 4.9 of 7 users Rating 4.9 of 7 users (7)
Course 10 common tools in Excel 365
Rating 3.0 of 2 users Rating 3.0 of 2 users (2)
Book Microsoft Excel 2021 Programming Pocket Primer