Recent Posts

How to Change Cell Color in Excel

Changing cell color can highlight specific areas on your worksheet that may otherwise go unnoticed. Specific problems, important...

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

Avoid manually running your query by hand every time and automate it using a few easy macros. Contents: 1. Macros 1.1. Refresh a Specific...

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

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

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

The "Wrap Text" feature allows you to display cell contents on multiple lines within a single cell instead of having the text overflow...

Find and Replace allows you to find specific information across large workbooks and make sweeping changes if necessary. Contents: 1....

When working with multiple Excel workbooks, you'll often find yourself needing to reference numbers from one workbook in a separate...