Excel Dashboard Mock up an Alternative solution

In the last blog post i have discussed that why mock ups for the dashboard are important and how to create one using an online tool.

There is also an alternative ways to create mock ups for your first Excel Dashboard. I would suggest to create these mockups for all the big dashboards you are planning to create. Let us discuss some alternative ways through which you can create mockups 


Traditional Approach: Using a Pen and a Paper

Traditional approach seems great if you don't have time to go online and do dashboard related designing. One can just take a piece of paper and a pen to just draw a basic outline of your dashboard. This way your majority of time is saved and you can easily create a great dashboard mock ups for approval from the concerned authority.

Modern Approach: Using Powerpoint

In the last blog post i explained how to create a mock up using an online tool. Now i am going to guide you on how to create such on power point. Its not great to create on power point but still if you don't have an internet connection or you just have a Microsoft office installed then you can pretty much play around with power point to create a dashboard mock up.

Step 1: Open Power point and then choose a blank layout to add mock ups and designs
Step 2: Insert shapes and charts for a basic mock up
Step 3:
Your ready reference for creating an Excel dashboard is done.

Watch a simple video walk through regarding creating Mockups using Powerpoint.

Amey (Exploring Excel)

I am enthusiastic Excel learner and Expert. I am founder of ExploringExcel.com with Articles, tutorials and videos.

Click Here to Leave a Comment Below

Leave a Comment: