Start with a table that has one header row and consistent number/date types. Choose Insert → PivotTable, place categories in Rows and measures in Values, then verify the aggregation against the source total. Explore sorting, filters, refresh and reporting practice.