Microsoft Excel 2000 Tutorial - Training Videos

Training CDs > Business Tutorial Videos > MICROSOFT EXCEL 2000

Affordable Training you can depend on
This Microsoft Excel 2000 video tutorial utilizes an easy to follow training format that is both engaging and informative. Created to assist the beginners to intermediate users, the author uses a unique training method that brings a high degree of visual clarity to even the most complex applications. Being over 8 hours long these Microsoft Excel 2000 tutorials are extremely comprehensive and easy to follow. Video Training by Experts - Low Cost.

Not sure which Training CDs to buy?
The Online University allows unlimited access to the entire range of training titles for one low fee of only $30 per month. There is no fixed term, no limits, and you can cancel at any time. For corporate users and schools we also offer multi user accounts.
Find out more about the online video tutorials »

About the Free Video Online Training Course Demos
To allow you to evaluate the quality of the Microsoft Excel 2000 training course we have made the first 3 chapters of this tutorial available for free viewing online, the purchased version of this training course contains all the topics listed below. The free demos below have been compressed for faster playback over the internet, the audio and video quality of the purchased CD / DVD is far greater. To play the free demo videos you will need QuickTime,

THIS TUTORIAL COVERS THE FOLLOWING SUBJECTS

Description

This Microsoft Excel tutorial will help you take control of your data and present it in various formats. Structured for people that have a busy life this form of training offers users accelerated learning and a high retention rate, users can learn at the pace that best suits them and there is no need to read complex manuals to become proficient. Authored by Lorie Flenner each aspect is covered in great detail. Topics covered include : Cells – Rows, Inserting data, Text Wrap, Autoformat, Advanced Formulas, Functions, Filter Data, Forms, Passwords, Macros and much more. We also have a more current training CD : Microsoft Excel 2007

Microsoft Excel 2000 Related Groups

Hide Description

The Blue Links below are free demos, when you purchase the video training CD / DVD the enitre content listings below are included , not just the free demo videos.

Introduction

The Basics

Working With Worksheets

Formatting Cells

Text Formats
Align and Text Wrap
Alignment Effects
Format Painter
Borders and Shading
Numbers Formats
Date and Time Formats
Custom Formats
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
Create 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 Tutorials - VIDEO INFO

» Studio quality audio and video
» Works on Pc or Mac
» Ideal for people that learn quicker by being shown
» Master complex application in days

Title	:	Microsoft Excel 2000
Instructor	:	Lorie Flenner/NMG
Price	:	US$ 99.95
Duration	:	8 hours - 157 Movies
OS	:	Win Vista XP 98,2000,ME. Mac OS 9, OS X
Delivery Options	:	Ground / 2 day / Next Day
Product Code	:	33101

BENEFITS OF THIS TRAINING COURSE

Master Microsoft Excel 2000 in the shortest time possible
Self paced tutorial, training on video, at your own pace
Just sit back and watch, no books to read, just easy to follow lessons
Training can be viewed from any location, on PC or Mac
All training is self-contained; you don’t even need the application you are learning loaded on your machine
The most affordable way to learn, benefit from a world-leading expert
High quality content for a fraction of the cost of a classroom training course
The Tutorials can be rewound, fast forwarded or stopped at any time
Learn from the comfort of your own desk.