Free Project Management Tools - Tutorials,Ebooks and Setups

We do face this problem when we want to color only the visible cells, we generally select all the cells and color them.Later when we remove the filters, we observe that the hidden cells have also been colored. But instead we can color only the Visible cells using this simple procedure. Lets see an example here: I have an excel sheet with the data as shown and i would like to now hide the rows 6,7,8 and if i select these cells by normal selection and color it in green color, all the hidden cells will also be colored. But instead i will select only the visible cells by 1. Selecting all the cells normally and then 2. Pressing " Alt+;"  on my keyboard which enables to select only the visible cells. 3.and then color the cells by green color. I get the desired result now as shown when i unhide the cells Back to MS Excel>>

We do face this problem of Finish date of the activity not getting changed, when we change the duration of the activity. Now, let us see the example and learn how to fix this issue. If you see the Activity A1030 in the below primavera schedule, the duration of the activity is 5 days and finish date as  24-Mar-14.  and now let's see the change in the Finish date by changing the duration from 5 days to 15 days and observe that there is no change in the Finish Date. and  this error is being caused as the primavera is not calculating the remaining duration of this activity when the original duration is being changed. In fact, we observe that the change we are making by increasing  original duration of the activity is not linking with the remaining duration. This is the situation where everyone gets panic and finally land upon the solution of adjusting the remaining duration as the tool doesn't automatically calculate the new remaining duration when the original du

Let us see how we can set different currency formats in excel. In general , in excel we have the English group formatting like 123,456,789.00. This can be converted into the Indian group formatting like 12,34,56,789.00 and vice versa. lets see conversion of English to Indian grouping first Step 1:  The number that i entered in excel sheet is " 3500000000" as shown below And when i click on the Comma function from the menu bar, the number will be grouped into the English format. Step 2: Now, Go to Control panel>> Region and Language Step 3: In the Format tab, under the drop down menu u will be seeing the default format, here it is English (United States). Step 4: Change this to   " English (India)" and click on "Apply" and then "OK"  Step 5: Now you can see the Number "3,500,000,000.00" changing to "3,50,00,00,000.00" Similarly, if we need to convert this Indian

In the earlier posts, we have already seen  how to export the primavera schedule into the excel format and then do the  modifications for further usage. Now, let us see how the schedule in excel looks similar to that of the schedule in the primavera. Here are the steps for the same: Step-1: Open the project in the primavera p6. Step-2: Now, the sample schedule in primavera looks like this as shown below Step-3: Now Press Ctrl+A to select all the rows and columns in the primavera schedule  and C opy all the selected data Step-4: Now go to an excel sheet and right click and select "Paste" option to paste the data that has been copied from the primavera screen Step-5: Insert a user defined column "Level" for filtering purpose and apply filters to all the data. and then filter the Column "Activity name" by checking the "Blanks" -This is nothing but we are filtering all the WBS rows and excluding the activities.

If an Excel spreadsheet is password protected, we are unable to edit the data in the sheet. If you do not remember the password or if you don't know the password to unprotect the excel sheet then just follow this process for unlocking the excel sheet. Step 1:  Open the Excel sheet Step 2: Press Alt + F11 or click on view code on the developers tool Then you would be seeing a sheet like this Step 3: In the above white space, just enter the code as shown below(Just Copy paste) Sub PasswordBreaker()     'Breaks worksheet password protection.     Dim i As Integer, j As Integer, k As Integer     Dim l As Integer, m As Integer, n As Integer     Dim i1 As Integer, i2 As Integer, i3 As Integer     Dim i4 As Integer, i5 As Integer, i6 As Integer     On Error Resume Next     For i = 65 To 66: For j = 65 To 66: For k = 65 To 66     For l = 65 To 66: For m = 65 To 66: For i1 = 65 To 66     For i2 = 65 To 66: For i3 = 65 To 66: For i4 = 65 To 66

Let us learn how to Autofill the Data in the Microsoft Excel 2013. In 2013 it would be very easy to autofill by just entering the data in one cell, placing the cursor at the right corner of the cell and then just dragging the cursor down. Microsoft Excel 2013 detects the format of the data that you have entered and it will autofill in the same format of the cell that you have entered. This can even be done using a shortcut. If you would like to autofill the data in a single columns without dragging the cells, just place your cursor in the cell and by pressing the shift  key select all the cells in the columns upto which you want to autofill the data and then press Ctrl+D. Similarly for doing the same auto fill by Rows, press Ctrl+R . Video Shown here for better understanding. Back to MS Excel>>

Here is a funny geeky trick you can learn in the Microsoft project where the gantt chart can be made walking as shown in the video below. Step 1: Open the Microsoft Project and add two tasks TASK-1 and TASK-2 Step 2: Now add the Duration as " 2 Days ". This trick works with only of 2 duration. So Enter the Duration for the two tasks as 2 days. Step 3: Enter the Start dates for the two task and the finish dates arrive by default based on the duration. you might be aware of this. Step 4: Right click on the Finish Date of Task-1 and Select " Copy cell" Step 5: And now Right Click on the Start Date of Task-2 and select the " Paste special" and choose the Paste Link and click " OK " Step 6:  Similarly Copy the Finish Date of the Task-2 and Paste it as the Paste link option in the Start Date of Task-1 And now observe the funny walking of the Gantt chart instantaneously, This can only be

In the earlier tutorial we have learnt How to create a new calendar for a project in Microsoft Project 2010. The problem we generally face is we have to make this all the time when we create a new project as by default we have only three calendars in the MS project "24 Hrs", "Night Shift" and "Standard". So, if you would like to create a new Calendar and add the same into your default list, here is the simple tip you can follow. Let's learn how to make a newly created calendar as a Global calendar by making it default. Step 1: Go to " Project " >> " Change Working Time" >> Step 2: And Click on " Create a New Calendar " Step 3: Name the Desired calendar. Here i am naming it as "6 Days" Step 4: In the Bottom of the window, go to " Work Weeks ">> Click on " Details" and Click "OK" Step 5: In the Details for Default Wizard, selec