Microsoft Excel Pivot Table Data Crunching (Office 2021 and Microsoft 365) (Business Skills)
Current price:
$47.24
Publication Date: December 17th, 2021
Publisher:
Microsoft Press
ISBN:
9780137521838
Pages:
544
Usually Ships in 1 to 5 Days
Description
Use Microsoft 365 Excel and Excel 2021 pivot tables and pivot charts to produce powerful, dynamic reports in minutes: take control of your data and your business Even if you've never created a pivot table before, this book will help you leverage all their flexibility and analytical power-- including important recent improvements in Microsoft 365 Excel. Drawing on more than 30 years of cutting-edge Excel experience, MVP Bill Jelen ("MrExcel") shares practical "recipes" for solving real business problems, expert insights for avoiding mistakes, and advanced tips and tricks you'll find nowhere else.
By reading this book, you will:
- Master easy, powerful ways to create, customize, change, and control pivot tables
- Transform huge datasets into clear summary reports
- Instantly highlight your most profitable customers, products, or regions
- Use the data model and Power Query to quickly analyze disparate data sources
- Create powerful crosstab reports with new dynamic arrays and Power Query
- Build geographical pivot tables with 3D Maps
- Construct and share state-of-the-art dynamic dashboards
- Revamp analyses on the fly by dragging and dropping fi elds
- Build dynamic self-service reporting systems
- Share your pivot tables with colleagues
- Create data mashups using the full Power Pivot capabilities in modern Excel versions
- Generate pivot tables using either VBA on the Desktop or Typescript in Excel Online
- Save time and avoid formatting problems by adapting reports with GetPivotData
- Unpivot source data so it's easier to work with
- Use new Analyze Data artificial intelligence to create pivot tables
Other Books in Series
Preorder
The Definitive Guide to KQL: Using Kusto Query Language for Operations, Defending, and Threat Hunting (Business Skills)
Paperback
Microsoft Excel Data Analysis and Business Modeling (Office 2021 and Microsoft 365) (Business Skills)
Paperback
Microsoft Excel 2019 Data Analysis and Business Modeling (Business Skills)
Paperback
Collect, Combine, and Transform Data Using Power Query in Excel and Power Bi (Business Skills)
Paperback
Microsoft Excel VBA and Macros (Office 2021 and Microsoft 365) (Business Skills)
Paperback
The Definitive Guide to Dax: Business Intelligence for Microsoft Power Bi, SQL Server Analysis Services, and Excel (Business Skills)
Paperback
Writing for Business Results (Business Skills Express Series)
Paperback
Telephone Skills at Work (Business Skills Express Series)
Paperback
Business Growth Strategy: Business Growth Strategy for leaders, leadership strategy & tactics (Essential Business Skills)
Hardcover
Time Management (Business Skills Express Series)
Paperback
How to start a business: How to start a business without any money (Essential Business Skills)
Hardcover
Microsoft Excel Formulas and Functions (Office 2021 and Microsoft 365) (Business Skills)
Paperback
Analyzing Data with Power Bi and Power Pivot for Excel (Business Skills)
Paperback
The New Supervisor: Skills for Success (Business Skills Express Series)
Paperback
International Negotiations Student's Book with Audio CDs (2) (Cambridge Business Skills)
Paperback
Everyday Project Management (Everyday Business Skills #1)
Paperback
Everyday Productivity (Everyday Business Skills #2)
Paperback
Marketing Basics (The Blue Print Business Skills Library Collection #9)
Paperback
Business Ethics (The Blue Print Business Skill Library #3)
Paperback