MS excel tutorial

MOUS Excel Tutorial
Info and Order

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.