Working with Data in PivotTables
Excel 2019 (Windows)
| Intermediate
- 8 Videos | 28m 44s
- Includes Assessment
- Earns a Badge
- CPE
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. 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.
WHAT YOU WILL LEARN
-
analyze data in a PivotTablework with multiple data tables in a PivotTableimport database tables into the Data Model and use them in a PivotTableuse calculations in a PivotTable
-
compare values in a PivotTableinsert a PivotChartmodify a PivotChartconfigure a PivotTable
IN THIS COURSE
-
1.Analyzing data in a PivotTable3m 57sUP NEXT
-
2.Working with multiple data tables in a PivotTable4m 24s
-
3.Analyzing your database tables in a PivotTable3m 54s
-
4.Using calculations in your PivotTable3m 40s
-
5.Comparing values in a PivotTable3m 5s
-
6.Inserting a PivotChart3m 44s
-
7.Modifying your PivotChart2m 37s
-
8.Configuring your PivotTable3m 22s
EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE
Skillsoft is providing you the opportunity to earn a digital badge upon successful completion of this course, which can be shared on any social network or business platform
Digital badges are yours to keep, forever.