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
    FREE ACCESS
  • Locked
    4. 
    Formatting your PivotTable
    5m 18s
    FREE ACCESS
  • Locked
    5. 
    Copying & reusing your PivotTable
    4m 40s
    FREE ACCESS
  • Locked
    6. 
    Inserting a calculation in your PivotTable
    4m 20s
    FREE ACCESS
  • Locked
    7. 
    Sorting data in your PivotTable
    2m 55s
    FREE ACCESS
  • Locked
    8. 
    Filtering your table data
    4m 50s
    FREE ACCESS
  • Locked
    9. 
    Grouping data in your PivotTable
    4m 48s
    FREE ACCESS
  • Locked
    10. 
    Inserting a slicer in your PivotTable
    4m 24s
    FREE ACCESS
  • Locked
    11. 
    Customizing your slicer
    3m 43s
    FREE ACCESS
  • Locked
    12. 
    Comparing values in a PivotTable
    3m 32s
    FREE ACCESS
  • Locked
    13. 
    Inserting a PivotChart
    3m 43s
    FREE ACCESS
  • Locked
    14. 
    Modifying your PivotChart
    4m 56s
    FREE ACCESS
  • Locked
    15. 
    Analyzing your database tables in a PivotChart
    6m 39s
    FREE ACCESS

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

COURSE Getting started with charts in Excel 365
Likes 9 Likes 9  
COURSE Working with Macros
Likes 12 Likes 12  
COURSE Complete Guide to Excel 365: Working With Charts & Sparklines

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

COURSE Inserting PivotTables
Likes 238 Likes 238  
COURSE Developing an Effective Business Case
Likes 679 Likes 679  
COURSE Finding & Analyzing Information with Formulas
Likes 44 Likes 44