Skip to content

Tutorial 1: Building the simplest MS Excel dashboard

February 17, 2012

Are you tired of searching for that simple practical easy step-by-step solution on how to build an excel dashboard without wasting much time and without getting bored flipping through infinite information?

Then relax coz you have arrived at your ultimate destination.

If you want to build the most basic form of an Excel Dashboard from scratch, just go through the image below: For conceptual explanation Go through this presentation:

A Quick Simple MS Excel Dashboard

Snapshot of Tutorial 1: Building the simplest MS Excel dashboard

Our Simplest Dashboard has a single indicator which is a pie-chart tracking the % break-up of all expenses incurred till date. To create this database we follow 4 steps:

Step 1: Present the data in a “list format”

Step 2: Filter out the essential data from the list

Step 3: Create a metric by processing the filtered data

Step 4: Assign a visual indicator to the metric

Download the Excel file here. ( approx. USD $3.26 ) This file is not free and will have to be purchased at a nominal value of ₹ 200 – Helps me to keep this website afloat :)

This concept can be extended to create more complex forms of dashboards. They can also be very handy tools of precise analysis on a regular basis.

Click here for next tutorial : Building interactive dashboards in MS Excel >>

About these ads

From → A. Tutorials

20 Comments
  1. hi!,I love your writing so so much! percentage we be in contact more about your post on AOL?
    I need a specialist on this space to solve my problem.
    Maybe that’s you! Taking a look forward to peer you.

  2. Hi there I am so delighted I found your blog, I really found you by mistake, while I was searching on Aol for something else, Nonetheless I am here now and would just like to say
    cheers for a remarkable post and a all round entertaining blog (I also love the
    theme/design), I don’t have time to read it all at the moment but
    I have saved it and also added your RSS feeds, so when I have
    time I will be back to read a great deal more, Please do keep up the fantastic
    job.

  3. Simply desire to say your article is as astounding.

    The clarity in your post is just cool and
    i can assume you’re an expert on this subject. Fine with your
    permission let me to grab your RSS feed to keep updated with forthcoming post.

    Thanks a million and please carry on the rewarding work.

  4. Actually no matter if someone doesn’t know afterward its up to other visitors
    that they will help, so here it occurs.

  5. I’d like to find out more? I’d like to find out some additional information.

  6. Thank you for sharing your info. I truly appreciate your efforts and I will be
    waiting for your further write ups thank you once again.

  7. Good day! Would you mind if I share your blog with my myspace group?
    There’s a lot of people that I think would really appreciate
    your content. Please let me know. Many thanks

  8. Rupa permalink

    Thanks Pranav, Nice and easy to follow. Thanks for sharing your knowledge

  9. Mukul Jain permalink

    Hi Pranav,

    nice work. great example and easy to use :)

  10. You may like to take a look at DashboardPlus (www.dashboardmore.com) , the only TRUE Excel Dashboard creator!

    Best regards

    Avi

  11. Felipe permalink

    Hi, Pranav,

    OK, I´ll be waiting for the next tutorial to try to understand your point!
    Keep up the good work!

    Thanks,

    Felipe

  12. Hi Felipe,
    Thanks for your response.
    You are right that the SUMIFS construct seems rather time consuming compared to a PivotChart..
    However, it becomes less useful when I want to choose what data needs to be filtered or referenced directly from my dashboard. SUMIFS plays a critical role in such interactive dashboards because of its power to flexibly refer to a single record or a group of records in a data list. I doubt if PivotCharts can give me complex customizations which SUMIFS allows to.
    In my next tutorial, I plan to write about basic interactive dashboards. I hope the usage of SUMIFS become much clearer then.

    Thanks again.
    -Pranav

  13. Felipe permalink

    Dear Pranav, that’s a great example of a simple dashboard, thanks for sharing!

    But why do you find the SUMIFS construction better than a PivotChart one? In the example you mentioned I would rather build the dashboard utilizing a PivotChart, because whenever a new Expenditure type (using your example) is added, the PivotChart would only need to be refreshed and the new Expenditure type would be shown.
    However, using the SUMIFS construction you would have to manually add all of the new Expenditure types, losing time and productivity.

    Thank you once again for sharing and I’ll be waiting for your comments!

    Best regards,

    Felipe

  14. Mangesh permalink

    I must say its informative…!!
    carry on..looking forward to next tutorial

  15. nice to see a useful and efficient way. Best of Luck !!!

Trackbacks & Pingbacks

  1. Quora

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Follow

Get every new post delivered to your Inbox.

Join 100 other followers

%d bloggers like this: