Google Sheets Introduction

• 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

• 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

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