Access 2013 – Level 1 course now available

by rhyttinen on April 11, 2013

If you're new here, you may want to subscribe to my RSS feed. Thanks for visiting!

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.

{ Comments on this entry are closed }

Creating and Displaying Scenarios in Excel

by rhyttinen on March 11, 2013

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.

Edit Scenario dialog box Excel image

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

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

{ Comments on this entry are closed }

Use Solver to Resolve Problems in Excel

March 7, 2013

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

Read the full article →

Using Flash Fill – a new feature in Excel 2013

February 26, 2013

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

Read the full article →

Excel 2013 – Level 1 course now available at PCM Courseware

February 13, 2013

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.

Read the full article →

Photoshop CS6 Courseware now available

February 4, 2013

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  

Read the full article →

Windows 8 Courseware Now Available in PCM Courseware Library

December 14, 2012

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

Read the full article →

Word 2011 Level 3 Courseware Added to PCM Courseware Library

October 25, 2012

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

Read the full article →

Convert Text to Columns in Excel

October 22, 2012

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

Read the full article →

Excel 2011 – Level 3 Now Available

October 16, 2012

We have just uploaded Excel 2011 – Level 3 courseware for Mac to our courseware library.  You can preview the course here:  http://pcmcourseware.com/excel-mac.html. To view a listing of all of our courses, please visit our Courses Page. Microsoft Word 2011 Level 3 is forthcoming.

Read the full article →