Menu
Cart 0

PCM Courseware Blog

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 →

Working with Fractions in Excel

Posted by Roger Hyttinen on

Working with Fractions in Excel

  You can format numbers in Excel so that they display fractions in old-school format, such as 3/4 or 1/2 from the Format Cells dialog box. Excel also supports compound fractions such as 4 1/2. Format Numbers a Fractions Select the cells you want to format. Right-click the selected cells and choose choose Format > Cells from the menu Or Click the dialog launcher on the Number group of the Ribbon. Click the Fractions category in the left pane. Choose the fraction format you want from the Type: window. You can also apply the Fraction format automatically as you enter...

Read more →