Once your Excel PivotTables have been created, you will need to know how to manage and work with the data contained within. In this 8-video course, learners will learn how to analyze, calculate, collaborate, and more with Excel PivotTables. Key concepts covered in this course include how to use a PivotTable to find trends and drill into data, adding extra levels of detail and multiple value fields in a single table; how to use the Data Model to work with data from multiple tables; and how to import existing database tables into the Data Model and use them in a PivotTable. Next, learners will examine how to add Calculated fields that use already inserted data; how to use the Value field settings to work with values for comparison calculations; and how to see data from a PivotTable in a PivotChart then customize and format the PivotChart. Finally, because a PivotTable is highly customizable, you will observe how to configure and customize a PivotTable's display and control settings.
Excel 2019: Working with Data in PivotTables