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.
16 freelancers are bidding on average $116 for this job
Dear cpjrdevelopment, I just discovered slicers 2 weeks ago and spent a lot of time playing with that amazing tool. I would be glad to help you with your dashboard. Kind regards.
Dear Sir, It would be my distinct pleasure in working on this project with you. I have a vast experience in excel especially in desktop creation. Please see PM for details.
I am very much interest on this project. I am experienced on working on excel and I have also worked on slicer. I would like to ensure you that I will be able to deliver the project on time.