Quick and Brief Tutorial to guide you through the process making interact dashboard in excel
When we are dealing with Data. People will immediately speak out Python, R, Tableau, PowerBI, etc… Although the above-mentioned software is the current hottest topic when talking about dealing with data. However, the intuitive way to do the basic data analysis and handling I will still give applause to Excel. Its own limitation when handing data in excel. But we still working on it in our Daily Business World.
In this article, I will provide the tips and that play around Excel without a struggle when we are creating an interactive dashboard. Data visualization is the presentation of data visually. We can easier to identify new patterns with interactive visualization.
Declaimer: I used the raw data provided by MyOnlineTrainingHub. You might use the same raw data by click here.
Create a Table
- Click CRTL + T and it will select the range you're provided and click “OK”
