Showing posts with label MS Project 2016. Show all posts
Showing posts with label MS Project 2016. Show all posts

Monday, May 12, 2025

Course Review: CHAMP and MSP 2016 Live Lessons – Excellent Courses for Mastering MS Project in both Traditional and Agile Environments

By Sanjeev Kaushal, PMP


I recently purchased the MS Project 2016 Live Lessons course, which has both traditional (waterfall) and Agile content. It has been an invaluable learning experience for me. 

The course provides a well-structured approach to understanding how MS Project, which can be effectively used for traditional project management and also for Agile project management. I've been using the CHAMP certification course in parallel with MS Project Live Lessons.

The current review is first with respect to using the MSP Live Lessons and then getting into CHAMP certification course. 

What I Liked?

Following are the ones I liked most about the courses.

Comprehensive Content: The courses cover everything from Traditional and Agile fundamentals to advanced MS Project features.

Practical Approach: The courses have hands-on exercises and real-world examples helped me grasp key concepts.

Clear Instructions: The instructor explains complex topics in a simple and easy-to-follow manner.

Great for Project Managers: The courses are perfect for anyone managing Traditional or Agile projects and looking to streamline planning and execution.

My Key Takeaways 

I now feel confident using MS Project to manage Traditional and needed Agile workflows, track progress, and improve team collaboration.

I highly recommended for professionals looking to enhance their project management skills with Agile methodologies. 

Features in the Courses

Following are the unique and distinct aspects of these courses.

1. Hands-on Practical Approach

The course includes real-world scenarios, case studies, and interactive exercises to ensure learners can apply their knowledge in actual projects.

2. Seamless Integration of Traditional and Agile with MS Project

Along with the traditional MS Project courses, this course specifically focuses on how Agile methodologies (Scrum, Kanban, etc.) can be implemented within MS Project. As I'm using both CHAMP and MSP courses, I use both to learn traditional with agile. 

3. Step-by-Step Guidance

The instructor breaks down complex Agile and MS Project functionalities into simple, actionable steps, making it easy to follow along—even for beginners.

4. Balanced Focus on Traditional and Agile Methods

These courses are well-suited for hybrid project managers as it provides insights into how with MS Project you can manage both Waterfall and Agile approaches. 

It covers Agile-specific tools such as Sprint planning, task boards, burndown charts, and backlog management, making it suitable for Agile project managers as well.

Brief Profile: Sanjeev Kaushal, PMP 

Current Role: Project Manager with over 10 years of experience in Software Development.



MSP and CHAMP Certification Reviews: 


Monday, December 25, 2023

Course Review: MS Project Live Lessons – Enables to Learn and Master the Application to Help in Delivering Successful Projects

By Mukundan Vikkath, PMP


Why this Course?

My whole 25 years’ experience is in heavy equipment manufacturing and construction. For the last 10 years, I’ve been responsible for managing project teams delivering orders with respect to various mega projects in the Oil & Gas and Energy sectors. 

Though I’m skilled enough to monitor schedules and resource allocation across multiple projects, I didn’t have hands-on experience in preparing schedules using software tools. 

I believed having a certain level of fluency and expertise in MS project software tool would be helpful to analyse complex schedules and manage shared resources without too much dependency on schedulers.  

Features in this Course

In my observations, the key aspects of MS Project Live Lessons course are the followings:

  • Seamless integration of the theoretical concepts from the Project Management Body of Knowledge (PMBOK) guide to software application usage in MS Project.
  • Simple and short videos, which makes it much easier to understand for any level.
  • Clarity on each topic has been reinforced by practical and quiz questions at the end of every lesson. 

Following topics helped me mostly in managing my work effectively:

  • Analyzing Project: Critical path analysis/measurement (CPA/CPM) and schedule compression techniques.
  • Tracking Project: Establishing the baselines for the project and determining the variances.
  • Project Reporting: Generating easy to understand infographics.

In this course, other areas such as Resource Levelling, Resource Pooling, Earned Value Management etc. are extremely beneficial and worth highlighting.

