Creating PivotTables and PivotCharts in Excel 365

Excel Microsoft 365 (2021)    |    Intermediate
  • 11 Videos | 48m 19s
  • Includes Assessment
  • Earns a Badge
  • Certification CPE
  • Certification PMI PDU
Excel 365 includes powerful tools to summarize data. In this course, you will learn how to create, edit, and format PivotTables and PivotCharts; and how to use slicers. Key concepts covered in this course include how to use a PivotTable to find trends in data, and how to add extra levels of detail and multiple value fields in a single table. Because a PivotTable is highly customizable, you will observe how to configure and customize its display and control settings. Next, you will examine how to use label and value filters to analyze data, how to use a slicer to filter data, and how to customize the appearance of a slicer. Finally, you will explore how to use data from a PivotTable to create a PivotChart and then customize and format the PivotChart.

WHAT YOU WILL LEARN

  • discover the key concepts covered in this Creating PivotTables and PivotCharts in Excel 365 course
    create a PivotTable in Excel 365
    edit a PivotTable in Excel 365
    format a PivotTable in Excel 365
    insert a slicer into a PivotTable in Excel 365
    customize a PivotTable slicer in Excel 365
  • copy and reuse a PivotTable in Excel 365
    use PivotTable label and value filters in Excel 365
    configure a PivotTable in Excel 365
    insert a PivotChart in Excel 365
    modify a PivotChart in Excel 365

IN THIS COURSE

  • Playable
    1. 
    Overview: Creating PivotTables and PivotCharts in Excel 365
    49s
    UP NEXT
  • Playable
    2. 
    Creating a PivotTable
    5m 50s
  • Locked
    3. 
    Editing a PivotTable
    5m 25s
  • Locked
    4. 
    Formatting a PivotTable
    5m 33s
  • Locked
    5. 
    Inserting a slicer in a PivotTable
    3m 43s
  • Locked
    6. 
    Customizing a PivotTable slicer
    5m 27s
  • Locked
    7. 
    Copying and reusing a PivotTable
    3m 34s
  • Locked
    8. 
    Using label and value filters
    4m 6s
  • Locked
    9. 
    Configuring a PivotTable
    4m 14s
  • Locked
    10. 
    Inserting a PivotChart
    5m 8s
  • Locked
    11. 
    Modifying a PivotChart
    4m 30s

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 9 Likes 9  
Likes 231 Likes 231