Creating PivotTables & PivotCharts

Excel 2016 (Windows)    |    Intermediate
  • 15 Videos | 1h 5m 42s
  • Includes Assessment
  • Earns a Badge
Likes 141 Likes 141
Excel 2016 includes powerful tools to summarize, sort, count, and chart data. Learn how to create, edit, and format PivotTables and PivotCharts; use calculations; sort, filter, and group data; and work with a slicer.

WHAT YOU WILL LEARN

  • Creating a PivotTable
    Creating a PivotTable with multiple data tables
    Editing your PivotTable
    Formatting your PivotTable
    Copying & reusing your PivotTable
    Inserting a calculation in your PivotTable
    Sorting data in your PivotTable
    Filtering your table data
  • Grouping data in your PivotTable
    Inserting a slicer in your PivotTable
    Customizing your slicer
    Comparing values in a PivotTable
    Inserting a PivotChart
    Modifying your PivotChart
    Analyzing your database tables in a PivotChart

IN THIS COURSE

  • Playable
    1. 
    Creating a PivotTable
    3m 52s
    UP NEXT
  • Playable
    2. 
    Creating a PivotTable with multiple data tables
    4m 24s
  • Locked
    3. 
    Editing your PivotTable
    3m 37s
  • Locked
    4. 
    Formatting your PivotTable
    5m 18s
  • Locked
    5. 
    Copying & reusing your PivotTable
    4m 40s
  • Locked
    6. 
    Inserting a calculation in your PivotTable
    4m 20s
  • Locked
    7. 
    Sorting data in your PivotTable
    2m 55s
  • Locked
    8. 
    Filtering your table data
    4m 50s
  • Locked
    9. 
    Grouping data in your PivotTable
    4m 48s
  • Locked
    10. 
    Inserting a slicer in your PivotTable
    4m 24s
  • Locked
    11. 
    Customizing your slicer
    3m 43s
  • Locked
    12. 
    Comparing values in a PivotTable
    3m 32s
  • Locked
    13. 
    Inserting a PivotChart
    3m 43s
  • Locked
    14. 
    Modifying your PivotChart
    4m 56s
  • Locked
    15. 
    Analyzing your database tables in a PivotChart
    6m 39s

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 238 Likes 238  
Likes 679 Likes 679  
Likes 44 Likes 44