Creating PivotTables and PivotCharts in Excel 365

Excel Microsoft 365 (2021)    |    Intermediate
  • 11 Videos | 37m 7s
  • Includes Assessment
  • Earns a Badge
  • Certification CPE
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. 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 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
    41s
    UP NEXT
  • Playable
    2. 
    Creating a PivotTable
    4m 30s
  • Locked
    3. 
    Editing a PivotTable
    4m 10s
  • Locked
    4. 
    Formatting a PivotTable
    4m 13s
  • Locked
    5. 
    Inserting a slicer in a PivotTable
    2m 47s
  • Locked
    6. 
    Customizing a PivotTable slicer
    4m 14s
  • Locked
    7. 
    Copying and reusing a PivotTable
    2m 46s
  • Locked
    8. 
    Using label and value filters
    3m 6s
  • Locked
    9. 
    Configuring a PivotTable
    3m 16s
  • Locked
    10. 
    Inserting a PivotChart
    3m 59s
  • Locked
    11. 
    Modifying a PivotChart
    3m 26s

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.