Search Linkedin-in Youtube
Newsletter

Spreadsheet Point – Google Sheets Tips & Tutorials

Most Popular Spreadsheet Guides

Most Popular Spreadsheet Templates

News and Resources

See All
A wedding ceremony happening on Lake Michigan in Chicago.

I Planned My Entire Wedding with Spreadsheets. Here’s the Template I Built

I downloaded a few wedding planning apps when we got engaged. They were fine. I stopped using them within a week and built everything in Google Sheets instead. That was...

How to Run a 90-Day Sprint for Your Small Business

Ninety days is the timeframe where ambition and accountability overlap. Long enough...

How to Set Sales Targets in Google Sheets (And Actually Hit Them)

Most small businesses track revenue. They log what came in, maybe sort...

How to Track Quarterly Business Goals in a Spreadsheet

Annual goals lose focus by March. Weekly goals lack strategic weight. Quarterly...
GOOGLEFINANCE Function in Google Sheets: Beginner's Guide

The GOOGLEFINANCE Function: An Easy Beginner’s Guide

The GOOGLEFINANCE function is an amazing tool used to make Google Sheets stock formulas for people who need to work with real-time finance data. This single function gives you not...

Google Sheets NOT Function: How to Use Step-by-Step

Google Sheets NOT Function: How to Use IF/NOT Step-by-Step

The Google Sheets NOT function is a handy tool that lets you negate or reverse a logical value. This tutorial shows how to apply it in different use cases....
Value not found

IFERROR in Google Sheets (Super Easy Guide with 4 Examples)

Error handling is an important part of data processing. When you perform operations on data, errors are almost always possible. Good thing Google Sheets is well-equipped to detect these errors...

VLOOKUP with multiple criteria formula

How to Use VLOOKUP with Multiple Criteria

Let’s talk about how to use VLOOKUP with multiple criteria. After all, I often use this formula to find data based on more than one thing. Fortunately, there’s an easy...

Here's how to use the ISERROR function.

How to Use the ISERROR Function to Highlight Errors

If you want to highlight errors in Google Sheets, consider the ISERROR function. I’ll show you how to use it with conditional formatting to highlight an entire row when it...

Easy Guide to the COUNTIF and COUNTIFS Google Sheets Functions

How to Use the COUNTIFS Google Sheets Function

The COUNTIFS in Google Sheets helps you count cells based on multiple criteria. This differs from COUNT, COUNTA, and COUNTIF. Below, I’ll explain the COUNTIFS formula. I’ll also provide a...

google sheets address function

 Google Sheets ADDRESS Function 101 [Easy Guide]

Not many people are familiar with the ADDRESS function since many don’t understand why they need it or how it can help. In this tutorial, we will get you familiar...

Pi in Google Sheets

How to Use Pi in Google Sheets [3 Easy Examples]

To find pi in Google Sheets, use the insert menu and choose the function. I’ll show exactly where to find it with screenshots and video. I’ll also discuss the mathematical...

Correlation Google Sheets [CORREL Function]

Correlation Google Sheets (CORREL Function) – Easy Guide on How to Use

Correlation is quite a frequently encountered term when performing data analysis. If you have a basic idea of how two variables are correlated, you can decide whether you want to...

7 Free Google Sheets Accounting Templates for Small Businesses

Track invoices, expenses, and monthly profit without paying for bookkeeping software. Here are 7 free Google Sheets accounting templates you can copy in minutes, plus clear instructions to set them...
Finding the net pay in the payroll template for Google Sheets

Free Payroll Template for Google Sheets

Use our free payroll template for Google Sheets to track employee expenses, reduce mistakes, and boost productivity....
a yearly calendar template

Google Sheets Calendar Templates: The 10 Best for 2026

A Google Sheets calendar template makes life a lot easier. Planning weeks, months, or years in advance can make you more efficient and productive. But there are so many calendar...

Google Sheets Dashboard

How to Make a Google Sheets Dashboard [Includes Template]

Learn how to build a dynamic Google Sheets Dashboard. Also get free templates for sales and management to track KPIs instantly....
A team with a google sheets workout template.

Google Sheets Workout Template (3 Free Downloads)

Track your fitness progress with our free workout spreadsheet in Google Sheets. Log sets, reps, and weights or copy our ready-to-use template today....
A worker using a free Google Sheets Mileage Log Template.

Free Mileage Log Template for Google Sheets

Keeping track of your miles can save you a fortune when tax time rolls around. Whether you need to request reimbursement from an employer or claim a deduction on your...

