Microsoft Excel 2019 Pivot Table Data Crunching
Bill / Alexander Jelen
544 pages, parution le 07/01/2019
Résumé
By reading this book, you will: - Master easy, powerful ways to create, customize, change, and control pivot tables - Control all future pivot tables using new pivot table defaults - Transform huge data sets into clear summary reports - Instantly highlight your most profitable customers, products, or regions - Use Power Query to quickly import, clean, shape, and analyze disparate data sources - Build geographical pivot tables with 3D Map - Construct and share state-of-the-art dynamic dashboards - Revamp analyses on the fly by dragging and dropping fields - Build dynamic self-service reporting systems - Share your pivot tables with colleagues - Create data mashups using the full Power Pivot capabilities of Excel 2019 and Excel in Office 365 - Automate pivot tables with macros and VBA - Save time by adapting reports with GetPivotData - Discover today's most useful pivot table tips and shortcuts
- Introduction
- 1 Pivot Table Fundamentals
- 2 Creating Basic Pivot Table
- 3 Customizing a Pivot Table
- 4 Controlling the Way you View your PivotTable
- 5 Performing Calculations Within your PivotTables
- 6 Using Pivot Charts and Other Visualizations
- 7 Power Query / Analyzing Disparate Data Sources with PivotTables
- 8 Sharing PivotTables with Others
- 9 Working With and Analyzing OLAP Data
- 10 Mashing Up Data with PowerPivot
- 11 Dashboarding with PowerView & Power Map
- 12 Enhancing PivotTables with Macros
- 13 Using VBA to Create Pivot Tables
- 14 Advanced PivotTable Tips and Tricks
- 15 Using GetPivotData
Mike Alexander is a Microsoft Certified Application Developer (MCAD) and author of several books on advanced business analysis with Microsoft Access and Excel. He has more than 15 years of experience consulting and developing Office solutions. Mike has been named a Microsoft MVP for his ongoing contributions to the Excel community.
Caractéristiques techniques
| PAPIER | |
| Éditeur(s) | Microsoft press usa (livres en anglais) |
| Auteur(s) | Bill / Alexander Jelen |
| Parution | 07/01/2019 |
| Nb. de pages | 544 |
| EAN13 | 9781509307241 |
Avantages Eyrolles.com
Livraison à partir de 0,01 € en France métropolitaine
Paiement en ligne SÉCURISÉ
Livraison dans le monde
Retour sous 15 jours
+ d'un million et demi de livres disponibles
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
