Description

Crunch data from any source, quickly and easily, with Excel 2019 pivot tables!

Use Excel 2019 pivot tables and pivot charts to produce powerful, dynamic reports in minutes instead of hours. Understand exactly what’s going on in your business, take control and stay in control! Even if you’ve never created a pivot table before, this book will help you leverage all their amazing flexibility and analytical power. Drawing on more than 40 combined years of Excel experience, Bill Jelen and Michael Alexander offer practical “recipes” for solving real business problems, help you avoid common mistakes, and present tips and tricks you’ll find nowhere else!

You will learn to:

Create, customise and change pivot tables;
Transform huge data sets into clear summary reports;
Analyse data faster with Excel 2019’s new recommended pivot tables;
Instantly highlight your most profitable customers, products or regions;
Quickly import, clean and shape data with Power Query;
Build geographical pivot tables with Power Map;
Use Power View dynamic dashboards to see where your business stands;
Revamp analyses on the fly by dragging and dropping fields;
Build dynamic self-service reporting systems;
Combine multiple data sources into one pivot table;
Use Auto grouping to build date/time-based pivot tables faster;
Create data mashups with Power Pivot; and
Automate pivot tables with macros and VBA.

Benefits of the ePUB format​ include:​

The ability to view on ​a ​desktop computer, notebook or tablet;
The ability to adjust fonts, rotate and flip pages, causing content to reflow to fit the device’s screen giving the user a more flexible experience; and
The ability to take notes, highlight and bookmark.