Recent Posts

How to Autofill Columns with Multiple Values

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

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

VBA & Macros

How to Create a Macro in Excel - VBA Tutorial

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

VBA & Macros

What are Arrays and How to Use Them - VBA Tutorial

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

VBA & Macros

What are With Statements and How to Use Them - VBA Tutorial

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

Tutorial

Multi-Sheet References & Formulas - 3-D References in Excel

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

VBA & Macros

What are Do While Loops and How to Use Them - VBA Tutorial

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

VBA & Macros

VBA Naming Conventions & How to Write Good Variable Names - VBA Tutorial

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

VBA & Macros

How to Declare Variables and Data Types - VBA Tutorial

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

VBA & Macros

How to Write Presentable VBA Code and Macros - VBA Tutorial

Good code presentation is an important part of writing VBA (or any other programming language for that matter), and will make your code...

VBA & Macros

What are For Loops and How to Use Them - VBA Tutorial

For loops are an essential programming method used across many different languages, and allow for more precise, readable, and flexible...

Tutorial

How to Extract The Year From any Date in Excel

When working in Excel, often times you'll want to be pulling a lot of information automatically from dates. There are a couple different...

Tutorial

How to Extract The Month From any Date in Excel

When working in Excel, often times you'll want to be pulling a lot of information automatically from dates. There are a few different...

Tutorial

How to Extract The Day From any Date in Excel

When working in Excel, often times you'll want to be pulling a lot of information automatically from dates. There are a few different...

Tutorial

How to Round a Date to the First of the Nearest Month in Excel

Contents: Formula Explanation Example - Rounding Dates to First of the Nearest Month Formula = EOMONTH(date, (DAY(date) >...

Function

What Is the N Function and How to Use It in Excel - 2 Examples

The N function converts non-number values to a number, dates to serial numbers, TRUE/FALSE to 1/0 respectively, and everything else to 0....

Tutorial

How to Sum Across Multiple Dynamic Arrays by Row in Excel

How to sum across multiple dynamic arrays in a dynamic, flexible formula using the BYROW and LAMBDA Functions.

Function

Excel's Secret Formula: =DATEDIF( )

An easy way to find the number of days, months, or years between two dates.

Tutorial

How to Update Pivot Table Data Sources on New & Copied Workbooks with VBA

When copying workbooks, sometimes Pivot Tables/Caches Won't update and link properly, here's a work around.

Learn

What Is the Best Way to Learn Excel?

Excel is massive. It can be intimidating to learn. What's the best way to start? What different methods are there to help you learn?