Week # 01 : Understanding advanced Excel with Aggregation, conditional, Text, date, and time functions.

Week # 02 : Understanding advanced Excel with data conversion, conditional formatting, and Pivot table creation.

➢ Organize the Ribbons (Toolbar and Manu Bar)
➢Aggregation Functions ( SUM, AVG, COUNT, MAX, MIN)
➢ Conditional Functions ( IF, COUNTIF, SUMIF)
➢ Text Functions (COUNTA, LEFT, LEN, REPLACE, CONCATENATE)
➢ Date and Time Function (DATE, TIME, NOW, YEAR)
➢ Reference Functions ( VLOOKUP, LOOKUP, MATCH, ROW)