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....
top of page
Recent Posts
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...
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...
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...
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...
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...
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 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...
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...
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...
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...
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...
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...
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...
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) >...
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....
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.
Excel's Secret Formula: =DATEDIF( )
An easy way to find the number of days, months, or years between two dates.
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.
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?
bottom of page