REAL-TIME

VBA Projects

Full Access with Source Code
  • Designed and Developed by PNRao

  • Full Access with VBA Source Code

  • Well Commented Codes Lines

  • Creative and Professional Design

Effortlessly
Manage Your Projects

120+ Project Management Templates

Seamlessly manage your projects with our powerful & multi-purpose templates for project management.

120+ PM Templates Includes:
  • 50+ Excel Templates

  • 50+ PowerPoint Templates

  • 25+ Word Templates

Share Post

Creating dashboards in Excel is very easy and you can create dynamic dashboards. This is a simple dashboard, I have used a dummy store data for illustration purpose.

You can download the example file

[Sample Dashboard (Sales Data).xlsx] and have a look into this

Creating dashboards in Excel is easy, follow this step by step tutorial to learn

Home Tab:

This is the main tab of your dashboard, it should explain the objective of creating this dashboards, data using for this dashboards and you can provide links for user navigation. A Typical dashboard includes the following information in the main page:

  • Objective of creating the dashboard : Users can understand the purpose and background of developing this dashboard
  • Data Description: Users can understand what data you are using for developing the dashboard and what are important variables you are considering, you can also describe important variable and its important and why you have considered those variables
  • You can provide the buttons to Navigate the worksheets: It is good idea to provide buttons or links to navigate the worksheet, it will increase the user experience while using the dashboard.
  • You can also include the your observations of the data or summary: You can write your findings in the data, these insights will help executives to better understand the data
    • Creating dashboards in Excel - Main Page

      Sales By Region Tab:

      The objective of this tab is understanding the sales by region, I have provided a pivot table and chart to easily understand the data based on the region. And I have formatted the Pivot table and the Chart to look better

      Creating dashboards in Excel - Sales by region

      Sales By Store Level Tab:

      You can understand the sales performance based on the Category and Sub-category, I have provided pivot table and chart for each and formatted

      Creating dashboards in Excel - sales by store level

      Dashboard:

      It will be the one place where you can keep all important tables and charts which can give the overall understanding of the dashboard at one glance. You can also include the overall observations in this dashboard.

      Creating dashboards in Excel - executive summary

Effortlessly Manage Your Projects and Resources
120+ Professional Project Management Templates!

A Powerful & Multi-purpose Templates for project management. Now seamlessly manage your projects, tasks, meetings, presentations, teams, customers, stakeholders and time. This page describes all the amazing new features and options that come with our premium templates.

Save Up to 85% LIMITED TIME OFFER
Project Management Templates

All-in-One Pack
120+ Project Management Templates

Essential Pack
50+ PM Templates

Excel Pack
50+ Excel PM Templates

PowerPoint Pack
50+ Excel PM Templates

MS Word Pack
25+ Word PM Templates

Ultimate Project
Management Template
Ultimate Resource
Management Template
Project Portfolio
Management Templates
Categories: Excel DashboardsTags: Last Updated: June 17, 2022

10 Comments

  1. stela November 18, 2013 at 9:31 AM

    Hi PNRao,

    How do you create this awesome dashboard with the tabs? Any step by step tutorial for this?

  2. PNRao November 18, 2013 at 10:07 AM

    Hi Stella,

    Thanks for your comments, I am working on it and can add step by step tutorials to create dashboards in few weeks.

    Thanks-PNRao!

  3. Gopichand July 17, 2014 at 8:50 PM

    Hi,
    Looking for advanced excel 2013 training as new role at work demands lot of reports and dashboard preparation, presentations and applying logical math’s.

  4. PNRao July 18, 2014 at 6:59 PM

    Hi Gopichand,

    We are going to launch the Excel Dashboard course in September 2014, you can join in that course.

    Thanks-PNRao!

  5. Leah Potter September 10, 2014 at 12:28 AM

    Any guidelines on how to use the dashboard builder on the add in. can’t seem to pull through data to create a dashboard- not sure if im doing sometihng wrong!

    Help!

  6. PNRao September 11, 2014 at 8:29 PM

    Hi Leah Potter,
    I am working on the video tutorials, this will take couple of weeks.
    Thanks-PNRao!

  7. Ramya December 18, 2014 at 4:25 PM

    Hi,
    It would be really helpful if we can get step by step guide to use the dashboard builder. Right now, I cannot make head or toe of how do I populate the fields after I click on the dashboard builder.

    thanks,
    Ramya

  8. murali February 17, 2015 at 9:40 PM

    super creation my dear..!

  9. Arup September 2, 2015 at 12:29 PM

    Dear Sir,

    First of all thank you so much for sharing this beautiful dashboard. I would be obliged if you teach me how can I add buttons to navigate the worksheets.

    Thank you.

    Regards,
    Arup

  10. PNRao September 2, 2015 at 11:18 PM

    Hi Anup,
    Please follow the below steps to create a button with hyperlink:

    1. Go to Insert Tab
    2. Insert a shape
    3. Right click on the shape
    4. Click on the Hyperlink.. command
    5. Now link to desired sheet in this document place

Leave A Comment