Excel 2000 MOUS MOS
|
Special Package Deals
|
|
Microsoft Excel 2000 Proficient and Expert
|
$150.00
|
n72030d
|
|
|
Office 2000 Package (MOUS) - Includes All Office 2000 courses Access, Excel, Powepoint, Frontpage, Outlook and Word
training
|
$299.00
|
n72021d
|
|
Excel 2000 Training CD-ROM... MOS MOUS Certification
MS Excel 2000 Core MOS MOUS Certification
MOUS Excel XP
 NETg's course packs over 12 hours of highly interactive
self-paced instruction through the following 2 titles:
- MS Excel 2000 MOUS Certification Proficient
- MS Excel 2000 MOUS Certification Expert
The course enables you to prepare for the MOUS: Microsoft Excel 2000 Proficient (MOUS) Exam. Each title in this course is individually certified by Microsoft for
depth and breadth of subject matter coverage for the Microsoft certification exam.
MS Excel 2000 Proficient introduces you to the Excel interface. This title also teaches you to create workbooks, master data entry techniques, and edit and format existing worksheets.
MS Excel 2000 Expert teaches you to perform calculations using formulas and functions. This title also teaches you to generate customized reports to facilitate analysis and decision-making.
In addition to the two titles, the course also includes a workout. The WorkOut is an exercise to test the learning on the procedures covered in the course. It provides two sets of questions that
simulate the software environment. Each session comprises 40 randomly selected questions. The learner is able to take this test (WorkOut) after completing both the titles.
Duration: 12-16 hours
Audience: This course is targeted at:
- Professionals who need to use Excel 2000 for day-to-day work and for generating reports
- Students preparing for the MS Excel 2000 Core (MOUS) Exam
Benefits: After completing all the titles in the course, the learner will be able to:
- Identify the functionality of Excel components
- Create workbooks
- Modify data in a worksheet
- Edit data in multiple worksheets of a workbook
- Save a workbook/worksheet as a Web page
- Format worksheets
- Apply built-in and user-defined styles to data in a worksheet
- Customize page set up
- Preview and print workbooks/worksheets
- Link worksheets
- Use formulas & functions to perform calculations
- Customize data display in a worksheet
- Use charts to graphically represent data
- Create lines and objects for enhancing data presentation
Pre-requisites
To benefit completely from this course, the learners should be familiar with the Windows interface and Windows terminology.
Outline
- MS Office 2000: Excel for Professionals - I
- Getting Started with Excel
- Working with Worksheets
- MS Office 2000: Excel for Professionals – II
- Generating Reports
- Enhancing Reports
System Requirements
The minimum system requirements are:
- 80486 DX processor or higher
- 8 MB RAM (more RAM improves performance)
- VGA or higher monitor
- MS-Windows mouse
- 15 MB free disk space
- MS Windows 3.1 or higher
MS Excel 2000 Expert MOS MOUS
This course packs over 8 hours of highly interactive self-paced instruction through the following title:
The course enables you to prepare for the MOUS: Microsoft Excel 2000 Expert (MOUS) Exam. Each title in this course is individually certified by Microsoft for depth and breadth of subject
matter coverage for the Microsoft certification exam.
MS Excel 2000 Expert teaches you to customize the Excel interface, automate tasks, perform complex calculations, analyze data by creating Pivot reports and perform what-if analysis. You
will also look at generating customized reports to facilitate analysis, decision-making, and learn to collaborate Excel with other applications.
MS Office 2000: Excel for Experts – II teaches you to . You will also .
In addition to the two titles, the course also includes a workout. The WorkOut is an exercise to test the learning on the procedures covered in the course. It provides two sets of questions that
simulate the software environment. Each session comprises 33 randomly selected questions. The learner is able to take this test (WorkOut) after completing both the titles.
Duration: 6-8 hours
Audience: This course is targeted to:
- Professionals who need to use Excel 2000 effectively for generating reports, analyzing and sharing data
- Students preparing for the MS Excel 2000 Core (MOUS) Exam
Benefits
After completing all the courses in the curriculum, the learner will be able to:
- Use formulas & functions to perform calculations
- Customize data display in a worksheet
- Use charts to graphically represent data
- Create lines and objects for enhancing data presentation
- Customize page set up
- Preview and print workbooks/worksheets
- Link worksheets
- Execute and record macros
- Validate data entry
- Use forms for data entry
- Customize built-in toolbars
- Create customized menus and toolbars
- Define and use named ranges in formulas
- Create PivotTable and PivotChart reports
- Analyze data using PivotTable and PivotChart reports
- Perform What-if analysis using:
- Goal Seek
- Scenarios
- Solver
- Import and export data from Excel
- Share workbooks
- Protect workbooks
- Insert, edit and delete comments
- Merge workbooks
- Manage PivotTables on the Web
Pre-requisites
To benefit completely from this course, the audience should be a proficient user of Excel. The audience can acquire these skills from the VMM course that includes the following titles:
- Microsoft Office 2000: Excel for Professionals - I
- Microsoft Office 2000: Excel for Professionals - II
Outline
- MS Office 2000: Excel for Experts - I
- Generating Reports
- Enhancing Reports
- Enhancing Worksheet Functionality
- MS Office 2000: Excel for Experts – II
- Analyzing Data
- Sharing Data
System Requirements
The minimum system requirements are:
- 80486 DX processor or higher
- 8 MB RAM (more RAM improves performance)
- VGA or higher monitor
- MS-Windows mouse
- 15 MB free disk space
- MS Windows 3.1 or higher
Testing Information
Tests are administered through
Microsoft
|
