· Excel Formulas · 3 min read

Excel Lesson 17: Pivot Table Basics

Summarise thousands of rows in seconds: create a pivot table, drag fields into Rows, Columns, Values and Filters, change Sum to Count or Average, group dates by month, show % of total, sort, filter with slicers and refresh.

Read article →