Microsoft Tips

PowerPoint Tip

Did you know when you are presenting you can highlight key words or items on your slide?  How cool is that!

  1. During your slide show right click the mouse button
  2. Scroll down to Pointer Options.
  3. Choose what you want and you are off to the races!
At the end of your presentation you will have the option to keep your markings or discard them.

Add a person’s name to their contact information

Easy to do! 

 

1.       Just Google the person’s name and chances are you will find a photo of them on LinkedIn, Twitter, YouTube, etc.,,

1.       Find the image

2.       Right-click on that image

  1. Click "Save Image As"
  2. Save to Desktop (Remember what it is called)
  3. Open up the contact
  4. Click in the Photo Field
  5. Select photo from Desktop (Remember the name from step 4)
  6. Save contact with the new image
  7. Delete photo from Desktop

 

You are done!

Did you know you can delete Duplicate Rows in #Excel?

  1. Highlight the column that has the duplicates. (You must select at least one column).
  2. Select the Data tab.
  3. Select Remove Duplicates
  4. Select OK.
  5. Select OK again.

 

NOTE:  You cannot UNDO this!

How to insert sample text into #Word

Microsoft Office Word lets you quickly insert sample text into a document. This article discusses how to insert sample text into a document when you use different versions of Word.

http://support.microsoft.com/kb/212251

5 Email Faux Pas that Can Destroy Your Career

A great lesson from Business Management Daily post:

 

5 types of emails to avoid

Maria had been emailing back and forth with a colleague all day about a work issue, when she finally decided to cc the boss. “We weren’t getting any closer to resolving the situation. I had to do something,” she says.

It felt like the right thing to do. Maria thought her supervisor would make the decision that the two co-workers couldn’t agree on. End of argument.

But that’s not how it turned out. In­­stead, it came back to bite her. Her co-worker became angry, and her boss saw Maria’s email as immature and undermining. Maria left the company shortly after, embarrassed but wiser.

“Emily Post was not around when email began,” says Marsha Egan, author of Inbox Detox and the Habit of Email Excellence. “So people have to make up their own rules. What one person might see as absolutely fine, another might find offensive.”

In the end, Maria’s “cc’ing up” exhibited poor etiquette and turned into a bad career move. Avoid cc’ing up and these other email faux pas:

  • The instant follow-up, or “Did you get my email?” Egan describes the instant follow-up as a “gotcha” move. The etiquette, she says, is to call before sending the email. “Let them know what you’ll be sending them and when.” They’ll be more likely to respond and read your message in the first place.  (or if you need to know and you are on your Smartphone, BBM and iMessage shows they read it!)
  • Screaming via email, or typing “READ THIS.” The intent may be to grab someone’s attention, but an all-cap message can come across as forceful or arrogant. The same goes for multiple exclamation points.
  • Correcting a co-worker. In an effort to make sure higher-ups see a clean document, a person may proofread, correct and resend an email sent by her colleague ensuring that the corrected version lands at the top of the boss’s inbox. How is the effort perceived? As a way of one-upping or publicly shaming a co-worker. Nobody wins.
  • Overflagging. Using the priority flag for too many emails, particularly ones without a deadline or an expiration date, is a “boy who cried wolf” move. The odds are your emails will have less of a chance of being read quickly.
  • Recycling an old email chain. Rather than begin a new email chain to someone, you piggyback on a message already in your inbox—with an old subject line. The perception on the recipient’s end may be that you’re disorganized or lazy. Solution: Always start a new email chain that reflects the subject being discussed.

The golden rule applies: How would you feel if you were on the receiving end of your message?  What are your comments?

Problems with #iCloud and #Outlook

I found this fantastic site below that talks about the troubles using Apple products and syncing with Outlook.  Check out all the info below and their site!

 

Lots of iPhone and iPad users got excited when they learned about iCloud and its ability to sync mail, calendar, contacts and tasks with Outlook via the Internet.

Hold the applause, if you actually try to use iCloud’s links to Outlook you’re in for disappointment and frustration.

You’re better off sticking with iTunes.

The iCloud/Outlook link is there and works so Apple isn’t outright lying. However the connection with Outlook is so proprietary and inflexible that it’s effectively useless for any existing Outlook user.

