Functions are the engine inside the cells of your spreadsheet. They power all your most important operations.

Whether you’re calculating compound interest, concatenating cells, or projecting financial expectations, you’ll need to use formulas in Google Sheets and Excel.

Here, we’ll talk about how they work. Our team of experts includes data analysts, programmers, and financial wonks.

Use our search function to look for any specific formula you want to explore, or read on for some of the most popular Google Sheets formulas we’ve ever covered.

## Popular Formulas in Google Sheets

We already mentioned a few powerful built-in formulas. The most common might be using a spreadsheet to calculate compound interest.

The same formulas also allow financial planners to project potential investment growth for retirement investments.

We use similar spreadsheet formulas for linear regression, which is helpful for predicting all sorts of financial situations.

Of course, many formulas are so ubiquitous they can’t be confined to a single category. You might need to concatenate cells for all sorts of imported data.

## Understanding Syntax

We cover the syntax of Google Sheets and Excel functions in every one of our articles. That means we’ll break down any formula with an equals sign.

In our article on the IF CONTAINS formula, you’ll see this:

`=REGEXMATCH(text, expression)`

Then, we break down what that means. The first term is the name of the function. The terms in parenthesis are arguments for the formula.

Those vary based on the Google Sheets function, so we give examples for exactly what you need.

We also include step-by-step instructions on how to use each formula. That’s true for Google Sheets and Excel functions.

Many of our articles also have their own videos. We post most of them on our YouTube channel, too.

## Find a Specific Formula

### How to Calculate Age in Google Sheets (2 Easy Methods)

To calculate age in Google Sheets, use the DATEDIF or YEARFRAC formulas. Follow along for screenshots and full formula explanations....

### How to Hide Gridlines in Google Sheets

To hide gridlines in Google Sheets, use the view menu or the print menu. This guide shows both (and how to add or remove lines in specific cells)....

### Excel and Google Sheets Drop Down Lists: Complete Guide

To make a Google Sheet drop down list, use the insert menu or right click. This guide also covers data validation in drop downs menus and Excel....

### How To Make a Google Sheets Heat Map: Easy 2024 Guide

Learn how to make a single-color, multi-color, and Geo Google Sheets heat map in a few clicks with this comprehensive step-by-step guide....

## How-To Videos

Our team of spreadsheet experts regularly makes videos on complex formulas.

Recently, we’ve covered VLOOKUP, SPLIT, and the COUNTIF formula.

### How to Make Multiple Selection in Drop-down Lists in Google Sheets

The main purpose of drop-down lists in Google Sheets is to offer options that a user can choose from. It gives users a clear look at all the available options and also makes sure the user selects only...

### A Simple Timestamp Google Sheets Tutorial for 2024

Looking for a timestamp Google Sheets tutorial? From keyboard shortcuts to formulas, discover everything you need about these quick hacks! ...

### How to Use VLOOKUP from Another Sheet in Google Sheets

There's a special function to help you use VLOOKUP from another sheet in Google Sheets and Excel. This guide includes screenshots....

Find out how to jump to a cell or range in Google Sheets. My guide shows two ways to do this, including a keyboard shortcut....

### How To Lock Cells in Google Sheets (Easy 7 Min Guide)

This tutorial covers how to lock cells in Google Sheets with several step-by-step examples including options for mobile devices....

### 5 Simple Ways to Insert Google Sheets Images

Using Google Sheets images is simple. But, there are a lot of ways to insert images into a cell. Check this guide for 5 easy ways to put images into Sheets....

### How to Freeze a Row in Google Sheets, Columns Too! [Easy]

Learn how to freeze a row in Google Sheets which can help be a lot more efficient when working with large datasets. This works for columns too....

### How To Use the Google Sheets’ Change Default Font Function (3 Easy Ways)

While you can't permanently change the font in Sheets, you can learn how to use the Google Sheets' change default font option with these three easy methods....

### How To Highlight Duplicates in Google Sheets

To highlight duplicates in Google Sheets, use conditional formatting and the UNIQUE function. This guide includes step-by-step instructions....

### Can Google Sheets Group Rows and Columns? Yes, Here’s How

Can Google Sheets group rows and columns? Yes, there are actually a few different ways to do it. Learn them all here....