by John MacDougall | Apr 30, 2016 | Lookup and Reference
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...
by John MacDougall | Apr 30, 2016 | Text
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... by John MacDougall | Apr 30, 2016 | Logical
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)... by John MacDougall | Apr 25, 2016 | Logical
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...
by John MacDougall | Apr 20, 2016 | Tips
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...