top of page


Task List in Google Sheets with Kanban & Automated Status Tracking
Efficient task management is essential for maintaining productivity. This tutorial will explore a powerful solution to streamline your tasks
Jun 24, 202312 min read
13,173
0


Duration Conversion with a Custom Function in Google Sheets
Convert text durations into numeric durations in Google Sheets with Google Apps Script
Jun 14, 20234 min read
341
0


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.
May 3, 20234 min read
709
0


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 26, 20234 min read
2,082
0


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 18, 202311 min read
5,040
0


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
Mar 2, 202312 min read
9,046
4


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.
Feb 8, 20233 min read
2,577
0


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 19, 20233 min read
8,294
0


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...
Jan 8, 20234 min read
39,197
0


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 28, 20224 min read
3,954
4


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
Dec 21, 20228 min read
362
0


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 24, 20227 min read
4,637
0
bottom of page