Google Sheets - Functions

Course Rating
4.8/5
Instructor Rating
4.94/5
Google Sheets

Running Sessions 
Every 2 weeks

0 +
Attendees

Linking sheets together, complex calculations and importing data from the web... this session has it all

Google Sheets is a powerful spreadsheet tool built within Google Workspace. 

To get the best out of it we have created several sessions to cover all of the functionality that will help you master Google Sheets. This is the 3rd in the series following on from the Introduction and Intermediate sessions and whilst we recommend you attend these first it is not mandatory to do so.

Functions are powerful tools built directly into Google Sheets and have a wide range of uses from simple calculations to importing tables from the web and much more!

Duration: 60 minutes

What we will cover in this course?

Overview of Functions

We take a look at the basics of functions and how to use them

IMPORTRANGE

Linking live data across different spreadsheets

VLOOKUP

Blending two separate tables into 1 using rules for importing

ARRAY

Making the most of this versatile function in differing scenarios

SPLIT

Enhancing your data by separating different data contained in the same cell

CURRENCY, TRANSLATE & TRANSPOSE

Three useful functions we take a look at importing in data from the web for live currency, translating text and more.

Want to join us? ​

Get in touch to get your team onto one of our free sessions
Gamification badge - sheets trained by CEyX

Your Shareable Badge

Earn a badge on completion

advanced icon
Advanced Level
Multiple session times

Lots of sessions to choose from

Live only session
Live Only content

Live instructor-led sessions available & video content

Shareable Certifications

Earn a certificate on completion