Microsoft Excel 2000 Tutorials

With Microsoft Excel 2000, you can take advantage of comprehensive tools to create spreadsheets and share them on the Web for universal viewing and collaboration. Excel allows you to easily analyze data with charts, Microsoft PivotTable, and graphs. You can even use automatic formatting to create data-rich spreadsheets and export data to word or access. In this tutorial, you are guided from basic thorough advanced techniques. This training course easily explains need-to-know topics such as columns and rows, workbooks and worksheets, basic and how to add advanced formulas, and even how to insert graphics. These microsoft Excel tutorials will help beginners and experts alike.

This training course is designed for fast learning and covers all the fundamental points of the application, all cds work on a mac or pc and no application is needed.

The links below are free Microsoft Excel 2000 tutorials. The entire contents may be purchased either on CD or watched via the Online University

Introduction
 Getting Started
 The Interface
 Menus
 Toolbars
 Formula Bar
 Columns & Rows
 Scroll Bars
 Sheet Tabs
 Status Bar
 Interface Review
 Workbooks & Worksheets
 Open and Close Workbooks
 Save Workbooks
 Getting Help

The Basics
 Select and Navigate Cells
 Enter Data
 Edit and Delete Data
 Cut,Copy and Paste
 Undo and Redo
 Drag and Drop
 Auto Fill
 AutoCorrect

Working With Worksheets
 Zoom Control
 Views
 Resize Rows and Columns
 Insert and Delete Cells
 Insert and Delete Rows and Columns
 Rename Worksheets
 Insert and Delete Worksheets
 Move and Copy Worksheets
 Hide and Unhide

Formatting Cells
Text formats
Align and Text Wrap
Alignment Effects
Borders and Shading
Number Formats
Date and Time Formats
Custom Formats
Format Painter
Autoformat
Conditional Formating
Styles

Basic Formulas
Formula Structure
Operators
Creating Formulas
Autofill Formulas
Autosum
Relative Reference
Absolute Reference
Function Wizard

Ready for Printing?
Headers and footers
Print Preview
Scaling the Print Area
Set Print Area
Margins
Printing

Charts and Maps
Creating a Chart
Chart Wizard
Chart Options
The Legend
The Series
Chart Toolbar
3D Charts
Creating Maps
Customizing Maps
Labeling Maps

Advanced Formulas
If Functions
And, Or
Nested If Functions

Using Excel as a Databse
Create a database
Sort Data
Filter data
Advance filter
Data forms
Database Functions

Linking and Protecting
Formula Links
Range names
Paste Special
Protect Cells
Protect Worksheets and Workbooks
Passwords

Analysis
Goal Seek and Solver
Scenarios
Pivot Tables
Validation
Auditing
Outlining

Toolbars and Macros
Customizing Toolbars
Create a Macro
Edit a Macro
Creat a Macro Button

Graphics and The Drawing Toolbar
Insert a Picture
Move, Resize and Crop
Creating Shapes and Lines
Arranging and Grouping
Fills and Line Color
Arrows
AutoShapes
Flip and Rotate
Text boxes
WordArt
Shadow and 3D Effects