PCM Courseware

Microsoft Office 2010 Now Shipping

rhyttinen — Fri, 18 Jun 2010 03:37:55 +0000

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.Similar Posts:

None Found

Enter Data into Noncontiguous Cells in Excel

rhyttinen — Tue, 18 May 2010 15:26:22 +0000

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:

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).
Type your data.
Press the Ctrl + Enter keystroke combination. Excel will enter the data you typed into all of the cells you selected.

Similar Posts:

Setting Grammar Options in Word

rhyttinen — Thu, 13 May 2010 15:51:19 +0000

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 grammar and/or style rules to check for.

To Modify Grammar Settings:

Click the Microsoft Office button.
Click the Word Options button.
In the left pane, click Proofing.
If you wish Word to stop checking grammar and/or spelling, uncheck the appropriate boxes in the “When correcting spelling and grammar in Word” area.
Click the drop-down list in the “When correcting spelling and grammar in Word” area and choose to have Word check either Grammar Only or Grammar and Style.
To specify which grammar rules Word is to check for, click the Settings button under the “When correcting spelling and grammar in Word” area.
In the Grammar Settings dialog box, uncheck any of the checkboxes next to the rules for which you do not want Word to check.
Click OK to close the Grammar Settings dialog box.
Click OK to close the Word Options dialog box.

Similar Posts:

Quick Navigation in Excel using Ctrl and Arrow Keys

rhyttinen — Tue, 11 May 2010 16:00:22 +0000

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. This is much faster than pressing the Page Down key to find the last row of data in your worksheet.

Additionally, if you press the Ctrl + Arrow + Shift keystroke combination, Excel will select all of the data between the active cell and the end of the range, as determined by which arrow key you press.Similar Posts:

Quickly Toggle the Display of Formulas in Excel Worksheet Cells

rhyttinen — Mon, 10 May 2010 15:42:32 +0000

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 display of formulas from any tab of your worksheet by using the Ctrl and ~ keystroke combination (Ctrl + ~). If you wish to display the dependent cells for a specific formula as well, select the cell for whose formula you wish to show dependencies.

To Toggle the Display of Formulas in Cells:

Press the [Ctrl] and ~ keystroke combination.
To display dependent cells for a formula, select the cell before typing in the keystroke combination.

Similar Posts:

Remove Spaces from Imported Excel Data

rhyttinen — Mon, 03 May 2010 15:54:06 +0000

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

One way to remove any leading spaces from data in a cell is to use the Value and Trim function. For instance, if I wanted to remove the spaces from cell A4, the formula would be:

=VALUE(TRIM(A4))

If your goal is to remove the spaces AND convert the text data to number format, select the cells that contain the data, click the Smart Tag button and choose “Convert to Number”.

Similar Posts:

Create a Workspace in Excel

rhyttinen — Fri, 23 Apr 2010 06:00:46 +0000

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 to as Creating a Workspace. You will first need to open a second window and then position the worksheets in the desired arrangement (tiled, horizontal, vertical or cascade). Once you have attained the desired window arrangement, you can save your workspace or window arrangement for the next time you open the workbook.

To Create a Workspace

Open the workbook file(s) you for which you want to create a workspace.
Click the View Tab on the Ribbon.
Click the New Window button on the Window group to add a second window.
Click the Arrange All button on the Window group.
Click the check box next to Windows of Active Workbook.
Click the radio button next to the window arrangement you want.
Click the desired worksheet tabs in each window.

To Save a Workspace

Click the View Tab on the Ribbon.
Click the Save Workspace button on the Window group.
Navigate to the folder where you want to save your workspace.
Type the name for your workspace in the File name text box.
Click the Save button.

Similar Posts:

Alignment and Text Wrapping in Excel

rhyttinen — Thu, 22 Apr 2010 06:00:17 +0000

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 on the Home Ribbon:

Align Left – Aligns cell contents along the left edge of the cell
Align Right – Aligns cell contents along the right edge of the cell
Center – Centers the cell contents within the cell
Top Align – Aligns text to the top of the cell
Middle Align – Aligns text so that it is centered between the top and bottom of the cell
Bottom Align – Aligns text to the bottom of the cell
Orientation – Allows you to rotate text
Decrease Indent – Decrease the margin between the border and the text in the cell
Increase Indent – Increase the margin between the border and the text in the cell
Wrap Text – Wraps the text within a cell so it does not cross adjoining cells or get cut off

Alignment Commands

Other alignment options are available from within the Format Cells dialog box.

To Change the Alignment of Data within Cells

Select the cell or cell range whose data you wish to align.
Click the desired alignment button on the Alignment group on the Home Ribbon
OR

Select the cell or cell range whose data you wish to align.
Display the Format Cells dialog box.
Click the Alignment Tab.
Choose options from the Horizontal and/or Vertical combo box.
Select any desired additional options such as Wrap Text, Orientation or Text Direction.
Click OK.

Similar Posts:

Reposition Worksheets in Excel

rhyttinen — Wed, 21 Apr 2010 06:00:04 +0000

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 small black arrow appears marking the new location of the sheet should you release the mouse button.

To Reposition a Worksheet

Click and hold the left mouse button on the tab of the worksheet you wish to move.
Drag the worksheet to the new location.
Release the mouse button.

Tip: You can also move worksheets from the Move or Copy dialog box.Similar Posts:

Using 3-D Formulas and References in Excel

rhyttinen — Tue, 20 Apr 2010 19:14:19 +0000

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, 2001 and Yearly Totals. In the Yearly Totals sheet, we want to calculate the sum of the values in cell C18 from both the 2000 and 2001 sheets. Thus, our formula in the Yearly Totals worksheet would be:

=‘2001’!C18 + ‘2000’!C18

To use a function such as SUM, AVERAGE, etc. in our 3-D formula, the format is:

=SUM(‘Sheet1:Sheet2’!C12:C35)

You can create your 3-D formula yourself by typing it into the cell or you can manually select the appropriate worksheets and cells to include in your formula.

To Create a 3-D Formula

In the cell where you want your formula to display, type = and the beginning of the formula, such as: =Sum(
Group the worksheets whose data you will include in the formula if the data is in the same cell address in each worksheet.
Select the cell or cell range to include in the formula.
Type the remainder of the formula if applicable and press Enter.

Similar Posts: