Menu
Cart 0

PCM Courseware Blog

Make a Backup of your Word or Excel Macros

Posted by Roger Hyttinen on

Make a Backup of your Word or Excel Macros

If you are a heavy Microsoft Word or Excel macro user, you may have experienced this scenario: After a Microsoft Office update, all of your beloved macros are gone. Poof! This has happened to me more than once and now I’ve learned to backup up my macros. This is actually a lot easier than you may think. What I do, is display the code for any of my macros, choose Select All from the menu, copy my macros to the clipboard and then paste the code into an external document. This can be and Evernote or OneNote note, a plain...

Read more →

Using the IF function in Excel

Posted by Roger Hyttinen on

Using the IF function in Excel

Using the powerful IF function, you can tell Excel to evaluate a condition and perform one of two calculations based on that condition. The two calculations are dependent on whether the condition is true or false. For example, if the sales of a store was greater than $60000, you could give the manager a $2,000 bonus (condition is true); if the sales were less than $60000, the manger would get a $50 bonus (condition is false). You can either type the IF function directly into the cell or click the Insert Function button and use the Insert Function dialog box....

Read more →

How to display the Developer tab (and macros) in Word

Posted by Roger Hyttinen on

The option to create and edit macros in Word is located on the Developer tab on the Ribbon. However, it’s hidden by default so you’ll need to go into your Word Options to display it. The Developer checkbox is located under the Customize Ribbon category in the Customize the Ribbon window. To Display the Developer Tab: Click the File tab on the Ribbon and click Options. Click Customize Ribbon in the left pane. In the Customize the Ribbon window on the right, click the checkbox next to Developer to check it. Click OK. The Developer tab will now display on the...

Read more →

How to change the keyboard shortcut for a macro in Word

Posted by Roger Hyttinen on

How to change the keyboard shortcut for a macro in Word

Have you ever created a macro and then forgotten the keyboard shortcut for it? Or perhaps you want to change the keyboard shortcut for a macro to something easier to remember. Whatever the reason, changing the shortcut is easy – as long as you know where to look, that is. You might think that it would be somewhere in the Visual Basic macro code. But alas, it is not. It’s actually located under the Customize Ribbon category of Word Options. To Change the Keyboard Shortcut of a Macro Click the File tab on the Ribbon and then click Options. In...

Read more →

Microsoft Access 2016 Level 1 is now available for download

Posted by Roger Hyttinen on

Microsoft Access 2016 Level 1 is now available for download

Microsoft Access 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 Access page. Microsoft Access 2016 courses are forthcoming.

Read more →