G Suite Sheets - Intermediate

Course Description

Self-taught users of Sheets often miss some of the great tools available in GSuite. This course aims to highlight the key functions in building spreadsheets, analysing, interrogating and presenting data.
1 days
Contact us for pricing

Prerequisites

Sheets users who want to move their skills from basic to Intermediate and gain an understanding of what's possible with more advanced tools in Sheets. The course is for existing Sheets users (or former Excel users) to ensure you've got the key knowledge to move on to Advanced skills and automating functions within Sheets and integrating with other G Suite apps.

Working with Sheets & Data

Create Multiple Sheets using Group mode
Naming/ Deleting/Inserting
Moving/Copying
Linking sheets
Sorting/Filtering
Sheet Protection

Cell Referencing

Mixed
Absolute
Relative

Range Names

Creating a Range Name
Using Range Names in Functions
Delete Range Names

Functions

Basic IF Function
SumIf
CountIf
If Function
ISBlank
ISText
ISError
IFError

VLOOKUP

Using VLOOKUP to Find Data
How to Find an Exact Match with VLOOKUP
Finding the Closest Match with VLOOKUP

Graphs

Creating Graphs
Manipulating Graphs
Advanced Edits

DocsG SuiteGoogle AppsGoogle Cloud PlatformGoogle DocsGoogle SheetsGoogle SuiteGSuiteSlidesGoogle