PivotTables in Excel 2016 for Mac

Excel 2016 (Mac)    |    Intermediate
  • 10 videos | 41m 13s
  • Earns a Badge
Likes 25 Likes 25
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 in Excel 2016 for Mac
    4m 50s
    UP NEXT
  • Playable
    2. 
    Editing your PivotTable in Excel 2016 for Mac
    3m 52s
  • Locked
    3. 
    Inserting a calculation in your PivotTable in Excel 2016 for Mac
    3m 42s
  • Locked
    4. 
    Sorting data in your PivotTable in Excel 2016 for Mac
    3m 22s
  • Locked
    5. 
    Filtering your table data in Excel 2016 for Mac
    4m 3s
  • Locked
    6. 
    Grouping data in your PivotTable in Excel 2016 for Mac
    3m 47s
  • Locked
    7. 
    Inserting a slicer in your PivotTable in Excel 2016 for Mac
    4m 18s
  • Locked
    8. 
    Comparing values in a PivotTable in Excel 2016 for Mac
    2m 42s
  • Locked
    9. 
    Formatting your PivotTable in Excel 2016 for Mac
    6m 4s
  • Locked
    10. 
    Copying & reusing your PivotTable in Excel 2016 for Mac
    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 on some of our courses, 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 59 Likes 59  
Likes 231 Likes 231  
Likes 2456 Likes 2456