Menu
Cart 0

PCM Courseware Blog

How to Total Data in an Excel Table

Posted by Roger Hyttinen on

How to Total Data in an Excel Table

You can quickly total data in an Excel table using the Total Row feature on the Table Style Options group of the contextual Design Ribbon (see our Creating a Table in Excel post for information on creating Excel tables). Clicking the Total Row check box adds a new row at the end of the table, with the word Total in the leftmost cell. Clicking in any of the cells in a total row displays a drop-down list from where you can choose an aggregate function to apply to the data in the row, such as Sum or Average. Typing a...

Read more →

Prevent Microsoft Word from Breaking Up a Paragraph

Posted by Roger Hyttinen on

Prevent Microsoft Word from Breaking Up a Paragraph

By default, Microsoft Word will insert a page break whenever you reach the end of the page. This means that often, an automatic page break is inserted within a paragraph and the remaining portion of a paragraph continues on the next page. This may not always be what you want. For instance, you might have a border surrounding a short paragraph so that it stands out from the other paragraphs in your document. A page break in the middle of a bordered paragraph would appear unsightly. Luckily, you prevent Word from inserting page breaks within a paragraph by using the...

Read more →

Automatically add travel and package delivery events to your Outlook calendar

Posted by Roger Hyttinen on

Automatically add travel and package delivery events to your Outlook calendar

Outook now includes the option of automatically adding travel information such as car rental reservations and airline tickets, as well as package delivery information automatically to your calendar. Outlook will retrieve travel and package information from your email and will pop the information into your calendar for you. The first time Outlook creates such an event for you, you'll receive the following message, along with information about the event being added: The thing with this feature, is that it is turned on automatically. If this is not what you want, you can turn it off or change its settings from...

Read more →

Save Time by Using Email Templates in Outlook

Posted by Roger Hyttinen on

Save Time by Using Email Templates in Outlook

Many people find that they email the same information over and over on a regular basis. Perhaps you run a business and receive the same customer inquires or questions on a regular basis. In this kind of situation, email templates can come in handy. A template is a snippet of content that you can reuse on an as-needed basis rather than typing the same content over and over. Quick Guide: To Create an Outlook Template Launch Microsoft Outlook and click Inbox in the left pane. Press the Ctrl + N keystroke combination to create a new blank message. Enter the...

Read more →

Excel 2016 for Mac Level 3 Now Available

Posted by Roger Hyttinen on

Excel 2016 for Mac Level 3 Now Available

Our Microsoft Excel for Mac - Level 3 course is now available for download from the PCM Courseware library. You can preview the first three chapters of the course - as well as the course outline - from our Excel for Mac page.

Read more →