Google Sheets: Create a Pivot Table (Summarize your data by repeated values or custom groups)
Pivot Tables are an easy way to reconfigure your data and summarize it in groups. How is your department performing by team? What the average score by group and date? [Try it out yourself by copying the demo sheet below].
See an example with projects: Create a pivot table by adding rows, values, and columns in a pivot date group by year (show average project completion by project manager divided into projects due by year). Filter out rows with no date.
Copy Demo Sheet: https://doittraining.page.link/pivott...
Slides: https://docs.google.com/presentation/...