Using Multiple Outlook Windows

by rhyttinen on February 3, 2012

Newwindow

If you find yourself switching back and forth between two views – such as calendar and mail, for example – you might want to consider keeping each view open in a separate window, which you can then arrange side by side.  I personally find that this greatly simplifies my work flow as I can easily drag contacts or e-mail messages directly to my calendar using this configuration.

To open a view or folder in a new window, right-click on the item (the calendar button, for example) and then click “Open in New Window”.

To make your screens even more uncluttered, you can also hide the Navigation Pane and the Ribbon.

{ 0 comments }

Share an Outlook calendar via E-mail

by rhyttinen on February 1, 2012

Outlook allows you to share the details of your calendar by E-mail.  This can include appointments for today, tomorrow, the next 7 days, next 30 days or during a specific date range.  You can even e-mail someone your entire calendar!  The calendar is saved as an iCalendar file which your recipient can easily import into Outlook.

Send calendar via E-mail dialog box

To Share a Calendar by E-mail:

  1. Open the calendar that you wish to share.
  2. Click the E-mail Calendar button on the Share group of the Ribbon.
  3. Click the Date Range drop-down list and chose the range of dates that you would like your calendar attachment to include.
  4. Click the Advanced button to set additional privacy options.
  5. Click OK. Outlook will prepare an e-mail message with the calendar file attached.
  6. Enter the e-mail details and send the message.

Applies to Outlook 2010

{ 0 comments }

Excel 2011 Level 1 Courseware for Mac Available

January 27, 2012

We have just released courseware for Microsoft Excel 2011 (for Macintosh – Level 1 and it is now available for download in our Courseware Library.  PowerPoint 2011 is forthcoming.

Read the full article →

Using the Reading Pane in Outlook 2010

January 25, 2012

You can preview items in your Inbox without opening them by using the Reading Pane.  This is ideal if you want to quickly browse through a bunch of messages.  To display the Reading Pane, click the View tab on the Ribbon, click the Reading Pane button on the Layout group of the Ribbon and then [...]

Read the full article →

Viewing Messages by Conversation in Outlook

January 23, 2012

Outlook now allows you to organize your messages by Conversations.  When the Conversations feature is activated, all messages that share the same subject are grouped together, where they can be then be acted on as a group.  Conversations can be expanded or collapsed for easy viewing.  Any Conversation that contains unread messages displays the count [...]

Read the full article →

Create a Contact Group in Outlook 2010

January 18, 2012

If you frequently send out e-mail messages to a specific group of recipients, you can create a contact group (formerly referred to as a distribution list).  A contact group is a collection of specific contacts from your contacts list, making it easy to send e-mail to a particular set of people, such as business associates, [...]

Read the full article →

Counting Blank Cells in Excel

January 17, 2012

In the last couple of posts, we looked at using the COUNT function to count the number of cells that contain numbers and the COUNTA function to count the number of cells that contain either text or numbers in Excel.
A third type of count function is the COUNTBLANK function.  Can you guess what this one [...]

Read the full article →

Counting Cells with Numbers and Text in Excel

January 16, 2012

In the last post, we looked at the COUNT function, which will count any cells that contain numbers and assign it a numerical value of “1”.  This way, you can determine how many cells in a range contain a number.
If you want to count any cell that contains data, you would use the COUNTA Function. [...]

Read the full article →

Microsoft Office Courseware 2011 for Mac

January 13, 2012

We have just released the first course in the Microsoft Office 2011 for Mac series:  Word 2011 – Level 1 to the PCM Courseware library.    Excel Level 1 is forthcoming.  We hope to have all of the Office 2011 courses completed within the next couple of months.
Anyone purchasing a license for the Macintosh [...]

Read the full article →

Counting Cells with Values in Excel

January 12, 2012

If you wish to count the number of cells that contain numerical values, use the Count Function.  Note that this does not provide a total sum of the numbers, but rather each cell that contains a number is given a numerical value of 1.
In the example below, cell B3 and B4 both contain numerical values. [...]

Read the full article →