Select Page

# Month: April 2016

## VLOOKUP function

What does it do? This function allows you to look up a value in one column based on a value in another column. Syntax VLOOKUP(Criteria, Range, Column, Type) Criteria (required) – This is the value you are going to try to find. Range (required) – This is the range of cells that you want to search. Column (required) – This is the column number of the range that contains the result you want to return. Type (optional) – This is the type of match you are looking for. FALSE if you want an exact match and TRUE if you want an approximate match. If nothing is...

## FIND function

What Does It Do?   This function can be used to find the first occurrence of a text string within another text string.   Syntax   FIND(Text to find, Text, Start position) Text to find (required) – This is the text you want to find within another text string. Text (required) – This is the text you want to search within. Start position (optional) – This is the result the function will return if the expression is false. If nothing is entered here the function will return FALSE when the expression is false.   Example Get Example Workbook In this example we...

## IFERROR function

This formula will return a specified value if your given expression results in an error.   Syntax   IFERROR(Expression, Value if error)   Expression (required) – This is part of the formula that is checked for an error. Value if error (required) – This is the value that is returned if the expression results in an error (#DIV/0, #N/A, #NAME, #NULL!, #NUM!, #REF!, or #VALUE!).   Example In this example we want to calculate an average cost per use = cost / # of uses (=A2/B2), however some of the # of uses are 0 and this results in a #DIV/0 error.     We can use the IFERROR function to set the average to 0 when we get a #DIV/0 error by using IFERROR(A2/B2,0)....

## IF function

This function allows you to test a logical statement and return one value if it’s true and another value if the statement is false.   Syntax   IF(Expression, Value if true, Value if false)   Expression (required) – This is the expression you want to test. Value if true (required) – This is the result the function will return if the expression is true. Value if false (optional) – This is the result the function will return if the expression is false. If nothing is entered here the function will return FALSE when the expression is false.   Example   In this example we use the formula IF(A2=”Donald Trump”,”Lame”,”Not Lame”). If the value in A2 is “Donald Trump” then the result is “Lame”, if it’s any other value the result is “Not Lame”.     [download...

## Essential Keyboard Shortcuts

These are the keyboard shortcuts I have found essential. There are a lot of others, but I think these are the most useful. If you use Excel a lot in your job or personal life, these are really worth knowing and using.   Shortcut Description Ctrl + A Select all Ctrl + B Bold format a cell or range Ctrl + C Copy a cell or range Ctrl + F Find Ctrl + G GoTo Ctrl + H Find and replace Ctrl + I Italic format a cell or range Ctrl + K Insert a hyperlink Ctrl + N...

• 1
• 2