All articles with 'project management' Tag
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.Continue »
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 […]Continue »
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
- Customers & marketing
- Planning & strategy
- Processes & workflows
- 5 features of Excel that help
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
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 »
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 »
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.
Final Implementation – Project Portfolio Dashboard
First lets take a look at the finalized dashboard implementation. Continue reading to learn more & download this dashboard.Continue »
Behold, here is the official trailer for our Project Portfolio Dashboard, releasing worldwide on 19th November (Monday), 2012.Continue »
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.
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 »
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 »
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 »
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 »
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 »
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 »
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.
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 »