Business and IT training from QA

Google Sheets Introduction

About this course

Course type Performance Plus
Course code QAGSINT
Duration 1 Day

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.

Show more Show less

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

Show more Show less

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

Show more Show less

Outline

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

Show more Show less
Performance Plus

1 Day

Duration

This course is authored by QA

Delivery Method

Delivery method

Classroom / Attend from Anywhere

Receive classroom training at one of our nationwide training centres, or attend remotely via web access from anywhere.

Find dates and prices

Online booking is currently not available for this course, to find out more please call us on 0113 220 7150 or email us at info@qa.com to discuss how we can help.

Trusted, awarded and accredited

Fully accredited to ensure we provide the highest possible standards in learning

All third party trademark rights acknowledged.