5910 Breckenridge Pkwy Suite B, Tampa, FL. 33610
(800) 272-0707

SkillSoft Explore Course

Productivity & Collaboration Tools     Microsoft Office 365     Excel 365

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.



Objectives

Excel 365: Creating PivotTables and PivotCharts in Excel 365

  • 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
  • Knowledge Check: Creating PivotTables and PivotCharts in Excel 365