HandyBizMan

MS Office tips are those shortcuts and some smart things you can do while working in the MS Office applications. You can be really innovative and creative by using these tips. They comprise of smart ways of working, doing things in different ways and using shortcuts, all of which helps you to save time and get amazing performance using these applications.

What you most often use in MS Office are Word, Excel, PowerPoint, and Outlook. So while discussing these tips we will concentrate on these applications.

Part 1

We begin with WORD

1.If you want to quickly change the case of the text, Select the text and press Shift+F3

2.How to paste using the insert key. There is no need to press Ctrl+C and Ctrl+V every time you need to copy and paste something. On your keyboard there is an insert key on your right. This key can be assigned the Paste task.

3.Create links to a long document using the Table of Contents

Table of contents is simple to make. First of all you have to identify the text that will appear as headings in the table.

Then they have to be formatted as heading one or heading two or other custom styles.
Go to Insert, Reference, and select Index and Tables. Click Options. Make sure that a toc number appears next to every heading you want to appear in the table of Contents.

When your TOC is inserted, go to the specific link by pressing the Ctrl key.

Mail Merge is a popular feature in word. Using mail merge you can create many mails to send many recipients using just one standard letter.

On the tools menu, select letters and mailings and click on Mail Merge Wizard.
The wizard gives you a step-by-step procedure.

Part 2

Tips in Power Point

Here are some special things, that you always wanted to do in Power Point.

While working in Power
Point you may have a picture and want to use only a portion of it.
This is how you go about it.

First insert the picture in the slide.
Select the picture and click ungroup from the draw menu.
Now click anywhere in the slide.
Now click on the object to be deleted and delete it.

Part 3

TIPS IN EXCEL
Now we will see some novel tips in EXCEL

Creating a chart in Excel is very easy. Make the data ready and select the data. Now, press F11.

Suppose you have a range of yearly figures in your excel sheet and you want a quick look at what the daily figures will be, here is what you can do.

Select a cell and type in =365
Click on copy
Highlight the data where you want the daily figures.
In the Edit menu click Paste special.
You will see a paste special dialog box.
In the dialog box click divide and OK.
All the data you highlighted now shows you the daily figures.

Generating random numbers in excel

If you require random numbers for some samples and analysis there is a shortcut to it.
This is what you do.

If you type =RAND () in a cell it generates random numbers between 1 and 0
If you type =RAND ()*100 it generates random numbers from 1 to hundred.
You can then use the fill handle on the lower right hand corner of the cell to fill up
As many cells as needed.

Part 4

Tips in OUTLOOK

Sometimes while working you require those sticky paper “paste it” notes.
In outlook, notes are the equivalent of that. Use notes to jot down tips, reminders and anything else required while working.
In Outlook, go to File menu and on the New command select Note
Type the text.
To close ,click on X in the upper-right hand corner.