Moving From 123 Win To Excel: Select Feat

Students will learn how to apply their knowledge of electronic spreadsheets to the Excel environment.

Prerequisites

Windows orientation or equivalent knowledge; working knowledge of Lotus 1-2-3 for Windows versions 4 or 5.

Target Student

Students enrolling in this course should be familiar with the 1-2-3 for Windows worksheet environment and procedures, as well as procedures related to charting and database concepts.

Performance-Based Objectives

Lesson objectives help students become comfortable with the course, and also provide a means to evaluate learning. Upon successful completion of this course, students will be able to:

Understand the basics of the Microsoft Excel environment.
Manipulate data and navigate in Excel.
Move, copy, and format data in Excel.
Create and modify charts that represent worksheet data.
Sort and filter information in a list.
Explore additional Excel features.

Delivery Method

Instructor-led, group-paced, classroom-delivery learning model with structured, hands-on activities.

What's next

Students who want to learn advanced features can take Excel 5.0: Advanced.

Course duration

1 Day(s) Course outline

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.

Hardware/Software Requirements

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.