SUMIFS and COUNTIFS

SUMIFS and COUNTIFS This quick video explains the SUMIFS and COUNTIFS Function in Excel. The SUMIFS and COUNTIFS functions allow us to add or count a range using multiple criteria – this is the function to use where multiple tests are required where usually an AND or...

HLOOKUP

HLOOKUP This quick video explains how to use the HLOOKUP Function in Excel. The HLOOKUP function is widely used to lookup values horizontally in an range of cells. Learn how to use it to find matches in columns on a worksheet [et_social_follow icon_style="slide"...

#DIV/0 instead of content

#DIV/0 Instead of Content This quick video will show you how to remove the #DIV/0 Error. The #DIV/0 – Division by 0 error is quite a common error in Excel. Learn what causes it and how to remove them from your spreadsheet [et_social_follow icon_style="slide"...

#N/A instead of content

#N/A Instead of Content This quick video explains how to Remove this very common Error in Excel. The #N/A error – is very common errors to appear in a spreadsheet. Learn what causes them and how to remove them from your worksheets [et_social_follow icon_style="slide"...

#NULL!, #REF!, #NAME?, #VALUE! Errors

#NULL!, #REF!, #NAME?, #VALUE! Errors This quick video explains how to correct the other Error Values that may appear in your cell. The #NULL!, #REF!, #NAME?, #VALUE! are very common errors to appear in a spreadsheet. Learn what causes them and how to remove them from...

Named ranges in table format

Named Ranges in Table Format This quick video explains a useful way of simplifying formula in Excel. Using named ranges from tables in formula is a useful way of simplifying formulae and ensuring that the formulae remain correct if the row count changes at a later...