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
    FREE ACCESS
  • Locked
    4. 
    Sorting data in your PivotTable in Excel 2016 for Mac
    3m 22s
    FREE ACCESS
  • Locked
    5. 
    Filtering your table data in Excel 2016 for Mac
    4m 3s
    FREE ACCESS
  • Locked
    6. 
    Grouping data in your PivotTable in Excel 2016 for Mac
    3m 47s
    FREE ACCESS
  • Locked
    7. 
    Inserting a slicer in your PivotTable in Excel 2016 for Mac
    4m 18s
    FREE ACCESS
  • Locked
    8. 
    Comparing values in a PivotTable in Excel 2016 for Mac
    2m 42s
    FREE ACCESS
  • Locked
    9. 
    Formatting your PivotTable in Excel 2016 for Mac
    6m 4s
    FREE ACCESS
  • Locked
    10. 
    Copying & reusing your PivotTable in Excel 2016 for Mac
    4m 33s
    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 on some of our courses, which can be shared on any social network or business platform.

Digital badges are yours to keep, forever.

YOU MIGHT ALSO LIKE

Course Referencing data in Excel 365
Course Manipulating PivotTable data in Excel 365
Course Using macros in Excel 365

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Course Configuring Excel 2016 for Mac
Likes 59 Likes 59  
Course Inserting PivotTables in Excel 2019 for Windows
Likes 231 Likes 231  
Course Maximize Your Productivity by Managing Time and Tasks
Likes 2456 Likes 2456