How to find the percentage (%) burn in client hours?

Total Hours = 850, Burns Hours = 180

Total % left = Total Hours - Burns Hours / (1 % Total Hours) = 850 - 180 / 8.5    =  78.82 %

% Burn = 100 - Total % left = 100 - 78.82 = 21.17

How to remove CR LF at end of the each line in Notepad++

 View -> Show Symbol -> uncheck Show End of Line.

                                        (OR) 

Check Show white space and TAB and show wrap symbol

Freeze Panes in Excel

Freeze Panes    :

Keep rows and columns visible while the rest of worksheet scrolls (based on current selection).

    

It will keep the left side columns and rows data while moving right  and It will keep the top side columns and rows data while scrolling down also

Freeze Top  Row    : 

Keep the row visible while scrolling through the rest of the worksheet

    

It will keep the headers while scrolling down also

Freeze First Column    :

Keep the first column visible while scrolling through the rest of the worksheet

    

It will keep the first column while moving right also

Copy all the columns from OIM Design console to Excel sheet and sort the columns

Steps : 

e.g : We want copy all the Reconciliation Field Mappings(Resource Object / Lookup) from OIM Design Console.

1. Login to Design console and navigate to Reconciliation Field Mappings (Process Definition)

2. Select the object name (*AD User*) then search

3. Copy all the field names and save in notepad ++ (.txt)

4. Open the Excel sheet first then click on file then open again (Ctrl + O)

5. Select the .txt file  then click on open ---> Yes

6. Choose the file type as Delimited and check

7. Delimiters - check Tab and Comma

8. Click on next

9. Click on finish.

10. Now the fields are separated in Excel sheet, select your required columns

Finding duplicate values in column

Steps : 

1. Below is the sample data and select all the values / data

    

2. Select Home ---> Conditional Formatting

        

        

3. Click on Highlight cell Rules    --->    Duplicate values

    (Below prompt will pop up)

    

4. Select the color of duplicate values (values with) then click on Ok

5. Duplicate values will show like below

    

    

Attaching any file / document to the Word

Steps : 

1. Open the word document

2.  click on insert 

    

3. click on Object 

    

4. Below promt will pop up

    

5. Browse the file / document from Browse option

6. Check Display as icon and click on Ok