Course Content

Topic 1: Calculating Fundamentals
The most important things you need to know about calculating in Excel Using common functions such as:
ABS
CONCATENATE
COUNTIF
SUMIF
VLOOKUP
VLOOKUP
If
Calculating with Date functions

Topic 2: Nesting Functions
Using functions to correct errors in formulas
Using Vlookup with If
Using Vlookup with match
Using Nested IFs

Topic 3: Array Formulas
Sum Values in Col A when value in Col B and Col C match Criteria

Topic 4: Using Advanced Tips and Tricks to achieve results
Copy and paste only non blanks cells
Automatically highlight highest and lowest values in a range
Topic 4C: Automatically highlight expired dates and dates that are 30 days from expiration
Automatically alternate row colors -one shaded, one white