Free Project Management Tools - Tutorials,Ebooks and Setups

Here is the detail introduction to Primavera Software , a Project Management tool. Detailed in-depth chapter wise real-time tutorials shall be posted subsequently. Part-1  Part-2 Back to Primavera>>

We all know how to export the Schedules prepared in the Primavera tool into a spreadsheet format, if not view the tutorial just below. After Exporting, sometimes it needs to be modified further so as to use it for other reporting purposes, updating of the data in excel. But unfortunately the P6 Exports the data as TEXT format and not into the exact existing format. and Simple "Format Cell" Function in Excel wont solve our problem and this needs a small exercise to make the data to handle simpler.  A Sample export of the schedule in P6 into an Excel format has been shown below and the tip will be explained further to that. If you look at the "Duration" in the Column E of the spreadsheet, you will notice apostrophe (') in front of the duration fields. Similarly you will find it in the date fields even All the data fields will have this apostrophe (') symbol as the data has been exported in the text format. Now, let us see the tip/trick to for

These days, S-Curves are being made compulsory in the progress reports. S-Curve is nothing but display of labor units, Cumulative costs or other quantities against time. If it is a must to generate the S-Curve without having proper information on Costing and resources, there is a trick to generate the Curve with the dummy resource weights Let's see how we can generate the S-Curve Step-1 : Develop a schedule with proper WBS. Step-2 :  Go to Resources tab and Right click, select Add to create a resource of Resource Type as " Labor ". Step-3 : Go to Activities Tab and click on Columns icon to add columns " Resources" , "Budgeted Labor units" , and "Actual Labor units" . Step-4: Now assign the labor resources to all the activities by selecting all the activities (using shift button) at a time and by holding Shift button left click on the resources cell of the last activity and select the created resource so as to assign res

Google has finally launched the Undo Send option in GMAIL. This was the feature i liked most in Outlook, where we can recall the mail or resend the mail, without knowing the recipients that we have done a mistake in the mail. If you make a typo error or sent a mail with some mistakes and would like to revert that/undo sending mail,  now you can do that by enabling the option "UNDO SEND" in Gmail. Thus, this will enable to get back the mail that you have sent, but remember this can be done only within 30 secs. To Enable this option in your GMAIL: 1. Go to settings in GMAIL. 2. Scroll down to " Undo send " option and check the tick mark on Enable 3. Set the cancellation period from 5 secs to 30 secs (the time within which you can undo) 4. Click Save changes for this Enable option to get into effect. Video on How to do this:

you can calculate a person's Age based on their birthday and Todays date The Calculation uses the function DATEDIF( ) Video: Back to MS Excel>>