Learn Microsoft Excel 2000

Unlimited Online Training and Tutorials

Microsoft Excel 2000 Online Video Training and Tutorials by Lorie Flenner/NMG consists of approximately 8 hours of training over 157 lessons. Start learning right now, free. Just click any lesson below to begin.

Course Outline For:

Microsoft Excel 2000

Start learning Microsoft Excel 2000 right away, Free! Click on the highlighted lesson links below to view the lessons immediately. You will require Quicktime. If you have any problems viewing the lessons, click here

Introduction

Workbooks & Worksheets

Open and Close Workbooks

Save Workbooks

Getting Help

The Basics

Select and Navigate Cells

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

More lessons below ...

Would you like to continue? You can have instant access to the rest of this training for just $30.00

Subscribe Now!

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 Video Training Detail:

Instructor:	Lorie Flenner/NMG
Course Lessons:	157 Total Lessons
Course Duration:	8hrs total
First Release Date:	1999-11-22
Course Price:	N/A - Included with membership
Monthly Membership:	$30 month to month
Annual Membership:	$250 annually
Courses Included:	ALL Training Titles

Sign Up Now and Start Learning!

Course Description:

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. In this tutorial, you are guided from basic thorough advanced techniques by author Lorie Flenner. She easily explains need-to-know topics such as columns and rows, workbooks and worksheets, basic and advanced formulas, and even how to insert graphics. If you need to know Excel, why not start now? Simply click a topic below.

Sign Up Now and Start Learning!

WHY BECOME A MEMBER?

This is the easiest, best, most cost effective way to learn Microsoft Excel 2000 from VTC Instructor Lorie Flenner/NMG?

Huge Learning Library Included - Access to one course includes access to our entire learning library of over 400 courses with 55,000+ lessons.

Superior Teaching Methods - No Books or classrooms! Combined video and audio delivered on your PC or Mac in bite size lessons - superior learning and retention. Many courses includes downloadable work files!

Flexible Learning - Learn on your schedule, at your pace... starting 60 seconds from now if you like!

Certifications - Downloadable (and third party verifiable) Certificates of Completion with each course you complete.

No Long Term Commitment - You CAN subscribe for a year to save $$, but you are also welcome to go month to month and cancel or suspend at anytime, no questions asked.

Proven Worldwide - Tens of thousands of students, professionals, small businesses, big businesses, schools, and governments around the globe use our training - Over 400 new members join every day.

Sign Up Now and Start Learning!

Students | Small Business | Big Business | Government | Schools

Try ANY Course Free | Available Courses | Complete F.A.Q. | Multi-User Accounts | Training on CDRom