Название: Excel 2021 / Microsoft 365 Programming By Example
Автор: Julitta Korol
Издательство: Mercury Learning and Information
Год: 2023
Страниц: 1107
Язык: английский
Формат: pdf (true)
Размер: 38.09 MB

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.

If you ever wanted to open a new worksheet without using built-in commands or create a custom, fully automated form to gather data and store the results in a worksheet, you’ve picked up the right book. This book shows you what’s doable with Microsoft® Excel® 2021 beyond the standard user interface. This book’s purpose is to teach you how to delegate many time-consuming and repetitive tasks to Excel by using its built-in language, VBA (Visual Basic for Applications). By executing special commands and statements and using several Excel’s built-in programming tools, you can work smarter than you ever thought possible. I will show you how.

The book’s approach is to learn by doing. There’s no better way than step by step. Simply turn on the computer, open this book, launch Microsoft Excel, and do all the guided Hands-On exercises. But before you get started, allow me to give you a short overview of the things you’ll be learning as you progress through this book.

Excel 2021 / Microsoft 365 Programming by Example is divided into 8 parts (29 chapters) that progressively introduce you to programming Microsoft Excel 2021 as well as controlling other applications with Excel.

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