I received a number of key-board shortcuts, tips and tricks provided towards the end of the course, and they are very useful. 

Conclusion

I would recommend this course to any project professional, either beginner or experienced to gain an in-depth understanding of the key project concepts along with basic skills to work on the wonderful MS Project software application. 

Mr Satya Narayan Dash is an inspiring teacher, and the entire course module has been compiled brilliantly to suit all kinds of learners at their own pace. 

Brief Profile: Mukundan Vikkath, PMP: Currently working as Project Management Department Manager in a leading Heavy Equipment Manufacturing Company in the Middle-East.



Tuesday, November 10, 2020

Course Review: MS Project 2016 Live Lessons–An Effective Way to Learn Microsoft Project

By Naveen Kumar, PMP


Introduction

Although I have in the Project Management field for a long time and have been managing various projects, I never had any formal training on MS Project software tool. I wanted to sharpen my skills, after my PMP on this tool and equip myself with all the available features of this tool. 

By gaining practical knowledge of this tool, I can now take full advantage of this tool to manage projects in my current role as a Program Manager. That is the reason why I decided to enrol for this course.


Why this Course?

This course is unique in the way that you can complete this online course in the comfort of your home and at your own pace. The training is quite comprehensive, detailed and with practical exercises for each and every topic. These practical exercises will really help you to actually master your skills in this tool usage.

Key Features

Although all the topics in the course are very informative, I liked reporting and analysing the project a lot. 

Reporting: Reporting is very helpful in how we communicate the project progress to top management. 

Project Analysis: Analysing project covers schedule compression techniques - Fast tracking, Crashing, Critical path analysis which are very helpful day to day project management.

Theory and Practical: This course has a blend of theory and practical. There is a detailed explanation of each and every feature of MS Project tool followed by quiz questions and practical exercises. This allows the user to check his or her existing knowledge post which the user can validate the result with the answers. 

Conclusion

I highly recommend this course to anyone who would like to have a detailed and structured knowledge of the MS Project tool. I found this to be very helpful in my current role as a Program Manager. I would like to specially thank Satya for his dedicated efforts to create this course and spreading his knowledge to various Project managers. He has been really very helpful and approachable throughout the learning process.

Brief Profile:

Naveen Kumar, Senior Program Manager, PMP, 20 years of total experience primarily in Project Management field.



Sunday, November 01, 2020

Course Review: MS Project 2016 Live Lessons–Concise Course with Precise Information and Effective Learning

 By Gowri Shankar S


Why this Course?

After I graduated in Engineering, I started and continued my career in construction industry and maintenance works. After getting experience in this field, I felt I was lagging in planning of work activities in a proper way due to working manually and missing my deadlines in some situations. Hence, I decided to work with a planning software tool. I believed that by learning a tool my work can be more precise and get more efficiency in my work output.

MS Project is a widely used software tool in the construction industry and hence, decided to proceed and learn the MS Project Course. As a planning professional, I believe this course will improve my skills in project planning. 


Features in this Course

This course has been designed in a proper way to give precise information in a shorter duration with an effective way of understanding. This makes the course unique compared to other online tutorials, which I’ve had checked. 

The course covers a number of areas such as planning, schedule management, resource assignment, resource levelling, earned value management (EVM), reporting, among many others

I’ll highlight the following key points of this course as I’ve gone through all the videos and related content. 

Basic Planning to Advance Schedule Control: After you have understood the basic planning, the best way to control your schedule is via EVM and related metrics. In the real world, it is more helpful for me while implementing my project activities to forecast my project schedule. EVM has quite a few forecasting metrics.

Balance between Theory and Practical: You can refer to books on MS Project, but with videos the learning is faster. This course comes with practical examples for each and every function in MS Project, which are essential for any project management professional. 

You can take the templates available, apply your real time experience and improve your understanding and knowledge effectively. 

Overcoming Scheduling Problems: As you proceed with the course, you will know many schedule management techniques. With this you can know how these techniques/functions affection schedule and its management and how one can overcome each problem with this course. 

