25,000+ Courses Nationwide
0345 4506120

Google Workspace - Sheets Essentials

Special Notices

Please note: for Attend from Anywhere customers an additional screen is required for this course to work through remote desktop labs and view training information.

In this hands-on instructor led course, you will learn about the basics of the Google sheets app.

Following the course, delegates will be confident in navigating, creating and modifying a Google sheet. Delegates will also learn about basic formatting and create basic formulas and functions.

This course can be customised to meet your organisation's specific requirements or Google environment, please contact us for further details. 

Select specific date to see price, venue and full details.

Learning Objectives

Delegates will learn how to

  • Get started with Google sheets
  • Create a basic worksheet
  • Modify a Google sheet
  • Use formulas and functions
  • Format a Google worksheet
  • Manage worksheets
  • Set up printing options

Pre-Requisites

  • Use a mouse
  • Type and use a keyboard
  • Experience in web browsing
  • Work with windows - minimise, maximise, open and close
  • Basic skills with Microsoft Office applications, or equivalent, are recommended, but   not mandatory
  • Basic knowledge of Google drive and what it does is recommended, although not necessary

Course Content

Module 1: Getting started with Google Sheets

  • Introduction to Google Chrome / Google Drive
  • Google Sheets and the Environment
  • Navigate and Select Data
  • Create a Basic Spreadsheet
  • Open, Save and Close a Google Sheet
Module 2: Modifying a Google Sheet
  • Cut, Copy and Paste Commands
  • AutoFill Options
  • Insert and Delete Options
  • Column Width and Row Height
  • Find and Replace
  • Undo / Redo
Module 3: Using Formulas and Functions
  • Create Relative Formulas
  • AutoCalculate
  • Insert Functions
  • Use AutoSum
  • Copy Formulas
  • Create Absolute Formulas
Module 4: Formatting a Google Sheet
  • Font Formatting Options
  • Add Borders and Fill Colours
  • Cell Alignment
  • Number Formatting
Module 5: Managing Google Sheets
  • Manage Worksheets
  • View different Google Sheets and Files
  • Freeze Panes and Split
  • Navigate around different Sheets within Google Chrome and Drive
  • Print Google Sheets and Change Print Options

Related Courses

Privacy Notice

In order to provide you with the service requested we will need to retain and use your contact information in accordance with our Privacy Notice. If you choose to provide us with this information you explicitly consent to us using the information as necessary to provide the requested service to you. If you do not agree please do not proceed to request the service from us.

Marketing Permissions

Would you like to receive our newsletter and other information on products and services which we think will be of interest to you by email. We will always treat your information with care and in accordance with our Privacy Notice. You are free to withdraw this permission at any time.

 

We work with the best