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, Countblank, Countif)

• Text/Content Functions (Vlookup, Hlookup, Xlookup; Find, Search, Take, Filter, Sortby; Concat, Right, Left, Mid; Len, Trim, Proper, Text Join; Drop Down List)

• Date-Time Functions (Today, Time)

• Programming Functions ('If' conditions)

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