How to create an Interactive Dashboard in Excel - Consumer Complaints Data Analysis

Exploring Dashboarding in Excel - Advanced - The video goes through a brief overview of the Dashboard in Excel and different charts to add in it and shows a hands-on way to do it.
Link to the Data set: drive.google.c...
Link to other dashboards:
• How to create an Inter...
• How to create an Inter...
• Create an Awesome Inte...

[@datafoodie]

Hello Sureya! I'm currently training as a data analyst, so your video appeared as a suggestion, and it has been helpful for practicing my Excel skills and dashboard creation. I see that you're also starting on TH-cam, best of luck!

[@SureyaBanu]

Glad It was helpful and best of luck to you too.

[@lize.6122]

Great Job 👍

[@specialk210874]

Hi there Sureya, are you able to explain the "Timely Response" column and how it's formatted/calculated in the data sheet please?

[@nusratpenkar6470]

Hi Syreya, First of all thankyou so much for explaining it so clearly step by step how to create dash board. I have one problem, After creating the text box in the Dashboard , Unable to bring the KPIs as you have demonstrated in your video by putting the = sign in fx . it gives me an error message. When I select a cell ref in a text box from another sheet i get an error I am able to get that value in a cell by directly using equal sign and than i can bring it into the text box but i am unable to bring it directly into the text box.

[@joed8896]

well done .

[@SureyaBanu]

Thank you.

[@letsdraw3]

When celect timeline showing date formatting field....plz reply

[@ImranKhan-dq5rc]

When i select data from pivot table for Kpi in text box ,it showing we found a problem with this formula, it applying getpivotdata formula when i select the cell in pivot table , what can I do now