|
Provided by: Serebra Learning Corporation Microsoft Excel 97 IntermediateExcel |
 |
Training
Provided by Serebra Learning Corporation
This highly interactive CBT contains six units that cover intermediate Excel skills. Through step-by-step instruction within a realistic simulation of Microsoft Excel 97, students learn how to work with formulas and functions, automate tasks, use and analyze list data, enhance charts and worksheets, and work with Excel and the Internet. Performance-based Pre- and Post-Assessments create a custom course path for each learner covering only the topics not yet mastered. A searchable index and online glossary make the CBT a great reference tool long after course completion. This course is designed for individuals who have basic proficiency in Microsoft Excel 97.
|
|
||||||||||
Microsoft Excel 97 Intermediate
Audience
This course is designed for individuals who have basic proficiency in Microsoft Excel 97.
Topics
Unit 1: Working with Formulas and Functions
- Creating a Formula with Several Operators
- Using Names in a Formula
- Generating Multiple Totals with AutoSum
- Using Dates in Calculations
- Building a Conditional Formula with the IF function
- Using Statistical Functions
- Calculating Payments with the PMT Function
- Displaying and Printing Formula Contents
Unit 2: Automating Worksheet Tasks
- Planning a Macro
- Recording a Macro
- Running a Macro
Objectives
Upon completion of this course, the student will be able to:Use names in a formula, and display and print formula content Generate multiple totals with AutoSum, and use dates in calculations Build a conditional formula, use statistical functions, and calculate payments with the PMT function Plan, record, run and edit a macro, and use the Personal Macro Workbook Plan, create, sort, print, extract, filter, summarize and validate data in a list Find, delete and retrieve recors, and add records with the data form Enhance charts and worksheets Create hyperlinks between Excel files and the Web, and create a web form Save an Excel file as an HTML document, and view Excel data in HTML format
About The Training Provider: Serebra Learning Corporation
Serebra Learning Corporation - Serebra Learning Corporation provides technology-based training solutions through a combination of Cortex, its proprietary learning management system (LMS), and a curriculum catalog with over 1,825 current courseware titles. Founded in 1987 (as FirstClass Systems, with a name change to Serebra in 2001), Serebra has over sixteen years" experience delivering e-learning solutions to both...
