Microsoft Excel 2019 VBA and Macros

Microsoft Excel 2019 VBA and Macros (Business Skills)
Authors: Bill Jelen – Tracy Syrstad
ISBN-10: 1509306110
ISBN-13: 9781509306114
Edition 版次: 1
Publication Date 出版日期: 2019-01-07
Print Length 页数: 624 pages
Use this guide to automate virtually any routine Excel task: save yourself hours,days,maybe even weeks. 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 you instantly visualize information to make it actionable; capture data from anywhere,and use it anywhere; and automate the best new features in Excel 2019 and Excel in Office 365. You’ll find simple,step-by-step instructions,real-world case studies,and 50 workbooks packed with examples and complete,easy-to-adapt solutions.
By reading this book,you will:
Quickly master Excel macro development
Work more efficiently with ranges,cells,and formulas
Generate automated reports and quickly adapt them for new requirements
Learn to automate pivot tables to summarize,analyze,explore,and present data
Use custom dialog boxes to collect data from others using Excel
Improve the reliability and resiliency of your macros
Integrate data from the internet,Access databases,and other sources
Automatically generate charts,visualizations,sparklines,and Word documents
Create powerful solutions with classes,collections,and custom functions
Solve sophisticated business analysis problems more rapidly
About This Book
For everyone who wants to get more done with Microsoft Excel in less time
For business and financial professionals,entrepreneurs,students,and others who need to efficiently manage and analyze data
Title Page
Copyright Page
Dedication Page
Contents at a Glance
Contents
Acknowledgments
About the Authors
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 errors
Chapter 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
Code Snippets

相关文件下载地址