Free Project Management Tools - Tutorials,Ebooks and Setups

In this tutorial, let us learn how to calculate and display Ratios in Excel. In Excel you might be aware that we don't have any specific function to calculate and display ratios. In this tutorial, I will show you three ways to calculate and display ratios in excel. 1. By Using Simple Division Method. We use this method when the larger value is exactly divisible with a smaller value. In this example, 20 is divisible with 4 We enter formula in D4 as = B4/C4&":"&"1" Click Enter to see the result as 5:1 2. Using the Round Function when you want to calculate and display ratio in terms of decimals, we use this method. It will show in decimals when higher value is not divisible with the smaller value here in this example 65 divided by 10 gives me 6.5, so the ratio would be 6.5:1 So, Let us enter formula in D5 as = ROUND(B5/C5,1)&":"&1 click enter to see the result as 6.5:1 3. Using the GCD Function In this example, I have numbers as...

One of our subscribers has asked me to explain how to remove redundant relationships in Primavera P6 Schedule. So friends, I will be explaining in detail in this video tutorial. This is a sample simple project with 3 activities A,B,C. Here Activity B's predecessor is A and Activity C's predecessor is B and as well Activity A. Actually A is not exactly required. Because A is followed by B and B is followed by C, so indirectly A is linked with C So here, Activity relationship between A and C is redundant relationship. Now, let us see how we remove this redundant relationship. First, let us export this schedule from P6 to Excel. Follow the steps like this 1. Go to file, click on Export 2. In Export Format, select Spreadsheet-XLSX format and click next. 3. In Export Type dialog box, select Activity Relationships, Click Next 4. In Project to Exports dialog box, select the project by ticking the checkbox , click Next. 5. Select a template in the select template...

In this tutorial let us learn How to Concatenate with a Line Break in Excel In Excel, we normally combine text from different cells using CONCATENATE function but sometimes we may require to add a line break between the text which we are combining. In this tutorial, let us see how we can insert a line break between text using the CHAR function. Consider this example with three columns Name, Sex, Age and let us combine into 4th column using these two tricks 1. Using the Ampersand with Char In cell D5, enter the formula as = A5&Char(10)&B5&Char(10)&C5 and press enter and make sure that you apply the Wrap text feature to see the line breaks in the combined text. 2. Get a Line Break with CONCATENATE and Char functions In Cell D6, enter the formula as =CONCATENATE(A6,CHAR(10),B6,CHAR(10),C6) Press enter and again in this formula, make sure to apply “Wrap Text” to the cell, to see the line breaks in the combined text. In this way, you can use the Char function to...

In this tutorial, let us learn how to change the calendar from 5-day workweek to 7-day work week but keeping the project finish Date unchanged in Primavera P6. After working for so many hours to complete the project schedule, you might be getting to know that you should be using the 7-day calendar instead of the 5-day calendar. Changing Activity calendar will change everything. Normally, if we change the calendar to 7 Day Workweek, all the activity finish dates will change. Now the sample project in this video is having the finish date as 21st Oct’19 And now, if you change the calendar to the 7-day workweek, the Project finish date will be changing to 03rd Jul’19. So, in this tutorial, I will show you How to Change Calendar from 5 Day Workweek to 7 Day Workweek but keeping Project Finish Date unchanged. In the original schedule Step 1: Go to menu bar and under Enterprise tab, choose User Defined Fields Create a field with the title “Finish 5D” and Data Type as Finish Date...