Dashboard Creation Using the New Slicer in Excel 2010

  • Status Closed
  • Budget N/A
  • Total Bids 17

Project Description

Create a Dynamic Dashboard using Excel Front End using the New Excel 2010 Slicer, The data and pivotal table are already created, The Dashboard front end has to be a very well design and clean look to the user. I am attaching a demo example of slicer and there will be a link in the Readme File that show where the sample came from. There will be another exampe showng tab on the spread sheet that allow you utilies the screen realstate or layout. There maybe 6 or 7 design report that may not fix on one page. The user should not have a problem viewing it in almost any screen resolution. This is why I am mention the TAB on the Dashboard Front End.

Dynamic Dashboard using Excel below is the location where I learn of SLICERS in Excel 2010

Learn how to use Excel Pivot Tables and Slicers to create dynamic dashboards from your data. A tutorial from [url removed, login to view]

Second Example file in the zip file will have the weight program with TABS. This will give you and ideal of TABS. There may not be a need for tab because all of the layout of the dashboard may allow for he 6 pre-create reports to work on one front ends. This maybe and option or need to make thing work on the dashboard.

Link the table to make it work Dynamic like you see in the sample and video. When you listen to the Author you will see what I am talking about. But, if a Dynamic Dashboard can not work or make sense with this concept we can discuss other opton. Would love to have sample of past work . Do not send me sample spread sheet with VBA Code. If you have sample code with VBA Code then send me a screen shot of work. The code that you will be working with is done with Excel Function and you will need to compatible with Excel Function only. Good Designer Eye for look and Fonts.

Get free quotes for a project like this
Skills Required

Looking to make some money?

  • Set your budget and the timeframe
  • Outline your proposal
  • Get paid for your work

Hire Freelancers who also bid on this project

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online