Artificial Intelligence and Data Science

8. Advanced Excel for Data Analysis (30 Hours)


Module 1: Excel Fundamentals (4 Hours)
  • Workbook basics
  • Data formatting
Module 2: Excel Functions (6 Hours)
  • Logical functions
  • Lookup functions
Module 3: Data Analysis Tools (8 Hours)
  • Pivot tables
  • Data validation
  • Conditional formatting
Module 4: Advanced Features (8 Hours)
  • Macros introduction
  • Power Query
Mini Project (4 Hours)
  • Financial data analysis