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 [...]

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 [...]

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 [...]

Read the full article →

Creating Shortcut Keys for Symbols in Word

January 11, 2012

Word provides shortcut keys to many helpful commands.  But did you know that you can create shortcut keys for symbols?  That is to say, you can quickly insert a symbol into your document by using a keystroke combination. To Create A Shortcut to Insert a Symbol Click File on the Ribbon to display backstage view. [...]

Read the full article →

Managing Junk E-Mail in Outlook 2010

February 10, 2011

Anyone with an e-mail account these days is no doubt familiar with junk e-mail, commonly referred to as Spam.  Outlook contains a powerful junk-mail filter that will move any messages that resembles junk e-mail to a special junk mail folder.   To adjust Outlook’s Junk E-mail settings, click the Junk button on the Delete group of [...]

Read the full article →

← Previous Entries

Next Entries →