Understanding Google Sheets - 2021 Edition: The Step-by-step Guide to Understanding the Fundamentals of Google Sheets

Updated to cover the latest version of Google Sheets, this guide will show you how to:

Start Google Sheets and find your way around navigation menus

Format text: bold, italic, underlined, and strikethrough

Align text, highlight and change text colour

Cut, copy, paste and using the clipboard

Add borders, cell shading and conditional formatting

Insert charts

Add, move and crop images

Insert formulas and functions

Filter and sort data

Analysed data with goalseek and pivot tables

Add validation rules to ensure users enter accurate data

Print your spreadsheets

Convert documents to other formats such as PDF or Excel

Share your spreadsheets, print them out, or email them as attachments.

Collaborate with other users with collaboration features

Check spelling and grammar

Expand the functionality of Google Sheets using Addons

Take Google Sheets with you on your tablet and work from anywhere

Get started with Google Drive

You'll want to keep this edition handy as you make your way around Google Sheets.

We want to create the best possible resource to help you, so if we've missed anything out then please get in touch using [email protected] and let us know. Thanks.

Have Fun!