Menu
Cart 0

PCM Courseware Blog

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 →

How to Subtract Dates in Excel

Posted by Roger Hyttinen on

How to Subtract Dates in Excel

In yesterday’s post, we looked at how to add two dates together in Excel. Today, we going to look at how to subtract dates. If you want to calculate how much time has passed between two dates, you need simply subtract the oldest date from the most recent date. For example, if the value in cell A1 was 12/31/2014 and the value in cell B1 was 9/3/2014, your formula would read: =A1 – B1 The resulting answer would be 4/28/1900 – hardly what we expected. In order to get the correct response, we need to format the cell where the...

Read more →