Google Sheets Pivot Tables: Your Secret Weapon for Data Analysis
Using Pivot Tables in Google Sheet
Spot trends and patterns in your data using Pivot Tables.
Have you always wanted to use Pivot Tables but did not know how to get started? Join us in this session and we will take you through how to make the most of Pivot Tables to help you understand and analyse your data more effectively.
This session sits alongside the other sessions in the Google Sheets series and would be advisable to attend before the Creating Dashboards session.
Badge earned on completion
Difficulty
Shareable Certificate
Key Takeaways
- Introduction to Pivot Tables and how they can be applied to data
- Creating Pivot Tables – the basics. We demonstrate how to create a basic Pivot Table and what to look out for
- Formatting – Applying conditional formatting to make your results stand out
- SORT – Using the sort function built within Pivot Tables so you can dig deeper into your data
- Advanced Pivot Tables – tools such as utilising the grouping function to help you understand trends in regions and sectors
£60.00