PCM Courseware

Using Multiple Outlook Windows

rhyttinen — Fri, 03 Feb 2012 16:09:27 +0000

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.Similar Posts:

Share an Outlook calendar via E-mail

rhyttinen — Wed, 01 Feb 2012 18:29:03 +0000

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.

To Share a Calendar by E-mail:

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

Applies to Outlook 2010Similar Posts:

Excel 2011 Level 1 Courseware for Mac Available

rhyttinen — Fri, 27 Jan 2012 17:25:50 +0000

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.Similar Posts:

Using the Reading Pane in Outlook 2010

rhyttinen — Wed, 25 Jan 2012 06:00:44 +0000

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 click Right from the pop-up menu to display it on the right side of your screen. You can also display it on the Bottom of your screen but only a small portion of your message is then visible. Unlike the AutoPreview view (located under the Change View button on the View Ribbon), the Reading Pane displays any graphics or text formatting in the message, not just the message text.

To Use the Reading Pane

Switch to Mail View.
To turn on the Reading Pane, click the View tab on the Ribbon, click the Reading Pane button and then click on either Right or Bottom from the menu
To turn off the Reading Pane, click the Reading Pane button and then click Off.

Note: When viewing messages in the Reading Pane, potentially malicious scripts or attachments are not opened or executed. Messages can be safely previewed in the Reading Pane.Similar Posts:

Viewing Messages by Conversation in Outlook

rhyttinen — Mon, 23 Jan 2012 15:37:40 +0000

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 of the unread messages next to the subject. Click the right-pointing arrow to expand a Conversation.

If a message gets two or more responses, the Conversation can split into multiple Conversations that are related. The most recent message in each split Conversation displays when you click on the Conversation.

To View Messages by Conversation

Click the View tab on the Ribbon.
Click the Show as Conversations check box on the Conversations group of the Ribbon.
To expand a Conversation, click the right-pointing arrow to the left of the message header.

Tip: You can reduce the size of a conversation by removing redundant messages (that are not unread, unflagged or uncategorized) to the Deleted item folder. Click the Clean Up button on the Delete group of the Home Ribbon and click Clean Up Conversation from the menu.

Applies to: Outlook 2010Similar Posts:

Create a Contact Group in Outlook 2010

rhyttinen — Wed, 18 Jan 2012 07:00:49 +0000

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, relatives or your Friday night pool league members.

A message sent to the contact group goes to all recipients that make up the group. The Contact Group is stored in your Contacts folder under the name that you provide. Any time you want to send a message to everyone in the group, use the contact group name in the To line of your message.

To create a new contact group, click the New Contact Group button on the Ribbon and then type in the name for your list in the Name box. To add members from your Contacts list to the group, click the Add Members button on the Ribbon and choose From Outlook Contacts from the menu. Either double-click a contact’s name to add it to the list or select the contact and then click the Members -> button. To add an e-mail address that is not in your contact list, click the Add Members button, click New E-mail Contact from the menu and then fill in the contact’s information.

To Create a Contact Group

1. Click Contacts in the left pane.

2. Click the New Contact Group button on the Ribbon.

3. Click in the Name box and type in a name for your contact group.

4. To Add Members from your Contacts list:
a. Click the Add Members button on the Ribbon.
b. Click From Outlook Contacts from the menu.
c. Select the contact you want to add to the list and click the Members -> button.
Or
Double-click the contact you want to add to the list

5. To Add Members that are not in your Contacts list:
a. Click the Add Members button on the Ribbon.
b. Click New E-mail Contact
c. Enter in the contact’s display name and e-mail address. Click the checkbox next to Add to Contacts to add the contact to your Contacts list.

6. Click OK when finished. The contact list is saved in the Contacts folder with the name that you provided.

Applies to: Outlook 2010Similar Posts:

Counting Blank Cells in Excel

rhyttinen — Tue, 17 Jan 2012 06:00:03 +0000

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 does? Yup – it counts any cells that are blank; that is to say, cells that do not contain any data. But there is one caveat: The COUNTBLANK function will count a formula if it evaluates to “”. In our screen shot, Cell B4 contains the formula: =If(B5 > 500, “yes, “”). Because the result of the formula evaluates to “”, the COUNTBLANK function considers B4 to be a blank cell, thus including it in the calculation.

The syntax for the COUNTBLANK function is: =COUNTA(Range). In our example, the function reads: =COUNTBLANK(B2:B7)Similar Posts:

Counting Cells with Numbers and Text in Excel

rhyttinen — Mon, 16 Jan 2012 19:49:00 +0000

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. This function will count cells containing text as well as numerical entries but will ignore blank cells. It’s important to note however that this function will count any type of entry – even the space character created by pressing the spacebar.

The syntax for the COUNTA function is: =COUNTA(value1, value2, etc.). In our example, the function reads: =COUNTA(B3:B7)Similar Posts:

Microsoft Office Courseware 2011 for Mac

rhyttinen — Fri, 13 Jan 2012 16:59:41 +0000

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 Library courseware now will be entitled to all of the Office 2011 for Mac courses, in addition to any other courses we release for the Mac in the coming year.Similar Posts:

Counting Cells with Values in Excel

rhyttinen — Thu, 12 Jan 2012 16:40:49 +0000

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. Cell B6 contains a formula (=B3 + B4). The count function work for both number values as well as formulas that produce a numerical value. The Count function does not include blank cells or cells that contain text data. So in the case of our example below, the count function included only cells B3, B4 and B6, for a result of 3.

The syntax for the Count function is: =COUNT(value1, value2, etc.). In our example, the function reads: =COUNT(B2:B7)Similar Posts: