Advanced Excel for Data Analysts (Intermediate)

A

1

Take your Excel skills beyond the basics. This course covers complex formulas, pivot tables, Power Query, data modeling, and dynamic dashboards used by working data analysts. By the end, you'll be able to build self-updating reports and analyze large datasets efficiently.

Modules

Power Query Introduction & Automation

4 videos

1h 27 mins

Mastering Power Query M Language & Errors

3 videos

46 mins

Mastering Power Pivot & Relational Data Models

5 videos

1h 25 mins

Data Normalization for Robust Models

1 video

19 mins

Creating Dynamic Excel Dashboards

2 videos

45 mins