Menu
Cart 0

PCM Courseware Blog

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 →

Using Excel's Sparklines

Posted by Roger Hyttinen on

Using Excel's Sparklines

A handy feature in Excel is Sparklines. A Sparkline is a little chart that displays in the background of a cell and can help you to spot data trends at a glance. Sparklines take little room (the contents of one cell) and allow you to get a glance of your underlying data and a graphical representation of data trends right next to each other. What’s especially handy, is that if you change any of the underlying data, the Sparklines update instantly. Sparklines can be added from the Insert tab of the Ribbon. To Insert Sparklines into your Worksheet Click the...

Read more →

Inserting Symbols and Special Characters in Microsoft Word

Posted by Roger Hyttinen on

Inserting Symbols and Special Characters in Microsoft Word

Microsoft Word supplies hundreds of special characters that do not appear on your keyboard that you can use in your documents. For example, you can insert international symbols such as ć or ñ, symbols such as a trademark symbol (®), em dash (—), copyright symbol (©) and many more. Each font set contains its own set of symbols or characters. The Windings and Monotype Sorts contain a nice variety of useful characters. You can insert a recently used symbol by clicking the symbol in the Recently used symbols list in the Symbol dialog box. The Special Characters tab displays a...

Read more →