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
Pivot Tables – Excel (Part 2)
Click here to see part 1 of this series if you have not already ..(cont.) Conditional Formatting inside a Pivot Table Even
Pivot Tables – Excel (Part 1)
Pivot Tables are one of the greatest features of Excel. They allow you to quickly summarize large data sets. You can quickly
Comparison Operators – Excel
Comparison operators are very helpful in Excel to force a Boolean result from a formula. Once we test two values against each
REMOVE DUPLICATES in Excel
How to Remove Duplicates in excel in a few clicks