Register your product to gain access to bonus material or receive a coupon.
This eBook includes the following formats, accessible from your Account page after purchase:
EPUB
The open industry format known for its reflowable content and usability on supported mobile devices.
PDF
The popular standard, used most often with the free Acrobat® Reader® software.
This eBook requires no passwords or activation to read. We customize your eBook by discreetly watermarking it with your name, making it uniquely yours.
Renowned Excel experts Bill Jelen (MrExcel) and Tracy Syrstad explain how to build more powerful, reliable, and efficient Excel spreadsheets.
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 wont 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 in Microsoft 365. Youll 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 gain the following skills:
The structure of the book is to provide an explanation of a concept followed by an example of how the concept would be used. Sample code in a chapter often builds up from previous samples in the same chapter. Larger code samples include comments so the user understands the progression of the program.
1Unleashing the Power of Excel with VBA
2This Sounds Like BASIC, So Why Doesnt It Look Familiar?
3Referring to Ranges, Names, and Listobjects
4Laying the Groundwork with Variables and Structures
5Looping and Flow Control
6R1C1-Style Formulas
7Event Programming
8Arrays
9Creating Classes and Collections
10Userforms: An Introduction
11Data Mining with Advanced Filter
12Using VBA to Create Pivot Tables
13Excel Power
14Sample User-Defined and LAMBDA Functions
15Creating Charts
16Data Visualizations and Conditional Formatting
17Dashboarding with Sparklines in Excel
18Reading from the web using M and VBA
19Text File Processing
20Automating Word
21Using Access as a Back End to Enhance Multiuser Access to Data
22Advanced Userform Techniques
23The Windows Application Programming Interface (API)
24Handling Errors
25Customizing the Ribbon to Run Macros[
26Creating Excel Add-ins
27An Introduction to Creating Office Add-ins
28Whats New in Excel 365 and Whats Changed