How to create a fully interactive Project Dashboard with Excel – Tutorial
Do you manage projects? You are going to LOVE ? this one. In this in-depth tutorial, learn how to create a fully interactive & dynamic Excel Project Management dashboard. Sample files & video instructions are also provided.
Project Plan – Gantt Chart with drill-down capability [Templates]
Create a gantt chart with ability to filter by levels. This drill-down gantt chart in Excel is useful for seeing activities by module or team. Read on for full instructions + downloadable template.
Free Excel Risk Map Template
Risk comes from not knowing what you are doing. Warren Buffet If you ever ask a project manager what they are up to, they will tell you “I have no idea“. So risks are quite common in project management. That is why I made this awesome free Excel risk map template to keep track and […]
Excel Links – PASS BA 2015 Edition
In about 3 days, I am leaving to USA for participating in PASS Business Analytics conference – 2015. It is an annual event for people in analytics profession. This is the first time I am attending & speaking at the event. I am so excited for many reasons.
- I will be meeting many Excel bloggers, authors & internet friends for the first time
- I will be meeting many of you (readers, listeners, followers & customers of Chandoo.org) too
- I will be speaking at an awesome conference
- I will be visiting San Francisco for the first time in life
- I will be meeting a few college friends too
All this excitement means, I have too much going on. But that shouldn’t leave you out . So here are a few awesome Excel links for you. Check out and learn.
Quick and easy Gantt chart using Excel [templates]
Gantt charts are a very popular way to visually depict project plans. Today, let us learn how to use Excel to make quick & easy Project Plan Gantt Chart.
This is what we will be creating.
Project Portfolio Dashboard in Excel [Part 2 of 2]
In this 2 part tutorial, we will learn how to design a project portfolio dashboard. Part 1 discussed user needs & design. Part 2 will show you Excel implementation.
Click here to get your copy.
Final Implementation – Project Portfolio Dashboard
First lets take a look at the finalized dashboard implementation. Continue reading to learn more & download this dashboard.
9 Excel Tips & Downloads Submitted by Our Readers [Reader Awesomeness Week]
Last week I announced Reader Awesomeness Week to celebrate the passion, attitude and knowledge of our little community here. I got 9 interesting and beautiful entries from our readers. In this post you can see 9 tips & downloads submitted by our readers. These include a project management template, a macro to remove blanks, a technique to make Google Earth maps using Excel and several other interesting tips & tricks.
Go ahead and read them, download attached workbooks and become awesome in Excel. 🙂