Articles
01 Simple Math
Who remembers PEMDAS and the order of operations? PEMDAS => Parentheses, Exponents, Multiplication, Division, Addition, Subtraction It may seem like a waste of time at first, but remembering simple math rules can go a long way in writing solid formulas in Excel. Take a look at this example that tries to see what 20+30 is [...]
Read Article ›
02 Basic Referencing
Referencing is Excel’s way of using the contents of a cell (or cells) other than the one that is in use. There are two basic types: Relative reference Absolute reference Absolute references stay locked, even if you drag or copy the formula elsewhere, it will still maintain the same reference. Example: =$B$5 (locked reference to [...]
Read Article ›03 Simple Logic
This is a straight forward concept, but once you understand the basics of logic statements and logic tests, you’ll be able to write IF statements like a pro! What I mean by “logic test” is a statement that results in either TRUE or FALSE. For example, 2=2 is TRUE, 2=3 is FALSE. This differs from [...]
Read Article ›04 Named Ranges
One commonly overlooked feature in Excel is the ability to give a name to a particular cell or range that can then be used directly throughout the workbook. There are two ways to do this: (1) Select the range that you would like to name. In the upper left hand corner, type over the cell [...]
Read Article ›