Lesson 1: Orientation to the Excel environment

• The workbook environment
• Converting a 1-2-3 for Windows file to Excel format
• Closing a workbook file

Lesson 2: Entering and working with data

• Entering data
• Working with formulas and functions
• Moving around in a worksheet

Lesson 3: Worksheet development and data formatting

• Moving and copying data
• Working with columns, rows, and ranges
• Formatting data

Lesson 4: Working with charts

• Creating a basic chart
• Modifying a chart
• Built-in AutoFormats

Lesson 5: Database topics

• Sorting data
• Filtering a list
• Maintaining a list with a data form

Lesson 6: Additional Excel features

• Printing in Excel
• Running and recording a macro

Additional information: This is an ExpressLine course.

You will need 8 megabytes (MB) of Random Access Memory (RAM) if you are using Excel. See your reference manual for hardware considerations that apply to your specific hardware setup. In addition, you will need printers if you want to print the worksheets created in the course.