Objective:
Guide for creating PivotTables in Excel for Mac.


Steps:

  1. Select Data Range

    • Highlight the data you want to analyse.

  2. Insert PivotTable

    • Go to Insert > PivotTable, and set up your PivotTable by dragging fields to the Rows, Columns, and Values areas.