Office-Watch.com has look at the Documents synchronization feature of iCloud separately.

After you’ve installed the iCloud application for Windows, you can see these configuration options.

 


iCloud control panel for Windows

 

If you want more details on the setup and workings of the iCloud program for Windows, check our detailed article.

MAIL

The Mail option is usually grayed out. That’s because you need a MobileMe account from Apple to enable this option. Any other email service doesn’t qualify .. move along, nothing to see here.

CONTACTS

Contacts can only be synced between iCloud and a specific iCloud Contacts folder it creates in Outlook.

There’s no way to make the iCloud Contacts folder the default contacts folder or ensure new contacts are saved in that folder.

You can copy/move your existing Contacts to the iCloud Contacts folder but any new contacts will go to the original contacts folder.

That means you have to keep checking to make sure any contacts are in the iCloud Contacts folder because there’s no way to do it automatically.

CALENDAR AND TASKS

It’s the same problem here. iCloud makes new Calendar folders independent of any existing, default calendars.

You can’t change Outlook’s settings so these new calendar/s are the default location for new appointments.

The result of all this is that customers will have to check their calendar, contacts and tasks folders manually and move any new entries into the iCloud equivalents. Hardly a satisfactory solution.

STICK WITH ITUNES

These severe limitations in iCloud with Windows are in stark contrast to the long standing method of syncing an Apple device with Outlook using iTunes. You plug your device into a computer with iTunes and it will sync all your music, apps and Outlook folders.

Unlike the simplistic iCloud version, in iTunes you can select which Outlook folders to sync. You can choose your existing calendar and contacts folders to synchronize and the choices even default to the Outlook default folders.

In other words the iTunes method of Outlook connection works while the iCloud one doesn’t, for all practical purposes.

Even better, with the latest iTunes and iOS v5 you can use iTunes to sync without the cable. The iPhone, iTouch or iPad and iTunes can sync whenever they are on the same local network.

OR USE WHAT YOU HAVE

Exchange Server, Small Business Server, Office 365, Gmail and Hotmail users don’t need the iCloud service. All those mail hosts already store your calendar and contacts in a ‘cloud’ that you can connect to Apple devices using ActiveSync plus you get email connection without paying for MobileMe.

In short, iCloud is worse that useless with Outlook and there are better, cheaper ways to keep your data synchronized anyway.

Where do I find How do to things in #Microsoft Office 2003, 2007, 2010?

Big thanks to http://www.howto-outlook.com/ an awesome resource for Microsoft products!

Changed Outlook version and can now no longer find your favorite feature? Feel like test driving Outlook 2010? Or have you heard of a feature but don't know where to find it in Outlook? This guide will help you on your way. It contains a list of most commonly used features and options that have been shifted around or renamed between Outlook versions and are sometimes hard to find back. In addition, a couple of options have links to them to find out more about how to use the feature.

Several options have multiple ways of accessing them. We will only list one method as the intention of the guide is only to locate the feature. The main focus will be on accessing the options via the main interface by using a standard click (left mouse button).

With the Office Logo we refer to the

Image001

icon in Outlook 2007 and within Office 2010 the File menu is the tab like

Image002

icon (also known as Backstage).
With the Ribbon we refer to the new tabbed interface for command buttons in Outlook 2007 and Outlook 2010 also known as Fluent UI.
With the Expand icon we refer to the

Image003

or

Image004

icon on the Ribbon (in the right bottom corner of some tab groups).

 

The features have been grouped in the following categories;

This guide is not a full feature list of Outlook. Its intention is to serve as a Quick Reference guide. Feel free to submit feedback if you can't find a specific feature or think that certain features should be listed here as well.


Global Outlook options and features

Default message format

Outlook 2003: Tools-> Options…-> tab Mail Format
Outlook 2007: Tools-> Options…-> tab Mail Format
Outlook 2010: File-> section Options-> section Mail-> group Compose messages…

Signatures (define)

Outlook 2003: Tools-> Options…-> tab Mail Format-> button Signatures…
Outlook 2007: Tools-> Options…-> tab Mail Format-> button Signatures…
Outlook 2010: File-> section Options-> section Mail-> button Signatures…
(more about creating signatures)

Mark as Read behavior

