Google Sheets Fundamentals
Do you build reports and wrangle data in Google Sheets, but feel stuck when it’s time to draw insights? This workshop teaches you to analyse, not just organise - turning spreadsheets into tools for clear, confident decision-making.
Book this courseCOURSE OVERVIEW
1 day course
Certificate of Attendance
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 private course, delivered virtually, at your offices, ours, or any location that works best for you, whether in the UK or internationally.
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
Draw insights from real-world scenarios and apply them to your own work with clarity and purpose
Apply repeatable workflows and smart shortcuts to save time and reduce errors
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 everything together with a project
Who it's for
This course is perfect for anyone wanting a solid foundation in working with data in Google Sheets.
Next Steps
Looking for the next step in your analytics journey? Check out our Data Storytelling, SQL Fundamentals and Looker Studio courses.
BOOK THIS COURSE
Enquire for a team or large group
For private sessions call our sales team