|
Provided by: Serebra Learning Corporation Microsoft Excel 2000 BasicExcel |
 |
Training
Provided by Serebra Learning Corporation
This highly interactive CBT contains five units that cover basic Excel skills. Through step-by-step instruction within a realistic simulation of Microsoft Excel 2000, students learn how to build, edit, and format worksheets, and how to work with charts, formulas, and functions. 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. Related Exam: MOUS Excel 2000 Expert. This course is designed to help individuals who want to achieve basic proficiency in MS Excel 2000. Individuals who want to become MOUS certified should use all of the courses in this series.
|
|
||||||||||
Microsoft Excel 2000 Basic
Audience
This course is designed to help individuals who want to achieve basic proficiency in MS Excel 2000. Individuals who want to become MOUS certified should use all of the courses in this series.
Topics
Getting Started with Excel 2000
- Defining Spreadsheet Software
- Starting Excel 2000
- Viewing the Excel Window
- Opening and Saving an Existing Workbook
- Entering Labels and Values
- Previewing and Printing a Worksheet
- Closing a Workbook and Exiting Excel
Building and Editing Worksheets
- Planning and Designing a Worksheet
- Editing Cell Entries and Working with Ranges
- Entering Formulas
- Copying and Moving Cell Entries
- Understanding Relative and Absolute Cell References
- Copying Formulas with Relative Cell References
- Copying Formulas with Absolute Cell References
- Naming and Moving a Sheet
Formatting a Worksheet
- Formatting Values
- Using Fonts and Font Sizes
- Changing Attributes and Alignment of Labels
- Adjusting Column Widths
- Inserting and Deleting Rows and Co
Objectives
Upon completion of this course, the student will be able to:
- Create, edit, preview, print, save and close an Excel workbook
- Edit, copy and move cell entries, and work with ranges
- Copy formulas with relative and absolute cell references
- Format values and labels, and apply colors, patterns, and borders
- Insert and delete rows and columns
- Design, create, modify, and enhance charts
- Create formulas, and display and print formula contents
- Build formulas that include the IF functions, the PMT function, and statistical functions
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...
