You have now learned valuable skills for visualizing and analyzing data in this chapter, using powerful tools such as PivotTable to create slicers and timelines, and you can now group PivotTable data. We applied these skills to create PivotCharts and also summarized data across worksheets using the Consolidate feature. With the ability to install the Analysis Toolpak, you are now able to analyze data using descriptive statistics and use the what-if analysis tools. We discovered the new 3D Maps feature and are now equipped to create a timeline tour. You also learned how to create macros and add them to a new tab in Excel, and you have a thorough understanding of data models. We also saw an introduction to Power Pivot and Power Query.
In the next chapter, we'll see a variety of common tasks that are applicable to Word, PowerPoint, and Excel.
