Working with Data in PivotTables in Excel 2019 for Windows

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 PivotTables display and control settings. In order to practice what you have learned you will find the Word document named Excel 2019 for Windows: Working with Data in PivotTables Exercise as well as the associated materials in the Resources section.