Microsoft Office 2010 Now Shipping

by rhyttinen on June 18, 2010

Microsoft Office 2010 Image

In case you haven’t heard, Microsoft Office 2010 is now shipping.  The Business and Profession version includes Word 2010, PowerPoint 2010, Excel 2010, Outlook 2010, Access 2010, Publisher 2010 and OneNote 2010.

PCM Courseware has already begun working on courseware for this new version.  Courses will be released in the coming weeks.  All new orders will include the Office 2010 courses upon their release.

You can purchase Microsoft Office 2010 HERE.

{ 0 comments }

Enter Data into Noncontiguous Cells in Excel

by rhyttinen on May 18, 2010

If you have the same data that you need to enter into several cells that are not next to each other, there is no need to enter it in manually or use copy and paste. Simply select the noncontiguous cells and use Ctrl + Enter to fill the cells with your data.

To enter data all at once into noncontiguous cells:

  1. Hold down the Ctrl key and select all of the cells into which you want to enter data (Holding down the Ctrl key allows you to select noncontiguous cells).
  2. Type your data.
  3. Press the Ctrl + Enter keystroke combination. Excel will enter the data you typed into all of the cells you selected.

{ 0 comments }

Setting Grammar Options in Word

May 13, 2010

Most people know that Word will check and fix your grammar for you. For example, it can check for sentence fragments, misused words, verb phrases, punctuation and more. However, this may not always be what we want – and some folks find this feature downright annoying. Luckily, Word allows you to pick and choose which [...]

Read the full article →

Quick Navigation in Excel using Ctrl and Arrow Keys

May 11, 2010

Using the Ctrl key and an arrow key, you can quickly navigate to the last populated cell in any direction. Thus, Ctrl + Right Arrow brings you to the last populated cell on the right side of your page, Ctrl + Down Arrow brings you to the last cell with data in the worksheet, etc. [...]

Read the full article →

Quickly Toggle the Display of Formulas in Excel Worksheet Cells

May 10, 2010

You may or more not know that you can display all of the Formulas in your worksheet by clicking the Formulas tab on the Ribbon and then clicking the Show Formulas button on the Ribbon. This will display the actual formula in each cell of your worksheet that contains one.
But you can also toggle the [...]

Read the full article →

Remove Spaces from Imported Excel Data

May 3, 2010

Very often, data that is imported into Excel needs to be formatted. You may find that when importing numbers, Excel will import your data as a text format – and often with spaces before the data. Converting the text to a number format using the Format Cells command will not clear the spaces – they [...]

Read the full article →

Create a Workspace in Excel

April 23, 2010

You may find yourself needing to compare two worksheets in the same workbook simultaneously or needing to work on two worksheets at the same time. With Excel, you can view multiple worksheets in your workbook in the same window by using the New Window and Arrange All commands on the View Ribbon. This is referred [...]

Read the full article →

Alignment and Text Wrapping in Excel

April 22, 2010

When entering data into cells, the default alignment is left-aligned along the bottom for text and right-aligned along the bottom for numbers. Excel supplies many other alignment options from which to choose – left alignment, right alignment, center alignment, as well as horizontal and vertical alignment options.
The alignment options are available on the Alignment group [...]

Read the full article →

Reposition Worksheets in Excel

April 21, 2010

After you begin creating worksheets in your workbook, you may decide that the worksheets are not in the order that you would like. You can rearrange the worksheets in your workbook by clicking the tab of the worksheet you would like to move and then dragging it to the new location. As you drag, a [...]

Read the full article →

Using 3-D Formulas and References in Excel

April 20, 2010

When you want to create a formula which uses data from several worksheets, you create a 3-D Formula. A 3-D Formula is created using 3-D References, that is to say, references to cells in a different worksheet. To create a 3-D Reference, the format is:
‘Sheet Name’!Cell Name
For example, suppose we have three sheets named 2000, [...]

Read the full article →

← Previous Entries