Microsoft™ ExcelExcel 1

Level 1

Getting Started

	Starting Excel
	The Excel Window

Managing Worksheets Within a Workbook

	Naming Worksheets
	Inserting & Deleting Worksheets
	Moving Worksheets

Getting Around in the Worksheet

	Using the Mouse and the Keyboard
	Using the Menu System
	Accessing Functions With Shortcut Keys

Entering and Correcting Text, Data and Formulas

	Selecting Rows, Columns and Cells
	Types of Data
	Basic Entry Procedures
	Entering Data and Correcting While in Text Entry Mode
	Long Text Across Cell Boundaries
	Editing Cells

Formulas and Functions

	Basic Mathematical Formulas
	Function Formulas
	AutoSum

Opening, Closing and Saving a Worksheet File

Printing and the Print Preview Functions

	Previewing and the Print Preview Buttons
	Printing the Worksheet

Copying, Pasting, and the Fill Command

	Copying, Cutting, and Pasting
	AutoFill
	Moving Cells and Ranges

Relative and Absolute References

Controlling Worksheet Appearance

	Changing Column Widths and Row Heights
	Fonts and Related Attributes
	Formatting Numbers and Dates
	Alignment of Cells and Ranges
	Borders, Shading and Patterns

Page Setup

	Margins
	Headers and Footers

Inserting and Deleting Rows and Columns

Freezing Panes

Using the Toolbars

	Adding and Deleting Toolbars
	Moving Toolbars

The Spelling Check and AutoCorrect

Using the Help System