Recent Posts

Excel and Google Sheets share most common formulas, but there are real differences. Here's what you need to know before switching between the two.

Worried that Excel macros are being phased out? Here's what Microsoft has actually said, and what it means for your VBA code.

Excel sheets are large, but they're not infinite. Here's exactly how many rows and columns you get, and what to do when that's not enough.

Yes, Excel can calculate standard deviation using built-in functions. Learn which formula to use and when, with examples.

Excel files and CSV files are not the same thing, though Excel can open and save both. Here's the difference and when it matters.

When working with dates, you'll sometimes find that you need to calculate the number of working (or business days) that have passed in...

I've always admired the way GitHub presents your contribution activity with a slick, heatmap-styled tracker. Let's create our own version in Excel. Contents: 1. Data Setup 2. Formula 3. Formatting 3.1. Conditional Formatting 3.2. Cell Size 3.3. Hide Text Values 3.4. Cell Border 3.5. Adding Month/Day Names 4. Adjust for Different Start Days (Non-Monday) Habit Tracker & Calendar Heat Map There are a two main parts that we need to convey with our heatmap. First w

When working with dates, you'll sometimes find that you need to calculate the number of working (or business days) in a month, from a...

There are lots of ways to convert decimal numbers into binary. Excel has a built in function for small numbers, but you'll need a custom...

There are two good ways of converting binary to decimal. Excel has a built in function for small numbers, but you'll need a custom...

Sometimes you find yourself wanting to start a cell with an "=", "-", or a "+" sign, but don't want Excel to create a formula. There are...

A regular, one-way XLOOKUP, is a fantastic tool, but sometimes you may find yourself needing to lookup a value in two different...

While the WRAPROWS function can be great to unstack a list with an even number of items, we'll need a custom formula to wrap, or unstack...

You'll often see names that are out of order, and need to flip them. Here are a couple quick formulas to help you accomplish that task....

Add an index column to any dynamic array using a few of the latest Excel functions for easy lookups. Contents: 1. Adding Index Column to...

Create a repeating list based off of a range and a specific numbers of repetitions. Contents: 1. Formula 2. Explanation Formula To...

A short formula you can use to calculate the number of days between two specific dates. Contents: 1. Formula 2. Explanation 3. Example...

An easy formula you can use to calculate the number of weekend days between two specific dates. Contents: 1. Formulas 2. Explanation 3....

A quick formula to calculate the number of weekend or non-working days remaining in the current month. Contents: 1. Formulas 2....

A quick formula to calculate the number of weekdays, business days, or working days remaining in the current month. Contents: 1. Formulas...