Recent Posts

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

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

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

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

Depending on the report, having a way to automate your data source refreshes may save you a ton of time. Contents: 1. How to Create a...

While not a built-in Excel feature, we can create our own function to easily sum cells by color. Contents: 1. How to Use VBA User Defined...

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

Usually, you need to return the last or first item in a list, but every once in a while, you may find yourself needing to return the...

Usually, you need to return the last or first item in a list, but every once in a while, you may find yourself needing to return the...

Usually, you need to return the last or first item in a list, but every once in a while you may find yourself needing to return a...

The Developer tab in Excel is hidden by default, but offers some very important functions and built in features that every Excel Expert...

While not a built-in Excel feature, we can create our own function to easily count colored cells. Contents: 1. How to Use VBA User...

To highlight any cell that contains a formula in an Excel workbook, there is a simple conditional formatting formula that can be used....

Sometimes you'll find yourself needing to pull a file's pathway into your Excel sheet. Luckily there is a quick formula we can use to...

The formulas below will take any text input and return the ASCII value of each character that comprises that string. Contents: 1....

Contents: Formula Explanation Example - Rounding Dates to First of the Next Month Formula = EOMONTH(date, 0) + 1 By feeding any date into...

Contents: Formula Explanation Example - Rounding Dates to the First of the Previous Month Formula = EOMONTH(date, -2) + 1 By feeding any...

Having dates associated with times in Excel can sometimes throw off time calculations. Luckily, there is an easy way to strip out date...

Having time associated with dates in Excel can sometimes throw off date calculations. Luckily, there is an easy way to strip out time...