Outlook 2003: Tools-> Options…-> tab Other-> button Reading Pane…
Outlook 2007: Tools-> Options…-> tab Other-> button Reading Pane…
Outlook 2010: File-> section Options-> section Advanced-> button Reading Pane…

Print Options

Outlook 2003: File-> Page Setup/Print…
Outlook 2007: File-> Page Setup/Print… (main Outlook window)
Outlook 2007: Office Logo-> Print (opened item)
Outlook 2010: File-> Print

Advanced Find

Outlook 2003: Tools-> Find-> Advanced Find…
Outlook 2007: Tools-> Instant Search-> Advanced Find…
Outlook 2010: Click in the Instant Search field-> the Search tab appears-> Search Tools-> Advanced Find

Startup Folder

Outlook 2003: Tools-> Options…-> tab Other-> button Advanced Options…-> Startup in this folder
Outlook 2007: Tools-> Options…-> tab Other-> button Advanced Options…-> Startup in this folder
Outlook 2010: File-> section Options-> section Advanced-> option group: Outlook start and exit-> Start Outlook in this folder

Tracking Options

Outlook 2003: Tools-> Options…-> tab Preferences-> button E-mail Options…-> button Tracking Options
Outlook 2007: Tools-> Options…-> tab Preferences-> button E-mail Options…-> button Tracking Options
Outlook 2010: File-> section Options-> section Mail-> option group: Tracking

Macros

Outlook 2003: Tools-> Macro-> Macros…
Outlook 2007: Tools-> Macro-> Macros…
Outlook 2010: tab Developer-> section Code-> button Macros
(read here how to enable the Developer tab)

International Options
(encoding)

Outlook 2003: Tools-> Options…-> tab Mail Format-> button International Options…
Outlook 2007: Tools-> Options…-> tab Mail Format-> button International Options…
Outlook 2010: File-> section Options-> section Advanced-> option group: International Options…

Outlook management and maintenance

About
(show version number)

Outlook 2003: Help-> About…
Outlook 2007: Help-> About…
Outlook 2010: File-> section Help

Repair

Outlook 2003: Help-> Detect and Repair…
Outlook 2007: Help-> Office Diagnostics…
Outlook 2010: Removed from interface.
(you can also run Repair from CD/DVD via setup or via Control Panel)

Check for Updates

Outlook 2003: Help-> Check for Updates…
Outlook 2007: Help-> Check for Updates…
Outlook 2010: File-> section Help-> button Check for Updates…

Add-ins
(enable/disable)

Outlook 2003: Tools-> Options…-> tab Other-> button Advanced Options…-> button Add-In Manager…/button COM Add-Ins…
Outlook 2007: Tools-> Trust Center…-> section Add-Ins
Outlook 2010: File-> section Options-> section Add-Ins…
More details can be found here.

Disabled Items

Outlook 2003: Help-> About…-> button Disabled Items…
Outlook 2007: Help-> Disabled Items…
Outlook 2010: File-> section Options-> section Add-ins-> drop down list Manage-> Disabled Items-> button Go…

Account and data file management

Mail Account Settings
(add/remove/edit account)

Outlook 2003: Tools-> E-mail Accounts…-> option: View or change existing e-mail accounts-> button Next
Outlook 2007: Tools-> Account Settings…-> tab tab E-mail
Outlook 2010: File-> section Info-> button Account Settings-> Account Settings…-> tab E-mail
(use these configuration settings for using Live Hotmail, Gmail, Yahoo or AOL and AIM)

Mailbox Cleanup

Outlook 2003: Tools-> Mailbox Cleanup
Outlook 2007: Tools-> Mailbox Cleanup
Outlook 2010: File-> section Info-> button Cleanup Tools-> Mailbox Cleanup…
(cleanup tips)

AutoArchive

Outlook 2003: Tools-> Options-> tab Other-> button AutoArchive…
Outlook 2007: Tools-> Options-> tab Other-> button AutoArchive…
Outlook 2010: File-> section Options-> section Advanced-> button AutoArchive Settings…
(troubleshoot common AutoArchive issues)

Archive

Outlook 2003: File-> Archive…
Outlook 2007: File-> Archive…
Outlook 2010: File-> section Info-> button Mailbox Cleanup-> Archive…

