Excel Dashboard Design Tips

10 rules for better dashboard.

As you learn to build your first dashboards,  you will get feedback from the end users. Their feedback will directly challenge you to ‘re-think’ what you initially presented. Take this advice and learn from it.  Below are some important tips for you to consider before you begin to build anything.

Determine the Needs of Your Users                  Choose relevant KPIs

Determine your goals                                           Communicate Information Quickly

Tell a story with your data                                   Do Not Use Too Many Colors

Select the Right Type of Dashboard                 Clearly Label Data Points

Limit Information On The Same Page              Add Filters For Interaction