Google Sheets

Browse our latest tips, tricks, and learn the latest news about how to use Sheets from Google.

Articles That Mention Sheets

Google Sheets Data Validation: Custom Formula, List & More Methods

September 14, 2020 | Posted by: Meghan Donovan
Google Sheets Data Validation Custom Formula

Google Sheets is a terrific cloud-based spreadsheet application offered for free, or as part of G Suite. Today we'll look at data validation and different ways to use data validation to improve how you work in Google Sheets (including with custom formulas).

Read More | Share:

How to Create a Google Sheets CRM

July 20, 2020 | Posted by: Meghan Donovan
Google Sheets CRM

Customer Relationship Management (CRM) software helps sales teams in many aspects of their day-to-day business. From organizing contacts, to managing leads and opportunities, a good CRM will make you better at your job. Expensive CRMs offer amazing functionality, but for those who want an effective solution that doesn't break the bank, using a DIY Google Sheets CRM is a great and easy alternative. Today I'll walk you through the basics of setting up your own CRM in Google Sheets.

Read More | Share:

Google Docs Edit History

June 22, 2020 | Posted by: Meghan Donovan
Google Docs Edit History

Nothing is more frustrating than losing your work. And while many users fear that changes to a Google Doc are permanent, the opposite is true! Today I'll show you how to use Google Docs Edit History (Version History) to view and restore previous versions of your Google Docs and Google Sheets files.

Read More | Share:

How to Use IMPORTRANGE in Google Sheets

June 10, 2020 | Posted by: Meghan Donovan
Importrange Google Sheets

The IMPORTRANGE Google Sheets function is the only way to integrate data between two different spreadsheets, rather than within one spreadsheet. If you're experienced with spreadsheets and working with data, this function is very easy to get the hang of and use, but if you're new to Sheets or just need a little help I've got you covered in this quick and simple tutorial.

Read More | Share:

Google Collaboration Tools Your Business Can Benefit From

May 13, 2020 | Posted by: Meghan Donovan
Google Collaboration Tools

Google collaboration tools are extremely accessible and a great way to easily collaborate with your team. There are a plethora of tools to use to keep your projects on track and moving quickly. In today's article I'll explain some of the ways Google collaboration tools help modern businesses work better, together. 

Read More | Share:

How to Use Google Sheets Spreadsheet Key to Merge Data from Multiple Spreadsheets

April 20, 2020 | Posted by: Meghan Donovan
How to Use Google Sheets Spreadsheet Key

Merging data is often a task handed off or outsourced to a third-party consultant. This is because data entry can be tedious and time-consuming. But there are ways to avoid entering data more than once, and today I'll show you how to use the Google Spreadsheets Key to import and query data to create shareable reports and dashboards at your organization.

Read More | Share:

Google Sheets 101: A Beginner's Guide

January 26, 2020 | Posted by: Meghan Donovan
Google Sheets Guide

Microsoft first invented the Excel spreadsheet, and later Google offered their own version of .XLS, with Google Sheets. Although Sheets are not difficult to use (like most Google products, this spreadsheet app is intuitive and very user-friendly), there might be a learning curve and there are a few tricks to getting the most out of the features available in Google Sheets. In this introductory guide we help you get started with Google Sheets and teach you how to begin using this powerful data processing tool.

Read More | Share:

Advantages and Disadvantages of MS Excel

September 22, 2019 | Posted by: Meghan Donovan
Advantages and Disadvantages of MS Excel

Microsoft Excel has been one of the best platforms for spreadsheet creation and analysis. With tons of built-in features to make advanced calculations easier, it has set the bar high for many business users for years. In this article we look at some of the advantages and disadvantages of MS Excel, and why Google Sheets might now be the better option for your business.

Read More | Share:

9 Google Sheets Formulas That Will Make You More Productive

July 28, 2019 | Posted by: Meghan Donovan
Google Sheets Formulas

Google Sheets is extremely powerful, with plenty of built-in functions that can help improve your productivity. Unfortunately, many people use Sheets without fully leveraging all of its power. Today, we’re going to share 9 Google Sheets formulas that you absolutely must know and use. These powerful formulas can transform the way you work, and increase your productivity.

Read More | Share:

Google Sheets vs Excel

July 1, 2019 | Posted by: Meghan Donovan
Google Sheets vs Excel

If you are trying to decide whether to use Google Sheets or Microsoft Excel as your spreadsheet app, you are not alone. Every business and individual can benefit from using spreadsheets to organize and analyze data, and in this article we compare Google Sheets vs. Excel to help you determine which spreadsheet application will be best for you.

Read More | Share:


Speak with a Google Cloud solutions expert