Recent Posts

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

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

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

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

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

The AND function checks if all provided conditions in the function are true, and returns a TRUE. If any of the conditions are false, a...

Macros are used inside an Excel workbook that automate repetitive and complex tasks, allowing you to streamline your workflow and save...

Knowing how to create macros will let you automate repetitive tasks and create your own customized features and functions in Excel. There...

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

An array is a set of values that are stored in a structured, linear way, allowing you to store and manipulate a large number of values in...

In VBA, a with statement is used to reference an object multiple times within a specific block of code. Reducing typing and creating more...

A 3-D reference is a reference to a range of cells across multiple worksheets in a workbook. For example, if you have a workbook with...

In VBA, a Do While loop is a type of loop that will continue to repeat a set of instructions until a specific condition is met. Contents:...

Naming your variables properly is an important, but often overlooking, building block that, once learned, will improve your codes...

Declaring variables is an essential part of programming in VBA. Declaring properly will help you avoid errors and improve the overall...