Data-driven Decisions with Google Sheets

Core Skills
Like Excel, Google Sheets is a spreadsheet program that provides users with advanced data analysis capabilities. It brings a familiar interface with many of the same functionalities as Excel. 

Data-driven Decisions with Google Sheets​

Core Skills
Like Excel, Google Sheets is a spreadsheet program that provides users with advanced data analysis capabilities. It brings a familiar interface with many of the same functionalities as Excel. ​

prerequisites

No prior knowledge 
necessary

All levels welcome

duration

Full day or
two half-days

Virtual or in-person

certification

afterskills Google Sheets 
practitioner

Awarded upon completion

course description_

Google Sheets is a web application, so it allows users to load data and perform a wide range of calculations right from within the browser. Because of this, it enables better collaboration amongst team members as multiple users are allowed to make changes simultaneously in real time. The platform is increasingly gaining popularity within the corporate realm as the files can be easily shared and maintained at scale for a low price. Additionally, GSuite is one of the fastest growing cloud-based solutions which is where Google Sheets sits. ​

Data-driven Decisions with Google Sheets provides a comprehensive overview of the core functions and collaborative tools available and is designed to take absolute beginners to proficiency in the shortest amount of time possible. Participants will leave with a strong knowledge of how to analyze, structure and solve real-world business problems using Google Sheets.

agenda

Topic 1: Introduction & Data Auditing
Topic 2: Functions & Formulas
Topic 3: Relative References
Topic 4: Vertical Lookups (Vlookup)
Topic 5: Grouping & Summarising - Pivot Tables, Aggregate Functions​
Topic 6: Charts
ENQUIRE