Blog • Page 24 of 24 • My Online Training Hub

September 29, 2010

Excel Nested IF’s Explained

Did you know we can use a nested IF formula to extend the number of logical tests and therefore, possible

September 25, 2010

Before the introduction of the IFERROR function in Excel 2007, if you wanted to hide errors displayed by some formulas

September 24, 2010

Excel Absolute References are the backbone of ALL formula writing enabling you to copy and paste formulas with ease. Enter

September 22, 2010

In my previous Excel VLOOKUP formula tutorial I mentioned that there are two ways you can use a VLOOKUP but

September 20, 2010

The Excel VLOOKUP formula is my favourite! Perhaps because it was one of the first formulas I mastered. It gave

September 13, 2010

In this tutorial we’re looking at the COUNTIF and COUNTIFS Formulas, and we'll take a look at a couple of

September 10, 2010

SUMIF extends the capabilities of the basic SUM function by allowing you to tell Excel to only SUM items that

August 25, 2010

In this tutorial we’re going to explain how to use the Excel IF function (also known as IF Statement), and