Cost Management: Resources on their own don’t consume money, but they do consume money when assigned to tasks. With this course, the effect of resource assigning to each task is well understood and how it reflects in the overall schedule with cost and duration so that financial aspects of the project can be better improved with proper knowledge. It’s also pertinent to note that resource levelling will have an impact on cost management.

Earned Value Management (EVM): I’ve already mentioned on EVM before. With this course, you will have a more efficient way of finding project efficiency which is being taught in this tutorial with real time experience.

Reporting: For every project management professional, reporting is one of the most important areas and one has to know it very well. This course explains very well for customizing the reports in different ways which can suite management requirements.

Forward pass, backward pass calculation and Critical Path: Finding out critical tasks is most important in any project and with this course, you will learn more about a critical path in an easy way so that we can plan to expedite the critical tasks works by learning forwards and backward pass calculations.


Conclusion

This course has many real-time practical examples. These will teach you how to apply them in the real-world and on the field. It also comes with many keyboard shortcuts, which gave me knowledge on how to expedite my work with MS Project.

Brief Profile: 

Gowri Shankar S, Project Planning Engineer

I’m a Mechanical Engineer with 10 years of experience in industrial construction and maintenance experience in India, GCC regions. I’ve worked on managing the EPC activities in green field projects and maintenance activities in O&M projects. Overall, I’ve been involved in planning a project from initial bidding stage to project handover stage.



Sunday, September 27, 2020

Out of Sequence (OOS) Logic: Splitting In-Progress Tasks in MS Project


I received the following question from one the participants in the global webinar on dependencies, leads and lags.


*********

Good Morning Satya,

Thanks for the presentation yesterday.  I was looking for a more simplistic manner to present to new superintendents and APMs this subject.  I like the way you laid out the predecessor column and successor column and think that is a great way to simplify it for others.

I filled out the survey information and made the following comment at the end of the survey:

I posted a question that was never asked - not sure why.  The topic was rather elementary and was expecting to be able to resolve issues we have with entering Actual Start dates that contradict the dependency entered - increasing the duration of the task due to an early start yet maintaining the logic which many times no longer applies.  The fix for this is to actually modify the task dependency to accurately reflect how it was started in relationship to the predecessor.

At some point MS Project (I believe it was with the 2007 release but may have been before that) changed the way task dependencies were handled when updating the project schedule.  The process used to hold logic until an Actual Start date was entered and then it reverted to calculating the task finish date by adding the duration to the Actual Start date entered.  Now Project maintains the task dependency even if the Actual Start did not follow the logic created.  Using your examples:

Task A – 4d

Task B – 4d – Task A FS

Task B Actual Start on day 3 in lieu of day 5

Task B duration now becomes 6d long

Our company is a multi-family general contractor in central Florida.  We build large apartment complexes, senior care, hotels, timeshares (which are few and far between these days), etc.  Our schedules deal with larger groups of units and we use a lot of leads and lags to overlap trades.  I was hoping this issue would have been discussed and I guess I was wondering if there is a specific way to create schedules that alleviate or minimize the impact of this condition.  My fix is to adjust the logic to accurately reflect the date we want the subcontractor to complete the scope.  It is hard to get PMs and APMs to actually focus enough when updating to pay attention to this issue.  As a result, I lean heavily on SS+ relationships.  Could you convey your view on this please.

Also, on the topic of SF dependency, I look at that logic differently.  I use it to create a Start and Finish date for a scope of work that needs to complete prior to a scope that has a fixed date (either by dependency or constraint though I rarely use constraints in my schedules).  An example would be normal weight concrete (though we refer to it as “lightweight concrete” in our schedules) at corridors and patios which is usually a long lead item requiring it to be scheduled 6-8weeks prior.  There is a scope of work that needs to be completed prior to this work (engineering inspection, plywood & gypsum sheathing, door pans).  The predecessor work may need to be completed out of sequence with the normal framing scope to accommodate the long lead task.  Comments?

Thanks again for taking the time to present and for your time with these questions.

DAVID HAMMOND | Scheduling Manager

