How to Make a Lightbox in a Google Sheet
Two ways to make pop-up images in a Google Sheet
#excel
Posts tagged #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...
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...
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...
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...
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...
