Free Project Management Tools - Tutorials,Ebooks and Setups

In this Tutorial, let us see how to adjust the space occupied by the Legends in Microsoft Project, enabling for a better professional print of the schedule. Step - 1: Open the Microsoft Project schedule and go to File>>Print Preview>> Step - 2: At the bottom of the print preview, you can view the Legend portion. Sometimes the legend space occupies the major portion of the page, making it unprofessional to print the schedule reports. Step - 3: So, in order to adjust this legend space,you need to go back to the schedule's Gantt chart view and place the cursor at the gantt chart and right click to select the Bar styles option. Step - 4: Here, you can view all the Legend Labels. Now start entering the symbol asterisk * at the beginning of all the labels which you intend not to reflect in the print view as shown here Now here is the Schedule layout with minimum & only required legends Step -5: Now, in addition to the ad...

Here is the detail procedure for installing the primavera software. Watch the video and install the tool for practicing right away.   Back to Primavera>>

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>>

If your are using the Excel 2013, then you can have access to the mentioned Inquire Feature that allows you to compare two workbooks to identify the differences and find the unique values . This is very easy to use and very powerful tool which can save lot of time. First let's see how to activate this tool " Inquire " in Excel 2013. 1. Open the Excel sheet and Go to File >> Options 2.  In Options, Select the " Add-Ins ", 3. In the Manage Drop down menu, select the " COM Add-Ins " and click on Go .. Button 4.  And then check the Tick mark on " Inquire " Add-In and Click OK button. 5.Then, you can see a new tab "Inquire" placed on your excel ribbon at the top right side as shown. 6. Now, the actual comparison of two workbooks comes into picture. Let's begin the process by opening the two workbooks. Then go to Inquire tab of the ribbon and click the comparison tool. 7.  Select the two...

Chapter 1: "Introduction to Microsoft Excel 2013" Chapter 2: "Getting Started" Chapter 3: "Entering Data into cells and other functions" Chapter 5: "Formatting: Font,Alignment,Number,Styles" Back to MS Excel>>

Sometimes, we may face it much difficult in fitting the email content into printing papers. Here i will be explaining you a trick on how to shrink and fit the content into a page when printing in Outlook. For shrinking the content and fitting into the printing paper, do the following in the Microsoft Outlook. Open the mail that you intent to print by just double clicking. Click on the Actions (or the other actions in 2007) >> View in Browser Then the mail opens in the browser, after which go to File>>Print Preview and Select the Shrink to Fit option and have a trouble free printing. In case the email message is in plain text or rich text then you need to convert it into html format. This can be done by going to Actions>>edit message>format text> HTML.

Here is a case when we are unable to change the original duration field once the schedule has been scheduled. This is because the activity has already been started. Let's get into detail explanation: The Start and Finish Dates which we see at the time of preparing a schedule will be locked as planned start and Planned finish respectively.So, any change to the Original Duration can be seen with a change in the Planned Finish/Finish. When a Task has not started: Planned Dates and Start,Finish Dates are linked to each other Lets see with an Example: Where Planned dates are same as the Start/Finish Dates When a Task is in Progress: The Planned Start Date Remains Unchanged if the Actual Start Date is different from the Original Planned Date. Here in the example, lets status the schedule with actual date of Activity 1 as " 26-Dec-14 " and schedule(F9) it. you will observe the following changes in the schedule Planned Start date remains unchanged.  Original Du...