PCM Courseware

Microsoft Word 2013 – Level 2 course now available

rhyttinen — Thu, 23 May 2013 14:22:46 +0000

We have just released the Microsoft Word 2013 – Level 2 course to the PCM Courseware library and it is now available for download. You can check out the course at our Web site at: http://pcmcourseware.com/word.html

Access 2013 Level 2 is forthcoming.Similar Posts:

Access 2013 – Level 1 course now available

rhyttinen — Thu, 11 Apr 2013 17:27:48 +0000

We have just released the Access 2013 – Level 1 course to the PCM Courseware library and it is now available for download. You can check out the course at our Web site at: http://pcmcourseware.com/access.html

PowerPoint 2013 Level 1 is forthcoming.Similar Posts:

Creating and Displaying Scenarios in Excel

rhyttinen — Mon, 11 Mar 2013 16:09:15 +0000

Scenarios allow you to create and save several versions of your worksheet and enable you to see how changing one or more of your worksheet’s values affects the other values in your worksheet. Using an example of purchasing a home, we could create several different scenarios to see how changing the interest rate and downpayment would affect the value of our monthly payment.

Once you have chosen the cells whose data you want to change and saved your scenario for later review, you can easily display and/or print the scenario when needed. You also have the option of printing a Summary Report to view your current values and your scenarios side-by-side.

To Use Scenarios

Click the Data tab on the Ribbon.
Click the What-if Analysis button and click Scenario Manager from the menu.
Click the Add button.
Enter a name for your scenario in the Scenario Name box.
Click in the Changing Cells box.
Hold down the Ctrl key and select the cells in your worksheet that you wish to change.
In the Scenario Values dialog box, enter in the new values.
Click OK.
To Apply a Scenario to your worksheet, select the desired Scenario and then click Show.
Click Close.

Similar Posts:

Use Solver to Resolve Problems in Excel

rhyttinen — Thu, 07 Mar 2013 16:35:46 +0000

Solver allows you to resolve problems where you know your target but two or more variables remain unknown. It is used to help find an optimal solution to a problem. For example, you might want to purchase a home but can only afford $800 a month. Solver can figure out how to best adjust the variables – price of the home, downpayment, etc. to help you reach your goal.

To use Solver to help you find an optimal solution, define the formula you want to change (the target) and then tell Solver which cells it can adjust in order to reach your goal. Solver will then present you with a solution that you can either keep or discard. If you choose to discard the solution, your original values will be restored.

When choosing the cells you want to adjust in order to reach your target, you have the option of setting constraints which limit the values that Solver can set. In the Example above, we set a constraint of a down payment less than or equal to $10,000.

Note: If you do not see Solver button on the Data Ribbon, it is not yet installed. To install Solver, click File tab, click Options, click the Add-ins category, click Solver Add-in from the View and Manage combo box and then click the Go button. Click the Solver Add-in and then click OK to install it.

To Use Solver

Click the Data tab on the Ribbon.
Click the Solver button on the Analysis group of the Ribbon.
Click in the Set Objective box and then select (or type in) the cell that contains the formula of your target.
Select the Max, Min or Value of radio button.
If you chose “Value of” in Step 4, type your desired result in the Value of: text box.
Click in the By Changing Variable Cells: text box, select the cells in your worksheet whose values Solver can adjust to reach your target goal. Use the Ctrl key to select more than one cell.
To add constraints, click Add, select the cell to constrain, select the appropriate comparison operator, and then type in the constraint.
To add another constraint, click Add.
Click the desired Solving Method from the Select a Solving Method drop-down list.
Click OK when finished.
Click Solve.
Select Keep Solver Solution to accept Solver’s changes and then click OK. To ignore Solver’s solution, click Cancel. (Note: if you click Restore Original Values, the formula in your target cell will be replaced by the actual value of the formula).

Similar Posts:

Using Flash Fill – a new feature in Excel 2013

rhyttinen — Tue, 26 Feb 2013 06:00:17 +0000

A handy and time-saving new feature in Excel is the Flash Fill feature. As you begin typing data, Flash Fill allows you to fill in empty cells based upon patterns that already exist in your spreadsheet. For instance, if you have a field that combines the first names and last names of your customers into one field, you can easily split them into separate fields using Flash Fill. Likewise, you can combine separate fields into one using the same method. If you have a huge spreadsheet, you don’t even have to click and drag to fill in the cells – Flash Fill does it for you.

As you type, Excel begins filling in information for the rest of that field. Additionally, it displays how subsequent rows will be filled in. Once you fill in the data, a Flash Fill Options button appears, allowing you to Undo the Flash Fill if you don’t like the results. You also can select all of the remaining cells in the series in order to change their formatting, if you so desire.

To Use Flash Fill to Copy Data or a FormulaBegin typing in the cell.

When Flash Fill suggestions appear, press the Enter key.
To Undo Flash Fill or to select all of the cells that Flash Fill has filled in, click the Flash Fill button and then make your selections.

Similar Posts:

Excel 2013 – Level 1 course now available at PCM Courseware

rhyttinen — Wed, 13 Feb 2013 16:11:28 +0000

We have just added the Microsoft Excel – 2013 Level 1 course to the PCM Courseware Library. You can view an outline or preview of the course from our Excel page at: http://pcmcourseware.com/excel.html

Excel 2013 – Level 2 is forthcoming.Similar Posts:

Photoshop CS6 Courseware now available

rhyttinen — Mon, 04 Feb 2013 14:15:18 +0000

PCM Courseware has just released courseware (training manuals) for Photoshop CS6 – Level 1 and it is available for download. To view a preview and outline of the course, visit our Photoshop page at:

http://pcmcourseware.com/photoshop.html

Similar Posts:

Windows 8 Courseware Now Available in PCM Courseware Library

rhyttinen — Fri, 14 Dec 2012 16:58:20 +0000

Microsoft Window 8 courseware is now available in the PCM Courseware library. You can check it out here: http://pcmcourseware.com/windows.htmlSimilar Posts:

Word 2011 Level 3 Courseware Added to PCM Courseware Library

rhyttinen — Thu, 25 Oct 2012 17:41:49 +0000

Microsoft Word 2011 Level 3 courseware as just been added to the PCM Courseware Library. PowerPoint 2011 Level 2 will be forthcoming.

Similar Posts:

Convert Text to Columns in Excel

rhyttinen — Mon, 22 Oct 2012 15:24:35 +0000

A welcome feature in Excel is the Convert Text to Columns Wizard, which allows you to separate simple cell contents, such as first and last names into distinct columns. The Convert Text to Columns Wizard uses a delimiter such as a space or a comma to determine where to separate the columns. For example, the name “Dan Baker” uses the space delimiter. To launch the wizard, click the Text to Columns button on the Data Ribbon.

To Convert Text to Columns

Select the cell range that you want to split into columns.
Click the Data tab on the Ribbon.
Click the Text to Columns button on the Data Tools group.
Click the Delimited radio button.
Click Next.
Select the delimiter type you want to use.
Clear any of the other delimiter check boxes.
Click Next.
Click a column in the preview window and click the Text radio button. Repeat for each column that you are converting.
Click the Collapse Dialog Box button to the right of the Destination text box and select the destination for the new columns.
Click the Expand Dialog Box button.
Click Finish.

Similar Posts: