The Complete Guide to Google Sheets
Commission may be earned if you purchase through links on this site - learn more
Google Sheets is the free spreadsheet program available to everyone. Whether you use a Chromebook, Windows PC or Apple Mac you can access Google Sheets from the Chrome web browser. All you need is a Google Account and you’re good to go.
This complete guide is currently a work in progress and you’ll find more helpful links added on a regular basis. You’ll find everything you need to know about using Google Sheets.
GOOGLE SHEETS – THE BASICS
There are many different Spreadsheet programs available. Although these programs are presented differently, they generally work very much in the same way. This is why it’s important to understand the basics of spreadsheets. Whether you’re using Excel, Google Sheets or another spreadsheet program. Understanding the basic principles will help.
UNDERSTANDING THE BASICS OF SPREADSHEETS – Find out the basics that everyone needs to know about how spreadsheets work and what they are capable of. Getting to grips with the basics will help you move onto what spreadsheets were made for, which is data analysis and calculations.
ADDING NUMBERS – Learn how to add numbers using Google Sheets. One of the most basic of calculations you’ll regularly do on a spreadsheet. You’ll find out that there are many different ways to do a calculation using Google Sheets.
SUBTRACTING NUMBERS – Learn how to subtract numbers in a spreadsheet. Again, you’ll see how there is more than one way to get the desired result, which is why spreadsheets such as Google Sheets are so flexible.
MULTIPLYING NUMBERS – Learn how to multiply numbers in Google Sheets.
HOW TO DIVIDE NUMBERS – Find out how you divide numbers when using Google Sheets.
GOOGLE SHEETS – FORMATTING
There are many different ways to format a spreadsheet in Google Sheets. Some types of the formatting may be cosmetic to make a spreadsheet look more visually appealing. Other types of formatting are more practical such as changing a numeric value to show in a specific currency.
HOW TO WRAP TEXT – Wrapping text in a spreadsheet is something you’ll most likely need to use. Wrapping text allows you to keep the spreadsheet in a certain format and is a very useful tool. Find out more about how wrapping text works in Google Sheets.
HOW TO ADD CONDITIONAL FORMATTING – Conditional formatting is a really useful tool and it helps to analyse data on your spreadsheet. It can help give you an instant snapshot of a situation. It’s used widely in the business world because it makes it easy to understand the data in front of you.
ADDING OR REMOVING DECIMAL PLACES – Find out how to add or remove decimal places when using numbers in Google Sheets.
HOW TO USE CURRENCY AND CHANGE THE DEFAULT CURRENCY – Find out how to add a currency to your numbers in Google Sheets. Also, how to change the default currency, so you can show the currency of your choice.
GOOGLE SHEETS – FUNCTIONS
There are hundreds of functions available to use in Google Sheets. These functions are one of the reasons why spreadsheets are so useful and powerful to the end-user. A function is not a formula, but it can provide the same outcome.
THE DIFFERENCE BETWEEN A FORMULA AND FUNCTION – Understand the difference between a function and a formula when using Google Sheets.
AVERAGE – Find out how to use the average function when using Google Sheets. This function makes averaging easy and is useful in many different situations.
VLOOKUP – The vlookup is one of the most well known and used functions used with spreadsheets. It’s an extremely powerful function that allows you to match data easily. Once you understand how the vlookup works you’ll find many different ways in how it can help you on future spreadsheet projects.