Course Outline

Microsoft Excel - Level 1
Let us make your introduction into the world of Excel fun and informative. We’ll take the mystery out of how to create worksheets, enter and format numbers, create simple formulas, and turn data into charts with one click of the mouse. You’ll begin to discover that Excel is a powerful tool that can help you simplify and automate how you work with numbers and data. 6 hours

Getting Started

  • Understanding pointer shapes
  • Undo and Redo
  • Excel's menus and toolbars
  • Activating another cell
  • Making selections within a worksheet
  • Using navigation keys
  • Working with sheet tabs

Creating a New Workbook


Entering Values

  • Entering labels (text)
  • Entering numbers
  • Entering dates
  • Changing column widths
  • Automatic date formatting
  • Number formatting
  • Using AutoComplete

Entering Formulas and Functions

  • Calculation operators in formulas
  • Order of operation precedence
  • Using the AutoSum function
  • Copying data within a row or column
  • Using AutoCalculate

Formatting a Worksheet

  • Formatting toolbar
  • Format Cells command

Editing Worksheets


Moving and Copying Cells


AutoFilling a Series


Creating a Custom Series


Relative vs. Absolute references

  • Relative references
  • Absolute and Mixed references
  • Switching between Absolute, Relative, and Mixed references

Preparing to Print

  • Formatting the sheet onscreen
  • Adding headers and footers
  • Repeating titles on every page
  • Changing the layout
  • Previewing and adjusting margins
  • Checking page breaks

Charting Basics

  • Anatomy of a chart
  • Choosing the best chart type
  • Selecting data
  • Creating an embedded vs. a separate chart
Prerequisites:  Macintosh Introduction, Microsoft Windows, or equivalent experience.

Revised 8/14/2011
Return to Class Schedules             Computer Magic Training Home Page
Computer Magic Training • 4030 Moorpark Avenue • Suite 108 • San Jose, California 95117 • 408-261-2600