Search Linkedin-in Youtube
Newsletter

Spreadsheet Point – Google Sheets Tips & Tutorials

Most Popular Spreadsheet Guides

The Google Sheets FILTER function making data easier to understand at a glance.

How to Use the FILTER Function in Google Sheets

See how to use the Google Sheets FILTER function. Learn to filter by multiple conditions, dates, and dynamic arrays to automate your reports....
A woman pointing to the Formula to count colored cells in Google Sheets

Count Colored Cells in Google Sheets (3 Ways – Full Guide)

Here's how to count colored cells in Google Sheets. I have a full video guide and a written guide with step-by-step instructions and screenshots....
Highlight duplicates in Google Sheets with a single formula.

How To Highlight Duplicates in Google Sheets

To highlight duplicates in Google Sheets, use conditional formatting and the COUNTIF function. My guide below covers this in detail. Specifically, I’ll show how to use conditional formatting to highlight...

GOOGLEFINANCE to Fetch Currency Exchange Rates over a Time Period

Google Sheets Currency Conversion: The Easy Method

Google Sheets can convert currencies automatically with one GOOGLEFINANCE formula. This guide shows how to pull live exchange rates, convert amounts from USD to popular currencies, fetch historical rates, troubleshoot...

Most Popular Spreadsheet Templates

A Google Sheets expense tracker spreadsheet template.

Google Sheets Expense Tracker (with Template)

Get the free expense tracker spreadsheet template for Google Sheets. This version tracks income and expenses with charts and graphs....
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 budget template

The Best Google Sheets Budget Template: Full Guide

Need a budget spreadsheet you can start using today? These free Google Sheets templates cover zero-based budgeting, household spending, weekly tracking, and annual planning, plus clear steps to customize categories,...
A Google Sheets expense tracker spreadsheet template.

Google Sheets Expense Tracker (with Template)

Get the free expense tracker spreadsheet template for Google Sheets. This version tracks income and expenses with charts and graphs....

News and Resources

See All
One method for adding leading zeros in Google Sheets

How to Keep Leading Zeros in Google Sheets

Sometimes, Google Sheets removes leading zeros in zip codes, employee ID numbers, or SKUs. Here's how to fix that and keep leading zeros in a spreadsheet instead....

How we find hidden subscriptions in a bank spreadsheet

Export a bank CSV, drop it into Google Sheets, and spot recurring...

How we find hidden subscriptions in a bank spreadsheet

Export a bank CSV, drop it into Google Sheets, and spot recurring...

How we find hidden subscriptions in a bank spreadsheet

Export a bank CSV, drop it into Google Sheets, and spot recurring...
A shilouette of a person looking at the IF CONTAINS formula in Google Sheets.

IF CONTAINS Google Sheets: SEARCH + REGEXMATCH

Here's how to use some formulas to search a cell to see whether it contains a specified value. The key is IF CONTAINS....
The Google Sheets FILTER function making data easier to understand at a glance.

How to Use the FILTER Function in Google Sheets

See how to use the Google Sheets FILTER function. Learn to filter by multiple conditions, dates, and dynamic arrays to automate your reports....
A reporter in front of the INDIRECT function in Google Sheets.

How to Use the Google Sheets INDIRECT Function (Step-by-Step)

Learn the Google Sheets INDIRECT function to create dynamic cell references. It consolidates data from multiple tabs and build dependent dropdowns....
A shilouette of a person looking at the IF CONTAINS formula in Google Sheets.

IF CONTAINS Google Sheets: SEARCH + REGEXMATCH

Here's how to use some formulas to search a cell to see whether it contains a specified value. The key is IF CONTAINS....
Standard Stacked bar chart

How To Make a Bar Graph in Google Sheets: No Fuss 2026 Guide

Have you ever wondered how to make a bar graph in Google Sheets? While Google Sheets is a spreadsheet tool where data is entered and stored, plain cells are not...

Combo chart with one line and one column

How to Make a Line Graph in Google Sheets (Easy Step-by-Step)

How to Make a Line Graph in Google Sheets – Video tutorial:   Line Graph (also called line chart) is one of the most used charts when it comes to...

use the edit chart shortcut

How to Make a Pie Chart on Google Forms (3 Easy Ways)

Learning how to make a pie chart on Google Forms is simple. In fact, you just have to click the Responses tab to get a basic pie chart. But, for...

Standard Stacked bar chart

How To Make a Bar Graph in Google Sheets: No Fuss 2026 Guide

Have you ever wondered how to make a bar graph in Google Sheets? While Google Sheets is a spreadsheet tool where data is entered and stored, plain cells are not...

Google Sheets reseller spreadsheets from Spreadsheet Point.

The Best Reseller Spreadsheet Templates for Google Sheets

We curated the best free Google Sheets templates designed specifically for the modern reseller. These sheets offer cloud-based flexibility, real-time collaboration, and powerful automation to help you track every flip...
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 Google Sheets expense tracker spreadsheet template.

Google Sheets Expense Tracker (with Template)

Get the free expense tracker spreadsheet template for Google Sheets. This version tracks income and expenses with charts and graphs....
Google Sheets reseller spreadsheets from Spreadsheet Point.

The Best Reseller Spreadsheet Templates for Google Sheets

We curated the best free Google Sheets templates designed specifically for the modern reseller. These sheets offer cloud-based flexibility, real-time collaboration, and powerful automation to help you track every flip...
A finger pressing the control button for shortcuts in Excel.

Ultimate Guide to the Best Excel Keyboard Shortcuts

A comprehensive guide to the most essential Excel keyboard shortcuts. Includes a downloadable PDF cheat sheet, Mac vs. Windows comparisons, and tips for navigation, formatting, and data analysis to help...
Here's our free P&L statement for Excel. It includes a walkthrough so you know exactly how to make it.

How to Create a Profit and Loss Statement in Excel

A Profit and Loss (P&L) statement is an essential financial document that helps businesses track revenue, expenses, and overall profitability. While some companies have complex P&L statements, the fundamental structure...

Here's everything you need to know about how to insert checkbox in Excel.

Use Checkboxes in Excel

Watch step-by-step how to insert a checkbox in Excel, customize its appearance, and link it to other sheets for increased functionality....
A finger pressing the control button for shortcuts in Excel.

Ultimate Guide to the Best Excel Keyboard Shortcuts

A comprehensive guide to the most essential Excel keyboard shortcuts. Includes a downloadable PDF cheat sheet, Mac vs. Windows comparisons, and tips for navigation, formatting, and data analysis to help...

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!