Easy to follow Microsoft Excel 2000 Tutorials and online training courses. These professionally created videos offer the user an accelerated way to master this application from the comfort of their own desktop. In addition to the Microsoft Excel 2000 tutorials we also list over 400 additional titles amounting to over 4000 hours, get unlimited access to all these courses for just $30 per month.

Microsoft Excel 2000 Tutorial Try for FREE

Select a tutorial category

Discounted Training Courses

Members of the VTC Online University have unlimited access to this tutorial. At the moment, you are in demo mode and only the first 3 chapters will play. But members have access to EVERY SINGLE TITLE IN OUR RANGE, i.e., over 40,000 tutorials on 400+ titles all with expert tutors. Where else can you get high quality one to one training for just $30.00 per month!

Benefits

01. Unlimited viewing.
02. Downloadable working files.
03. Expert instructors.
04. Use at home / work or both.
05. Works on PC or Mac.
06. Telephone Tech support.
07. Cancel at any time.
08. 300+ courses for 1 low fee.
09. New titles added regularly.
10. 100% Guaranteed

Should you need any help, just call - contact details at the bottom of the page.

Click here to Join

Unlimited Professional Training on over 400+ applications and programming languages for only $30.

The fastest and most cost effective way to learn! Forget boring books! No need for expensive classroom training - just easy to follow training videos that play right from your own computer. Login from home or office - the choice is yours. All courses are taught by world leading experts, unlimited access, on over 400 different subjects.

Please Note:
You are in Demo mode which only allows access to the first 3 chapters of this Microsoft Excel 2000 training course and all the other titles listed on this site, this is to help you evaluate the quality of the training before joining. If you decide to join, you will instantly have totally UNLIMITED ACCESS to over 400 professionally created video tutorials, you will be able to access the content from any location and no restrictions are placed on the amount of content you can watch, you can also cancel at any time you wish. Over 4000 hours of training for just $30.00.

Topics covered on this course include:

Introduction to excel tutorials

The Basics

Working With Worksheets

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

Microsoft Excel 2000 Course Details

Microsoft Excel 2000 Training Course
Author:	Angie Rawling All Training Videos by author
Duration:	7 Hours
No. of movies	157
Later - Releated Titles
Beginners Excel 2007 Training Videos

Benefits:
Join the VTC Online University and you will have UNLIMITED access to this tutorial and all the others in the entire library for just US $30 a month. That's over 4000 hours worth of high quality training for one low price of less than $1 a day. Click here to Join

Own this Training Course on CD

If you would like to own this Microsoft Excel training title on CD, you may purchase it from our online store, because we don't have to use the same level of compression on the CDs as we do with the online, the audio and video playback is of a higher quality. For a single low payment you can buy this
Microsoft Excel tutorial on CD.

Free Certification - Prove your Skills

After you have completed a tutorial, a Certificate of Completion can be obtained to verify that you have taken a particular course. All certificates are FREE, but the training course must be completed before a certificate can be issued.

Customers Comments

I have just finished my first ever website thanks to all of your training, I spent weeks reading the Dreamweaver manual, but your training gave me the answers and skills in hours. I hope this is the first of many. I would now recommend your services to any one.
Greg Croall
Monroe Michigan

Easy to Use QuickTime Format

QuickTime 105 In order to view the training, you must have the latest version of QuickTime installed. Please note that the online movies have been compressed for quicker downloads, CDs and DVDs have far higher audio and video quality.