Hi there,
Welcome to Pointy Haired Dilbert. Over the last few weeks, we have seen huge influx of new members in our little community. So I am writing this to welcome you.
This is a site for people who want to tell stories using charts and data. Although we focus more on learning Microsoft Excel, we have hundreds of useful resources on data visualization, dashboards, charting best practices and data analytics.
My name is Chandoo, I am from India, but I travel around the globe frequently and have worked in 7 countries in last 3 years. I have started writing PHD in 2004, mostly to tell my friends and family about my b-school life. The blog became an excel and charting community in 2007 and has been growing strongly ever since. In year 2009, I have received the MVP award from Microsoft. Just few days back I have become a dad too…
If you are a subscriber to this blog, you should be getting fresh excel and charting tips through e-mail / RSS. But, there is more to Pointy Haired Dilbert than just a regular update.
Here is a list of 5 things about PHD that you probably don’t know,
Comprehesive resources to help you make an excel dashboard
That is right. We have a good selection of articles, tutorials and free downloadable templates to help you with your excel dashboards. There is a 6 part tutorial on making KPI dashboards using excel guest authored by Robert from Clearly and Simply.
Click here to see the excel dashboard section of the site.
Learn 51 Everyday Excel formulas in plain English
You can learn almost all the eveeryday excel formulas using the learn excel formulas section of the site. You can even buy the e-book version of it, which has 75 formulas in a much more learner friendly format.
Click here to see the excel formulas page.
Free Excel Downloads & Templates
We have a huge collection of free, downloadable excel templates, chart templates, excel utilities, excel games and much more in the free excel downloads section of the site.
Click here to see the downloads section.
Free Excel E-books
We have 2 free excel e-books on the site.
(1) 95 Excel & Charting Tips to make your 9 to 5 better
(2) Excel Ribbon Learning Guide
These books present great content in a fun & easy to learn way.
Ask an Excel question in our Discussion Forums
Recently we have added a discussion forum to PHD. In the discussion forum you can ask any excel or charting related question and get help from other members.
Click here to access our discussion forums.
Welcome once again. I hope you are learning and enjoying this place as much as we like to learn and share. Have a fun week ahead.
7 Responses to “CP014: How to create awesome dashboards – 10 step process for you”
Very interested in topic unfortunately I get no sound when I play it.
Where can I get add ins for excel 2007
#Budala
Try using Google to search for Excel Addin
I would like to join your email newsletter.
@Andy
Goto: http://chandoo.org/wp/
The newletter registration is top Right corner
Hello Chandoo,
i am one of the great fan of your. i am one MIS executive in realstate company.And i try make dash board for CRM(Client Relation Management) Dept formance and anlysis process.Its get created not so effective according to can u suggest me .what i hve to give or take for makeing it for effective and attractive?.
regards,
Shashak verma
Hi,
I want to create an interactive dashboard in excel (Google Drive) which should have multiple data along with beautiful charts..
I handle two teams in IT Tech support so were preparing 2 different dashboards.. however need to club and want to create single report, can anyone help something like