Course length 

1 day

Why come on this course?

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.

Course contents

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

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

Using Formulas and Functions

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

Formatting a Google Sheet

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

Managing Google Sheets

• Managing Sheets
• Freeze Panes

Printing Google Sheets

• Printing Options
• Print Preview Options