All articles with 'dashboards' Tag

Today, we will take a detour to world-wide web and learn how we can improve our dashboards, reports, presentations or workbooks by using one of the ideas, called as Golden Triangle.

I know I am late to the party, but better late than…, uh! forget it.

As the keen readers of our blog knew, I like cricket and I show my enthusiasm by making an excel dashboard (or info-graphic) whenever Indian team reaches a major milestone. So naturally, I was super excited when we won the ICC World cup 2011. Last time Indian won the event was in 1983 and my idea of a dashboard at that time was a bottle of milk and jingo-bell, my favorite shake-to-make-annoying-noise toy. I think our latest world-cup victory deserves something more than that. So here we go.

Wow, what a weekend it has been. Indian cricket team has won Cricket world cup 2011. It has been a highly entertaining tournament and the finals were just incredible.

Congratulations to Team India for winning Cricket World-cup 2011.

I am tempted to make a dashboard of sorts to show the journey of Team India in this world cup. But I could not get much time to work on anything. I will post something this week to celebrate the victory.

Read the rest of this post to get 5 recommended Excel resources to learn new things.

During last one week, we had a gala time with Dashboard Week on chandoo.org. To wrap-up the week, I am sharing a list of recommended resources, websites, tutorials & ideas for making dashboards.

Recommended Resources on Making Dashboards:
I have broken down this post in to various sections. Click on the links to quickly access the part you want to know or just keep scrolling to get the whole thing.

1. Books on Dashboards
2. Websites for Learning about Dashboards
3. Dashboard Training Programs
4. Add-ins & Software to Make Dashboards
5. Dashboard Tutorials & Downloads on Chandoo.org

In 2008, I received an email from Robert Mundigl, which was the start of a life-long friendship. Robert asked me if he can teach us how to make KPI dashboards using Excel. I gladly said yes because I am always looking for new ways to use Excel.

The original KPI dashboards using Excel article was so popular. They still help around 12,000 people around the globe every month. Many of our regular readers and members have once started their journey on Chandoo.org from these articles.

In this article, we will revisit the dashboard and give it a fresh new spin using Excel 2007.

Purpose of the dashboard:

This is a guest article written by John for our Excel Dashboard Week.

This Dashboard was constructed for a number of reasons, one of which was to reduce the number of reports produced with the same data ( up to 6 separate files ). As we all know, when it comes to senior management and reports / files the more information they can get on one report / file the better for them. So, with this in mind I created the Dashboard to show the data they need to see “quickly” each week.

Early in Jan, I got this mail from Mara, a student in Excel School first batch.

Hi Chandoo,

I took your first Excel batch class and loved it. I created a dynamic and interactive dashboard for my work. My boss thinks it’s an excellent tool and I have you to thank for and also Francis Chin who shared his travel dynamic dashboard. I integrated things you taught so thanks so much!

I felt very proud reading her email, so I asked her if she can share the dashboard with some dummy data so that we all can learn from her example.

Being a lovely person Mara is, she gladly emailed me the workbook and I am thrilled to include it in Dashboard Week.

As part of Dashboard Week, in this post, we will take a look at Health-care Dashboard prepared and shared by Alberto. He put together an excellent dashboard to visualize hospital performance and understand what is going on. Read this post to understand how this dashboard is made, watch a tutorial video & download example workbook.

Thank you Alberto for sharing the file & helping us learn.

Hello there,

I am glad to announce this week (21-25 March, 2011) as Dashboard Week on Chandoo.org
What happens in Dashboard Week?
As you can guess, during this week, I will be posting exclusively about Excel Dashboards. This is the tentative agenda … []

Many of us want to learn advanced Excel and make progress in our career. But how to do it? In this post, I show 3+1 ways in which you can learn advanced excel.

Last week I did an interview with Robert Mundigl of clearlyandsimply.com. Robert is an Excel wizard. You may know him thru the KPI Dashboard articles he has written on chandoo.org a while ago.

We spent about 90 minutes discussing some really cool & advanced Excel stuff. The interview will be available shortly on Excel School for our Dashboard students. But here is a snapshot of the dashboard we discussed in the interview. Robert taught me how to make such a dashboard using Excel.

Our of curiosity and fun I asked you “how long have you been using Excel?”. I was overwhelmed by the response we got to this simple question. More than 437 people responded with their comments, stories and enthusiastic responses. Thank you so much.

It would taken me more time to make the charts and understand the data. But thanks to Hui, who volunteered to tabulate all the survey data in a simple CSV.

Shown above is a chart I came up with based on the data. Read the rest of the post to understand the survey results and view more charts. Also, you can download the excel workbooks and original data set to play.

Transferring data regularly between Excel and Word for the production of Word based forms or reports cab be tedious if it involves much more than a few numbers.
This post looks at a technique for automating this process.

Some of you know our guest author and Excel ninja Hui. Yesterday was his birthday. And I wanted to create nice birthday gift for him. So I took a database dump of our forums data and created a dashboard.

Read rest of this post to see the dashboard & download workbook.

Friends & Readers of Chandoo.org, I am excited to announce that Excel School, my online excel & dashboard training program is now available for your consideration. Please take a minute to read this post.

What is Excel School & Who Should join?

Excel School an online Excel & Dashboards training program. It is designed to make you awesome by teaching formulas, charting, formatting, data analysis & dashboards.

If you use Excel everyday and find my site useful & helpful, then this is a perfect program for you.

I have trained more than 700 students in this program so far and many of them have benefited tremendously. I am hoping you too will benefit from Excel School.

If you want to join Excel School, click here.

Wish you a happy new year and Welcome back to Chandoo.org. So how did you celebrate the new year’s eve? We put the kids to sleep early and partied till 1. Next day, we took them to a park. The kids loved grass, trees and ran like wind. What about you? As for the new […]