KnowledgeAir

 
  • Increase font size
  • Default font size
  • Decrease font size

Excel 2003 Level 1

Hours: 4

Short Description:

You have basic computer skills such as using a mouse, navigating through windows, and surfing the Internet. You have also used paper-based systems to store data that you run calculations on. You now want to migrate that data to an electronic format. In this course, you will use Microsoft® Office Excel 2003 to manage, edit, and print data.

Course Outline:

Lesson 1; Getting Started with Excel An Overview of Excel

Navigate in Excel
Select Data
Enter Data
Save a Workbook
Obtain Help

Lesson 2: Modifying a worksheet

Move and Copy Data Between Cells
Fill Cells with Series of Data
Edit Cell Data
Insert and Delete Cells, Columns & Rows
Find, Replace, and Go To Cell Data
Spell Check a Worksheet

Lesson 3: Performing Calculations

Create Basic Formulas
Calculate with Functions
Copy Formulas and Functions
Create an Absolute Reference

Lesson 4: Formatting a Worksheet

Change Font Size and Type
Add Borders and Color to Cells
Change Column Width and Row Height
Merge Cells
Apply Number Formats
Create a Custom Number Format
Align Cell Contents
Find and Replace Formats
Apply an AutoFormat
Apply Styles

Lesson 5: Developing a Workbook

Format Worksheet Tabs
Reposition Worksheets in a Workbook
Insert and Delete Worksheets
Copy and Paste Worksheets
Copy a Workbook

Lesson 6: Printing Workbook Contents

Set a Print Title
Create a Header and a Footer
Set Page Margins
Change Page Orientation
Insert and Remove Page Breaks
Print a Range

Lesson 7: Customizing Layout

Split a Worksheet
Arrange Worksheets
Freeze and Unfreeze Rows and Columns
Hide and Unhide Worksheets
Find out more about Excel training in Buffalo