Working with Data in PivotTables

Excel 2019 (Windows)    |    Intermediate
  • 8 Videos | 40m 44s
  • Includes Assessment
  • Earns a Badge
  • Certification CPE
  • Certification PMI PDU
Likes 46 Likes 46
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.

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
    FREE ACCESS
  • Locked
    4. 
    Using calculations in your PivotTable
    3m 40s
    FREE ACCESS
  • Locked
    5. 
    Comparing values in a PivotTable
    3m 5s
    FREE ACCESS
  • Locked
    6. 
    Inserting a PivotChart
    3m 44s
    FREE ACCESS
  • Locked
    7. 
    Modifying your PivotChart
    2m 37s
    FREE ACCESS
  • Locked
    8. 
    Configuring your PivotTable
    3m 22s
    FREE ACCESS

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 Excel Visualization: Getting Started with Excel for Data Visualization
Likes 0 Likes 0  
COURSE Working with tables in Excel 365
Likes 11 Likes 11  
COURSE Working with Excel Tables
Likes 212 Likes 212  

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

COURSE Inserting PivotTables
Likes 132 Likes 132  
COURSE Working with Data in PivotTables
Likes 139 Likes 139  
COURSE Working with Excel Tables
Likes 206 Likes 206