FAIL (the browser should render some flash content, not this).
Course Catalog

Summary:

This series is designed to help users prepare for the MOS Excel 2000 Expert examination. It covers expert-level Excel topics such as importing and exporting data, working with templates, linking workbooks, and using the Report Manager. It also covers advanced worksheet formatting, including page setup and printing, and sorting and filtering data. More advanced topics covered include ranges, macros and customization, validating and auditing data, and creating and using charts, graphs, and pivot tables. Data analysis, file sharing, and security issues are also discussed.

Certification:

MOS Expert

Audience:

This series is for anyone preparing for the MOS Excel 2000 Expert certification exam.

Features:

  • Simulations teach learners to perform specific tasks in applications through guided, multi-step exercises.
  • Activities allow learners to apply course concepts in an interactive questioning environment.
  • Exercises allow learners to practice in the actual application being studied.
  • Supplied sample files include sample documents, application files, programs, and programming code that enable learners to practice with these files, enhancing the learning experience.
  • A Course Topics list contains active hyperlinks, permitting quick access to specific topics.
  • Find-A-Word allows learners to look up an unfamiliar term in the Glossary, on the Web, or in a dictionary. In addition, it lets them find other occurrences of the term in the same course.
  • Search text enables learners to rapidly search all text within a course to easily retrieve information required.
  • Courses challenge the learner with a variety of question formats, including multi-step simulations, true/false, multiple choice, and fill-in-the-blank.
  • A skill assessment generates a customized learning path based on the results of a pre-test.
  • A glossary provides a reference for definitions of unfamiliar terms.
  • Bookmarking tracks the learner's progress in a course.

Importing and Exporting Data

4.0 Hours

Working with Templates, Links, and Report Manager

2.0 Hours

Formatting, Sorting, and Filtering Data

3.0 Hours

Naming Ranges, Working with Macros, and Customizing Toolbars

5.0 Hours

Validating and Auditing Data

2.0 Hours

Analyzing Data and Using PivotTables

3.0 Hours

Sharing Work and Adding Security

3.0 Hours

Powered by Sigsiu.NET RSS Feeds

Latest News

NOW AVAILABLE!!

Microsoft Windows Server 2008 Courses
Microsoft Windows 7 Courses

 

Course Outlines