Manipulating PivotTable data in Excel 365

Excel Microsoft 365 (2021)    |    Intermediate
  • 11 Videos | 39m 1s
  • Includes Assessment
  • Earns a Badge
  • Certification CPE
Once you have created your Excel PivotTables, you will need to know how to manage and work with the data contained in them. In this course, you will learn how to analyze, calculate, compare, and work with Excel PivotTables as well as use the timeline. Key concepts covered in this course include how to edit the source data and field setup in a PivotTable; how to organize data logically by creating data groups within a PivotTable; and how to incorporate data from external sources to analyze in an Excel 365 PivotTable. You will also learn how to use sort tools to change the display of data; use filter tools to show and hide data, and work with values for comparison calculations. Finally, you will discover how to troubleshoot common PivotTable issues in Excel 365. In order to practice what you have learned, you will find practice exercises and samples in the Resources section.

WHAT YOU WILL LEARN

  • discover the key concepts covered in this Manipulating PivotTable data in Excel 365 course
    sort PivotTable data in Excel 365
    filter PivotTable data in Excel 365
    use the Data Model to work with data from multiple tables in an Excel 365 PivotTable
    analyze PivotTable data in Excel 365
    analyze database tables in a PivotTable in Excel 365
  • compare values in a PivotTable in Excel 365
    use the Timeline tool with PivotTables in Excel 365
    group PivotTable data in Excel 365
    add calculated PivotTable items and fields in Excel 365
    troubleshoot issues with PivotTables in Excel 365

IN THIS COURSE

  • Playable
    1. 
    Overview: Manipulating PivotTable data in Excel 365
    49s
    UP NEXT
  • Playable
    2. 
    Sorting data in your PivotTable
    2m 45s
  • Locked
    3. 
    Filtering your PivotTable data
    3m 38s
  • Locked
    4. 
    Working with multiple PivotTable data tables
    5m 11s
  • Locked
    5. 
    Analyzing data in a PivotTable
    3m 37s
  • Locked
    6. 
    Analyzing your database tables in a PivotTable
    4m 21s
  • Locked
    7. 
    Comparing values in a PivotTable
    3m 40s
  • Locked
    8. 
    Using the Timeline
    3m 38s
  • Locked
    9. 
    Grouping data in your PivotTable
    3m 33s
  • Locked
    10. 
    Using calculations in a PivotTable
    3m 44s
  • Locked
    11. 
    Troubleshooting issues with PivotTables
    4m 5s

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