Microsoft Excel 2021 Programming Pocket Primer / / Julitta Korol.

• VerfasserIn: Korol, Julitta,
• Place / Publishing House: Dulles, VA : : Mercury Learning and Information, , [2022]; ©2022
• Year of Publication: 2022
• Language: English
• Series: Pocket Primer
• Physical Description: 1 online resource (262 p.)

As part of the successful Pocket Primer series, this book was designed for someone like you who needs to master Excel programming fundamentals without spending too much time. All you need is a short book to get you started. It will show you only the things you need to know to feel at home with VBA. What you learn in this book on Excel programming will also apply to, say, Access programming. The book is divided into nine chapters that progressively introduce you to programming Microsoft Excel 2021. Features:Includes a companion disc with all of the “Hands-On” files needed to complete the chapter projects and all the images from the text (also available from the publisher by writing to [e-mail] you to using the VBA programming language in Microsoft Excel 2021.

Table of Contents

Frontmatter -- Contents -- Acknowledgments -- Introduction -- Chapter 1 Excel Macros: A Quick Start in Excel VBA Programming -- Chapter 2 Excel Programming Environment: A Quick Overview of its Tools and Features (VBE) -- Chapter 3 Excel VBA Fundamentals: A Quick Reference to Writing VBA Code -- Chapter 4 Excel VBA Procedures: A Quick Guide to Writing Function Procedures -- Chapter 5 Adding Decisions to Excel VBA Programs: A Quick Introduction to Conditional Statements -- Chapter 6 Adding Repeating Actions to Excel VBA Programs: A Quick Introduction to Looping Statements -- Chapter 7 Storing Multiple Values in Excel VBA Programs: A Quick Introduction to Working with Arrays -- Chapter 8 Keeping Track of Multiple Values in Excel VBA Programs: A Quick Introduction to Creating and Using Collections -- Chapter 9 Excel Tools for Testing and Debugging: A Quick Introduction to Testing VBA Programs -- Index