Microsoft Excel 2019 VBA and Macros

id: 832498 not VIP Open in MaM

By Bill Jelen, Tracy Syrstad

Language: English

Category: Ebook - Business

Categories: Business/Money

Size: 44.3 MiB pdf Files: 1

Uploader:

Uploaded At: 2022-05-05 11:43:45

nonfiction, finance, economics, business, excel, microsoft excel, vba

Description

This book shows students how to make Excel do things you thought were impossible, discover macro techniques you won't find anywhere else, and create automated reports that are amazingly powerful. Bill Jelen and Tracy Syrstad help students instantly visualize information, so they can act on it... capture data from anywhere, and use it anywhere... automate Excel 2019's best new features. Students will find simple, step-by-step instructions, real-world case studies, and workbooks packed with bonus examples, macros, and solutions--straight from MrExcel!


Contents at a Glance
Introduction
CHAPTER 1 Unleashing the power of Excel with VBA
CHAPTER 2 This sounds like BASIC, so why doesn’t it look familiar?
CHAPTER 3 Referring to ranges
CHAPTER 4 Looping and flow control
CHAPTER 5 R1C1-style formulas
CHAPTER 6 Creating and manipulating names in VBA
CHAPTER 7 Event programming
CHAPTER 8 Arrays
CHAPTER 9 Creating classes and collections
CHAPTER 10 Userforms: An introduction
CHAPTER 11 Data mining with Advanced Filter
CHAPTER 12 Using VBA to create pivot tables
CHAPTER 13 Excel power
CHAPTER 14 Sample user-defined functions
CHAPTER 15 Creating charts
CHAPTER 16 Data visualizations and conditional formatting
CHAPTER 17 Dashboarding with sparklines in Excel 2019
CHAPTER 18 Reading from and writing to the web
CHAPTER 19 Text file processing
CHAPTER 20 Automating Word
CHAPTER 21 Using Access as a back end to enhance multiuser access to data
CHAPTER 22 Advanced userform techniques
CHAPTER 23 The Windows Application Programming Interface (API)
CHAPTER 24 Handling errorsCHAPTER 25 Customizing the ribbon to run macros
CHAPTER 26 Creating add-ins
CHAPTER 27 An introduction to creating Office add-ins
CHAPTER 28 What’s new in Excel 2019 and what’s changed
Index

Other Torrents