Module 1: Introduction to Advanced Excel

• Review of Basic Excel Concepts

  • Formulas and functions
  • Data manipulation techniques
  • PivotTables and charts

• Introduction to Advanced Excel Features

  • Power Pivot
  • Data Model
  • DAX (Data Analysis Expressions)
  • Power Query

Module 2: Data Modeling with Power Pivot

• Creating a Data Model

  • Importing data from various sources
  • Managing relationships between tables
  • Creating calculated columns and measures

• Data Analysis with Power Pivot

  • Slicing and dicing data
  • Creating interactive dashboards
  • Time-series analysis

Module 3: Data Transformation with Power Query

• Data Cleaning and Transformation

  • Removing duplicates
  • Handling missing values
  • Transforming data formats

• Data Shaping and Reshaping

  • Merging and joining data
  • Unpivoting and pivoting data
  • Creating custom functions

Module 4: Advanced Formulas and Functions

• Array Formulas

  • Creating and using array formulas
  • Understanding the benefits of array formulas
  • Troubleshooting array formulas

• Lookup Functions

  • VLOOKUP, HLOOKUP, INDEX, MATCH
  • Using advanced lookup techniques
  • Combining lookup functions with other formulas

• Text Functions

  • LEFT, RIGHT, MID, LEN, FIND
  • Manipulating text data
  • Extracting specific information from text

Module 5: Advanced Charts and Visualization

• Creating Advanced Charts

  • Waterfall charts
  • Stock charts
  • Gantt charts
  • Combination charts

• Data Visualization Techniques

  • Sparklines
  • Slicers
  • Timelines
  • Maps

• Customizing Charts

  • Formatting charts
  • Adding annotations
  • Creating interactive charts