Create Excel KPI Dashboard

[jiajia97]

Hi Team,

May I have some samples or suggestions on how to create a dashboard in excel? Basically, there are 7 different tables extracted from 5 departments' report. And for the extract data part, I used power query to solve the issues. Now my problem is I have no idea on how to create an excel dashboard which is no statistic or chart at all but tables only.

I hope the team may assist me on this matter. Thank you!

 

[NARAYANK991]

Hi ,

Start with this :

https://chandoo.org/wp/create-kpi-dashboards-excel-1/

Narayan

 

[NARAYANK991]

Hi ,

Continue with this :

https://chandoo.org/wp/kpi-dashboard-revisited/

Narayan

 

[NARAYANK991]

Hi ,

This is at an advanced level :

https://chandoo.org/wp/kpi-charts-dashbaords/

Narayan