Free Project Management Tools - Tutorials,Ebooks and Setups

Excel Trick#56 : How To Transpose Multiple Columns And Rows Into Single Column || dptutorials 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://ift.tt/2kB14dh

How to update Baseline in Primavera P6 || Primavera Scheduling || dptutorials As per the schedule management philosophy, the schedule has to be baselined once it has been agreed by all the stakeholders. Baseline is something that we usually do not change. But in some cases, we require to change it. In this video tutorial, let us see how we can update baseline in Primavera P6. Let us consider a simple project which is having an assigned baseline. After some weeks, after updating schedule, the project is delayed from the baseline.  After discussing with stakeholder and specific owner, we need to get permission to update our baseline so as to make it identical to the current schedule. In this tutorial, we will see two ways to update baseline. Method 1:  We need to copy paste our current schedule to make as a new baseline B2 and assign the new baseline to our project. Before that, we need to make an important configuration. Go to menu Admin, select Admin Preference

Excel Trick#54 : Compare Text In Microsoft Excel Using Exact Function || Excel tips || dptutorials In this tutorial, let us see how we can compare Text in two cells to check whether they are matching strings. Normally we use the “=” formula to check whether two cells are having the same text. But, if you want to check the case/ strings of the cells, you need to use the EXACT function. Let us consider an example here with 2 columns having some texts, if text cases matches or not. Let us use the EXACT function in column C, enter formula as C5 as “=EXACT(A5,B5)” and press enter and you will get the result as False as in A5 we have the lower case text and B5 has the upper case though the text in both the cells is same. Drag the formula to the bottom of the table to compare the values in other cells as well. In column, let us put the = formula, in cell D5 enter the formula as “=A5=B5” and enter to see the result as true, now drag the formula to the bottom of the table to se

How To Display Only One Critical Path With Multiple Projects Opened In Primavera P6 || dptutorials You know that in Primavera we can work with multiple projects simultaneously at the same time. when we open 2 projects, by default Primavera show 2 critical paths, as each project will have its own critical path. What if? we want to show only 1 critical path for the program consisting of two projects. Let us see this in detail in this tutorial. Click F9 or schedule icon and click on Options In general tab, under “Calculate float based on finish date of”. Check on “Opened projects” rather than each project Click Close and click on schedule button to run Schedule. Now we can see Primavera display only 1 critical path, you can see the bars in red. This critical path is being calculated based on the Finish date of Project 2 to calculate the Total Float. So friends, in this way you can display only one critical path with multiple projects opened in Primavera P6. For Persona

Excel Trick#53 - How to create Radio buttons in MS Excel || Excel Tips || dptutorials Options button or Radio button can be used in Excel to choose a particular option from some multiple options. Let us consider an example that you are creating a survey and you require to create questions with 4 options to choose from. You have to get the answer of the option that has been selected like this. To create option buttons, first you need to go to Developer tab. To add developer tab like this to menu bar, you need to right-click ribbon and select customize the ribbon option and then under Choose commands from drop-down menu, select all commands, click on Developer command and click on add button to add that control into the main tabs to the right side and click ok. Once the developer tab is added to your menu bar, go to Developer tab in the menu bar, under Controls group, click on Insert and from the “ Form Contro l” click on option button and draw a rectangle on the sheet to