Microsoft Excel Fundamentals

Instructor:   Paul N. Lee, [Owner/Consultant of Nahee Enterprises]

This course, on the Microsoft Excel application, will have students beginning with the very basics and working their way up through more complex abilities.   The instructor will present several scenarios and exercises to allow skill practice for data entry, layout, formatting, printing, calculations, and much more.   Besides the class handout, a CD is supplied with 814 files of examples, templates, add-ins, training, help files, and tips/tricks (a total of over 225-MB of information).

The following is the outline used for this class:

  1. Beginning Basics.
    1. Getting started with Excel.
      1. Areas of the Application Window.
      2. Menus, Toolbars, Options, and Customizing.
    2. Accessing Files.
    3. Columns, Rows, and Cells.
      1. Selecting Cells.
      2. Single Cell.
      3. Multiple Cells and Ranges.
    4. Entering Data.
      1. Text.
      2. Numeric.
      3. Date/Time.
      4. Formula.
    5. Saving Workbooks.

  2. Working with Columns and Rows.
    1. Adjusting, Hiding, and Freezing.
    2. Inserting, Deleting, Cutting, Copying, and Pasting.
    3. Moving, and Clearing.
    4. Sorting.

  3. Working with Cells.
    1. Inserting, Deleting, Cutting, Copying, and Pasting.
    2. Formatting.
      1. Number, Alignment, Font, Border, Patterns, Protection.
      2. Conditional Formatting.
      3. AutoFormat.
    3. Styles.
    4. Finding and Replacing.
    5. Comments.

  4. Working with Worksheets and Workbooks.
    1. Moving and Copying.
    2. Viewing, Arranging, and Splitting.
    3. Workspaces.
    4. Basic Referencing.

  5. Printing.
    1. Page Setup Dialog.
      1. Page Orientation.
      2. Setting Margins.
      3. Custom Headers/Footers.
      4. Other Sheet Options.
    2. Defining print areas, and Page Breaks.

  6. Easy Calculations.
    1. Basic Operators.
    2. Basic Functions.
      1. Date functions.
      2. Financial functions.
        1. Forecast Loan Payments.
        2. Calculate Cumulative Interest.
        3. Compute Investment Value.

  7. Simple Charts.
    1. The Chart Wizard.
    2. Editing the Chart.
    3. Printing a Chart.