|
The best excel certification training site on the Internet.
FREE Online Courses
Video and CD's Info and Order!
Excel Tutorial
Cisco CCNA
Microsoft certification
Windows 2000 Tutorial
Windows NT
MS Exchange
SQL Server
IIS 4
TCP/IP
QuickBooks
HTML
Oracle 8i
RPG IV
Crystal Reports 8
XML Programming
SAP R/3
GroupWise 5.5
GUI Programming
Visual Basic
Visual InterDev
Lotus Notes
Novell 560 CNE
Novell 570 CNE
SAS Tutorial
SAS 8
LAN Training
UNIX
Sybase
Web Design
Contact Us
|
|
This course is for anyone preparing for the MOUS Excel 2000 Core certification exam, or interested in learning excel.
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!
This is self-paced, internet-based training -- there are no books to purchase and no scheduled classes to attend.
- Working with Cells shows how to enter and edit data in worksheet cells and how to create hyperlinks.
- Working with Files shows how to locate, open, and save files.
- Formatting Worksheets shows how to format and adjust cells, adjust rows and columns, and apply formatting and styles in an worksheet.
- Page Setup and Printing shows how to preview and print worksheets and workbooks; add headers, footers, and titles, and adjust page settings in worksheets.
- Worksheets & Workbooks shows how to work with worksheet rows and columns, manage worksheets, and consolidate data in worksheets.
- Formulas and Functions shows how to work with formulas and functions in worksheets.
- Charts and Objects shows how to create, modify, and print charts; insert, move and delete pictures, and draw lines and shapes in worksheets.
- Importing and Exporting Data shows users how to import data from other applications into query a database application to extract data and export data to other applications.
- Working with Templates Links and Report Manager shows the user how to work with templates link workbooks and use Report Manager.
- 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.
This course has the following features:
- Exercises that allow users to practice
- A file containing the text of the exercises
- Simulations that allow users to practice course skills
- A course index
- A glossary
- A Skill Assessment
Courses are included in "Tech General Pack" set of online courses.
|