Microsoft Office Specialist Exam Skill Standards: Excel 2000
The Microsoft Office Specialist Certification, (MOS) recognizes clerical and office professionals who have demonstrated proficiency or expertise in Microsoft Office 2000. SmartCert's Excel 2000 course provides students with the knowledge and skills that are needed to
use the advanced software features, and integrate the Office programs with other software. When you pass the
Excel 2000 exam, you achieve Microsoft Office Specialist (MOS) status. You also earn core credit towards the MOS Master Certification, which requires three exams and one elective.
As a Microsoft Certified Partner, SmartCert follows the approved Microsoft course curriculum, ensuring you receive the training and knowledge needed to succeed. SmartCert is so certain this course meets and exceeds the exam objectives, we guarantee you will pass your exam!
Learning segments
Working with Cells and Cell Data
Insert, delete and move cells |
Enter and edit cell data including text, numbers, and formulas |
Check spelling |
Find and replace cell data and formats |
Work with a subset of data by filtering lists |
Managing Workbooks
Manage workbook files and folders |
Create workbooks using templates |
Save workbooks using different names and file formats |
Formatting and Printing Worksheets
Apply and modify cell formats |
Modify row and column settings |
Modify row and column formats |
Apply styles |
Use automated tools to format worksheets |
Modify Page Setup options for worksheets |
Preview and print worksheets and workbooks |
Modifying Workbooks
Insert and delete worksheets |
Modify worksheet names and positions |
Use 3-D references |
Creating and Revising Formulas
Create and revise formulas |
Use statistical, date and time, financial, and logical functions in formulas |
Creating and Modifying Graphics
Create, modify, position, and print charts |
Create, modify, and position graphics |
Workgroup Collaboration
Convert worksheets into Web pages |
Create hyperlinks |
View and edit comments |
|