Empty Deleted Items
(upon exit)

Outlook 2003: Tools-> Options…-> tab Other-> option: Empty Deleted Items folder upon exiting
Outlook 2007: Tools-> Options…-> tab Other-> option: Empty Deleted Items folder upon exiting
Outlook 2010: File-> section Options-> section Advanced-> option group: Outlook start and exit-> Empty Deleted Items folders when exiting Outlook

Add new Personal Folders
(pst-files)

Outlook 2003: File-> New-> Outlook Data File…
Outlook 2007: File-> New-> Outlook Data File…
Outlook 2010: tab Home-> button New Items-> More Items-> Outlook Data File…

Open existing Personal Folders
(pst-files)

Outlook 2003: File-> Open-> Outlook Data File…
Outlook 2007: File-> Open-> Outlook Data File…
Outlook 2010: File-> section Open-> Open Outlook Data File…
(errors when opening a pst-file can often be fixed via scanpst.exe)

Data File Management
(list connected pst-files, their locations, close them, set as default)

Outlook 2003: File-> Data File Management…
Outlook 2007: File-> Data File Management…
Outlook 2010: File-> section Info-> button Account Settings-> Account Settings…-> tab Data Files…

New folder

Outlook 2003: File-> New-> Folder…
Outlook 2007: File-> New-> Folder…
Outlook 2010: tab Folder-> section New-> New Folder

Import

Outlook 2003: File-> Import and Export
Outlook 2007: File-> Import and Export
Outlook 2010: File-> Open-> Import

Export

Outlook 2003: File-> Import and Export
Outlook 2007: File-> Import and Export
Outlook 2010: File-> Open-> Import

Views

Field Chooser

Outlook 2003: Right click a column-> Field Chooser
Outlook 2007: Right click a column-> Field Chooser (single line layout)
Outlook 2007: Right click a column-> Custom…-> Fields… (multi line layout)
Outlook 2010: Right click a column-> Field Chooser (single line layout)
Outlook 2010: Right click a column-> View Settings…-> Columns… (multi line layout)
(for more info about multi line and single line layout see this post)

AutoPreview

Outlook 2003: View-> AutoPreview
Outlook 2007: View-> AutoPreview
Outlook 2010: tab View-> button Change View-> Preview (this view has the Reading Pane turned off by default)

Organize

Outlook 2003: Tools-> Organize…
Outlook 2007: Tools-> Organize…
Outlook 2010: tab View-> button View Settings-> button Conditional Formatting
(for more info about Conditional Formatting see this guide)

Define Views

Outlook 2003: View-> Arrange By-> Current View-> Define Views…
Outlook 2007: View-> Current View-> Define Views…
Outlook 2010: tab View-> button Change View-> Manage Views…
(how to apply a custom view to all folder)

Reading Pane
(enable/disable, position right/bottom)

Outlook 2003: View-> Reading Pane-> …
Outlook 2007: View-> Reading Pane-> …
Outlook 2010: tab View-> Reading Pane-> …

Exchange

Out of Office Assistant

Outlook 2003: Tools-> Out of Office Assistant
Outlook 2007: Tools-> Out of Office Assistant
Outlook 2010: File-> section Info-> button Automatic Replies
(for Exchange administrators: verify if Out of Office to the Internet is allowed)

Delegates

Outlook 2003: Tools-> Options…-> tab Delegates
Outlook 2007: Tools-> Options…-> tab Delegates
Outlook 2010: File-> button Account Settings-> Delegate Access
(more about Permissions)

Recover Deleted Items

Outlook 2003: Tools-> Recover Deleted Items…
Outlook 2007: Tools-> Recover Deleted Items…
Outlook 2010: tab Folder-> section Cleanup-> button Recover Deleted Items

Add secondary mailbox

Outlook 2003: Tools-> E-mail Accounts…-> option: View or change existing e-mail accounts-> button Next-> select your Exchange account-> button Change…-> button More Settings…-> tab Advanced-> button Add…
Outlook 2007: Tools-> Account Settings…-> tab E-mail-> select your Exchange account-> button Change…-> button More Settings…-> tab Advanced-> button Add…
Outlook 2010: File-> section Info-> button Account Settings-> Account Settings…-> tab E-mail-> select your Exchange account-> button Change…-> button More Settings…-> tab Advanced-> button Add…

