Free Project Management Tools - Tutorials,Ebooks and Setups

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

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

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

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