18 Years of Service

WINTER PARK CONSTRUCTION

WWW.WPC.COM

221 Circle Drive |  Maitland, FL 32751

*********


This question was repeated by others who use my MS Project courses and some who had joined the webinar. Hence, I decided to put it as a post. There is another question on SF dependency, which I’ve already explained in the webinar. 

Now, let’s see the first question and how changing dependency changes the duration “visibly” to additional days! 

The Situation

I’ll outline the situation that David has used and I’ve put similarly in my explanations. 

  • Two tasks – Task A and Task B
  • Duration – 4 days for each task
  • Task B follows Task A with a Finish-to-Start (FS) relationship. 
  • It has no lead or lag. It’s a pure FS dependency. 
  • You saved this plan, baselined and started tracking. 

So far, no problem at all. This is shown below. 

 

As shown above, both Task A and Task B, are of 4 days duration. There is a FS dependency between these two tasks. The black bar below the blue bar is for the baseline. The redline is for the status date, which is as on Wednesday (Day 3) end.

But then the problem arises when you start Task B ahead of its “planned start”. In other words, the “actual start” of Task B is ahead of the “planned start’. 

It means the following:

  • Task A planned start is on Monday (Day 1) and finish is on Thursday (Day 4). It’s going according to the plan. By days, I mean only working days. 
  • Task B's planned start is on Friday (Day 5) and it finishes on coming Wednesday (Day 8). This is because of the FS relationship.
  • But then Task B actually started 2 days before, i.e., instead of starting on Friday (Day 5), it started on Wednesday (Day 3). 

This is how it’s represented in MS Project.  


Can you see the problem above?


The Problem

Task B has a splitting line drawn in-front when the actual start is on Tuesday (Day 3). In other words, the total duration looks to be 6 days instead of 4 days. 

This is what David notes in his problem and tells the Task B becomes 6 days of duration. Because Task B has now the following dates in its duration:

  • Day 3 (Wed) + Day 4 (Thu) + Day 5 (Fri): This week, which totals to 3 days.
  • Day 6 (Mon) + Day 7 (Tue) + Day 8 (Wed): Coming week, which totals to another 3 days.

The representation at least shows that Task B is of 6 days of duration, instead of 4 days. Hence, it becomes confusing for many. 

However, MS Project software correctly notes the values in the Tracking table. The default table is Entry table and I’ve switched to Tracking table by going to View – Data – Tables – Tracking table.

As you can see, in the tracking table, Task B’s remaining duration is still 4 days, not 6 days! 

Nevertheless, some management practitioners want to show the dependencies properly with FS dependency and no-split at all and that’s what David’s needs were and also others who sent related questions. 

The Solution

To have the dependency shown without any splitting of tasks, all you have to do is clear the related checkbox in the global setting. You can do so by going to Backstage View – Options – Schedule – Scheduling options for this project – Split in-progress tasks.


By default, it will be enabled. You have to clear this checkbox. 

After you disable split in-progress tasks, you can have the below representation in MS Project.

As you can see, now the dependency is shown properly. For Task B, the schedule has shifted two days to the left (also from the baseline) and the total duration “visibly” is 4 days, not 6 days.  

Cautions

Be careful with such situations as there will be consequences for it. As the MS Project software notes in splitting in-progress tasks the following. 

“Allows rescheduling of remaining duration and work when a task slips or reports progress ahead of schedule.

If this check box is cleared, progress information is recorded on the originally scheduled dates, regardless of when the actuals took place. Likewise, remaining work is not scheduled to maintain the task relationship.”

This statement is significant as noted in MS Project software tool. If you are clearing the checkbox, then the progress information will be on the originally scheduled dates. Also, the remaining work of the tasks will not be scheduled to maintain the task relationship. 

Conclusion

When a task deviates from a pure FS relationship, then various software will have different representations depending upon the logic set. 

When a pure FS relationship is changed–as in our case the actual start of the success task is before the planned start, the FS relationship is no longer pure. The logic is also no longer pure. This kind of logic among tasks is known as out-of-sequence (OOS) logic. 

