How to Make a Lightbox in a Google Sheet
Two ways to make pop-up images in a Google Sheet
Aug 20, 20246 min read119
Command Palette
Search for a command to run...
#excel
Articles tagged with #excel
6 Ways to number in Excel
Since last we spoke I’ve been recording several new long and short form videos. Check out the YouTube Channel if you haven’t. I’ve also wrapped up training for a marathon I’ll be racing on March 3rd… 🤞🤞 Now to the sheets… Do you ever feel lost in E...
Feb 29, 20243 min read102
Excel Tutorial – How to Clean Data with the TRIM() and CLEAN() Functions
Originally published for freeCodeCamp Without clean data, your spreadsheet is knocking on death's door. In this tutorial, I will show you two fast ways to clean up the data in your Excel or Google Sheets spreadsheet. When dealing with data sets, esp...
Jan 27, 20236 min read55
Accounting Number Format in Excel – How to Apply it to Selected Cells
Originally published for freeCodeCamp In this article I will show you how to format cells in Microsoft Excel. We'll be looking particularly at the Accounting format for cells with numbers. At the end of the article I'll give you two bonuses: a short...
Jan 18, 20234 min read126
How to Clear Formatting in Excel – Remove Format From a Cell
Originally published for freeCodeCamp In this article I will show you how to clear formatting from a cell in Excel. If you want the quick and dirty version, it's first up and will require you to simply click a couple times. If you want to become a s...
Jan 12, 20235 min read33
How to Calculate Percentage Differences Between Two Numbers in Excel - Cell Percentage Change Tutorial
Originally published for freeCodeCamp Spreadsheets are powerful and awesome. 💪 In this tutorial I will show you four ways to find the percentage difference between two numbers in Excel. I'll also show you how to use custom functions in Google Sheet...
Dec 20, 20227 min read30