Menu
Cart 0

PCM Courseware Blog

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 →

Adding Symbols with AutoCorrect in Microsoft Word

Posted by Roger Hyttinen on

Adding Symbols with AutoCorrect in Microsoft Word

The AutoCorrect feature in Word comes with several predefined symbols that you can automatically insert in your documents by tapping the appropriate shortcut keys. Below are some handy ones to get you started (c) will insert this: ©(tm) will insert this: ™(r) will insert this: ®(e) will insert this: €--> will insert this: →<-- will insert this: ←This can be a time-saver if you add these symbols to your documents on a regular basis. In the next post, we'll look a bit more at working with symbols and special characters.

Read more →

Microsoft Access 2016 - now available for download

Posted by Roger Hyttinen on

Microsoft Access 2016 - now available for download

Microsoft Access 2016 Level 2 is now available for download from the PCM Courseware library. You can preview the first three chapters of each course from our Microsoft Access page. Microsoft PowerPoint courses are forthcoming.

Read more →