Microsoft Excel Training

FREE Online Courses

Video and CD's
Info and Order!

Excel 2000

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 Training

UNIX

Sybase

Business Opportunity

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

This is self-paced, internet-based course -- 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.

• 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