Working with Data in PivotTables

Excel Microsoft 365 (Windows)
  • 8 Videos | 33m 48s
  • Includes Assessment
  • Earns a Badge
Likes 139 Likes 139
Explore ways to analyze data for trends by using a PivotTable in Excel for Office 365, in this 8-video course, which demonstrates how to organize fields, add extra levels of detail to data, and to insert multiple value fields in a single table. You will observe how to use a data model to pull data from multiple tables and build a relational data source inside a workbook. This course demonstrates how to pull data from external sources, for example, an Access database, and analyze it in a PivotTable. You will learn to insert calculated fields that use already inserted data in the PivotTable. You will also learn how to change a summary calculation or apply a comparison in a PivotTable, and how to visualize data rank as a percentage or as a difference. You will learn how to create a new PivotChart or convert already inserted data in a PivotTable. Finally, you to use PivotTable options to change how null data values and errors are displayed.

WHAT YOU WILL LEARN

  • use a PivotTable to find trends and drill into data
    use the Data Model to work with data from multiple tables
    import existing database tables into the Data Model and use them in a PivotTable
    add Calculated Items and Calculated Fields to a PivotTable
  • use the Value tools to and summary and comparison calculations
    visualize data from a PivotTable in a PivotChart
    customize and format a PivotChart
    configure and customize a PivotTable's display and control settings

IN THIS COURSE

  • Playable
    1. 
    Analyzing data in a PivotTable
    4m 10s
    UP NEXT
  • Playable
    2. 
    Working with multiple data tables in a PivotTable
    4m 41s
  • Locked
    3. 
    Analyzing your database tables in a PivotTable
    3m 56s
  • Locked
    4. 
    Using calculations in your PivotTable
    3m 22s
  • Locked
    5. 
    Comparing values in a PivotTable
    3m 16s
  • Locked
    6. 
    Inserting a PivotChart
    4m 5s
  • Locked
    7. 
    Modifying your PivotChart
    2m 55s
  • Locked
    8. 
    Configuring your PivotTable
    3m 24s

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

Likes 206 Likes 206  
Likes 212 Likes 212  

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Likes 255 Likes 255  
Likes 206 Likes 206  
Likes 238 Likes 238