Eamonn Cottrell's Developer Blog
Tag

google sheets

#google-sheets

More content

Read more stories on Hashnode

Articles with this tag

How to Make a Lightbox in a Google Sheet

Aug 20, 20246 min read

Two ways to make pop-up images in a Google Sheet · this originally appeared on my free weekly newsletter, Got Sheet. In this article and accompanying...

How to Make a Lightbox in a Google Sheet

Google Sheets Tutorial – How to Enable Multiple Selection Data Validation Using Apps Script

Feb 6, 20238 min read

Originally published for freeCodeCamp In this article I will show you how to allow for multiple items to be selected using the drop-down data...

Google Sheets Tutorial – How to Enable Multiple Selection Data Validation Using Apps Script

Excel Tutorial – How to Clean Data with the TRIM() and CLEAN() Functions

Jan 27, 20236 min read

Originally published for freeCodeCamp Without clean data, your spreadsheet is knocking on death's door. In this tutorial, I will show you two fast...

Excel Tutorial – How to Clean Data with the TRIM() and CLEAN() Functions

How to Calculate Percentage Differences Between Two Numbers in Excel - Cell Percentage Change Tutorial

Dec 20, 20227 min read

Originally published for freeCodeCamp Spreadsheets are powerful and awesome. 💪 In this tutorial I will show you four ways to find the percentage...

How to Calculate Percentage Differences Between Two Numbers in Excel - Cell Percentage Change Tutorial

Google Sheets Tutorial – How to Use Regex and VLOOKUP to Display Images from Google Drive

Aug 15, 20226 min read

Originally published on freeCodeCamp. Images make many things better. And Google Sheets is one of those things. The easiest way to add an image to...

Google Sheets Tutorial – How to Use Regex and VLOOKUP to Display Images from Google Drive

How to Query Data in Google Sheets

Jun 17, 20224 min read

Use the built in SQL-like Query Language · This article appeared first on freeCodeCamp's news publication. I built a spreadsheet and wanted to display...

How to Query Data in Google Sheets