Course Outline

Microsoft Excel 2007 - Level 1
This class is designed for the beginning Excel user; no previous experience with Excel is needed. Participants will learn to create worksheets and to enter and format numbers and text. The class covers basic Excel functions and formulas, simple charts, and printing reports from Excel. 6 Hours
Getting Started
Understanding pointer shapes
Undo and Redo
The Microsoft Office Fluent User Interface
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
Using Format Groups on the Ribbon’s Home tab
Format Cells command		 Editing Worksheets
Moving and copying cells
Inserting a comment
Inserting and deleting a worksheet
Copying a worksheet
Exporting a worksheet

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
Using the Ribbon’s Page Layout tab
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
Embedded charts vs. separate charts
Prerequisites:  Familiarity with Windows.
Revised 11/27/2007
Return to Class Schedules             Computer Magic Training Home Page
Computer Magic Training • 4030 Moorpark Avenue • Suite 108 • San Jose, California 95117 • 408-261-2600