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.

➢ How to use Macro and VBA in Excel?
➢ Do calculations on a different sheet.
➢ How to format cells in Excel?
➢ How to create a Pivot table?
➢ How to create a chart or histogram from the pivot table?
➢ How to identify and remove duplicate data from the dataset.
➢ Homework and project.