Overview

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.

Target Audience

  • This course is designed for those who wish to gain the necessary skills to create, edit, format and print basic Google sheets.
  • This course is suitable for users of G-Suite tools by Google. If you're attending at a QA location, the course will be delivered on Google Chrome.

Prerequisites

  • 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

Dual monitor setup is required for when attending this course via the QA Attend from Anywhere delivery method.

Learning Outcomes

  • 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

Course Outline

Module 1: Getting Started with Google Sheets

  • Introduction to Google Chrome / Google Drive
  • Google Sheet Environment
  • Introducing Google Chrome
  • Logging in to your G Suite Tools
  • Accessing Google Sheets
  • Navigate and Selecting Cells in Worksheets
  • Open, Save and Close a Google Workbook

Module 2: Modifying a Google Sheet

  • Cut, Copy and Paste Commands
  • AutoFill Options
  • Find and Replace
  • Spell Check
  • Undo and Redo Commands
  • Insert and Delete Options
  • Column Width and Row Height
  • Hide and Unhide Options

Module 3: Using Formulas and Functions

  • Create Relative Formulas
  • Insert Google Functions
  • Copying a Formula
  • Creating an Absolute Formulas

Module 4: Formatting a Google Sheet

  • Font Formatting
  • Add Borders and Colours to Cells
  • Cell Alignment
  • Number Formatting

Module 5: Managing Google Sheets

  • Managing Sheets
  • Freeze Panes

Module 6: Printing Google Sheets

  • Printing Options
  • Print Preview Options

Please complete this form and we'll be in touch

Hide form
Please enter a date or timescale
Please type in a preferred location or region...