Moving From 123 Win To Excel: Select Feat

This course is provided by Wintrac. Wintrac provides one stop shopping for all your IT training needs. Wintrac’s course catalog of over two thousand courses includes courses on Desktop Application Software training, database training, E-Mail/Groupware training, Office Suite training, Operating Systems training, Presentations training, Spreadsheets training, Web Browsers training and Word Processing training

Overview

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.

Please contact your training representative for more details on having this course delivered onsite or online

Training Outlines - the one stop shopping center for IT training.
© Training Outlines All rights reserved