Microsoft®
Excel 2003 Level 1
Prerequisites:
Students must be familiar and comfortable working in a Windows environment to progress to this level.
Course Content:
The Fundamentals
- Starting Excel
- What's New in Excel 2003?
- Understanding the Excel
Program Screen
- Using Menus
- Using Toolbars and Creating
a New Workbook
- Hiding, Displaying, and
Moving Toolbars
- Filling Out Dialog Boxes
- Keystroke and Right Mouse
Button Shortcuts
- Opening a Workbook
- Saving a Workbook
- Moving the Cell Pointer
- Navigating a Worksheet
- Entering Labels in a
Worksheet
- Entering Values in a
Worksheet and Selecting a Cell Range
- Calculating Value Totals
with AutoSum
- Entering Formulas
- Using AutoFill
- Previewing and Printing a
Worksheet
- Getting Help from the
Office Assistant
- Changing the Office
Assistant and Using the "What's This?" Button
- Closing a Workbook and
Exiting Excel
Editing a Workbook
- Entering Date Values and
Using AutoComplete
- Editing, Clearing, and
Replacing Cell Contents
- Cutting, Copying, and
Pasting Cells
- Moving and Copying Cells
with Drag and Drop
- Collecting and Pasting
Multiple Items
- Working with Absolute and
Relative Cell References
- Using the Paste Special
Command
- Inserting and Deleting
Cells, Rows, and Columns
- Using Undo, Redo, and
Repeat
- Checking Your Spelling
- Finding and Replacing
Information
- Advanced Printing Options
- File Management
- Inserting Cell Comments
- Understanding Smart Tags
- Recovering Your Workbooks
Formatting a Worksheet
- Formatting Fonts with the
Formatting Toolbar
- Formatting Values
- Adjusting Row Height and
Column Width
- Changing Cell Alignment
- Adding Borders
- Applying Colors and
Patterns
- Using the Format Painter
- Using AutoFormat
- Creating a Custom Number
Format
- Creating, Applying, and
Modifying a Style
- Formatting Cells with
Conditional Formatting
- Merging Cells, Rotating
Text, and using AutoFit
- Finding and Replacing Formatting
Managing Your Workbooks
- Switching Between Sheets in a
Workbook
- Inserting and Deleting
Worksheets
- Renaming and Moving
Worksheets
- Working with Several
Workbooks and Windows
- Splitting and Freezing a
Window
- Referencing External Data
- Creating Headers, Footers,
and Page Numbers
- Specifying a Print Area and
Controlling Page Breaks
- Adjusting Page Margins and
Orientation
- Adding Print Titles and
Gridlines
- Changing the Paper Size and
Print Scale
- Protecting a Worksheet
- Hiding Columns, Rows and
Sheets
- Viewing a Worksheet and
Saving a Custom View
- Working with Templates