Microsoft Excel Training

Excel 2000 Training

Oracle Tutorial

Microsoft MCSE
2000 Training

Microsoft Office
MOUS Certification

Access 2000

Power Point

Cisco CCNA

CompTIA Courses

SQL Server

IIS 4

TCP/IP

QuickBooks

RPG IV

Crystal Reports 8

XML

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

UNIX

Sybase

These microsoft excel training courses are for people who will work with microsoft excel or preparing for Microsoft MOUS Excel 2000 certification.

This is self-paced, internet-based training course -- there are no books to purchase and no scheduled classes to attend.

• Working with Cells shows how to enter and edit data in excel worksheet cells and how to create hyperlinks.
• Working with Files shows how to locate, open, and save files in excel.
• Formatting Worksheets shows how to format and adjust cells, adjust rows and columns, and apply formatting and styles in an excel worksheet.
• Page Setup and Printing shows how to preview and print worksheets and workbooks; add headers, footers, and titles, and adjust page settings in excel 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.

• Enter data
• Edit one or more cells
• Find and replace values
• Use the AutoFill feature to create series
• Create and edit hyperlinks
• Open files
• Save files
• Send a workbook via e-mail
• Save a worksheet or workbook as a Web page
• Use the Office Assistant
• Format cells
• Adjust alignment and indentation of text in cells
• Adjust rows and columns
• Format numbers
• Use the AutoFormatting feature
• Define, apply, and remove a style
• Preview worksheets, workbooks and Web pages
• Change page setup
• Set up headers and footers
• Set print options
• Print worksheets, workbooks, and selections
• Insert and delete rows and columns
• Hide and unhide rows and columns
• Freeze and unfreeze rows and columns
• Move between worksheets in a workbook
• Rename, insert, delete, move, and copy worksheets
• Link worksheets, consolidate data, and check spelling
• Enter and revise formulas
• Use absolute and relative references
• Use the AutoSum feature
• Enter and use basic functions
• Enter and use date functions, financial functions, and logical functions
• Use the Chart Wizard to create a chart
• Modify charts
• Preview and print charts
• Insert, move, and delete an object (picture)
• Create and modify lines and objects