Working with Data in PivotTables in Excel Microsoft 365 for Windows

Excel Microsoft 365 (Windows)    |    Intermediate
  • 8 Videos | 29m 48s
  • Includes Assessment
  • Earns a Badge
Likes 243 Likes 243
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 in Excel Microsoft 365 for Windows
    4m 10s
    UP NEXT
  • Playable
    2. 
    Working with multiple data tables in a PivotTable in Excel Microsoft 365 for Windows
    4m 41s
  • Locked
    3. 
    Analyzing your database tables in a PivotTable in Excel Microsoft 365 for Windows
    3m 56s
  • Locked
    4. 
    Using calculations in your PivotTable in Excel Microsoft 365 for Windows
    3m 22s
  • Locked
    5. 
    Comparing values in a PivotTable in Excel Microsoft 365 for Windows
    3m 16s
  • Locked
    6. 
    Inserting a PivotChart in Excel Microsoft 365 for Windows
    4m 5s
  • Locked
    7. 
    Modifying your PivotChart in Excel Microsoft 365 for Windows
    2m 55s
  • Locked
    8. 
    Configuring your PivotTable in Excel Microsoft 365 for Windows
    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

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Likes 231 Likes 231  
Likes 21 Likes 21