Microsoft Excel Pivot-Tabellen – Das Praxisbuch

From ABC analysis to timeline: Get a grip on all your data with PivotTables and Power Pivot
For Excel 2013-2019 and Excel 365
With many practical examples from everyday work
Incl. free exercise files for download

Pivot tables are a particularly powerful tool for analyzing large amounts of data in Excel. The book shows how Excel users with previous knowledge can benefit from PivotTables in their daily work. In addition, the book is aimed at users who already use PivotTables, but want to understand how they work properly in order to model professional solutions.

A separate chapter is dedicated to the Power Pivot tool, which allows you to import and analyze large amounts of data from multiple sources. Using practical examples such as project financial control, quality analysis or personnel structure analysis, you will learn how PivotTables and PivotCharts work in Excel 2013 to 2019 as well as 365, understand them and use them profitably.

From the content:

PivotTable quick start tips.
Plan and prepare
Preparing and analyzing data
Using data to gain information
Use dynamic segment tables cleverly for your purposes
Increase the informative value of data with groupings
Getting to know the variety of data segments
Variety or one-way street - using the internal value fields
Hourly variance analysis
PLAN-IST comparison
ABC analysis with PivotTables
Personnel cost and personnel structure analysis
Sales analyses with PLAN-actual comparisons
Recognize the power of data models and integrate them into your work
Data analysis with Power Pivot - a new dimension.