Google Workspace - Sheets: Intermediate
Course Description
Self-taught users of Sheets often miss some of the great tools available in Google Workspace. This course aims to highlight the key functions in building spreadsheets, analysing, interrogating and presenting data.
1 Day
Contact us for pricing
Prerequisites
Sheets users who want to move their skills from basic to Intermediate and gain an understanding of what is possible with more advanced tools in Sheets. The course is for existing Sheets users (or former Excel users) to ensure you have got the key knowledge to move on to Advanced skills and automating functions within Sheets and integrating with other Google Workspace apps.Working with Sheets & Data
Create Multiple Sheets using Group modeNaming/ Deleting/Inserting
Moving/Copying
Linking sheets
Sorting/Filtering
Sheet Protection
Cell Referencing
MixedAbsolute
Relative
Range Names
Creating a Range NameUsing Range Names in Functions
Delete Range Names
Functions
Basic IF FunctionSumIf
CountIf
If Function
ISBlank
ISText
ISError
IFError
VLOOKUP
Using VLOOKUP to Find DataHow to Find an Exact Match with VLOOKUP
Finding the Closest Match with VLOOKUP
Graphs
Creating GraphsManipulating Graphs
Advanced Edits
DocsG SuiteGoogle AppsGoogle Cloud PlatformGoogle DocsGoogle SheetsGoogle SuiteGSuiteSlidesGoogleGoogle Workspace