Menu
Cart 0

PCM Courseware Blog

3 Types of Learning Styles

Posted by Roger Hyttinen on

3 Types of Learning Styles

This post is part of the “Effective Technical Trainer” series. There is a theory called Neurolinguistic Programming which suggests that not everyone learns in the same manner. In fact, this theory has narrowed down learning to three distinct styles that determine how people (your students) retain and retrieve information. I can personally vouch for this theory. In my experience as a software trainer, I regularly encounter students who tend to learn best according to one of these three learning styles (some folks use a combination of two – some use all three modalities). As a trainer, it’s important to keep...

Read more →

How to use the COUNTIF Function in Excel

Posted by Roger Hyttinen on

How to use the COUNTIF Function in Excel

The COUNTIF function in Excel comes in handy if you need to know how many occurrences of something appears in a range of data. For instance, if you have a list of movies, you could view a count of the number of movies before 2014. The COUNTIF function consists of 2 arguments: The cell range and the criterion. Using the example above, let’s say that the Year cell range for our movies is B2:B400. If we wanted to find out how many movies in our list were made prior to 2014, our formula would read: =COUNTIF(B2:B400, “<2014”) As we can...

Read more →

How to take a screenshot in Excel

Posted by Roger Hyttinen on

How to take a screenshot in Excel

A handy feature in Excel is the ability to take a screenshot directly from within an Excel document. The Screenshot tool is located on the Illustrations group of the Insert Ribbon. When you click the Screenshot button, several screenshot samples from your open documents will display. You can either choose from the available sample screenshots or take your own screenshot by clicking the Screen Clipping option. If you select Screen Clipping, the active Excel document will be minimized and a resizable window will appear over next open window (whether this be another open document or your Desktop). Note that the...

Read more →

How quickly to jump to the last cell with data in Excel

Posted by Roger Hyttinen on

How quickly to jump to the last cell with data in Excel

When you press Ctrl key and any of the arrow keys (left, right, up or down), you will jump to the last populated cell in that direction. For example, pressing the Ctrl + Down Arrow key wFor example, pressing the Ctrl + Down Arrow key will move downward to the last cell that contains data. This is an excellent way to move quickly to the bottom row in your spreadsheet, especially if your worksheet is lengthy. If you want to jump no the last populated cell and also select all the cells in between, hold down the Shift key as...

Read more →

How to Resend a Message in Outlook

Posted by Roger Hyttinen on

How to Resend a Message in Outlook

Has someone ever asked you to resend a message that you’ve previously sent to them? Or perhaps you want to send the same message you sent to someone else without copying/pasting or forwarding it. There’s an easy way to do this in Outlook, which many people aren’t aware of. Here’s how. To Resend a message in Outlook Click to open your Sent Items folder in the left pane. Double-click the message you want to resend. This will open it in the message window. Click the Actions button on the Move group of the Ribbon.  Click Resend This Message in the...

Read more →