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 probably get the most out of this course if they want to learn the skills and concepts necessary to begin using the charting and list-management capabilities of Excel 2000 or if they need to create charts to graphically represent worksheet data or to maintain and manage lists at their workplace. Students should have a basic knowledge of the concepts involved in using Excel 2000 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 98: Introduction
- Excel 2000: Worksheets
Target Student
Students enrolling in this course should understand data types (text, numbers, and formulas) and the use of the menu system for copying data and for opening and saving files.
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 Advanced Filter feature.
What's next
Excel 2000: Advanced is the third course in this series. Students can take Excel 2000: Advanced to learn advanced features.
Delivery Method
Instructor-led, group-paced, classroom-delivery learning model with structured, hands-on activities.
Certification
Excel 2000: Charting and Organizing Data is one of a series of courseware titles that addresses Microsoft Office Specialist (Office Specialist) skill sets. The Office Specialist program is for individuals who use Microsoft's business desktop software and who seek recognition for their expertise with specific Microsoft products. Certification candidates must pass one or more product proficiency exams in order to earn Office Specialist certification.
Benefits
Students will learn how to represent data graphically and maintain and manage lists.
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 Labels
- 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: Importing Data
- Topic 5E: 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: Additional Topics
- Database Functions
- Excel Web Pages and the Internet or an Intranet
Hardware/software Requirements
You will need:
- A minimum of 32 megabytes (MB) of Random Access Memory (RAM).
- A minimum of 500 MB of available hard-disk space for Office
2000, after Windows 98 is installed.
- A Pentium 90 or higher processor.
- A typical installation of Windows 98.
- A full-suite installation of Microsoft Office 2000 for Windows
98, using a full installation, installing everything.
- Though printers are not required, you’ll need an installed
print driver.
