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, duration hours minute second in high quality that is uploaded to the channel DoIT Training at Stony Brook University 01 November 2019. Share the link to the video on social media so that your subscribers and friends will also watch this video. This video clip has been viewed 14,886 times and liked it 56 visitors.
