1 day course

Certificate of Attendance

Private

A private training session for your team. Groups can be of any size, at a location of your choice including our training centres.

This hands-on workshop is built for analysts, marketers, and business professionals who want to move beyond the basics and use Google Sheets like true data pros.

You’ll learn how to clean, transform, analyse, and visualise data using the powerful formulas, functions, and features already at your fingertips. Instead of teaching tools in isolation, we focus on real-world use cases, repeatable workflows, and smart shortcuts that make your work faster, clearer, and more impactful.

Whether you're wrangling messy campaign data, building reports, or supporting fast-moving teams, this course gives you the structure and confidence to turn spreadsheets into your most powerful analysis tool.

Our Google Sheets Fundamentals course is available as a private session that can be delivered at a location of your choice across South Africa, globally or online.

Course overview

Who should attend:

This course is perfect for anyone wanting a solid foundation in working with data in Google Sheets.

What you'll learn:

By the end of this course, you will be able to:

Confidently clean, transform, analyse, and visualise data using the built-in power of Google Sheets
Apply repeatable workflows and smart shortcuts to save time and reduce errors
Draw insights from real-world scenarios and apply them to your own work with clarity and purpose

Course agenda

Spreadsheet Foundations

-Why spreadsheets matter (still!) in modern analytics
-Overview and Navigation in Google Sheets

-Structuring raw data for analysis:

-Creating a table
-Creating and managing tabs
-Formating data in a table
-Filtering data in a table

Essential Formulas & Functions

-Calculation formulas
-Aggregation: SUMIFS, COUNTIFS, AVERAGEIFS
-Date and time functions
-Conditional logic: IF, IFS, SWITCH
-Lookup formulas: VLOOKUP, INDEX, MATCH, XLOOKUP
-Dynamic ranges and automation: ARRAYFORMULA, OFFSET, INDIRECT
-Bonus: QUERY, IMPORTDATA, SPARKLINE

Reporting & Visualisation

-Creating effective pivot tables
-Creating Graphs to visualise the data
-Building dashboards with linked charts and summaries
-Formatting tips for clean, executive-friendly outputs

Time-Savers & Scaling

-Named ranges, data validation, drop-downs
-Version control and sharing best practices
-Troubleshooting formulas and debugging errors
-Automating recurring tasks

Putting all together with a project

Next Steps:

Looking for the next step in your analytics journey? Check out our Data Storytelling, SQL Fundamentals, and Looker Studio courses.