LARGE – Excel Function
What it does: The LARGE() Function provides the n-th largest piece of data from an array. Plain English: The LARGE() Function
COUNTIFS – Excel Function
What it does: The COUNTIFS() Function allows you to count the number of cells that match multiple criteria. Plain English:
Using AUTOFILL in Excel – Part 2
(click here for Part 1) Paste Formulas Another way that you can autofill a formula across multiple cells is to Paste
Using AUTOFILL in Excel – Part 1
The Autofill button is one of the simplest, yet greatest tools in Excel. There are a variety of different ways to use the
Using IFERROR to trap and handle errors
When I first found out about IFERROR, I was a little confused. “There’s a formula to use if we generate an error?
How to Use Excel’s COUNT Functions
There are many functions in Excel that contain “count” in the name. What are the differences? In this blog post
Text to Columns – Excel
Text to Columns is a very fun feature of Excel. This feature will help you break apart cells that have information that
Manipulating Text in Excel – LEN, RIGHT, LEFT, & MID
There are many times in Excel when you only need to extrapolate or evaluate PART of a cell. For this, the following functions
The IF Function in Excel & Boolean Logic
If new to Excel and building formulas, there’s a concept I think is very important to understand before learning to