FREE Computer Training Courses
Video and CD Info and Order!
A+ Certification
Training
Network+ Certification
Microsoft Certification
MCSE
Certification
MOUS
Certification
Internet
Training
Exchange Server
IIS4
SQL
Server
TCP/IP
Windows NT
Windows 2000 Professional
Windows 2000 Server
MS
Access
2000
Excel 2000
Excel
2000
Expert
Word
2000
Word 2000 Expert
PowerPoint
Tutorial
Microsoft Project
Office
2000
Office
97
Outlook 2002
Cisco
CCNA
Cisco CCDA
Cisco Tutorial
Oracle
8i
E-Commerce
Novell
Lotus Notes
Visual Basic
Tutorial
FrontPage Tutorial
Java
Certification
HTML Tutorial
Visual InterDev
PowerBuilder
FOCUS
UNIX Tutorial
Sybase
PhotoShop
S.A.S.
S.A.P.
QuickBooks
MS Works
Computer Security
Crystal Reports
XML Tutorial
RPG IV Programming
|
This course is for anyone preparing for the MOUS Excel 2000 Expert certification exam.
This is self-paced, internet-based course -- there are no books to purchase and no scheduled classes to attend.
Training that's Easy, Convenient and Affordable! High-quality, online, self-paced training designed to help you achieve your goals.
Affordable annual subscription plans give you unlimited access to an entire suite of training topics at prices that you just won't find anywhere else.
Our courses are based on sound principles, from extensive research in instructional design, adult learning and information processing. All courses are design so that new knowledge and skills will be remembered and retrieved for future use. Each course include a 30-questions skill assessment, which evaluates your knowledge of the course material. You can be assured that this high-quality, instructionally-sound online product will enchance your professional and personal growth.
Try our FREE courses right now, and see for yourself how much you will learn!
We offer folowing online courses:
- Importing and Exporting Data shows users how to import data from other applications into Excel query a database application to extract data and export data from Excel to other applications.
- Working with Templates Links and Report Manager shows the user how to work with templates link workbooks and use Report Manager.
- Formatting Sorting and Filtering Data shows 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.
- Naming Ranges Working with Macros and Customizing Toolbars shows users how to create and use named ranges and how to use lookup functions. It also shows how to record run and edit a macro as well as hide display and customize toolbars.
- Validating and Auditing Data shows users how to validate data trace and fix errors trace precedents for a formula and trace dependents for a specific cell.
- Analyzing Data and Using PivotTables shows users how to use data analysis tools such as Goal Seek Solver and scenarios. It also shows how to use PivotTables and PivotCharts.
- Sharing Work and Adding Security shows users how to work with cell comments apply workbook protection and share and merge workbooks.
A typical course has the following features:
- Certificates of Completion
- Instructional steps -- walk through a procedure
- Exercises -- try it out
- Notes - See additional information related to the topic in the text
- Tips - See a different, faster, or easier way of doing something
- Quick References - See a quick reference guide to the features introduced in a chapter
- Details - Display more detailed information related to the current topic
- Hotwords - See related information
- Navigation Bar - Maneuver easily through the courses
- Microsoft Approved Courseware Logo - to prepare you for a Microsoft certification
- Course Topics and Index -- with searching feature and hyper-links
- Printable Exercises - PDF downloadable files
- Sample Application Files - PDF downloadable files
- Course Glossary
- Skill Assessment - can be used for pre and post-testing -- tracking first try, best try and course grade - if passed, green check mark will appear as 'mastered' - hyperlinks to units within the course to go back and re-take a certain unit again. Use as pre-test to determine which course topics you want to focus on and to go directly into that unit.
All MS Excel courses are included in PC Desktop Pack and PC Business Pack.
Certificates of Completion!
Just complete an entire course with a passing grade of 70% or better and the 'Certificate' button will automatically display on
a course score's page. Click on this button and you will have the choice of printing a Classic or Jazzy style certificate with the course title, your name and date of completion.
|