All articles with 'project management' Tag

CP047: Best Excel tools for Entrepreneurs

CP047: Best Excel tools for Entrepreneurs

In the 47th session of Chandoo.org podcast, let’s see how Excel can make you an awesome entrepreneur.

What is in this session?

In this podcast,

  • Why Excel for entrepreneurs
  • Key areas of a business owner’s work
    • Projects & to dos
    • Finances
    • Customers & marketing
    • Planning & strategy
    • Processes & workflows
  • 5 features of Excel that help
  • Conclusions
Continue »

CP046: Gantt charts & project planning using Excel

Published on Oct 8, 2015 in Chandoo.org Podcast Sessions, Charts and Graphs
CP046: Gantt charts & project planning using Excel

In the 46th session of Chandoo.org podcast, let’s talk about gantt charts and project plans.

What is in this session?

In this podcast,

  • A brief intro to Excel 2016
  • What is a Gantt chart?
  • How Gantt charts can help us?
  • How to create Gantt charts in Excel
    • Using bar charts with invisible series
    • Using conditional formatting and formulas
    • Using ready-made templates
  • Resources on Gantt charts & project planning
  • Conclusions
Continue »

Quick and easy Gantt chart using Excel [templates]

Published on Feb 18, 2014 in Charts and Graphs, Learn Excel
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.

Continue »

Excel Risk Map

Published on May 28, 2013 in Automation, Project Management, VBA Macros
Excel Risk Map

We all have some projects to manage every now and then and there are needs of various trackers that help us in gauging the progress of the same. One of the most important things are heat maps that quickly help us in visually displaying the names of the projects that need special attention and resolve issues that are impacting them.

Continue »

Project Portfolio Dashboard in Excel [Part 2 of 2]

Published on Nov 19, 2012 in products, Project Management, VBA Macros
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.

Project Portfolio Dashboard Pack is now available.
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.

Continue »

Project Portfolio Dashboard – Official Trailer

Published on Nov 15, 2012 in Project Management

Behold, here is the official trailer for our Project Portfolio Dashboard, releasing worldwide on 19th November (Monday), 2012.

Continue »

Designing a Project Portfolio Dashboard [Part 1 of 2]

Published on Oct 25, 2012 in Project Management
Designing a Project Portfolio Dashboard [Part 1 of 2]

In this 2 part tutorial, we will learn how to design a project portfolio dashboard. Part 1 will focus on user needs & design. Part 2 on Excel implementation.

Background
As you may know, we sell a set of Excel Project Management templates. These templates help plan, track, manage & report a project right from Excel.

While these templates good, they have one limitation. They work for one project at a time. Many customers have asked me if I come up with a project portfolio dashboard that can tell what is going on in a set of projects in one view.

And that is where we begin.

Continue »

Excel for Project Managers program is open, Please join today

Published on Nov 14, 2011 in products, Project Management

Excel for Project Managers - Online Training Program from  Chandoo.org & Pristine

My dear friends & readers of Chandoo.org,

We are so happy to announce Excel for Project Managers program for your consideration. Please read this short page to understand the benefits of this course & to sign-up. Or visit our sales page for details.

Who is this course for?

Well, I am sure you know the answer. This course is aimed at Project Managers, Business Analysts, Project Leads and people aiming for various project management roles. This course also helps project sponsors, people working in reporting & financial analysis of projects.

To enjoy this course, you should be familiar with various aspects of Excel (preferably Excel 2007 or 2010). This course is not aimed at absolute newbies of Excel.

Continue »

Excel for Project Managers is coming up next Monday (14th), Details Inside…

Published on Nov 9, 2011 in Project Management, Training Programs
Excel for Project Managers is coming up next Monday (14th), Details Inside…

Last week, we have announced about an upcoming online training program – Excel for Project Managers. Quite a few of expressed interest and shared ideas on how we should do this course. Finally, I am happy to announce the dates for this program and share details. Read on… Who is this program for? Well, there […]

Continue »

Tell us what you would like to learn in our Excel for PMs course [Survey]

Published on Oct 25, 2011 in products, Project Management
Tell us what you would like to learn in our Excel for PMs course [Survey]

Few days ago, we announced about our upcoming Excel for PMs course. Quite a few of emailed me and told that you are looking forward for this.

Today I want to share our preliminary agenda for this course and take your help in fine-tuning it.

Continue »

Commercial Aspects of Project Management

Published on Oct 14, 2011 in Project Management
Commercial Aspects of Project Management

In 2005, fresh out of MBA School, I was put on managing an e-business transformation strategy project. It was then that realized that project management was a full time job (I always wondered before that why PMs were even paid a dime!). We created huge Project Management reports for the client, where were tracked and […]

Continue »

Scenario Analysis for the Project Valuation [Financial Modeling]

Published on Jul 26, 2011 in Financial Modeling
Scenario Analysis for the Project Valuation [Financial Modeling]

Few months ago, we learned how to create a project valuation model in Excel as part of our series on Financial Modeling in Excel.

My Project Evaluation Model had a limitation!! In one of the personal comments that I received, the reader pointed out an important problem!

Continue »

Introduction to Project Finance Modeling in Excel

Published on Feb 8, 2011 in Financial Modeling, Learn Excel
Introduction to Project Finance Modeling in Excel

This is a guest post written by Paramdeep from Pristine. Chandoo.org runs Financial Modeling School program in partnership with Pristine Careers. Visit Financial Modeling School to learn more and sign-up for our newsletter.

Greetings!

It’s been long time since we interacted on Chandoo.org. Actually I was very busy teaching the 105 awesome students for financial modeling in Excel. We all worked together to create some easy and some complex financial models. I found the journey to be quite exciting and enriching (From the feedback that I got, my students too didn’t find it bad either 😉 )

During the interaction, I found that a lot of students were looking for financial modeling around the project financing as well. So we thought why not introduce financial modeling for project finance.

In this post I will speak about some of the key aspects of a project finance model and why it can be different from modeling a normal company.

Continue »

9 Excel Tips & Downloads Submitted by Our Readers [Reader Awesomeness Week]

Published on Aug 9, 2010 in Charts and Graphs, Excel Howtos, Learn Excel, VBA Macros
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. 🙂

Continue »

Gantt Box Chart Tutorial & Template – Download and Try today

Published on Jul 12, 2010 in Charts and Graphs, Learn Excel
Gantt Box Chart Tutorial & Template – Download and Try today

On Firday, we proposed a new chart for showing project plans. I chose an ugly name for it and called it Gantt Box Chart. Essentially, a gantt box chart is what you get when a gantt chart and box plot go to a bar, get drunk and decide to make out. It shows the project […]

Continue »