Introduction to MS Excel.

  • Introduction to MS Excel, Quick Review on MS Excel Options, Ribbon, Worksheets and Toolbar

Working with Formulas/Functions

  • Lookup and Reference Functions: VLOOKUP, HLOOKUP, Match and Index.
  • Logical Function: IF / ELSE, AND, OR, NOT, NESTED IF/ELSE.
  • Math Functions: ROUND, TRUNC, CEILING, FLOOR, MOD, SUM, SUMIF, SUMIFS.
  • Statistical Functions: AVERAGE, COUNT, COUNTA, COUNTBLANK, MAX, MIN.
  • Text Functions: LEFT, RIGHT, TRIM, MID, LOWER, UPPER, PROPER, REPLACE, FIND, CONCATENATE, SEARCH, SUBSTITUTE.
  • Date and Time Functions

Leave a Comment