Events Calendar Print Email help
Flat View
See by year
Monthly View
See by month
Weekly View
See by week
Daily View
See Today
Search
Search
Microsoft Excel 2003: Level 1

 Overview: Microsoft Excel 2003: Level 1

This course is designed for persons who desire to gain the skills necessary to create, edit, format, and print basic Excel 2003 worksheets.

Course Outline:

Lesson 1: Getting Started with Excel
A: An Overview of Excel
B: Navigate in Excel
C: Select Data
D: Enter Data
E: Save a Workbook
F: Obtain Help

Lesson 2: Modifying a Worksheet
A: Move and Copy Data Between Cells
B: Fill Cells with Series of Data
C: Edit Cell Data
D: Insert and Delete Cells, Columns, and Rows
E: Find, Replace, and Go To Cell Data
F: Spell Check a Worksheet

Lesson 3: Performing Calculations
A: Create Basic Formulas
B: Calculate with Functions
C: Copy Formulas and Functions
D: Create an Absolute Reference

Lesson 4: Formatting a Worksheet
A: Change Font Size and Type
B: Add Borders and Color to Cells
C: Change Column Width and Row Height
D: Merge Cells
E: Apply Number Formats
F: Create a Custom Number Format
G: Align Cell Contents
H: Find and Replace Formats
I: Apply an AutoFormat
J: Apply Styles

Lesson 5: Developing a Workbook
A: Format Worksheet Tabs
B: Reposition Worksheets in a Workbook
C: Insert and Delete Worksheets
D: Copy and Paste Worksheets
E: Copy a Workbook

Lesson 6: Printing Workbook Contents
A: Set a Print Title
B: Create a Header and a Footer
C: Set Page Margins
D: Change Page Orientation
E: Insert and Remove Page Breaks
F: Print a Range

Lesson 7: Customizing Layout
A: Split a Worksheet
B: Arrange Worksheets
C: Freeze and Unfreeze Rows and Columns
D: Hide and Unhide Worksheets

Location : Norton, MA

Back