In this chapter, you will learn about the tools required to effectively analyze and organize data in Excel 2019. We will cover summarizing data using PivotTables and PivotCharts and you will learn how to access the Quick Analysis tools. We will also work with maps and the new 3D Maps feature, use Power Pivot to effectively build and use relational data sources in an Excel workbook, consolidate workbook data by creating a summary sheet, build a relationship between datasets for easy reporting with Excel's data model, and take a look at macros.
The following topics are covered in this chapter:
- Consolidating data and investigating macros
- Creating and managing PivotTables and PivotCharts
- Working with the 3D Maps feature
- Using tools for analysis in Excel
- Understanding data models
