In a previous tutorial we looked at the IF statement, which is one of the most versatile functions in Excel, but on its own you’re limited to only one of two outcomes. That is, if the answer to the question I am asking is true, do this, if not, do that. To extend the number [...]
September 2010
Before the introduction of the IFERROR formula in Excel 2007, if you wanted to hide errors displayed by some formulas you had to employ a combination of IF and the ISNA formulas, which resulted in Excel having to do the calculation twice. Once to establish whether the result was an error, and again if the [...]
Once you uncover the mystery of Absolute References copying and pasting formulas becomes child’s play. You might have seen cell references in formulas surrounded by ‘$’ signs. For example $D$3:$D$10. What’s that all about? Well, the ‘$’ before the column or row reference instructs excel to keep the reference absolute. Huh, I hear you say. [...]
In my previous Excel VLOOKUP tutorial I told you that there are two ways you can use a VLOOKUP but most people know one way or the other, and only a few know both. If you haven’t read the first article in the VLOOKUP series then read it first to get an understanding of how [...]
Watch the video extract as seen on YouTube, then read the full tutorial below. Click the Full Screen button on the player to watch it in HD. To get the full video with troubleshooting tips for VLOOKUP formulas sign up for our free Microsoft Office Online Training. Excel VLOOKUP Exact Match Formulas Explained VLOOKUP is [...]
Video extract as seen on YouTube, plus extended tutorial below. Click the Full Screen button on the player to watch it in HD. In this Microsoft Office tutorial we’re looking at the COUNTIF and COUNTIFS Formulas, and we’ll take a look at a couple of different applications for them. Plus download a practice workbook so [...]
In this Microsoft Office Online Training article we’re going to explain how to use the SUMIF and SUMIFS Formulas, and look at a couple of different applications for them. You can download the workbook used in this example and practice what you learn. Learning the SUMIF formula extends the capabilities of the basic SUM formula [...]
... I would highly recommend My Online Training Hub for all your Microsoft Office needs .... Geniuses
