10 Insanely Simple Google Sheets Formulas (Beginner Guide)



If you’re not using formulas in your Google Sheets, you’re missing out. Here’s 10 simple Google Sheets formulas to get you started…


If you’ve ever watched a pro manoeuvre and organise data inside Google Sheets or Excel, it is quite a site to behold. They move things, take averages, extract trends from seemingly incomprehensible data sets – it is damn impressive basically.

And the sky’s the limit with what you can do with Google Sheets, once you have a firm grasp of how to implement and use formulas.

Obviously, most new users do not know any Google Sheets formulas, let alone the more advanced ones you can use to organise and glean information from large data sets.

But do not be put off by this; it is actually really easy to get started with formulas in Google Sheets. In this guide we’ll show you 10 really simple Google Sheets formulas that every beginner user should know.

Once you’ve mastered the formulas listed below, you can move on to more advanced Google Sheets formulas and really start workin’ your data.

This is a very basic set of formulas, mostly you will be using these to better organise and glean quick tidbits of information from your Google Sheets. But it is a great place to start and you’ll quickly find that, once you’re used to using formulas, you’ll quickly want to learn more.

How To Add Formulas in Google Sheets

Before you do ANYTHING, though, you’ll first need to know how to add a formula in Google Sheets.

10 Insanely Simple Google Sheets Formulas (Beginner Guide)
  • Save
source

Again, it is very straightforward; Sheets was built with formulas hard-baked into its functionalities, so adding a formula to any of your Sheets is a cinch.

What Can You Do With Formulas in Google Sheets?

Formulas – either in Excel or Sheets – are designed to make data management more efficient. At first, they can seem very daunting. I know this because I didn’t dare look into them for years – it just looked so complicated (and kind of reminded me of advanced mathematics).

But once you have even a basic handle on how to use formulas in Google Sheets, you can really start mining your data in a much more meaningful way. If you work with spreadsheets a lot, or they’re integral to your workflow, learning how to use formulas is one of the best things you can do.

Okay, let’s say you’re convinced. But what can you ACTUALLY do with formulas inside Google Sheets? Here’s a quick overview of just some of the cool stuff formulas unlock inside Google Sheets:

Things You Can Do With Formulas Inside Google Sheets

  • Basic arithmetic: You can use formulas to perform basic calculations such as addition, subtraction, multiplication, and division on numerical data in your sheet.
  • Statistical functions: You can use formulas to calculate statistical measures such as mean, median, mode, standard deviation, and more.
  • Date and time functions: You can use formulas to perform calculations on dates and times, such as finding the difference between two dates or adding a certain number of days to a date.
  • Lookup functions: You can use formulas to search for and retrieve specific data from your sheet or from other sheets within the same workbook.
  • Conditional formatting: You can use formulas to apply formatting to cells based on certain conditions. For example, you might use a formula to highlight cells that contain values above a certain threshold.
  • Importing data from other sources: You can use formulas to import data from other sources such as web pages, other sheets, or even other workbooks.

Again, with formulas, the sky really is the limit. Billions of people use Google Sheets, from large scale multinational corporations to students and bloggers – and they all use formulas and Sheets differently.

For instance, a business professional might use formulas to create a budget, calculate profitability, or analyze sales data.

If you’re a student, you might use formulas to track grades, create class schedules, or analyze survey results.

A researcher or PHD student might use formulas to calculate statistical measures, process data from experiments, or create graphs and charts.

Going further, a data analyst might use formulas to process and analyze large data sets, create pivot tables, or build models and predictions.

As I said, the potential with formulas is massive. If you want to start messing around with data – and you really should; big data is a huge trend right now – you need a way to understand and organise it. Using formulas in conjunction with Google Sheets is the easiest way to get started.

Google’s Sheets is free, unlike Microsoft’s Excel, and while it does lack of Excel’s more advanced features, Sheets has more than enough features and functionality under its hood to satisfy even the most hardcore spreadsheet users.

All you need is a Google Drive account to access Sheets. Check out our complete beginner’s guide to Google Drive for more information about what’s included inside Google’s productivity suite.

  • Save

Richard Goodwin

Richard Goodwin has been working as a tech journalist for over 10 years. He is the editor and owner of KnowYourMobile.
Subscribe
Notify of
0 Comments
Inline Feedbacks
View all comments

Keep Reading

Share via
Copy link
Powered by Social Snap