Menu
Cart 0

PCM Courseware Blog

Adding a Date/Time Interval in Excel

Posted by Roger Hyttinen on

Adding a Date/Time Interval in Excel

One of the most common date calculations used is that of adding together a date and a date interval. For instance, if your customer invoices are due every 30 days, you would find the next due date by adding 30 to the last billing date. To add the number of days to a date, just use basic addition. For instance, if you wanted to add 30 days to today’s date, the syntax would be: =TODAY + 30 Adding Months & Years to a Date If we want to add months or years to a date, the formula becomes a little...

Read more →

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 →