Free Project Management Tools - Tutorials,Ebooks and Setups

In this tutorial, let us learn How to use the Expected Finish Date feature in Primavera P6 or How To Apply Deadlines To Your Project This is the sample schedule. If you go to the Status tab in the activity details, you can see the expected finish field below the Finish date. So what is this expected finish date and how do we use it? Now, go to the scheduling option and find that the "Use Expected Finish Dates" option is switched on to enable the Expected finish date act as a constraint. You should be using the expected finish constraint when you do not know the duration but sure about the finish date. so, when this constraint is applied, every time you schedule the project, the P6 will calculate the new remaining duration based on the expected finish date constraint. For example, in this sample schedule. For Activity C, let us set the Expected finish date as 30th Apr'19. Now, while updating the project, you will update the finish date of Activity A by 6 days d...

Hello Friends, Welcome to dptutorials. In this tutorial, I will show you How To Transpose Or Convert A Single Column To Multiple Columns In Excel There can be multiple ways to perform this trick, I will show you some of these in this tutorial now. So, let us go to the 1st method: 1. Using Indirect Function First consider this as an example, where I have got entries in a single column like this and let us try to convert these into 3 columns. Enter the formula in Cell C1 as =INDIRECT(ADDRESS((ROW($A1)-1)*3+COLUMN(A1),1)) Copy and paste it 2 cells to the right, then down until you start to get zeros (delete these zeroes later). In this formula, A1 points to the first item in the column you want to re-arrange. To change the number of columns, modify 3 in the formula into something else. Got it right. This is one way to do this trick. 2. Now let us see the 2nd way of doing this: Using OFFSET Function Enter the formula in Cell C1 as =OFFSET($A$1,COLUMNS($A1:A1)-1+(ROWS($...

In this tutorial, let us learn how to Color WBS levels after Primavera P6 Export To Excel. After exporting activity table from Primavera P6 to Excel, it’s very hard to tell which activity belong to which WBS. So in this tutorial, let us see how to color WBS levels automatically so we can have a report like in Primavera P6. This is my sample schedule in primavera, 1. I press Ctrl+A to select entire data and copy the data and then go to Excel sheet and paste it. 2. Add a column left to Activity Id i.e column A and name it as WBS level to show the WBS level for each activity. 3. enter the formula in Cell A2 as = =((FIND(TRIM(B2),B2))-1)/2 4. Hit enter and then apply the same formula to all the cells in column A to see WBS level for each activity. 5. See now, you can view the WBS level for each activity this way easily in Excel after exporting the Primavera P6 Schedule. And Now let us color the WBS levels. 1. Select the entire Data range. 2. Go to Conditional F...

We know that by using the functions Today() and Now() in Excel, we get the current Date and Time but these values will not be static and keep on updating on saving your workbook. But if we need to get a static date into a cell after data is entered into other cells. Here is the solution, watch this video to know this trick. Let’s suppose when data is entered in column A, we want to have the corresponding current dates into column B in the same row. Follow these steps now to perform Step1: Right click on the sheet tab, select view code option Step2: Copy the code ( I have shared this code in the description as well) Code @ http://bit.ly/2Is1EbD And paste into this VBA window. Step3: Exit this VBA window and go back to the Excel workbook Step4: Now, let us test it by adding any data to any cell in the range A1:A1000. You will see the current date appearing in the corresponding cell in column B. It is awesome right!!! If you want to have both Date and time in ...

In this tutorial, let us learn how to identify WBS level for activity after Primavera P6 Export To Excel. After exporting activity table from Primavera P6 to Excel, it’s very hard to tell which activity belongs to which WBS. So in this tutorial, let us see this with an example. This is my sample schedule in primavera, 1. I press Ctrl+A to select entire data and copy the data and then go to Excel sheet and paste it. 2. Add a column left to Activity Id i.e column A and name it as WBS level to show the WBS level for each activity. 3. enter the formula in Cell A2 as =((FIND(TRIM(B2),B2))-1)/2 4. Hit enter and then apply the same formula to all the cells in column A to see WBS level for each activity. 5. See now, you can view the WBS level for each activity this way easily in Excel after exporting the Primavera P6 Schedule. So, friends, this is all about this trick If you have enjoyed this tutorial, please give me a like, share and comment. For further more interest...

Hello Friends, Welcome to dptutorials If you want a cell to return the name of a workbook, or the workbook's filename and path. Then this is the tutorial to watch out. In this tutorial, let us use a small macro to retrieve the workbook’s name, file path, and sheet name. We can do the same trick using the formulae. Right click on the sheet tab and click on view code, or press Alt+F11 to go to VBA window. Select insert, module Copy this code and paste into this module, Function WorkbookName() As String WorkbookName = ThisWorkbook.Name End Function Function Filepath() As String Filepath = ThisWorkbook.FullName End Function Function SheetName(rAnyCell) Application.Volatile SheetName = rAnyCell.Parent.Name End Function Close this VBA window and go back to the Excel window. Go to Formulas tab, click on insert function, under the category, and select the user-defined, you will find three functions Filepath, sheet name, and workbook name. If you click on file path ...

In this tutorial, let us learn how to Merge two separate schedules into One Master schedule in Primavera P6. In this example, I am considering two separate projects which are these two, One is master schedule and one is the subproject. First, let us open the subproject and export this schedule as a .XER file onto Desktop. and now let us start the exact process of merging two separate schedules. 1. As a first step, We need to open the project schedule into which we want to insert the other project as a sub-project. So, let us open the Master schedule here. 2. Go to Import, select XER format, Click Next 3. Select Project and click Next 4. Now select the Subproject .xer file from the Desktop and click Next 5. Under Import action, select the option as “Update Existing Project” and under import to section, select the Master schedule which is already open. Click Next and Finally Click on Finish. 6. Please note and make sure that your WBS and activity IDs should not confl...

Hello Friends, Welcome to dptutorials. If you want to save your excel workbook using the text in a specific cell as a filename, you need to watch this tutorial. Click on the cell B2, enter some text and save it, you can see the file name as same as cell B2. Let us learn this trick now, how to Name a Workbook with the Text in a Cell Step1: Right click on sheet1 tab and select the view code option or else press Alt+F11 as a shortcut to go to VBA window. Step2: Insert module and copy this code Sub SaveAsCell( ) Dim strName As String On Error GoTo InvalidName strName = Sheet1.Range("B2") ActiveWorkbook.SaveAs strName Exit Sub InvalidName: MsgBox "The text: " & strName & _ " is not a valid file name.", vbCritical, "dptutorials.com" End Sub Step3: And paste it here in the VBA window Step4: Close this VBA window and go back to the Excel sheet. Step5: From the menu bar, go to view tab and under macros, click on view macro...

In this tutorial, let us learn how to show only some WBS in the Gantt Chart in Primavera P6 Generally, Gantt chart will show bars for each activity and If your Schedule is too big, sometimes you may feel it is distracting a lot. and you may sometimes like to present a report to show and focus only some of the WBS, rather than distracting with all bars. So let us see how we can do this in Primavera P6. This is my sample schedule with around approximate 1500 activities. and you can see the cluttering in the Gantt chart with all relationships So, to do the trick, right click on the Gantt chart portion, click on Bars,  you select the bar which is being shown in the Gantt chart. Go to bar settings, by default the "show bar when the collapsed" option is checked. Now you need to uncheck them all. Then you can see clean Gantt charts like this whenever you collapse and expand any particular WBS element in Primavera P6. So, friends, this is all about this trick for no...

Hello Friends, Welcome to dptutorials In some of our Excel reports, we may want to name the sheets automatically according to the names on each sheet without manually renaming them. So, in this tutorial, let us learn how we can automatically change Worksheet names based on Cell values using a small macro. In this example, I am considering a sample report of 6 states in 6 sheets and let us rename these sheets with that of States names from cell B2 of each sheet. Now, let us follow the step-by-step procedure Step-1: Right click on any sheet and select view code or press Alt+F11 as a shortcut Step2: Click on Insert from the menu bar, click on Module to insert a module Copy the code Sub RenameSheet() Dim rs As Worksheet For Each rs In Sheets rs.Name = rs.Range("B2") Next rs End Sub And paste in this new module. Step3: Close this VBA window and go back to your Excel workbook Step4: Go to the view tab and under macros, click on view macros Step5: After se...

In this tutorial, let us understand how to export primavera schedule to show only lowest summary data Generally, to show summaries of the Primavera Schedule, we right-click on the Activity table and click on Group & Sort and then tick the checkbox "Show Summaries Only" and click Ok The problem with this is you will get to view summaries at all levels. But we want to view only the lowest level summaries only and with the high-level summaries as Zero. Here is the solution, watch this completely. Right-click and select Group & sort and deselect the option "Indent" and Click OK. Now you can view only the summary data at the lowest level with the higher level summaries showing zeroes in the duration column. so, friends, this is the trick to export primavera schedule to show only lowest summary data. For Personalized detail learning, write to dptutorials15@gmail.com If you found this video valuable, give it a like. If you know someone who needs to ...

In this tutorial, let us learn how to find and remove blank cell, rows and columns in Excel. Let us consider an example with data range as shown here in the video. This Excel sheet is having some blank cells, rows and columns. Now, let us see how we can remove all these blank cells. Firstly, Select the data range Go to Find & Select feature in the menu bar and choose Go to Special function option and select Blanks. You can also use the keyboard shortcut Ctrl+G to arrive at this dialog box of Go To. Select blanks and Click Ok. Now all the blank cells will be selected. Now in the cells group, under delete function, click on Delete Cells Select any one of the options as per your convenience. I am selecting Shift cells up and click on OK. Again to remove the blank columns, select the data range, click Ctrl+G, click on special, select blanks, Click Ok. Under delete, select delete sheet columns. You can fund that all the blank cells have been removed completely now. So, ...

In this video, let us learn about Resources, Resource Codes, Roles in Primavera P6. This chapter describes how to use the Resources, Resource codes, and Roles in the Primavera P6. For Personalized detail learning, write to dptutorials15@gmail.com If you found this video valuable, give it a like. If you know someone who needs to see it, share it. Leave a comment below with your thoughts. Add it to a playlist if you want to watch it later. *************************************************************** Read my full article on this:  http://ift.tt/2kB14dh *************************************************************** Subscribe for more Awesome Tutorials:  goo.gl/4T8ePc *************************************************************** Support The Channel via shopping:  http://ift.tt/2jH38PR ************************************************************** You Can Connect With Me at G+ :  http://ift.tt/2kAOpa6 Twitter :  https://twitter...

In this tutorial , let us learn How to Sum Values Between Two Dates using SUMIFS formula. Let us consider an example with some sales data by date wise and let us calculate some of values between 01st Jan 2018 to 31st Jan 2018. I enter formula in Cell D4 as shown in the video When you hit enter, this function will return the result as 58629 in the cell, which is the sum of the sales between 01-Jan-2018 to 31-Jan-2018. To verify this calculation, just filter the January dates in column A and select the Column B and check out the status bar for the sum of these values as 58629 which is the exact figure we got from the formula. So, friends in this way you can calculate sum of values falling between two dates in a range. For Personalized detail learning, write to dptutorials15@gmail.com If you found this video valuable, give it a like. If you know someone who needs to see it, share it. Leave a comment below with your thoughts. Add it to a playlist if you want ...

In this tutorial, let us see how we can open a .plf format file into Primavera P6. A .plf file is a Primavera Layout File which stores information about screen layouts. Kindly make a note that there are 5 types of layouts in primavera, viz., Activities layout, Projects, WBS, Resources, Tracking Layouts. If you want to import any .plf file, first you need to be on the same screen on primavera matching with that of .plf layout. So, if you are importing an activities .plf layout, you need to be on the activities screen in your primavera. Now, let us see how to open a .plf file format. First be there on the activities screen on Primavera 1.Go to View tab, click on Layout submenu and click on Open layout. 2. Click on the Import button, browse the .plf file and click on open. 3. Give a name to your layout. I am keeping it as it is. 4. And choose to whom it will be available, whether to a current user/project or make it as global. 5. Click on Save button to save t...

You might be knowing how to apply conditional formatting in an Excel spreadsheet, But in this tutorial, we will be discussing how to apply conditional formatting in Excel charts. Here is the sample sales data by week wise. Let us consider this as an example now. If I select the entire data range along with the headers and draw a chart, all the bars in the histogram will look in the same color as this. Now, let us apply conditional formatting for this chart. In order to do this, first we need to categorize the Sales date in column B into 5 categories as 0-100, 100-200, 200-300,300-400,400-500 from columns B to G. Let's put data in rows 4 and 5 like this to use these cells as references in formulas. So, we need to enter a formula in Cell C7 as shown here when you press enter, this will show the result if it falls between the limits of rows 4 and 5 (i.e., 0 and 100) or else it will show blank. Now copy this formula and fill into the entire range C7:G14. Make a cop...

How To Use Level Of Effort Activity In Primavera P6 To Summarize Schedules || LOE Definition Level of Effort activities are an essential component in building complete schedules, for displaying and representing supportive, non-discrete work. Examples of Level of Effort activities include:  Customer Meetings, Project Management, Site Management tasks, Maintenance of equipment Clerical work, In this tutorial, let us consider a small sample project with 7 activities from Start to Finish and with 5 more activities In this example, let us add an activity called as Project Management and put the type of activity as Level of Effort in the activity details. And then link it with the predecessor as Start activity with Start-Start relationship and successor as Finish activity with the Finish-Finish relationship. When you schedule by pressing F9, you will notice that the LOE activity's duration and dates change accordingly with the relationships given. Observe one more point...

In this tutorial, Let us learn How To Count Cells By Colors With Conditional Formatting In Excel For Personalized detail learning, write to dptutorials15@gmail.com If you found this video valuable, give it a like. If you know someone who needs to see it, share it. Leave a comment below with your thoughts. Add it to a playlist if you want to watch it later. *************************************************************** Read my full article on this:  http://ift.tt/2kB14dh *************************************************************** Subscribe for more Awesome Tutorials:  goo.gl/4T8ePc *************************************************************** Support The Channel via shopping:  http://ift.tt/2jH38PR ************************************************************** You Can Connect With Me at G+ :  http://ift.tt/2kAOpa6 Twitter :  https://twitter.com/dptutorials15 Facebook :  http://ift.tt/2kfRnDi Blogspot :  http://i...