Analyzing and Organizing Data in Microsoft Excel 2019

In this chapter, you will learn about the tools required toeffectively analyze and organize data in Excel 2019. We will coversummarizing data using PivotTables and PivotCharts and you will learnhow to access the Quick Analysis tools. We will also work with maps andthe new 3D Maps feature, use Power Pivot to effectively build and userelational data sources in an Excel workbook, consolidate workbook databy creating a summary sheet, build a relationship between datasets foreasy 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