Working with Data in PivotTables

Excel 2019 (Windows)    |    Intermediate
  • 8 Videos | 28m 44s
  • Includes Assessment
  • Earns a Badge
  • Certification CPE
Likes 78 Likes 78
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 PivotTable
    work with multiple data tables in a PivotTable
    import database tables into the Data Model and use them in a PivotTable
    use calculations in a PivotTable
  • compare values in a PivotTable
    insert a PivotChart
    modify a PivotChart
    configure a PivotTable

IN THIS COURSE

  • Playable
    1. 
    Analyzing data in a PivotTable
    3m 57s
    UP NEXT
  • Playable
    2. 
    Working with multiple data tables in a PivotTable
    4m 24s
  • Locked
    3. 
    Analyzing your database tables in a PivotTable
    3m 54s
  • Locked
    4. 
    Using calculations in your PivotTable
    3m 40s
  • Locked
    5. 
    Comparing values in a PivotTable
    3m 5s
  • Locked
    6. 
    Inserting a PivotChart
    3m 44s
  • Locked
    7. 
    Modifying your PivotChart
    2m 37s
  • Locked
    8. 
    Configuring your PivotTable
    3m 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.

YOU MIGHT ALSO LIKE

COURSE Managing Data
Likes 50 Likes 50  
Likes 231 Likes 231  

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Likes 266 Likes 266  
Likes 95 Likes 95  
Likes 238 Likes 238