How to use the SUMIF Function in Excel

How to use the SUMIF Function in Excel This quick video explains how to work with the SUMIF formula in Excel. Learn how to work with the SUMIF formula to add up values in a range of cells only if a matching cell meets a certain criteria (particular sales person,...

IF Statement

IF Statement This quick video explains The IF Statement in Excel. Learn to use the IF statement – widely used in Excel when testing for a particular condition (is commission payable? Is it a Monday?) Learn when to use this function and understand when it is used....

VLOOKUP

VLOOKUP This quick video explains how to use the VLOOKUP Function in Excel. The VLOOKUP function is one of the most widely used functions in Excel and is regularly used incorrectly. Learn why it is so useful and what errors to avoid. V is short for Vertical and lets...

MATCH and INDEX

The MATCH Function and The INDEX Function This quick video explains how to use The MATCH Function and The INDEX Function in Excel. The MATCH Function and The INDEX Function work well together to provide a powerful lookup function in Excel [et_social_follow...

OFFSET

OFFSET This quick video will show you how to use The OFFSET Function in Excel. The OFFSET function is used to retrieve a value based on an ‘offset’ or index from a reference or range of cells. This can be very useful when we wish our spreadsheet to automatically...

SUMPRODUCT

SUMPRODUCT Function This quick video explains how to use The SUMPRODUCT Function in Excel. The SUMPRODUCT function will add and multiply a range of items in one step – useful when trying to simplify formulae and save spreadsheet space. [et_social_follow...