Share
Behold, here is the official trailer for our Project Portfolio Dashboard, releasing worldwide on 19th November (Monday), 2012.
Few days ago, we learned how to design a project portfolio dashboard. The next part talks about how to create this dashboard using Excel.
Click here to download Project Portfolio Dashboard Template.
Share this tip with your colleagues
Thank you so much for visiting. My aim is to make you awesome in Excel & Power BI. I do this by sharing videos, tips, examples and downloads on this website. There are more than 1,000 pages with all things Excel, Power BI, Dashboards & VBA here. Go ahead and spend few minutes to be AWESOME. Read my story • FREE Excel tips book
– Jason
From simple to complex, there is a formula for every occasion. Check out the list now.
Calendars, invoices, trackers and much more. All free, fun and fantastic.
Still on fence about Power BI? In this getting started guide, learn what is Power BI, how to get it and how to create your first report from scratch.
This week, let’s try something new. I have a spreadsheet challenge for you. Solve it, post your answers by leaving a comment. No cheating or
11 Responses to “Learn how to create these 11 amazing dashboards”
Wow..some of the dashboards you've created here, I had no idea could be created using excel. Thank you for sharing such in depth information. Will be visiting back to learn more.
[…] Learn how to create these 11 amazing dashboards […]
Hi
Can I download the above dashboards?
I would like to try some out?
Fantastic dashboards!
[…] some inspiration? Go to Chandoo’s blog for some awesome examples of Excel […]
Hi Chandoo,
I am a big admirer of your work for a while now as well as used tips and tricks for my work as a data analyst.
I really like these dashboards you've done. My question is how to be able to download the source files? are they available in the excel school?
My other question is: with relevance to Dashboards which course would take priority? Excel School OR Power Pivot class??? (I can only take 1 at the moment)
Kind regards, Tom.
@Tomas.. thanks for your love and appreciation of our work.
Answers.
1. Yes, all these workbooks and detailed tutorials can be downloaded from Excel School program (except those marked as Power Pivot class)
2. For Dashboards, go for Excel School + Dashboards program.
Please visit http://chandoo.org/wp/excel-school/ to sign-up.
Hi Chandoo,
I have to say really useful webpage. I have a quick question. I have just build a dashboard but I stuck we a small problem.
In my dashboard I have a slicer with week nr. When select in slicer a week nr for example week nr 5 like to have compared with week nr. 4.
Current week 10
Chnage vs Previous Week 5 -50%
But I am not able to get the last weeks figure. Can you help me ?
Hi i am alireza i like nice dashboards
I've used sumproduct(subtotal(....)) formula on dashboard to dynamically calculate values form a table, by applying filters to the table on sheet2. I need to have filters(dropdown values of filters) on the dashboard, in order to avoid going to sheet2 for applying different filters and instead select a values from dropdown list and it automatically filters the related column in sheet2. I can share the sheet, anyone plz help me.
Very Awesome!
Please keep me updated of new excel and PowerPoint newsletters and tips pls