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?
27
Sep
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
27
Sep
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
27
Sep
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
27
Sep
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
27
Sep
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
23
Sep
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
23
Sep
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
22
Sep
REMOVE DUPLICATES in Excel
How to Remove Duplicates in excel in a few clicks
13
Sep