- ホーム
- > 洋書
- > 英文書
- > Computer / Spreadsheets
Full Description
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 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 in Microsoft 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 gain the following skills:
Confident VBA programmer: Readers will learn to write and understand VBA code, automating complex Excel tasks.
Data manipulation mastery: They'll gain the ability to import/export data, interact with cells programmatically, and manipulate data efficiently.
Advanced reporting automation: Readers will learn to generate and update charts and pivot tables through code, creating powerful automated reports.
One-click data analysis: They'll develop the skills to build custom buttons that transform raw data into comprehensive reports with a single click, streamlining their workflow.
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.
Contents
1 Unleashing the Power of Excel with VBA
2 This Sounds Like BASIC, So Why Doesn't It Look Familiar?
3 Referring to Ranges, Names, and Listobjects
4 Laying the Groundwork with Variables and Structures
5 Looping and Flow Control
6 R1C1-Style Formulas
7 Event Programming
8 Arrays
9 Creating Classes and Collections
10 Userforms: An Introduction
11 Data Mining with Advanced Filter
12 Using VBA to Create Pivot Tables
13 Excel Power
14 Sample User-Defined and LAMBDA Functions
15 Creating Charts
16 Data Visualizations and Conditional Formatting
17 Dashboarding with Sparklines in Excel
18 Reading from the web using M and VBA
19 Text File Processing
20 Automating Word
21 Using Access as a Back End to Enhance Multiuser Access to Data
22 Advanced Userform Techniques
23 The Windows Application Programming Interface (API)
24 Handling Errors
25 Customizing the Ribbon to Run Macros[
26 Creating Excel Add-ins
27 An Introduction to Creating Office Add-ins
28 What's New in Excel 365 and What's Changed
