Data Modeling: Create Relationship in Power Pivot

Powerful Feature: Drill Down/Drill Up Feature in Pivot Chart

KPI in Power Pivot for dashboard and report

Measure: SUMX Function in Power Pivot

Calculated Column in Power Pivot (LOOKUPVALUE Vs RELATED)

Power Gantt Chart (Project Planner) for Project Management

Comparative Analysis Dashboard in Excel

Data Transformation to create Comma Separated List automatically | FILTER, TEXTJOIN and CONCATENATEX

Dynamic Attendance Sheet using Power Pivot

Mastering Project Management with a KANBAN Board using Power Pivot and VBA