OfficeWheel

How to Count Unique in Google Sheets (3 Easy Ways)

April 3, 2022 Basics

Today, we will look at a few ways we can count unique entries in Google Sheets. While the idea is simple, it also means that there can be multiple ...

How to Count Unique in Google Sheets (3 Easy Ways)

How to Concatenate Number and String in Google Sheets

March 22, 2023 Basics

Today we will look at a couple of ways to concatenate number and string in Google Sheets. We will also see some advanced examples based on combining ...

How to Concatenate Number and String in Google Sheets

How to Concatenate With Separator in Google Sheets (3 Ways)

March 22, 2023 Basics

Separators, or more technically known as delimiters, are a crucial part of making concatenated values in spreadsheets more presentable. Today, we ...

How to Concatenate With Separator in Google Sheets (3 Ways)

How to Concatenate Strings in Google Sheets (2 Easy Ways)

March 22, 2023 Basics

Concatenating values is one of the more fundamental tasks performed in a spreadsheet. Today, we will be specifically looking into how to concatenate ...

How to Concatenate Strings in Google Sheets (2 Easy Ways)

Compare Two Columns for Duplicates in Google Sheets (3 Easy Ways)

March 28, 2022 Basics

Today we will look at a few ways to compare two columns for duplicates in Google Sheets. While the idea is simple, we can have multiple scenarios ...

Compare Two Columns for Duplicates in Google Sheets (3 Easy Ways)

Using Conditional Format to Compare Two Columns in Google Sheets

May 16, 2023 Basics

Today we are going to specifically look at how to compare two columns using conditional formatting in Google Sheets. Let’s get started. 2 ...

Using Conditional Format to Compare Two Columns in Google Sheets

How to Put Date in Google Sheets (3 Easy Ways)

March 24, 2022 Basics

There are multiple ways of how you can put a date in Google Sheets and our target today is to cover all of these in one single article. We will be ...

How to Put Date in Google Sheets (3 Easy Ways)

How to Format Date in Google Sheets (3 Easy Ways)

March 23, 2022 Basics

Working with dates is one of the more common tasks available for any spreadsheet user. However, many users of varying expertise still have certain ...

How to Format Date in Google Sheets (3 Easy Ways)

How to Add Months to a Date in Google Sheets (2 Easy Ways)

March 22, 2022 Formulas

Working with dates is one of the core tasks that anyone does in a spreadsheet. And today, we will look specifically at how we can add months to a ...

How to Add Months to a Date in Google Sheets (2 Easy Ways)

Count Days From Today in Google Sheets (5 Easy Ways)

March 21, 2022 Basics

Counting between dates is a common task for any spreadsheet user as dates tend to be one of the most important forms of data in any spreadsheet. ...

Count Days From Today in Google Sheets (5 Easy Ways)

Find and Display Current Date in Google Sheets (Easy Guide)

March 21, 2022 Basics

The Date and time are one of the more fundamental aspects of any professional report. Understanding that, finding and displaying the current date and ...

Find and Display Current Date in Google Sheets (Easy Guide)

How to Auto Sum in Google Sheets

March 16, 2022 Basics

Unlike MS Excel, Google Sheets does not have a built-in AutoSum feature. But that doesn’t mean that summing in this application is slow or ...

Google Sheets: Sum If Checked (2 Ways)

March 15, 2022 Basics

Adding values under certain conditions is a common affair in Google Sheets. But one approach that can be used to simplify a condition is the ...

Applying SUMIF from Another Sheet in Google Sheets

March 14, 2022 Basics

SUMIF is one of the fundamental functions of Google Sheets which also means that its application might vary. As such, today we will look at how we ...