top of page


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
38,982
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,946
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
361
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 23, 20227 min read
4,633
0


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
2,286
0


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
2,392
0

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
1,074
0


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
1,284
0

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
543
0


Create a Progress Bar in Google Sheets
Visualising your progress can be a real motivator to getting stuff done. Sparklines and repeat functions can help with that.
Aug 10, 20224 min read
10,787
1
bottom of page