fbpx
Search
Close this search box.

Ready to use Excel Dashboard Templates – Official Trailer

Share

Facebook
Twitter
LinkedIn

Hello folks,

It’s almost ready. Our ready to use Excel dashboard templates available now.

Here is a teaser preview of the dashboards. Our own official trailer, rated A for awesome.

Watch it below:

(see it on our YouTube Channel, alternative link)

Excel Dashboard Templates – What are they?

As the name suggests, these are a set of workbooks where you can key in your data, set up how you want the looks & bam, a beautiful, insightful, fun, easy to use dashboard pops right out. All in few minutes.

Here is how these templates can help you:

  • Design awesome dashboards in minutes, not months: Don’t waste hours trying to figure out formulas, chart settings and layouts. Instead focus on what your users want, how your business works and use those insights to tell the ‘Excel Dashboard Template’ what you want. Save time and look awesome.
  • Accommodate change elegantly: People change. Businesses change. What your boss wanted last month is no longer what she wants today. So when someone asks you, “hmm, can you show me YTD data instead of last 13 months”, or “Can I see top 10 KPIs instead of all”, you just smile and tap a few clicks and bingo, the new dashboard will be ready. These templates are designed to handle change (data, requirements, design preferences and insights).
  • Beautiful & Informative: These templates are designed with a delicate balance of beauty & insight. Everything is seamlessly designed, perfectly aligned and precisely calculated so that you & your boss can focus on the insights & decisions. Time tested and well honored visualization principles & guidelines are observed thru-out the reports.
  • Built for starters, built for pros: Whether you are just starting with Excel or a seasoned pro, you can find the templates right up your alley. For advanced users, we have many customizations to whet your appetite. Want to build a custom calculation or include another type of sorting, you can do it by tinkering with ‘calculations’ sheet.

How to get them?

Please click here to get your copy of Excel Dashboard Templates.

How do you like the first look?

I am very excited and nervous about these templates. It took me more than an year to conceptualize, create, test & publish these templates. They reflect what I learned about using Excel to create awesome things, in last 10 years.

I would love to know what you think about them. Please share your feedback in comments.

Facebook
Twitter
LinkedIn

Share this tip with your colleagues

Welcome to Chandoo.org

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 storyFREE Excel tips book

Chandoo is an awesome teacher
5/5

– 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.

letter grades from test scores in Excel

How to convert test scores to letter grades in Excel?

We can use Excel’s LOOKUP function to quickly convert exam or test scores to letter grades like A+ or F. In this article, let me explain the process and necessary formulas. I will also share a technique to calculate letter grades from test scores using percentiles.

