Recent Posts

How to Refresh SAP Analysis for Office Queries & Data Sources with a Macro

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

Tutorial

How to Sum Cells By Color in Excel

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

Tutorial

How to Highlight Weekends in Excel

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

Tutorial

How to Convert a Month Name to a Number in Excel

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

Tutorial

How to Return the Second to Last Item in a List in Excel

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

Tutorial

How to Return the nth to Last Item in a List in Excel

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

Tutorial

How to Enable the Developer Tab in Excel

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

Tutorial

How to Count Colored Cells in Excel

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

Tutorial

How to Highlight Cells Containing a Formula in Excel

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

Tutorial

How to Return the File Pathway of an Excel Workbook Using a Formula

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

Tutorial

How to Return the ASCII Number for Every Character in a Cell

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

Tutorial

How to Round a Date to the First of the Next Month

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

Tutorial

How to Round a Date to the First of the Previous Month

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

Tutorial

How to Remove Date Data from a Time in Excel

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

Tutorial

How to Remove Time from a Date in Excel

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

Tutorial

How to Take the Average of Non-Zero Cells in Excel

Using the standard AVERAGE function with data that contains zeros can give you an incorrect average. Instead, we can use the AVERAGEIF...

Tutorial

How to Abbreviate a Middle Name in a Full Name in Excel

Formatting names can be a manual and slow process. Here is a quick method to turn a middle name into a middle initial when given a full...

Tutorial

How to Separate a Full Name Into First and Last Names in Excel

Often, you'll receive a list of first and last names combined into a full name and need to separate them. Here's a quick method to easily...

Tutorial

How to Combine First & Last Names Into a Full Name in Excel

Often, you'll receive a list of names broken up into two separate columns, first and last, and need to combine them into a full name....

Tutorial

How to Extract Everything to The Right of a Specific Character in Excel

A lot of time spent in Excel is used to clean up data that may not be immediately useful into something valuable. Being able to break up...