This class will teach When & How to use the following Excel Functions:

• Math Functions

  • Average, Median, Mode, Averageif

  • Max, Min, Maxif, Minif

  • Large, Small

  • Count, Counta, Countif

• Text/Content Functions

  • Vlookup, Hlookup, Xlookup

  • Find, Search, Concat, Concatenate

  • Len, Trim, Proper, Right, Left, Mid

  • Drop Down List

• Date-Time Functions

  • Today, Now, Days, Edate, Networkdays

  • Weekday, Workday, Year, Yearrac

• Programming Functions

  • If

 (Prerequisite: Must have taken Excel-Beginning class; Basic computer and keyboard knowledge)