Open Folder from Other User

Outlook 2003: File-> Open-> Other User's Folder…
Outlook 2007: File-> Open-> Other User's Folder…
Outlook 2010: File-> section Open-> button Other User's Folder

Receiving Settings

Send/Receive Settings

Outlook 2003: Tools-> Options…-> tab Mail Setup-> button Send/Receive…
Outlook 2007: Tools-> Options…-> tab Mail Setup-> button Send/Receive…
Outlook 2010: File-> section Options-> section Advanced-> button Send/Receive…

New Email Alerts

Outlook 2003: Tools-> Options-> tab Preferences-> button E-mail Options…-> button Advanced E-mail Options…-> option group: When new items arrive in my Inbox
Outlook 2007: Tools-> Options-> tab Preferences-> button E-mail Options…-> button Advanced E-mail Options…-> option group: When new items arrive in my Inbox
Outlook 2010: File->  section Options-> section Mail-> option group: Message arrival
(configure the New Mail Desktop Alert to stay longer and show for all messages)

Rules and Alerts

Outlook 2003: Tools-> Rules and Alerts…
Outlook 2007: Tools-> Rules and Alerts…
Outlook 2010: tab Home-> section Move-> button Rules-> Manage Rules & Alerts…

Messages (composing and reading)

Unless specified otherwise, these instructions are about the message window, both composing and reading.

Change message format;
HTML/Plain Text/Rich Text

Outlook 2003: Format-> Plain Text/HTML/Rich Text (Outlook as the editor)
Outlook 2003: E-mail toolbar-> dropdown list next to Options… button (Word as the editor)
Outlook 2007: Ribbon-> tab Options
Outlook 2010: Ribbon-> tab Format Text

From and BCC field
(enable/disable)

Outlook 2003: View-> From Field/Bcc Field (Outlook as the editor)
Outlook 2003: E-mail toolbar-> dropdown button on Options… button-> From/Bcc
Outlook 2007: Ribbon-> tab Options
Outlook 2010: Ribbon-> tab Options

Resize picture attachments

Outlook 2003: Insert-> File…-> after attaching: button Attachment Options…
Outlook 2007: tab Message-> section Include-> button Attach File…-> after attaching: expand icon on Include
Outlook 2010: File-> section Info

Message Options (composing)

Outlook 2003: View-> Options… (Outlook as the editor)
Outlook 2003: E-mail toolbar-> Options… (Word as the editor)
Outlook 2007: tab Options-> section More Options-> expand icon
Outlook 2010: tab Options-> section More Options-> expand icon

Message Options (reading)
(message header)

Outlook 2003: View-> Options…
Outlook 2007: tab Message-> section Options-> expand icon
Outlook 2010: File-> Properties

Save Attachments (all)

Outlook 2003: File-> Save Attachments
Outlook 2007:

Blind Copy Etiquette

Who doesn't hate it when someone hits reply to all and says a one word answer?  To avoid this happening to your recipients when sending a mass email:

  1. Put your name in the To: field
  2. Put the recipients' names in the BCC: field
  3. Or try out a program that I use called "Send Personally"

#Microsoft - How to change a Page's Column Breaks in Excel

Here's how to adjust your page breaks:
  1. Select Page Break Preview from the View tab
  2. Place your cursor over the blue column line you want to move until it becomes a double arrow.
  3. Hold down your left mouse button and move the blue line to where you want the column break to be.
  4. Release the left mouse button. The dashed blue line becomes a solid blue line, indicating where the new page break will occur.
You follow the same procedure to move a page break for the rows.

Quick way to format a word in Word.

When you format a single word--say, with bold, italic, or underline--it's not necessary to select the entire word (and then press Ctrl-B, Ctrl-I, or whatever to do your formatting). Just move the cursor anywhere inside the word and format it. This can save you the trouble of reaching for the mouse to double-click or holding down Shift while using the arrow keys or clicking to select the entire word. This convenience is part of Word by default. If this doesn't work, choose Tools, Options and click the Edit tab. Then check the 'When selecting, automatically select entire word' box.
Syndicate content