# PCM Courseware Blog

## 3 Types of Learning Styles

Posted by Roger Hyttinen on

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...

## How to use the COUNTIF Function in Excel

Posted by Roger Hyttinen on

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...

## How to take a screenshot in Excel

Posted by Roger Hyttinen on

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...

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

Posted by Roger Hyttinen on

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...