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/...
Watch video Google Sheets: Create a Pivot Table (Summarize your data by repeated values or custom groups) online without registration, duration hours minute second in high quality. This video was added by user DoIT Training at Stony Brook University 01 November 2019, don't forget to share it with your friends and acquaintances, it has been viewed on our site 14,886 once and liked it 56 people.