PivotTables

Excel 2016 (Mac)    |    Intermediate
  • 10 Videos | 41m 13s
  • Earns a Badge
Likes 20 Likes 20
A PivotTable is one of the most powerful and intimidating features in Excel. Learn how to get the most out of a PivotTable to help you summarize and extract information from your data.

WHAT YOU WILL LEARN

  • create PivotTables in Excel 2016 for Mac
    edit PivotTables in Excel 2016 for Mac
    insert calculations in PivotTables in Excel 2016 for Mac
    sort data in PivotTables in Excel 2016 for Mac
    filter your table data in Excel 2016 for Mac
  • create data groups in your PivotTables
    insert a slicer into your PivotTable
    compare values in your PivotTables
    format your PivotTables
    copy and reuse your PivotTable

IN THIS COURSE

  • Playable
    1. 
    Creating a PivotTable
    4m 50s
    UP NEXT
  • Playable
    2. 
    Editing your PivotTable
    3m 52s
  • Locked
    3. 
    Inserting a calculation in your PivotTable
    3m 42s
  • Locked
    4. 
    Sorting data in your PivotTable
    3m 22s
  • Locked
    5. 
    Filtering your table data
    4m 3s
  • Locked
    6. 
    Grouping data in your PivotTable
    3m 47s
  • Locked
    7. 
    Inserting a slicer in your PivotTable
    4m 18s
  • Locked
    8. 
    Comparing values in a PivotTable
    2m 42s
  • Locked
    9. 
    Formatting your PivotTable
    6m 4s
  • Locked
    10. 
    Copying & reusing your PivotTable
    4m 33s

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.

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Likes 86 Likes 86  
COURSE Tools
Likes 72 Likes 72