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,
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 the skills and concepts necessary to begin using the charting and list-management capabilities of Excel 97. Students should have a basic knowledge of the concepts involved in using Excel 97 for Windows 95 worksheets. For example, they should be familiar with data types (text, numbers, and formulas) and the use of the menu system for copying data and for opening and saving files.
Prerequisites
To ensure students’ success with this course, we recommend that they first take the following Content courses or have equivalent knowledge:
- Windows 95: Introduction
- Excel 97: Worksheets (Windows 95)
Performance-Based Objectives
- Create charts that graphically represent worksheet data.
- Modify charts.
- Customize charts by applying formatting.
- Enhance worksheets and charts by using the drawing tools to add graphic objects.
- Sort information in a list by using the Data, Sort command.
- Locate and manage information in a list that meets specified conditions by using
the Advance filter feature.
Delivery Method
Instructor-led, group-paced, classroom-delivery learning model with structured, hands-on activities.
Course duration
1 Day(s)
Course outline
Lesson 1: Creating charts
- Topic 1A: Creating a chart sheet
- Topic 1B: Creating an embedded chart
- Topic 1C: Comparing chart sheets with embedded charts
Lesson 2: Modifying charts
- Topic 2A: Chart types
- Topic 2B: Modifying embedded charts
- Topic 2C: Adding and deleting chart items
- Topic 2D: Moving and sizing chart items
Lesson 3: Formatting a chart
- Topic 3A: Formatting chart text
- Topic 3B: Formatting numbers
- Topic 3C: Formatting the chart
- Topic 3D: Printing a chart sheet
Lesson 4: Using graphic objects
- Topic 4A: Adding graphic objects
- Topic 4B: Formatting graphic objects
- Topic 4C: Using graphic objects to enhance worksheets and charts
Lesson 5: Sorting data
- Topic 5A: Single-level sorting
- Topic 5B: Multiple-level sorting
- Topic 5C: Sorting options
- Topic 5D: Design considerations
Lesson 6: Filtering data
- Topic 6A: Filtering a list
- Topic 6B: Custom criteria
- Topic 6C: Multiple-condition criteria
- Topic 6D: Managing a filtered list
Appendix A: Querying data
- Database functionsTopic
- External databases and queriesTopic
- Excel 97 and the InternetTopic
Hardware/Software Requirements
You will need:
- a minimum of 8 megabytes (MB) of Random Access Memory (RAM);
- a minimum of 20 MB of hard-disk space available for Excel, after Windows 95
is installed;
- a 386 DX or higher processor (486 recommended);
- a typical installation of Windows 95; and
- a custom installation of Excel 97 from Microsoft Office 97 for Windows 95.
