Search Linkedin-in Youtube
Newsletter

Spreadsheet Point – Google Sheets Tips & Tutorials

Most Popular Spreadsheet Guides

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

Glowing glass blocks shaped like spreadsheet cells are dynamically stacking together to form a rising bridge

5 Useful Google Sheets Project Management Templates [Free]

If you want a project management system you can launch today, Google Sheets templates are the quickest path. This guide highlights five free templates worth copying and how to make...

News and Resources

See All
Unused hand weights sitting on a yoga mat covered in dust.

How we find hidden subscriptions in a bank spreadsheet

Export a bank CSV, drop it into Google Sheets, and spot recurring charges fast, then cancel, downgrade, or consolidate....

The Hidden Prices Workers Pay Returning to an Office

Return to office can function like a pay cut once you price...

Turn Google Sheets into a Scholarship Application Tracker

February is when scholarship deadlines get real. A tracker turns scattered portals,...

Excel Hell? These Shortcuts Will Save You Hours of Work

Excel rarely wastes your time in one dramatic mistake. It drains it...
The Google Sheets AVERAGE Formula in Action

The Google Sheets AVERAGE Formula: Full Guide

Whether you’re performing some simple calculations for school, dipping into more difficult statistics, or building a presentation for your office, the Google Sheets AVERAGE formula can come in very handy....

The IMPORTHTML Google Sheets function for tables

The IMPORTHTML Google Sheets Function

The IMPORT functions are some of the best ones for saving time when you’re working with large amounts of data from outside sources. The IMPORTHTML Google Sheets function in among...

Google Sheets Today’s Date Function: Full Guide

To include today’s date in Google Sheets, use the TODAY function or the keyboard shortcut. I’ll show both methods in my guide below. What Is the Google Sheets Today’s Date...

The most important Google Sheets formulas in one sheet.

The Ultimate Google Sheets Formulas Cheat Sheet

Here’s the ultimate Google Sheets formulas cheat sheet. It’s technically two documents. The first is a robust 13-page document that contains all the most common Google Sheets formulas and functions....

A person looking at their phone with an Excel dashboard in the background.

How to Make a Dynamic Excel Dashboard (Free Template)

Excel dashboards are a great way to present vital data at a glance while offering incredible technology and user interactivity. Learn to make one, or customize our free template....
organizational chart template google docs 3

Free Organizational Chart Template for Google Docs (3 Types)

In this article, we’ll show you how to create an organizational chart template for Google Docs by using the drawing feature. And if you just want a ready to go...

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....
Here's our activity schedule template and a walkthrough of how to make one yourself.

Activity Schedule Spreadsheet (Template and Guide)

This guide shows how to put together an effective activity schedule spreadsheet. It also includes a free activity schedule spreadsheet template....
content calendar template google sheets

3 Google Sheets Content Calendar Templates (Easy to Use)

Being a content creator isn’t easy. There’s a lot of planning to do before publishing our posts. And one of the struggles we face as content creators is organizing our...

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....
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,...

A complete guide to the Excel SWITCH function.

The Excel SWITCH Function

This guide explains the =SWITCH() function in Excel. I share what it does and when it is most helpful. I’ll also share some practical examples of its use. The Excel...

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...

This is how to build a stock tracker in Microsoft Excel.

How to Set Up a Stock Portfolio Tracker in Excel: A Comprehensive Guide

Tracking your stock portfolio effectively is crucial for understanding performance, identifying trends, and making informed investment decisions. Fortunately, Excel offers an excellent platform to build a custom portfolio tracker. You...

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!