Excel 2000 Advanced Formatting, Sorting, and Filtering Data

computer training tutorials Computer Training

Course List
Value Packages
Site Map
MOS Certification
Free Training

Online Training Series:
Excel 2000 Advanced Training

Office 2000 > Excel 2000 MOUS / MOS Advanced > Formatting, Sorting, and Filtering Data

This Excel 2000 MOS Expert Training Course on Formatting, Sorting, and Filtering Data is part of a 7 course, 22 hour online training series. This complete online training series can be purchased for only $29.95.



Length: 3 Hour

Summary:
This online computer training course teaches users how to format numeric data, create custom and conditional formats, sort and group data, use data forms for data entry and retrieval, and use filters to extract data.

Objectives:
After completing this course, students will be able to:

  • Apply accounting, currency, and number formats to data
  • Create a custom number format
  • Use and apply conditional formatting
  • Sort data
  • Generate subtotals
  • Group and outline data
  • Use a data form for data entry and retrieval
  • Create a data filter
  • Extract data
Outline:
  • Formatting Numbers
  • Using and Applying Conditional Formats
  • Sorting and Grouping Data
  • Using a Data Form
  • Using a Data Filter
Features:
  • Exercises that allow users to practice the application
  • A file containing the text of the exercises
  • Simulations that allow users to practice course skills, even if they don't have access to the application
  • Online computer glossary
  • Online skill assessment testing
Applicability:

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

Prerequisites: None

Technical Requirements: (Minimum)
  • Computer: 200MHz Pentium with 32MB Ram. 640 x 480 256-color video
  • Operating System: Windows 95, 98, NT, ME, 2000, or XP.
  • Minimum Connection Speed: 28.8k.
  • Browser: Internet Explorer 5.0 or higher required.
  • Authorware and Macromedia Flash player recommended but not required.
  • JavaScript must be enabled.
  • Netscape and AOL browsers not supported.

Need help or have questions about Excel 2000 MOS Expert? How about 24x7 access worldwide to our instructors! Now you can get answers from real experts within minutes via our online chat service. For just $30.00 additional you add our Instant Mentoring service and get your Excel 2000 MOS Advanced training courses questions quickly answered anytime from anywhere.

You might also be interested in our Desktop Computing Package which includes all of our Excel 2000 MOS Expert courses plus over 800 hours of additional courses.

Retake any or all of our computer training as often as you want. Our online tutorials allow you to learn anywhere, anytime from any computer with internet access. All courses allow for 1 year unlimited access (1 user), includes a variety of features and all courses qualify for Continuing Education Units - CEU credit..
continuing education unit CEU credit

StaffKit is a worldwide leader in providing computer training, online tutorials and career education. StaffKit has satisifed customers in over 30 countries.

online training
Back to Microsoft Excel 2000 MOS Advanced Tutorial

About Us
News
Contact Us
Features
Certification

Reviews:

"this is the Ultimate Career Development Package."
MidWest Technology Journal

Great Service and Excellent Training Product - Great People
Kenosha, WI

"this is a must have resource"
TheTechMag.com

Read more customer reviews about our e-learning training tutorials.

e-learning tutorial