Welcome

Welcome to Teri's Tech Tips. This blog is intended to be used as a training resource for GCCISD staff to share tips in using Microsoft Office or any other Administrative application that the district provides.


Entering your email address in the space provided below will ensure you receive an email message each time information is posted.

Tuesday, June 28, 2011

Easily Attach Files In Outlook


Attaching a file to an email message can be a cumbersome process. To simplify this task and to ensure you don't forget the attachment,  follow the simple steps below.

With Outlook open, go to Start/My Computer and browse to the file you want to attach to a message. 
Click and drag the file from its folder onto the inbox shown in your mail folders in Outlook. A new message is created and the file is attached the file in one step.

Now simply address the message, include a subject and complete your message.

The Repeat Command

The Repeat command (Ctrl+Y) repeats the last single edit made in an a spreadsheet or document. For instance, if you change the font color of a word to red, simply move the cursor to another word in your document, and use Ctry+Y. The font for that word will change to red.

To use Repeat to duplicate multiple commands, use the keyboard shortcut Ctrl+1 to bring up the Format Cells dialog box. Make all of your editing choices and click OK. Now when you highlight another field and Repeat with Ctrl+Y, it will repeat all of the changes made on the format menu as if it were a single change. This is a great time saver. Give it a try.

Thursday, June 16, 2011

Auto Sum Command in Excel

The Auto Sum command is probably one of the most popular commands in Excel. On the Ribbon you will find it on the Home tab in the Editing group. This command will add a row or column of numbers. The keyboard shortcut for Auto sum is Alt+= . What you may not know is, you can select a group of numbers and extend the fields by one row and or column and when you use Alt+= it will total all rows and columns that are preselected. This is a great time saver if you work with large amounts of data.

Wednesday, June 15, 2011

Viewing Outlook in Multiple Windows

I know that many times I am creating an email and I need to reference my calendar. Rather than closing your message window and navigating to the Calendar tab, simple Right Click on the Calendar tab, and select Open in a New Window. Maximize your message window on the task bar and now you will be able to see your calendar while creating your email. This works in each of the navagation payne sections.