How to use INDEX and MATCH together
I’d probably list INDEX-MATCH in the top 5 things to know in excel if you want to add the skill to your resume and not
How to use Paste Special in Excel
Paste special is a very good tool to have for a variety of reasons. Let’s cover the most common use cases: Paste Values
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