Request or Schedule a Virtual Class

Request or Schedule a Class

Course length: 1 day

Course Objectives:

Upon successful completion of this course, you will be able to create and develop Excel Formulas.

Prerequisites:

Excel Level 1

Excel Level 2

 

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

You may also be interested in:

Macros

Pivot Tables

Visualizing Data with Charts 

What's Next?

View our Excel Flow Chart