Section outline

• Select section Day 1: Advanced Data Handling and Modeling

  Day 1: Advanced Data Handling and Modeling

  Collapse all Expand all

  • Advanced Functions and Formulas (2 Hours)
    • Complex lookups with INDEX, MATCH, and XLOOKUP.
    • Advanced conditional functions like SUMIFS and COUNTIFS.
    • Array formulas and dynamic arrays.
  • Data Cleaning and Transformation with Power Query (2 Hours)
    • Data cleaning techniques and transformations.
    • Custom functions and calculated columns.
  • Data Modeling with Power Pivot (3 Hours)
    • Building relationships and data hierarchies.
    • Using DAX for measures and calculated columns.
• Select section Day 2: Visualization, Automation, and Integration

  Day 2: Visualization, Automation, and Integration

  • Advanced Data Visualization Techniques (3 Hours)
    • Create Waterfall, Pareto, and Gantt charts.
    • Build interactive dashboards with slicers and timelines.
    • Design visually appealing dashboards.
  • Automation with Macros and VBA (2 Hours)
    • Record, edit, and debug macros.
    • Automate tasks with VBA scripts.
  • Integrating Excel with Other BI Tools (2 Hours)
    • Connect Excel to SQL databases and Power BI.
    • Export and import data for broader BI ecosystems.