Home / Sheets
Category: Sheets

How to Save a Google Spreadsheet to Desktop

Google's services might be primarily online, but you can save its documents to desktop, too. Here's how to save a Google Sheet for offline editing.

Read more

Learn the Uses and Examples of Functions in Excel and Google Sheets

Use functions in Microsoft Excel and Google Sheets to accelerate your spreadsheet work with this easy to follow guide. Updated to include Excel 2019.

Read more

Are You Using Everything Your Spreadsheet Program Has to Offer?

Here is a definition of the term spreadsheet and a general description of the features of spreadsheet programs such as Excel and Google Sheets.

Read more

Learn How to Count All Types of Data With Google Spreadsheets COUNTA

Learn how to use Google Spreadsheets' COUNTA function to count text, numbers, error values, and more in a selected range of cells.

Read more

Here's How to Add the Current Date and Time to a Google Sheets

Working in Google Sheets: add date and time. Learn to use the Google Sheets NOW function to add the date and time to worksheets and in formulas.

Read more

How to Enter Dates with the DATE Function in Google Sheets

Learn all about Google Sheets DATE function and how to properly enter dates into a worksheet or into other date formulas for Sheets.

Read more

How to Utilize Column and Row Headings in Excel Spreadsheets

Need an Excel workbook refresher? Learn how to identify column and row headings or headers as they are used in Excel and Google Spreadsheets.

Read more

Sheets

Google Sheets is a free, web-based spreadsheet program. It works a bit differently from other spreadsheet programs so we're here to help you sort it...

Read more

When Would I Use the MODE Function in Google Sheets?

The MODE function in Google Sheets can be used to find the most frequently occurring value in a list of numbers.

Read more

The Essential Function of Google Sheets' COUNT Function

Use Google Sheets' COUNT function to count only cells containing numbers (ignoring blank cells, text and other types of data).

Read more

Here's How to Remove Extra Spaces From Data in Google Spreadsheets

Learn how to use the TRIM function to remove extra spaces from between words or other text in Google Spreadsheets.

Read more

Add Functionality to Google Sheets With These Awesome Add-Ons

To extend the functionality of Google Sheets, add-ons are a great way to gain real power and control. We examined tons of add-ons to bring your this...

Read more

Plot Area in Excel and Google Spreadsheets

Here's the definition of the term "plot area" as it applies to charts and graphs in Excel and Google Sheets.

Read more

Count Working Days Between Two Dates in Google Sheets

Use the NETWORKDAYS function in Google Sheets to count the number of working days between two dates, excluding holidays.

Read more

How to Use SUMIF in Google Sheets

The SUMIF function in Google Sheets lets you only add elements that meet a single criterion. Here's how to use it to keep your data in order.

Read more

A Quick Guide On How to Use Google Sheets for Beginners

Google Sheets is an alternative to Microsoft Excel, and it's not all that hard to use. If you're new to it, here's how to use Google Sheets,...

Read more

Can't See Formulas in Google Sheets? This Is How You Toggle Them

Want to make Google Sheets show formulas? Use keyboard shortcuts, the view menu, or worksheet protection, so other users cannot edit them.

Read more

This Is How You Create a Google Sheets Drop-Down List

Get step-by-step tutorials on how to create, modify or remove a drop-down list or other data validation criteria in Google Sheets for Android or...

Read more

Using VLOOKUP in Google Sheets Is an Essential Skill. Here's How

Using VLOOKUP in Google Sheets should be something you master early on because it gives you the ability to manage and view data, better. Here's how...

Read more

Google Sheets RAND Function Generates Random Numbers

Explore how to use the RAND function in Google Sheets to generate random numbers between zero and one with this step-by-step overview.

Read more

Google Sheets Formula Tutorial

This tutorial shows you how to create and use a simple Google Sheets formula and includes a step-by-step example.

Read more

How to Put Google Sheets to Work for You

Use functions to harness the power of Google Sheets. Here's what functions are, how they work in Google Sheets, and some function examples.

Read more

Learn How To Use The Google Sheets QUERY Function On Your Data

Learning how to use the Google Sheets QUERY function gives you access to a very flexible way to filter data in a spreadsheet. This may be one of the...

Read more

Find the Arithmetic Mean With Google Spreadsheets' Average Function

Is there a spreadsheet average formula? Use the Google Sheets AVERAGE function to find the average, or arithmetic mean, of values for selected data.

Read more

How to Use the Concatenate Function in Google Sheets

Learn how Google Sheet's CONCATENATE function is used to combine cells of text data in a new cell with this step-by-step guide.

Read more

How to Use the AND and OR Logical Functions in Google Sheets

Discover how to use the AND and OR logical functions in Google Sheets to test for multiple true or false conditions. A step-by-step example is...

Read more

How to Subtract in Google Sheets

Learn how to subtract in Google Sheets using a formula with this step-by-step example. Subtract two or more numbers in a Google spreadsheet.

Read more

Learn to Make Your Own Google Sheets Templates

If the built-in Google Sheets templates don't fit the task at hand, learn how to make your own template in Google Sheets that you can use over and...

Read more

Latest 20