Recent Posts

How to Calculate Working Days Passed in Current Month

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

Tutorial

GitHub Style Habit Tracker & Calendar Heat Map in Excel

I've always admired the way GitHub presents your contribution activity with a slick, heatmap-styled tracker. Let's create our own version...

Tutorial

How to Calculate Working Days in a Month

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

Tutorial

How to Convert Large Decimal Numbers to Binary

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

Tutorial

How to Convert Large Binary Numbers to Decimal in Excel

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

Tutorial

How to Begin a Cell with an =, -, or + Sign Without Creating a Formula

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

Tutorial

How to Perform a Two-Way XLOOKUP

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

Tutorial

How to Unstack Uneven Data From a List in Excel

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

Tutorial

How to Reverse or Flip First and Last Names in Excel

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

Tutorial

How to Create Index Columns Using Dynamically Spilled Arrays

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

Tutorial

How to Create a Dynamic Array of Repeating Cells

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

Tutorial

How to Calculate Number of Days Between Two Dates in Excel

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

Tutorial

How to Calculate Weekend Days Between Two Dates in Excel

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

Tutorial

How to Calculate Number of Weekend Days Left in the Current Month in Excel

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

Tutorial

How to Calculate Number of Weekdays Left in the Current Month in Excel

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

Tutorial

How to Highlight Weekdays in Excel

Using conditional formatting, we can use a custom formula to highlight all weekday dates from any date range, letting you visually see...

Tutorial

How to Autofill Columns with Multiple Values

If you have ever gotten a report that looks like this, you know it can be a pain to work with. It's like a PivotTable without the Pivot....

Tutorial

How to Round a Price to .99 in Excel

When working with prices, it can often be beneficial to round to the nearest .99 cents. There are a few formulas we can use depending on...

Tutorial

How to Calculate Flow Rate in Excel

Flow rate can be tricky to calculate, but if you have all of the required pieces we can create some easy Excel formulas to do the work...

Tutorial

How to Calculate Weighted Average in Excel

A weighted average is an average where each value has a different level of importance, represented by a weight, which affects the overall...