Recent Posts

Not sure which Excel formula to reach for? Here's a plain-English guide to picking the right function for the most common tasks.

Excel doesn't store dates as text. It stores them as plain numbers, and that explains a lot of strange date behavior.

Ever wondered what's actually happening under the hood when you type into Excel? Here's a plain-English explanation.

In 2010, a simple Excel mistake in a landmark economics paper shaped years of global austerity policy. Here's exactly what went wrong.

Yes, Excel can solve for x. Learn how to use Goal Seek to back-solve any formula for an unknown variable in just a few clicks.

Most Excel formulas ignore case entirely. Here's what that means for your data, and what to do when case actually matters.

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.

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

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

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...

The OCT2BIN function converts octal numbers into binary form. Contents: 1. Syntax 2. Explanation 2.1. What is an Octal Number 2.2. What...

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...

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....