If you are a scheduling manager or a scheduling professional, you should be clear about various OOS logic that can happen in a schedule and the subsequent impact on the schedule. 


Articles on MS Project:


Friday, September 04, 2020

Seven Practical Nuggets–Dependencies, Leads and Lags with MS Project



Recently, I spoke in a global webinar on a very important area of Dependencies, leads and Lags and showed how it’s addressed by Microsoft Project Software tool. You can check the recorded webinar in the below link.

Understanding Dependencies, Leads and Lags with MS Project

Irrespective management domain you are in – project, program, portfolio, delivery, agile, risk or any other, you have to know about dependencies, though task  or activity dependencies are predominantly used in projects and programs. In this post, I’ll outline some of the practical tips associated with leads, lags and dependencies. 

These nuggets are primarily from MS Project Live Lessons. The theory part of depdencies, leads and lags are from PMP Live Lessons, with the formal definitions coming from the PMBOK Guide.


Practical Nugget1: Changing the Dependencies with Task Information Dialog Box
This is widely used in the software tool of MS Project. In the task information dialog box, you can quickly change the dependencies as well as the lead and lag. This is shown below. 




The task information dialog box pops-up when you double click on a task or activity in MS Project. 

Practical Nugget2: Change the Dependencies On-The-Fly
You can change the dependencies on the fly with MS Project. To do that:
  • Put your cursor over the link, and
  • Double click. 
This will pop-up the dialog box shown below, where you can change the dependencies. 




Practical Nugget3: Change the Leads and Lags On-The-Fly
In the above pop-up dialog box shown, you can also change the leads and lags on the fly. As the dialog box pops-up, you can change the field value of “Lag:” as shown in the above figure.

For lag, you have to enter a positive value and for lead, you have to enter a negative value. 

Practical Nugget4: Create the Dependencies On-The-Fly
You can create dependencies on-the-fly between tasks of MS Project. Do note that it’s NOT about changing the link, but creating a fresh link between tasks.  To do that:
  • Select the “from task” where you want to create the link.
  • Then drag to the “to task”, where you want to have the link. 
  • As you drag, the cursor will show a link icon. 
  • Drop the cursor at the “to task” and a link will be created. 

As shown above, I’m drawing a link from Task 3 (Task B) to Task 5 (Task C). When you finally drop the cursor at Task 5 (Task C), a FS dependency will be created on the fly.




Practical Nugget5: Auto Insert Dependencies 
You can auto insert dependencies between newly added or moved tasks. When you add a new task, among a set of contiguous tasks, the link is not created by default. To have such a link, you have to enable it from Global Options. To do that:
  • Go to Backstage view – Options.
  • From there Schedule tab – Scheduling options for this project.
  • There you have to enable “Autolink inserted or moved tasks”. 


Practical Nugget6: Entering Percentage Values to Have Leads and Lags 
By default, you can enter days for Leads and Lags for an activity or task. You can also enter percentage values to generate leads and lags, which is shown below.




When you enter 50% in the Lag field, it will take 50% value of the predecessor. 

Practical Nugget7: For Start-to-Finish Dependency, Have the Successor Task First, followed by Predecessor! 
Many get this dependency wrong. In a Start-to-Finish dependency, the start of successor task drives the finish of the predecessor task, which many put in varieties of wrong ways. 

As the successor task drives the professor task’s finish or end, you have put the successor task first, followed with the predecessor task. This is counterintuitive, but it works that way! This is shown in the below figure.




For videos and explanations with a number of tips, you can refer:

MS Project Live Lessons (comes with full moneyback gurantee) 

In fact, a dedicated set of tips, unknown to many, are part of this live lesson. In together, you will find hundreds of such tips as you proceed through the lessons.




Articles on MS Project:


Friday, May 29, 2020

15 Excel Like Features in Microsoft Project – Part 3




In the part – 2 of this series, we discussed five excel like features in MS Project. They are:
  • Selection of a set of cells in a mini-table area.
  • Selection till the end of a row or column from a particular cell.
  • Selection of an entire table.
  • Increasing the height of multiple rows or all rows
  • Auto-fitting the content.

