QuickTips on Date/Time in MS Office

Current Date and Time

Use these keyboard shortcuts to easily insert the current date and time into your Microsoft Office documents.

Microsoft Word

• Alt + Shift + D will insert the current date into your document.

• Alt + Shift + T will insert the current time into your document.

Microsoft PowerPoint

• Use either of the above key combinations for MS Word to bring up the Date and Time window where you can choose what format to insert the current date and time onto your PowerPoint slide.

 

Microsoft Excel

• Ctrl + ; (semicolon) will insert the current date into your worksheet.
• Ctrl + Shift + : (colon) will insert the current time into your worksheet.

And speaking of date and time... Remember Daylight Saving Time (DST) will end on November 4, 2007.  

It is important to make sure that your computer systems are appropriately updated to reflect the changes in Daylight Saving Time this year.  Pay particular attention to appointments you have scheduled on your computer between October 28 to November 4.

 

Microsoft Outlook Email Tips

Here are a few quick tips from CMIT to customize your use of Microsoft Outlook. These tricks will help you manage that email inbox when there are so many messages coming and going in a normal business day.

Do you ever wish you could set yourself a reminder to reply to an email? Here's how:

1. Right-click the message you want to set the reminder for.
2. Point to Follow Up.
3. Click Add Reminder.
4. In the Due By list, click the date when you have to complete the reply.
5. In the second list, click a time.
6. In the Flag Color list, click the flag color you want.
7. Click OK.

Is there any way to add your own words to a follow-up flag on a new message? Yes, there is! Follow these simple steps.

1. Click the Message Flag button.
2. Type the text you want in the Flag to box.

Send your message to multiple people without revealing other recipients' identities. This one is important for following good email etiquette.

1. Use the Bcc line in the message.
2. Bcc stands for Blind Carbon Copy.
3. If you add someone's name to the Bcc line, a copy of the message is sent to that person, but his or her name is not visible to other recipients.

Bcc is not showing up in the New Message window. How do you add it?

1. If you have Microsoft Office Outlook 2007: In the new message, on the Message Options tab, in the Fields group, click Show Bcc.
2. If you have Microsoft Outlook 2002 or 2003 and Microsoft Word is your email editor: Click the arrow to the right of the Options button, then click Bcc.
3. If you have Microsoft Outlook 2002 or 2003 and Outlook is your email editor: On the View menu, click Bcc Field.

Daylight Saving Time Ends November 4th

Important Notice:

Daylight Saving Time (DST) began three weeks early this year, on March 11, 2007 and will end a week later than normal, on November 4, 2007.

It is important to make sure that your computer systems are appropriately updated to reflect the changes in Daylight Saving Time this year. Pay particular attention to appointments you have scheduled on your computer between October 28 to November 4.

SPAM - The Pesky Inbox Problem

Spam, the unsolicited email you receive more often than not. It's usually commercial advertising and frequently for dubious products, get-rich-quick schemes, or illegal services.

Identifying the culprit

The first step in combating the onslaught of spam is to know it when you see it. If you're lucky, you can identify spam based on its subject line. If it's offering you a lower mortgage, a date with Trixie, or free $$$, you know it's spam. But be careful, because spammers often are very clever and make the subject line something you might click on, such as "FWD: great punch line." So, even if the subject line looks harmless, your best bet is to just delete it if you don't recognize the email address of which it came from.

Many spammers also fake the name of the sender with something common such as "Joe." Is this an email from Grandpa? Or maybe it's from your co-worker? You don't know, and the spammer counts on your curiosity. Also be sure to check the date it was sent. Most inboxes are sorted by time, so spammers may send messages to the top of the list by changing the date to several days earlier or later. Worse yet, some spammers will fake an email as being from someone you trust, such as a national bank or a well-known online retailer. It's all pretty sneaky.

Handling the evidence

Once you've identified a message as spam, don't just delete it. Here's what to do (and what not to do) when you have unwanted email on your hands.

• First, identify spam to your email provider. Companies like America Online (AOL), Microsoft (MSN/Hotmail), and Yahoo! stop a significant amount of spam using email filters, so make sure your filter is on. Once it's activated, it will funnel unwanted messages into a Bulk Mail or Junk Mail folder.
  
• Never, ever open an attachment from a suspicious email. It may contain a virus that could wipe out everything on your PC. To compound the damage, it could duplicate the virus and send it to everyone in your email address book, potentially destroying their machines as well.
  
• Don't forward unknown email. Sometimes spam will have a fake "To" or "From" field. Since it appears that the email was erroneously sent to you, the spammer hopes you'll read it and hopefully forward it along. Don't.
  
• Resist the temptation to unsubscribe. Sometimes clicking a link that promises to unsubscribe you lets the spammer know that your email address is valid, which means you might be spammed even more.
  

Handy prevention tips

The best way to fight spam is to keep it from arriving in your inbox in the first place. Here are some tips for preventing unwanted email.

• Don't post your email address online. Spammer software scans newsgroups, web sites, and web forums looking for email addresses. if you post in such places, disguise your email address.
  
• Don't give out your email address unless you know how it will be used. Read a site's privacy policy (such as CMIT's Online Privacy Statement) to learn about the company. If they don't have a privacy statement, you probably shouldn't trust them with your address.
  
• Never buy anything advertised in spam. Even if you happen to be looking for a lower mortgage rate, don't look for it in junk email. Chances are the services advertised are bogus anyway. Respected loan companies don't randomly flood inboxes.
  
• Update your address book. Make sure that the people you want to have contact with are in your address book: your friends, family, business associates, and companies you've requested email from. Most email systems have a filter, so messages may not be delivered into a recipient's inbox unless the sender's email address is included in their address book.
  

Remember to keep reporting spam to your Internet service provider so they can track key offenders. If we all work together, spam may again become just a canned meat product!