Login 
Password
  
 


Free Exams!
Test your skills with one of our certification exams and see how you stack up right now.

Homepage
Visit our homepage and find out more about what NCSA can do for you.

Learn More About Us
Find out more about how our certifications can benefit you.

Course Descriptions
View a complete listing of certifications available through NCSA.

Access 2000
Excel 2000
Word 2000
PowerPoint 2000
Access 2002
Excel 2002
Word 2002
PowerPoint 2002
Office 2000
Office XP
Windows 2000 Pro
Windows 2000 Server
Visual C++
JavaScript
Computer Hardware
ColdFusion 4.5
HTML 4.0

HTML Tag Library
Visit our HTML tag library, a free reference we provide to our visitors.

Certificate Database
Lookup a certification in our online database.

Affiliate Program
Make money by helping people get the computer training and certification they need. Sign-up Here!

Support Center
If you have questions or concerns feel free to visit our online support center.


 


In addition to our training courses we also offer free online certification exams on several topics including Microsoft Office, Computer Hardware, HTML, PC Basics and more.

Click here for online certification exams.


The training system for Microsoft Excel 2000 spans 3 CD-ROM's and contains over 6 hours of professional quality instructor led training. Multimedia content allows you to quickly learn Excel concepts and the CD format lets you quickly pause and review important areas. After completing the course you will be prepared to take and pass the CS244 Microsoft Excel certification exam. A detailed outline of the course as well as a short introduction to the trainer are included below.

   Excel 2000 Essentials set of 3 (CD) $159.95
   Excel 2000 Essentials set of 3 (VHS) $159.95
   Shipping (US only)
FREE

About The Trainer:

Dennis P. Taylor currently trains employees at Amgen, IBM, and other companies in his specialized area of spreadsheet software. Dennis has over 15 years experience presenting PC software to individuals and seminar groups. He has also co-authored a number of books on spreadsheet topics.

Beginning Excel 2000 (2 Hrs 16 Mins)

1.0 The Excel Screen (32 Mins)
1.1 The Excel Workbook & Worksheets
1.2 Title Bar & Menu Bar
1.3 Toolbars
1.4 Formula Bar
1.5 Columns & Rows
1.6 Navigation
1.7 Sheet Names & the Status Bar
1.8 Mouse Pointers & Shortcut Menus
2.0 Entering Data into a Worksheet (27 Mins)
2.1 Data Entry Techniques
2.2 Auto-Fill Entry Techniques
2.3 Erasing Data
2.4 Auto Complete
3.0 Entering Formulas (26 Mins)
3.1 Three Methods of Entering Formulas
3.2 Repeating a Formula
3.3 Formulas Beyond Addition & Subtraction
4.0 Basic Functions (21 Mins)
4.1 Summation
4.2 Recalculating Effects
4.3 Averages
5.0 Formatting (13 Mins)
5.1 The Formatting Toolbar
5.2 Adjusting Column-width & Row-height
5.3 Numeric Formatting
6.0 Saving (17 mins)
6.1 File Save or File Save as
6.2 Opening a File
6.3 Closing a File
6.4 Creating a new Workbook

Intermediate Excel 2000 (2 Hrs 5 Mins)

1.0 Changing Worksheet Layout (26 Mins)
1.1 Inserting Columns
1.2 Deleting Columns
1.3 Moving Cells
1.4 Copying Cells
2.0 Additional Formatting (6 Mins)
2.1 Formatting Cell Attributes & Alignment
2.2 Borders
2.3 Numeric Formatting
2.4 Center Text across Columns
2.5 Hiding & Unhiding Columns & Rows
3.0 Printing (25 Mins)
3.1 Using Print Preview & Page Setup
3.2 Printing Controls
3.3 Using Page Break Preview
4.0 Using Cell References (29 Mins)
4.1 Absolute References
4.2 Mixed References
5.0 Tools Options Command (18 Mins)
5.1 Show/Hide Gridlines
5.2 Show/Hide Formulas
5.3 Recently used Files List
5.4 Sheets in New Workbook
5.5 Default Settings

Advanced Excel 2000 (2 Hrs 2 Mins)

1.0 Adjusting Worksheet Views (13 Mins)
1.1 Freeze/Unfreeze Panes
1.2 Horizontal & Vertical Split screen
2.0 Auditing Techniques (12 Mins)
2.1 Using the Auditing Toolbar
2.2 Tracing Dependant Cells
2.3 Tracing Precedent Cells
3.0 Using Functions (18 Mins)
3.1 Paste Function
3.2 The PMT Function
3.3 Expanding the use of standard functions
4.0 Logical Functions (30 Mins)
4.1 IF Functions & Relational Operators (> < >= <= = <> )
4.2 Using Words in IF Functions
4.3 Using IF Functions with Arithmetic Operators (* / + -)
4.4 Using Logical Operators (AND & OR) with the IF Function
4.5 Nested IF Functions
4.6 Using the VLOOKUP Function to overcome Limitations of the IF Functions
5.0 Date & Time Functions (21 Mins)
5.1 Using Dates as Values
5.2 Entering a Series of Dates
5.3 Date/Time entry Techniques
6.0 Multi-Sheet Workbooks (22 Mins)
6.1 Re-Naming & Re-Ordering Sheets
6.2 Inserting & Deleting Sheets
6.3 Moving
6.4 Formulas across multiple sheets


Please visit our special offers page to view some superb offers from our partners on the web. To view our special offers click here.

Or continue browsing our courses below.


3D Studio Max
A+ 2003
Microsoft Access 2007
Acrobat 4
ActiveX and OLE
Adobe Illustrator
Adobe InDesign CS
Adobe PhotoShop CS
ASP .NET
AutoCAD 2000
C Programming
C# Programming
Cisco CCNA
CompTIA Security+
CorelDRAW 10
Crystal Reports 8
Delphi 6

Exchange Server 2000
Flash 5
Frontpage 2000
ICDL/ECDL
IIS 5
Java 2
Linux 101
Linux 102
Lotus Notes 5
MicroSoft .NET
Network+ 2002
Oracle 8iR2
Outlook 2000
Outlook XP
PageMaker 6.5
Paradox 8

Perl 5
PhotoDraw 2000
PhotoPaint 8
SQL Server 2000
TCP/IP 4
Unix
Visio 2002
VB .NET
VBScript 5
Visual FoxPro 6
MCSE 2000
Windows XP User
WordPerfect 9
WordPerfect 11
XML
ZenWorks 3.0

     

     


Typing Speed Test
Test your typing speed with our certified typing speed test today.

  
HOME      EMPLOYERS    TESTING CENTERS    CERTIFICATION LIST    INSURANCE QUOTES    AFFILIATES    CONTACT US

© 2002-2010 National Computer Science Academy, All Rights Reserved.