Course length: 1 day
Course Objectives:
Upon successful completion of this course, you will be able to create and develop Excel Formulas.
Course Content
Topic 1: Calculating Fundamentals
- 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
- Automatically highlight expired dates and dates that are 30 days from expiration
- Automatically alternate row colors -one shaded, one white