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