Google Sheets | Spreadsheet Wise 2/4

May 2, 20234 min read

How to Remove Duplicate Rows in Google Sheets

Removing duplicate entries in Google Sheets can be a time-consuming and tedious task. Fortunately, there’s a way to streamline the process.

Mar 26, 20234 min read

How to use the CONCATENATE Function in Google Sheets

The CONCATENATE function in Google Sheets allows you to combine two or more text strings or cells together.

Mar 18, 202311 min read

Chat GPT Custom Function in Google Sheets

Explore the possibilities of utilising Chat GPT as a custom function in Google Sheets to bring AI into any cell in your sheets!

Mar 2, 202312 min read

How to use Chat GPT in Google Sheets

Learn how to connect OpenAI’s Chat GPT to Google Sheets to harness the power of natural language processing

Feb 7, 20233 min read

Relative and Absolute References in Google Sheets

Relative and absolute references are essential tools in Google Sheets to make your work easier and more efficient.

Jan 19, 20233 min read

Dependent Drop-down Chips in Google Sheets

You can take drop-down lists to the next level by making them dynamic with dependent Drop-down Chips

Jan 8, 20234 min read

Use the Sparkline function in Google Sheets to create a mini Progress Bar Chart

The Sparkline function in Google Sheets creates a miniature chart contained within a single cell. This is great for showcasing your data...

Dec 28, 20224 min read

Create a Dropdown list with Smart Chips in Google Sheets

Dropdown chips are a better-looking version of the old-fashioned dropdown lists you could create using Data Validation.

Dec 21, 20228 min read

How to Create Pivot Tables in Google Sheets

Pivot Tables are an efficient and powerful way to analyse large amounts of data and make meaningful insights with minimal effort

Oct 23, 20227 min read

How To Apply Conditional Formatting Across An Entire Row In Google Sheets

Conditional formatting in Google Sheets can be a great time saver to highlight cells or text based on conditional logic automatically.

Oct 3, 20225 min read

IMPORT RANGE Function in Google Sheets

Connecting two Google Sheets with the IMPORTRANGE function can be hugely beneficial when you need to collate data across multiple sheets

Sep 8, 20226 min read

IF Function and Multiple IF Statements in Google Sheets

The IF function in Google Sheets is the next logical step up from the basic functions such as the SUM or AVERAGE functions.