Pages

Thursday, January 26, 2012

Help in Excel, Word and Outlook


EXCEL
WORD
OUTLOOK
Clicking and dragging a formula down a column is easy!  This process can be tedious if you have hundreds or even thousands of rows of data.  Whether it is 10 rows or 10,000 rows, if there is data on the left or right of a formula you are about to copy, just double click the auto fill handle.  The way you know you are on the AutoFill handle is that your cursor changes from a white plus to a black plus.  The formula will stop copying where your data stops.  You can also copy cells contents by just clicking (with the black plus) and dragging down to a selected cell, if there is no data in the neighboring cells.
Keep repeating the same information over and over?  Do you always close with the same few lines in your letters or often insert similar requests for information?  Create your own Quick Part and repeat your actions with a couple of clicks.  Type in your verbiage and select it.  On the insert tab, in the text group, click Quick Parts.  Select the last option, Save Selection to Quick Part Gallery.  To use it again, simply click the same button.  Your own Quick Parts should show up at the top of the drop-down menu.  Hint:  This works in Outlook too!
Follow up with Outlook. Set a follow-up flag BEFORE you send an email by using the message tab, which appears in place of the Home tab when composing email. Click on the drop down button of the Follow Up tab. Select one of the preset follow-up times or a custom date.  You can even set a reminder.  It will then show up as a task on your To-Do Bar.  You will get a pop up reminder when it is time to send a follow-up.