62 Responses to “Ready to use Excel Dashboard Templates – Official Trailer”

  1. David says:

    Looks like a great head start for developing a management report out.
    How 'locked' will the file be - can we unlock the workbook (including VBA code?) or individual sheets to customise charts / colour themes etc. beyond what is initially set up?
    Understand many will be happy to use your set up as it stands but some will want to tinker, break and 'repair' it too 🙂
    Thanks Chandoo!!

    • Chandoo says:

      The file (purchased ones) will be completely unlocked and 100% editable. The beauty is, there is no VBA. Pure formulas. So customization is easy too.

  2. KungDi says:

    I'm very excited to learn more!
    Thanks for your help, Chandoo!

  3. Franee says:

    Looks pretty awesome. Wish I knew more about dashboards and the underlying pieces.

  4. Swarup says:

    I am a great fan of chandoo. If Chandoo dies something, close your eyes and buy it.... Noone will have any opportunity to regret

  5. Michelle says:

    Can't wait!!

  6. Vladimir says:

    The uploader has not made this video available in your country... No beauty, Mr Chandoo. I thought at least Excel stays out from all that jazz.

  7. Davide says:

    It looks amazing!!

    Great job!
    For which Excel version will it be available? please not only for the last one!

  8. Donna says:

    Looks awesome! will I be able to get my personal data loaded via a web query? (we use SAP for our financial data)

  9. Abhishek says:

    Hi Chandoo,

    Trailer looks fantastic!!!! Will try to get inspired by your work and create a similar dashboard for my company..... I read your earlier comment too... I am not, VBA trained but yes I can try my hands on formulae, validation, and slicer, to create a similar one.... May be not that impactful but surely a good one 😉 u simply rock and inspire us Chandoo!!!! Cheers!!!!

  10. Cristi says:

    So what kind of data source can we use for the raw data and how to we "plug" our data into your framework?

  11. Thomson says:

    They look awesome and I'm surprised there are no VB to enable this. Looks awesome.
    I was currently building something like this and was often hitting bottlenecks due to my very limited knowledge in VBA. I started your VBA course get through those bottlenecks.
    Awesome work!!

  12. Lee says:

    Wow. Knocked my socks off. I put the date into my calendar. I will be coming back here on November 13th. KPIs, measures, trends, all ready for my data without VBA? Sold. Excellent video demo (btw). -Lee

  13. Dan says:

    Looks good and I'm interested. I'm wondering what the process will be to link my existing data sources into the dashboard.

  14. Brad Edgar says:

    Chandoo

    This looks awesome! What a great idea. In the past month I've been working with a project called $5 dollar dashboards on my website which only looks at individualized dashboards by industry (not templated as you've done here) I love the idea that you can take one dashboard and flip it around to meet any of your needs regardless of your data set.

    Great job!

    I look forward to having a peak.

    Cheers.

    Brad

  15. Harry Jude says:

    Really awesome !!!
    Dashboard templates I am hearing for the first time in excel....
    definitely it saves lot time in preparing the reports..

    Thanks Chandoo...:)

  16. Steve A says:

    YOU are Awesome!!! Love this idea.

  17. Karanbir says:

    Dear Chandoo,
    How pricey will the worksheets be?

    Regards
    Karanbir

  18. Darrell says:

    Chandoo, I like the initial look of your Dashboard templates. I've been creating a monthly report very similar to this for the past couple of years that I share with our Board of Trustees. I call it "Vital $igns". They really like the idea of seeing a number of relevant benchmarks presented all on one page. I look forward to seeing how I might integrate your templates into my reports to make my job easier.
    Thanks a bunch!
    Darrell

  19. Terra says:

    I can't wait. This is a primary function of my job and the dashboard I operate today SUCKS. This looks beautiful!

  20. Claudio says:

    Thanks so much Chandoo, it souds terrific!, I'm following you for a while and I really need Dashboard templates to work with.

    It will be the price "affordable" ? Can we use it with other "open" system like LibreOffice or Openoffice without loosing the look&feel?

    Way to go!

  21. Scott Olson says:

    These look great! I look forward to seeing more and hopefully fill a gap in my work that has long needed to be filled! Can't wait!

  22. Cesarino says:

    Just a word:

    Awesomeawesomeawesomeawesomeawesomeawesomeawesomeawesomeawesomeawesomeawesomeawesomeawesomeawesomeawesomeawesomeawesome!

    Regards
    Cesarino Rua

  23. Juan Carlos Etayo says:

    Definitivamente es el mejor sitio de todos para aprender sobre lo grandioso que es el Excel.

    Personalmente llevo muchos años utilizando los buenos consejos y practicas que desde http://chandoo.org/wp se pueden obtener y los resultados para mi han sido los mejores.

    Thanks Chandoo!!

  24. Jake says:

    Very nice! I look forward to seeing them released!

  25. Sue says:

    These look really great. Just the kind of high level summaries executives want. Like Karanbir, I'm wondering how much these will cost?
    Thanks!
    Sue

  26. Di says:

    Hi Chandoo

    I will be going overseas for a week from the 13th and will have minimal access to the internet. Will the offer to purchase them still be going on the 21st? They seriously do look awesome.

    Thankyou
    Di

  27. Rao P.S. says:

    With the teaser it seems amazing but need to know how and at what application it will be useful to put in the real world. If it is for Daily Sales Report or Daily Cash Report of monthly MIS Report everything can be taken in one go.... Can't wait for Nov 14th when you show us in detail....

    Its really very unique....

  28. Chandoo,

    This is an awesome idea and I know that it will be a huge success like most of your products and I can´t wait to promote these with my fellow subscribers!

    A week is too long to wait....I want it NOW!

  29. Jose says:

    I can't wait for the roll-out of this product. I need to create some compensation spreadsheets, and this will save me tons of time!

    Thank you sir!

  30. NickC says:

    Hi Chandoo,

    How hard would it be to use these in conjunction with data in a PowerPivot model?

    Cheers

    Nick

  31. Luke says:

    If this template can address views for Revenue/Cost/GP, Inventory management, project-change-request management, operational manpower resource tasks....... i'll be hooked.
    Looks good Chandoo. Will try this tool.

  32. Sergio Silva says:

    Hi.

    I'll be one of those who really can't wait until 13th November.
    as someone said before, waiting one week is to much!!!

    kind regards from PORTUGAL

  33. Jamie Dodd says:

    Can't wait! The video triggered about a hundred ideas in my head, and now I'm like a little kid at Christmas!!!

  34. Santosh says:

    Hi Chandoo,

    I was wondering if at first we can have a locked version say like a trial version for a day or two to check the awesomeness of this Dashboard ?

    This is to just make sure it fits individual needs and one can provide suggestion if any upgrades required.

    Cheers

  35. Peter Allen says:

    Hi Chandoo
    I need to show about 6 top20/6 bottom20 daily assessment marks filtered by class, teacher, faculty, date and range, historically and daily. Can the KPI indicator be used for this?
    Just ignore this if it's too much.
    Peter

  36. Vincent says:

    Just simply awesome. Cant wait for the launch. I've done a few basic one pagers - but this interactive format is brilliant.

  37. Mahir says:

    Looks Great. WoW. Congrats to you and your team Chandoo.

  38. michel says:

    Wow, I'm impressed! Looks like I can go in any direction I want (or rather : my managers want)

  39. Bob Hoskins says:

    I find it amazing that you can do all this without VBA, you are truly the master of Excel. That said, are there any plans to do a VBA version? I can only imagine the kind of features that you'd be able to pack into it

  40. Krishna Teja says:

    Hi Chandoo,

    Its a treat to eyes. I am still wondering how did you enable the sorting option on clicking the Top 10 and Bottom 10 without using VBA. Will try to figure out soon.
    I will mail you if I have figured it out!!!

    And all the best for the dashboards 🙂

    Krishna

  41. Bobi Lekic says:

    Hi Chandoo,

    Thank you for this early present. I've been looking for ways to develop an inner active dashboard and functions that you presented. Will there be a tutorial on how you developed this? I've subscribed to the Power Pivot and Power Pivot advanced and the tuitorials have helped me to tailor my reporting. You have help me and I'm sure others to stand out when looking for employment.

    Warmest Regards!
    Bobi

  42. Brett in Houston says:

    Hi Chandoo!

    As always, you produce great stuff to make us AWESOME!

    Thanks!

  43. Juan Carlos Etayo says:

    Hi Chandoo,

    Envio a usted y toda la comunidad mis mas sinceras felicitaciones por este sitio tan maravilloso, sus enormes aportes son de gran ayuda para quienes nos beneficiamos de estos espectaculares dashboard.

    Estoy invitando a toda la comunidad de habla hispana (idioma Spanish) para que haga parte de este foro.

    Saludos desde Bogota, Colombia.

  44. Sumesh P S says:

    Hi Chandoo,

    This is awsome!!!

    Thanks!
    sps

  45. Koms says:

    Chando

    When this is going to be available?

  46. Rajendra says:

    Hi Chandoo,

    Excellent. Waiting to watch the Blockbuster in Excel ...

    Thanks !

  47. Oneshoot says:

    excelent..!!

    nice for more tutorial and learning

  48. Meg says:

    Chandoo = Awesome!!!

    I've watched this three times in a row and just can't wait to see the full version. It's like Christmas has come early!!

  49. Kostas Ntzounis says:

    Look like a great piece of work. Since there no VBA involved it should be a masterpiece of training, too.

  50. Steve Little says:

    Salivating 🙂

    Great stuff Chandoo!

  51. Maginet says:

    Do we need to wait until Thursday ? What about a sneak preview Saturday night !

    The Oscar goes to Chandoo !

    Great stuff

  52. New and Confused says:

    Is it possible to have trial version for download (for 4 to 5 days) just to make sure it is going to be working with my data - what I am tracking and reporting on has nothing to do with sales performance and customers etc...

  53. Zilla says:

    Is there a way to download files and play around with a copy with all the cells locked with some data just to see the functionality of the dashboards. If cells are locked then the only way to add data is to purchase a copy for use.

  54. Sohail Anwar says:

    Chandoo, this looks fantastic, its going to save me a great deal of time. I'll be picking up a copy for sure

  55. Martin Håkansson says:

    Looks really great!
    But would really appreciate as well to know how the update process works. Do we need to copy/paste all the new data, or is it possible to hook up to external databases?
    Thanks.

    • Chandoo says:

      Hi Martin,
      As of now the templates support copy paste or manual entry methods only. Since the dashboard is quite complex, I do not recommend direct linking thru DB connections. I suggest below method:
      1) Get data thru a connection to a separate sheet
      2) Ensure the imported data is in right format
      3) Plug this data to the end of Dashboard Data table with copy paste or VBA macro

  56. robert says:

    Hi, I'm looking for a dashboard template for kpi/vendor metrics reporting.looking for the usual stuff like otif,scar,capa.any of these templates can be used with this report?

Leave a Reply