Microsoft Excel 2019 VBA and Macros
Bill / Syrstad Jelen
Résumé
- 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
- 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
- I Introduction
- 1 Unleash the Power of Excel with VBA
- 2 This Sounds Like BASIC, So Why Doesn't It Look Familiar?
- 3 Referring to Ranges
- 4 Looping and Flow Control
- 5 R1C1-Style Formulas
- 6 Create and Manipulate Names in VBA
- 7 Event Programming
- 8 Arrays
- 9 Creating Classes, Records, and Collections
- 10 Userforms[md]An Introduction
- 11 Data Mining with Advanced Filter
- 12 Using VBA to Create Pivot Tables
- 13 Excel Power - Sample Macros
- 14 Sample User-Defined Functions
- 15 Creating Charts
- 16 Data Visualizations and Conditional Formatting
- 17 Dashboarding with Sparklines
- 18 Reading from and Writing to the Web
- 19 Text File Processing
- 20 Automating Word
- 21 Using Access as a Back End to Enhance Multi-User Access to Data
- 22 Advanced Userform Techniques
- 23 Windows Application Programming Interface (API)
- 24 Handling Errors
- 25 Customizing the Ribbon to Run Macros
- 26 Creating Add-Ins
- 27 Creating Apps with Java Script
- 28 What's New in Excel 2016 and What's Changed
Caractéristiques techniques
PAPIER | |
Éditeur(s) | Microsoft press usa (livres en anglais) |
Auteur(s) | Bill / Syrstad Jelen |
Parution | 27/12/2018 |
Nb. de pages | 656 |
EAN13 | 9781509306114 |
Avantages Eyrolles.com
Consultez aussi
- Les meilleures ventes en Graphisme & Photo
- Les meilleures ventes en Informatique
- Les meilleures ventes en Construction
- Les meilleures ventes en Entreprise & Droit
- Les meilleures ventes en Sciences
- Les meilleures ventes en Littérature
- Les meilleures ventes en Arts & Loisirs
- Les meilleures ventes en Vie pratique
- Les meilleures ventes en Voyage et Tourisme
- Les meilleures ventes en BD et Jeunesse