1 day course 
Certificate of Attendance 
Classroom, Virtual, Private 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 scheduled session at our training centre in The Shard, London, or via Virtual Classroom. We also offer it as a private course, delivered virtually, at your offices, ours, or any location that works best for you, whether in the UK or internationally.
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
- -Why spreadsheets matter (still!) in modern analytics
- -Overview and Navigation in Google Sheets
- -Creating a table
- -Creating and managing tabs
- -Formating data in a table
- -Filtering data in a table
-Structuring raw data for analysis:
- -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
- -Creating effective pivot tables
- -Creating Graphs to visualise the data
- -Building dashboards with linked charts and summaries
- -Formatting tips for clean, executive-friendly outputs
- -Named ranges, data validation, drop-downs
- -Version control and sharing best practices
- -Troubleshooting formulas and debugging errors
- -Automating recurring tasks