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
    A PivotTable can be used to reanalyze data that has been inserted into your table. Excel 2016 for Mac's PivotTable is extremely flexible and can be modified in a variety of different ways to extract previously-unseen… FREE ACCESS
  • Playable
    2.  Editing your PivotTable in Excel 2016 for Mac
    3m 52s
    Excel 2016 for Mac's PivotTables are extremely customizable. You can change the different fields that have been added and change the calculations that are performed. You can also update your PivotTable to ensure that it… FREE ACCESS
  • Locked
    3.  Inserting a calculation in your PivotTable in Excel 2016 for Mac
    3m 42s
    As well as standard data fields, your Excel 2016 for Mac PivotTables can also be modified to display calculated fields. These are fields that are created using existing data and a calculation method. In this way, you can… FREE ACCESS
  • Locked
    4.  Sorting data in your PivotTable in Excel 2016 for Mac
    3m 22s
    Excel 2016 for Mac PivotTables can be used to cross-reference different data values. You can also use the fields that you have inserted to filter and sort your data values. FREE ACCESS
  • Locked
    5.  Filtering your table data in Excel 2016 for Mac
    4m 3s
    In Excel 2016 for Mac, it's easy to filter your data. The filtering tool will display your data in a table view with drop-down columns allowing you to choose to filter from among any of the data values that appear in each… FREE ACCESS
  • Locked
    6.  Grouping data in your PivotTable in Excel 2016 for Mac
    3m 47s
    Another useful way of sorting and organizing your data in your Excel 2016 for Mac PivotTable is to create data groups. You can, for example, group your data by month, year or category. You can also choose to temporarily… FREE ACCESS
  • Locked
    7.  Inserting a slicer in your PivotTable in Excel 2016 for Mac
    4m 18s
    A slicer is a special filter tool offered by Excel 2016 for Mac. It can be used to adjust the data that is visible in your PivotTable. It can also allow you to identify quickly the data filters that are currently applied.… FREE ACCESS
  • Locked
    8.  Comparing values in a PivotTable in Excel 2016 for Mac
    2m 42s
    In Excel 2016 for Mac, you can change the way in which you compare the values in your PivotTable. You can visualize your values in percentages, as a difference, and you can even sort and recalculate your data in… FREE ACCESS
  • Locked
    9.  Formatting your PivotTable in Excel 2016 for Mac
    6m 4s
    If you want to improve the appearance of your PivotTable, you can change its formatting settings. In Excel 2016 for Mac, you can change your PivotTable's style, color settings, and even the font that is used for your data… FREE ACCESS
  • Locked
    10.  Copying & reusing your PivotTable in Excel 2016 for Mac
    4m 33s
    Once you have created your PivotTable, you can move it, copy it, and reuse it. Once you have created a copy of your PivotTable, you can modify it as you see fit. You can copy and paste your PivotTables as much as you want… 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.

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Likes 742 Likes 742  
Likes 59 Likes 59