All articles with 'dashboards' Tag

Welcome back. In final part of Making a Customer Service Dashboard using Excel let us learn how to add macros & VBA code that makes our dashboard interactive.

As you can see, there are 2 important macros in this dashboard.

Welcome back. In third installment of our Customer Service Dashboard series, we will learn how to construct the charts in our dashboard. We will understand the sparklines, traffic lights & dynamic chart setup. To help you learn better, I have recorded a short video too. Go ahead and enjoy.

Hi readers,

Just a quick reminder. We are closing early-bird discount for my Australian Excel & Dashboards Masterclass on 16th April. So if you want to attend my training program in Sydney, Melbourne or Brisbane, you have very little time left to sign-up.

Click here to sign-up for Advanced Excel & Dashboards Masterclass.

Hello folks,

We pause the regular broadcast of Excel awesomeness to share something exciting. As you may know, I will be running a series of Advanced Excel Dashboard Masterclasses in Australia this May & June. So if you live in (or nearby) Sydney, Melbourne, Canberra, Perth or Brisbane and want to one up your dashboard skills, you know what to do next.

I am conducting these masterclasses in partnership with Plum Solutions.

Read this short post or Click here to know more about this masterclass.

Is Excel acting slow & taking ages? As part of our Speedy Spreadsheet Week, today lets talk about optimizing & speeding up Excel by formatting & charting better. Use these tips & ideas to super-charge your sluggish workbook.

No matter how much data you got, how many formulas you wrote, the end users seldom see them on your workbook. They see the finalized dashboard, they play with the model, they look at the report. And if you make poor choices, your end users will thing your workbook is slow.

So let me present you 7 charting & formatting tips to optimize & speed up Excel. Read on…,

Welcome back. In part 2 of Making a Customer Service Dashboard using Excel let us learn how the data & calculations for the dashboard are setup.

Designing Customer Service Dashboard
Data and Calculations for the Dashboard
Creating the dashboard in Excel
Adding Macros & Final touches

In this installment, we will examine all the variables, named ranges & various formulas that drive our dashboard. Also, you can download the full dashboard workbook and play with it to examine these formulas and learn better.

Hello folks, I have a super exciting news to share with you all. I will be conducting a series of Masterclasses on Advanced Dashboards & Excel in Australia this Autumn (May – June 2012). So if you live in (or nearby) Sydney, Melbourne, Canberra, Perth or Brisbane and want to one up your dashboard skills, […]

Sawadee Krup folks. Today, we begin a new series on Chandoo.org – Making a Customer Service Dashboard using Excel. This 4 part tutorial teaches you,

Designing Customer Service Dashboard
Data and Calculations for the Dashboard
Creating the dashboard in Excel
Adding Macros & Final touches

Customer service is one area where a lot of data is collected regularly. Understanding all this and making business decisions is quite complex task. This is where dashboards shine.

Read on to learn how to design customer service dashboards.

Hello lovelies,

We break the regular awesomeness on Excel & related beauty to bring you an important notice.

You may know that I run an online Excel & Dashboard training program, called as Excel School. We have been running this course since Jan 2009 and trained more than 1,500 students thru this so far. And starting next Monday (29 August), the course prices are going up.

So, if you are waiting to become awesome in Excel, now is your chance.

Click here to learn more about Excel School & Join us.

Any Tom, Dick and Sally can make things complex. It takes guts and clarity to simplify things. That is why I was pleasantly surprised to see this dashboard prepared by Michigan State. You can see it in the detailed article.

Linda, one of My Excel School students shared this dashboard link with me and asked if I can show how to construct something like this. Here is my version of the dashboard.

Read this post to learn how to construct a similar dashboard on your own. Also, you can download the excel workbook and play with it.

Nothing gives a teacher more satisfaction than seeing a student apply the knowledge to do something awesome. So naturally, I jumped with joy when I got this email from Dan, one of my VBA Class students,

Hi Chandoo,
After going thru your VBA Classes, I realized that we can lots of awesome stuff with pivot tables + simple macros. I recently created an Excel Dashboard to depict MLB (Major League Baseball) Pitching Stats. I could not have done this had I not learned VBA. Thank you so much for teaching the class.

I got curious and requested Dan, if I could share the file with you all. Being a lovely person, Dan agreed immediately.

Few days ago, we published an article on how to create interactive dashboards using hyperlinks. Many of you loved this tutorial. But quite a few of you also said, this tutorial is a bit complex to follow.

So, I made a short video explaining how the UDF and interactive hyperlinks work and how our dashboard is weaved together.

Last week we learned how to create dynamic hyperlinks in Excel. Today, I want to show you something even cooler. An interactive dashboard based on hyperlinks, like shown above.

Isn’t it impressive?

Well, to create something like this, you don’t need a degree in advanced cryogenics. You just need a bunch of data, a chart, a one line macro code and some pixie dust (go easy on pixie dust).

Recently, I ran a contest asking you to analyze a bunch of sales data and present your results in charts. We received a total of 78 charts from 45 people. The contest entries had a mind-boggling variety of excel charts, techniques and ideas. It took me a while to go thru all the files and compile the results. Thanks for your patience. In this post, you can find all the charts along with my comments & links to download files.

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.