Skip to main content

Section outline

    • 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.
    • 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.