Recent Posts

The CLEAN function removes all non-printable characters from a text string. Characters like line breaks, tabs, and other characters that...

A dynamic array is an array that can change size on the fly, unlike a static array that has a fixed number of elements. Contents: 1. What...

Formulas are an integral part of Excel, and are the defining feature that elevates a workbook far above a simple calculator. Contents: 1....

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