Menu
Cart 0

PCM Courseware Blog

Tracing Errors in Excel

Posted by Roger Hyttinen on

Tracing Errors in Excel

Excel’s Trace Error auditing tool helps you to discover the source of formula errors on your worksheet. The Trace Error tool draws arrows from the cell that causes the error to the active cell that contains the error. Should you have a relatively complex formula, this feature can save you a lot of time in trying to track down formula inaccuracies. Some typical error values are: #VALUE - The wrong type of operand or value is used in the formula #DIV/0! - Occurs when a number is divided by zero. #REF - The cell reference in the formula is not...

Read more →

How to set the default font in Microsoft Word

Posted by Roger Hyttinen on

How to set the default font in Microsoft Word

If you find yourself changing the same font settings over and over in your Microsoft Word documents, you can save yourself time by changing the default font in the Normal template. Once you do so, the default font settings will be applied automatically to any new documents that you create. To Set the Default Font for New Microsoft Word Documents Create or open a new Word document. Click the Font dialog launcher on the Home Ribbon.  Select the font settings that you want applied to all new documents. Click the Set as Default button. When the dialog box appears, click...

Read more →

PowerPoint 2016 Level 1 - Now available for download

Posted by Roger Hyttinen on

PowerPoint 2016 Level 1 - Now available for download

Microsoft PowerPoint 2016 Level 1 is now available for download from the PCM Courseware library. You can preview the first three chapters of each course from our Microsoft PowerPoint page. Microsoft Excel 2016 Level 3 is forthcoming.

Read more →

How to convert data to Proper Case in Excel

Posted by Roger Hyttinen on

How to convert data to Proper Case in Excel

Last week, a collegue sent me a list of data that was in all uppercase. He asked me if I knew of any way to convert it into proper case, in which the first letter of each word capitalized. The answer: Use the “Proper” Function. Here’s how to convert uppercase (or lowercase) list to sentence case. Let’s say that the list that we want to convert was in A3:A130. In cell B1 type: =Proper(A3) Drag-copy the formula down to B130. With the Range B3:B130 still selected, press the Ctrl-C keystroke combination to copy the data to the clipboard. Press Ctl-Alt-C...

Read more →

How to Track Changes in Microsoft Word

Posted by Roger Hyttinen on

How to Track Changes in Microsoft Word

  If you have a document that is being worked on by many people and want to be able to review the changes made to it, use the Track Changes feature. The Track Changes feature highlights any changes made to the document by others and displays the changes either inline or in a colored balloon in the right margin. You then have the option later on of accepting or rejecting the changes. To turn on the Track Changes feature, click the Track Changes button arrow on the click the Track Changes button. You can also display all of your changes...

Read more →