Google Sheets
Intermediate Training
Google Sheets is a powerful tool for organising and analysing data. This course focuses on advanced features for impactful data visualisation. Participants will learn to use functions, create complex charts, and analyse data effectively, enhancing their ability to communicate insights clearly.
From £199
Per person
Onsite
Live online
1 day
Our Google sheet training courses are designed for all skill levels, from beginner to advanced and specialised topics. We offer flexible onsite and live online sessions, accommodating groups as small as 2 participants and up to 20, providing a personalised learning experience for everyone.
What you will learn
Familiarise yourself with the interface, refresh basic formulas, and understand relative vs. absolute addressing.
Master statistical functions (Average, Max, Min), use SUMIF, COUNTIF, and the basic IF function, along with text and date/time functions.
Utilise the conditional formatting rules manager, create custom rules, clear formatting, and highlight duplicate values.
Freeze rows/columns, sort and filter data, create filter views, and develop dynamic charts.
7 lesson covers:
Google Sheets Interface & Basics
Review the Google Sheets interface and refresh your knowledge of basic formulas and functions to ensure a solid foundation.
Advanced Formulae
Learn to understand and use relative and absolute addressing, as well as create and utilize range names for more advanced formulae that enhance your data management capabilities.
Working with Sheets
Cover how to delete, move, and copy sheets effectively. You will also learn how to perform calculations across multiple sheets, streamlining your data analysis.
More Advanced Functions
You will examine a variety of advanced functions, including statistical functions such as Average, Max, Min, Count, and Counta. Additionally, you will discover how to utilize SUMIF, COUNTIF, SUMIFS, and COUNTIFS, along with implementing the basic IF function, text functions, and date and time functions.
Conditional Formatting
Learn how to use conditional formatting rules, create conditional formatting using formulas, and clear formatting rules as needed. You will also learn how to highlight duplicate values to maintain data integrity.
Working with Data
Discover how to freeze rows and columns for improved visibility, organize and filter data efficiently, and apply sort and filter functions. You will create filter views and design dynamic charts to visualize your data.