In this part, we will check the next five excel like features. These features are quite handy and makes you more productive with MS Project software.

This series: Part - 1

This series: Part - 2


Feature – 11: Undo or Redo the actions

Brief: You want to undo (or redo) as many actions as you want.


How to do: You want to undo a number of actions. By default, you can undo up-to 20 levels, which can be configured from Global options.

This feature is actually applicable for all the applications of the MS Office. However, the settings in MS Project will be different. 

Example: The commands that you used are shown in the “Undo” and “Redo” buttons in the Quick Access Toolbar (QAT).


You can now select these actions (one or more) to undo. Same can be done for redo.


As shown above, I’ve selected to undo 6 actions, depicted as “Undo 6 Actions” above.

The number of “undo levels” can be set in the global options by going to Backstage view -- Options -- Advanced -- Undo levels:. This is shown below.



Feature – 12: Auto-wrapping of text

Brief: You want to auto-wrap the text to fit within the cell, instead of increasing the width of a column.

How to do: To auto-wrap a long text so that it can fit into the cell, you can use the “Wrap-text” command.

Example: In the below “Task Sheet” view, I’ve a long task name “Design and develop the backend module”. When I entered this task, as shown below, the entire task name is not visible. I don’t want to increase the width of the column; rather want to fit the task name within.


To auto-wrap the text, use the “Wrap text” command in “Format” tab of Task Sheet tools.


As shown, the command informs you to “wrap extra-long text into multiple lines so you can see all of it.” As click on this command, the text will be wrapped and will be shown as below.

This command is by default enabled.

You can also enable or disable it, by selecting a cell’s column and right clicking. This is shown below.


Feature – 13: Hiding multiple columns

Brief: You want to hide multiple columns in a table in one go.

How to do: To hide multiple columns in any table in any view, you need to select the columns, right click and select the “Hide Column” command.

Example: In the “Resource Sheet” view below, you want to hide three columns “Material Label”, “Initials”, and “Group”. First, select the three columns. You can select a contiguous set of columns or a discontiguous set of columns by pressing the “Control” key. This we have seen earlier in “Feature – 4” and Feature – 5”. This under Part - 1 of this series.


Next, right click within the selected area and select “Hide Column” command.


This will hide all the columns selected, i.e., “Material Label”, “Initials”, and “Group”.

Note: This feature is not applicable for rows in MS Project.


Feature – 14: Drag and Drop of column and/or rows. 

Brief: You want to rearrange the columns or rows by dragging and dropping.

How to do: To rearrange the columns and/or rows by dragging and dropping them in the table side of any view, you can select the column or rows and move them anywhere you need.

Example: In the “Task Sheet” view below, you want to move the “Total Slack” before the “Free Slack” column. The table used here is “Table: Schedule”.


You can select the “Total Slack” column and ensure the cursor becomes a “four-headed arrow”. Next, keep the mouse pressed and drag your cursor to the left. This will result in a shape shown below.


Next, drop the mouse press and you have “Total Slack” coming after “Free Slack” as shown below.


For rows, you can do the similar thing, which is shown below.


Note: In rows, you can select and drag multiple rows to your needed position in the sheet. For the column case, you drag and drop only one!

Feature – 15: Auto-filter option for the fields in MS Project

Brief: You want to enable auto-filter for the columns in a table in any view.

How to do: To apply auto filter in any table-sheet in any view, use the “Display AutoFilter” command from View tab -- Data group -- Display AutoFilter.

Example: You want to apply the auto filter to the columns in a table. To do so, you can use the “Display AutoFilter” shown below.


After you have applied the filter, the “inverted triangle” pointer will be enabled and displayed. This is shown below. This is next to the column name of every column.


If you have applied a filter, then the “funnel” icon will also be shown. For example, you can see the funnel icon below where I’ve applied the filter type “work” for the resources. This is next to the column name, where filter has been applied.



This series: Part - 1

This series: Part -2




Articles on MS Project: