Free Project Management Tools - Tutorials,Ebooks and Setups

How To Use The Progress Line In Primavera P6 || Primavera Tips || dptutorials You know that the Primavera has got the feature called Progress Line, which can be used to compare Actual Progress with the Baseline on Gantt chart. Today, in this tutorial, let us learn how to do this. 1. Let us consider a simple sample project like this and then maintain the baseline as the same current project and let us assign it as a Project Baseline. 2. Then let us update the project. I will be updating the schedule randomly say like. Activity A finish 2 days late so Activity B start late, which is behind the schedule. Activity C finish 2 days early so Activity D start early, which is ahead of schedule. Schedule the project and let us compare the current progress with baseline. 3. Right click on Gantt chart and select Bar chart option. 4. Go to Progress Line tab, Select the option called “By connecting progress points based on activity’s” and from the drop-down menu select the “Percent C...

Excel Trick#52 - How To Compare Format Of Two Cells In Microsoft Excel || Excel Tips || dptutorials In this tutorial, let us learn how to compare the format of two cells in Excel 1st Example: In cell A5 and B5 let us put the date as 12/9/2018 i.e 12th Sep and now let us format A5 to display as 12/9/2018 and format B5 to display in a different format like 09/12/2018 that means we are keeping the format of cell A5 as dd-mm-yyyy and format of B5 as mm-dd-yy and let us check the format in both the cells A5 and B5 same or not, using the formula as =CELL(“format”,A5)=CELL(“format”,B5) which gives the result as FALSE which is correct 2nd Example: Now let us test with the other formats, we have 27.11 in A6 and B6 but lets us show two decimals in A6 and only one decimal in B6, so the only difference being the decimal places. Hence, both the cells contain the same value with different format. Here, let's try with the same formula by dragging the cell C5 to C6, to see the re...

In Primavera, when we click on filter called critical path, it only show 1 critical path by default. But, in some complex projects, we might need to show some more critical paths like “near critical” path. In this video, I will show you how to do display multiple critical paths in primavera P6. Let us consider a simple project like this: Press F9 to schedule In the Schedule dialog box, Click on Options Click on “Advanced” tab, tick the Checkbox “Calculate multiple float paths”. Under “Display multiple float paths ending with activity”, select the last activity i.e J Under Specify the number of paths to calculate: type the number, for example: 2 as we wanted to show 2 paths. Click Close and Now, click on Schedule. Right click on activity table, click on Group & Sort Under Group By, choose “Float path” and click OK Now Primavera will display 2 critical paths like this. For Personalized detail learning, write to dptutorials15@gmail.com If you found this vid...

A Gantt chart is used to represent the project schedule in a graphical view. Do you know that the Gantt chart has been named after Henry Gantt. Let us learn how we can prepare a gantt chart in excel. However, there are many scheduling tools to prepare a project schedule In this tutorial, we shall be using the stacked chart to generate the gantt chart and let us see how to do this now. 1. I am considering a sample schedule with 5 activities like this as shown in B2:D7 having activities, target dates and duration 2. Select the entire data range B2:D7 3. Go to Insert tab from the menu bar, in the charts section, click on horizontal 2D stacked bar 4. Right click on the chart area and click select data 5. “Select Data Source” dialog box will then appear, Click on “Edit” button under the category of Horizontal (Category) Axis Labels and select axis label range as B3:B7, click ok. 6. Under Legend Entries (Series), Click on add to add a new series 7. Under series name: typ...