I write about web development, design and tooling from a solopreneur's perspective.
this originally appeared on my free weekly newsletter, Got Sheet. In this article and accompanying video, I'll show you two ways to create a lightbox effect in a spreadsheet. The first will trigger the image to be displayed in a large area in the she...
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...
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 validation feature in Google Sheets. Here's the Google Sheet we'll use for the example. You can make a copy...
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...
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...
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...
📈 Spreadsheets and Goals I found it immensely helpful to create a spreadsheet outlining some of my goals this past year. I'll reference it throughout this article, and here's the link if you'd like to check out the View Only version. This year has ...
Originally published for freeCodecamp ROM stands for Rough Order of Magnitude. It is a project management guideline to determine the estimated range of costs for a project. This article will explain: Who should use a ROM When to use a ROM How to ...
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...
Originally published for freeCodeCamp I needed to log in to AWS. But my main email address was rejected. I'd done this in the past and the account had been irreversibly deleted. No reset option – just a message saying the account was permanently del...
Holy backslash! We can program SVG animations directly within the file! 😲 What's an SVG? From Wikipedia: SVGs are scalable vector graphics. They are an XML-based vector image format for defining 2d graphics that supports interactivity and animation...
Meet unMove: my latest project where I built my first open-source library using vanilla CSS, GitHub Projects, Issues, tags and releases, semantic versioning and jsDelivr. I set out building this to better learn good project management and the ins & ...
No other online platforms have had as big an impact in my life as Khan Academy && freeCodeCamp. I'm forever grateful to the wealth of knowledge they provide, and their missions: Our mission is to provide a free, world‑class education for anyone, any...
Beginning and re-beginning My first experiences with coding were in middle school. I didn't quite realize it at the time, but I was writing rudimentary programs on our graphing calculators and having a ball programing conditional statements in a choo...
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 is to simply insert one into your sheet. But if you have added many images this way, you...
Sometimes you've gotta check to make sure that nothing isn't actually...nothing. 😲❗❓ In JavaScript, null is a primitive type intentionally containing the value of null. Undefined is a primitive type and represents a variable you declare without init...
This article originally appeared on freeCodeCamp here. Dates are a pretty fundamental concept. We use them all the time. And computers use them all the time. But parsing dates using JavaScript can be a little...well, interesting. In this article, we...
More Commands 🌟 We're creating more bash files to do some of the heavy lifting and querying for us. Here are a list of commands used in Learn SQL by Building a Student Database: Part 2. They'll be useful to (definitely) my future self and (hopefull...
This article appeared first on freeCodeCamp's news publication. I built a spreadsheet and wanted to display some of the data in a small table which would update based on the day of the week. After some digging, querying seemed the best option to pul...
Back to the SSQL 🎶 I'm glad to be back in SQL for this course. Bash was great, but let's make some more databases! https://media.giphy.com/media/Rm1p7xp3Odl2o/giphy.gif If you, like me, need a cheat sheet for some of the PostgreSQL commands from the...