Blog • Page 24 of 24 • My Online Training Hub

November 24, 2010

Excel OFFSET Function Explained

The OFFSET function is one of Excel’s best kept secrets. Probably because it’s quite tricky to explain, and can be

November 21, 2010

Creating Excel drop down lists, or Data Validation Lists as they're formally known, enables you to control the value entered

November 8, 2010

It’s common practice in Excel to format decimal places to get the desired rounding of numbers. But the problem with

November 1, 2010

Excel Pivot Tables are one of the most powerful tools at our disposal, and once you understand how they work,

October 27, 2010

Named Ranges in Excel are an essential tool for simplifying and enhancing the functionality of spreadsheets. They allow you to

October 7, 2010

Have you ever wanted your very own interactive Google Map dotted with locations relevant to your business? You might want

October 6, 2010

If you think SUM is handy, wait til you meet SUBTOTAL. SUBTOTAL has so many tricks up its sleeve you’ll

September 29, 2010

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