ICICI

Tips and Tricks


kartik_somu (B.Com, ACA, CISA, CIMA)     07 February 2008

kartik_somu
B.Com ACA CISA CIMA 
 15 likes  1659 points

| My Other Post

 

MS-Office includes a lot of features and options which can be used for increasing efficiency or for completing the desired task within the least possible time. This article summarises a few quick tips for increasing efficiency.

1. Use the Clipboard Collector to collect and paste multiple items at a time. To invoke the Clipboard (in any MS-OFFICE) program, press CTRL+C and keep it pressed till the clipboard screen appears. Anything which is copied then goes into the Clipboard collector. For example, if there is a very long document, and you are looking at just keeping relevant extracts, you can keep on copying onto the Clipboard and then paste all such copied content into a new file at one go. Try it, it is very handy.

2. The default number of sheets in MS-EXCEL workbook is 3. Many times, the information is stored in just one sheet. When a workbook with three sheets is presented, one has to browse through all the three sheets to ensure that there is no information in the other sheets. The practice which I prefer is to set the default number of sheets in a new workbook to 1 and not 3 (Change it from Tools Õ Options Õ General Õ Sheets in new workbook (1) from MS-EXCEL). Then, if I want to have a second sheet, I can insert a sheet. The advantage of this approach if universally followed is that if there are 2 sheets in a file, you are sure that there is information in each of them.

3. If I want to view two different sheets of a workbook at the same time, I can use the Window Õ New Window to create two views of the same workbook. Both the Window views can then be adjusted to display simultaneously on the screen and can contain different worksheets.

4. In case a single mail has to be sent to multiple users, the general tendency is to type the list of e-mails in the To or CC or BCC fields. The To & CC fields would expose the recipient list to all the recipients. All the three approaches also have limitations in terms of number of recipients. In such a scenario, if the mail size is not huge (Say you are just announcing, greeting or reminding), a better approach is to create the matter in MS-WORD and then mail-merge it to Electronic Mail.

5. Use the Shift+F5 combination to quickly navigate to the previous editing area in MS-WORD. You can use this combination multiple number of times. Just try it once.

6. Use your Favorites Folder in the Start Menu to include all your regularly used folders on the hard disk and also all the frequently visited web-sites. You will find that once this exercise is done, you can navigate through your entire computer with a single mouse-click.

7. One can very quickly draw a table intuitively by using the keyboard. Use the + key on a blank line to start the process, continue the + with - keys till you reach the end of a particular column. Use + to indicate a column break. Continue this process till you complete the desired table. To indicate the end of the table, again use +. Press Enter and the table is ready for you. For example, typing

+—+————+———+—————+

followed by Enter on a blank line would create a table like this :

       

avater

Darshu (CA)     05 March 2008

Darshu
CA 
 54 likes  1580 points

View Profile | My Other Post

Thanks a lot...

avater

pushpendra (Director- FinMAT Consultants)     05 March 2008

pushpendra
Director- FinMAT Consultants 
 11 likes  1698 points

View Profile | My Other Post

Really very informative

avater

Radhika (Company Secretary)     06 March 2008

Radhika
Company Secretary 
 27 likes  1233 points

View Profile | My Other Post

thatz amazing...thankx a lott

avater

CA.Aman Dugar (Chartered Accountant)     17 March 2008

CA.Aman Dugar
Chartered Accountant 
 181 points

View Profile | My Other Post

The one which helps to create a table was a good one!!!

saurabh (CA)     21 April 2008

saurabh
CA 
 9 likes  552 points

View Profile | My Other Post

that's nice.. thnkss dude

avater

nishant monani (ARTICLE ASSITANT)     29 April 2008

nishant monani
ARTICLE ASSITANT 
 68 points

View Profile | My Other Post

HEY MAN THANKS A LOT! TIPS ARE REALLY VERY HANDY AND INFIOMATIVE.

U CAN SEND SOME MORE SUCH TIPS OR SOMETHING USEFUL AT MY MAIL ID "NISHANTMONANI @ YAHOO.COM"

THANKS 1CE AGAIN

 

avater

M.Sriram Shenoy (CA Final)     29 April 2008

M.Sriram Shenoy
CA Final 
 13 likes  814 points

View Profile | My Other Post

Great one yaar. Keep it up..


Leave a reply

Your are not logged in . Please login to post replies

Click here to Login / Register  




Popular Discussion


view more »