The following topics will be taught in the Course

• VLOOKUP (one table and two tables), HLOOKUP, INDEX, MATCH, ADDRESS, TRANSPOSE
• Conditional Formatting
• Pivot Tables
  • Creating pivot Tables
  • Using Pivot Tables
  • Changing and Updating Data Range
  • Formatting Pivot Tables
  • Making Dynamic Pivot Tables
• Graphs
  • Only Primary Axis
  • Both Primary Axis and Secondary Axis
• Referencing – Absolute and Relative
• IF conditions
• Nested IF Conditions
• IF Conditions with OR and AND
• Functions
  • Date (DATE, DATEValue, Second, Minute, Year, Now, Today, Month, Time, Weekday, NetworkDays)
  • Info (Cell, ISERROR, ISERR, ISEVEN, IS LOGICAL, ISNA, ISNONTEXT, ISNUMBER, ISREF, ISTEXT, TYPE)
  • Time (Today, Now)
  • Math (RAND, ROUND, MOD, SUMIFs, SUMIF, INT)
  • Statistics (COUNTIFS, COUNTBLANK, AVERAGE, MIN, MAX)
  • Text (LEFT, RIGHT, TEXT, TRIM, MID, LOWER, UPPER, REPLACE, REPT, FIND, REPLACE, REPT, SEARCH, TRIM, TRUNC, CONCATENATE, LEN)
• Named Ranges
• Operators - =, <>, <, >, <=, >=
• Filters / Slicers [ALT SFT :]
• Protecting cells
• Protecting Workbooks
• Linking Worksheets
• Sheet referencing
• Data Validations
• Freeze Pane
• Split Worksheets
• Gridlines
• Print Features
• Multiple Sheets Handling