The Best Free Job Tracker Spreadsheet Template

Track job applications with this job tracker spreadsheet. Make your own copy for free to use on Sheets or Excel....
a man on a laptop calculating game sales with a spreadsheet

The Game Sales Spreadsheet: A Practical Guide to Measuring and Improving PC Revenue

A video game sales spreadsheet template. Free to use. Tracks steam sales vs. other stores and includes after-fee revenue....
A triptych of weight loss images associated with this weight loss spreadsheet template.

Try The Best Weight Loss Spreadsheet for Google Sheets

Get our free weight loss tracker spreadsheet, or build your own with Google Sheets using this simple, free guide. Customizable for weekly or daily progress tracking....
There's an easy way to transform Microsoft Excel into a pixel art editor.

Creative Accounting? Excel Doubles as a Pixel Art Editor

Microsoft Excel—best known for its number crunching and data organization capabilities—can also be used to create pixel art. Whether you’re a fan of retro graphics or just looking to explore...
A user is creating an Excel drop down list on a computer.

2 Simple Ways to Create an Excel Drop Down List

I often use an Excel drop-down list In my line of work to improve the efficiency of my data entry tasks by limiting my choices. This saves me a lot...

Image6

5 Ways You Can Merge Excel Files [10 Min Easy Guide]

Merging files in Excel is a pretty common need for many users and a challenging one at that. Luckily, Excel provides several features that allow you to merge Excel files,...

Look for the Compare and Merge Workbooks command in the list for commands and click Add

4 Easy Ways You Can Compare Two Excel Files

There are many reasons why you may need to compare Excel files, such as ensuring data integrity and consistency and data analysis. This can be quite difficult if you have...

Illustration of various text "How to Convert Currencies" in Excel using top currency converters such as XE, OANDA, Google, Wise

How to Use Excel as a Currency Converter (With Pictures)

There are several dynamic ways to convert currency using Excel. Whether you’re looking to convert USD to EUR or any other currency pair, Excel provides powerful tools to help you...

The Excel Filter Function written as text on a green background.

How to Use the Excel FILTER Function: A Complete Guide

This guide shows you how to use the Excel FILTER function. I break down the syntax, provide practical examples, and share a video that demonstrates the process. You can also...

Here's what to know about the Excel CHOOSE Function.

How to Use The Excel CHOOSE Function

Let’s talk about the Excel CHOOSE function. We will cover its syntax, how it works, and ways to make the most of it. As always, I’ve also made a video...

A guide to using =NOT() in Microsoft Excel.

Understanding the Excel NOT Function: A Comprehensive Guide

Let’s delve into one of Excel’s powerful functions — the NOT function. I’ll discuss syntax first, then examples. By the end of this tutorial, you’ll understand how the NOT function...

To calculate running totals in Excel, use the SCAN function.

Calculate Running Total with the SCAN Function in Excel

To calculate running totals, Excel’s SCAN function handles everything in a single formula. This guide includes a video and step-by-step instructions. Learn how to easily calculate a running total in...

Welcome to Spreadsheet Point!

If you’re looking to transform your data management, analysis, and reporting skills, we can help. We have hundreds of in-depth guides dedicated to simple, intermediate, and much more advanced spreadsheet formulas.

Most importantly. . .

We know spreadsheets.

Want to develop your data skills? Many businesses benefit from our recommended spreadsheet courses. Remember: Course completions and certifications can help a resume stand out.

And many of our articles feature video explanations. Not sure you understand all the specifics of a complex Google Sheets formula? It doesn’t matter if they’re the most common terms in the spreadsheet world or accounting-specific formulas you only use twice a year.

We listen to reader feedback and include detailed explanations for each topic.

We’re also web browser agnostic. Our advice caters to mobile and desktop spreadsheet tools. Use our tips for Excel, or open Google Sheets to follow along with our most popular spreadsheet templates.

We also know data, and we understand the importance of data analysis in news reporting. We share data-backed articles, including analysis and feedback from the community, on a regular basis.

Ready to get started?

Our Google Sheets guides include basic information, including topics for total novices (like making new spreadsheets or adding graphs), more advanced advice on formulas (including when to use those optional arguments), and expert advice.

Browse our categories, search for your specific needs, and unlock the incredible world of spreadsheets with Spreadsheet Point, your trusted source for expert spreadsheet advice. Or join the newsletter for news and access to free templates.

Like something we made? Please share it with your colleagues.

Thanks for visiting. We’re delighted you’re here!