Excel 2021 / Microsoft 365 Programming By Example
by Julitta Korol(Author)
Publisher finelybook 出版社: Mercury Learning and Information (December 30, 2022)
Language 语言: English
Print Length 页数: 1072 pages
ISBN-10: 1683928865
ISBN-13: 9781683928867
Book Description
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
