top of page


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


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


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


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


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


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
Oct 3, 20225 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.
Sep 8, 20226 min read


How to Create a Drop-down list in Google Sheets
Creating a drop-down list in Google Sheets is super easy to make with Data Validation and even easier to use. Find out how.
Aug 18, 20224 min read


How to Bulk Translate with Google Sheets
With Google Translate, you can translate anything, but did you know that you you can also achieve this using a Google Sheets Function?
Aug 15, 20223 min read


INDEX Function in Google Sheets
The INDEX function in Google Sheets, when used in conjunction with other functions can easily compete and excel compared to VLOOKUP.
Aug 13, 20225 min read
bottom of page