Home
Username:
Password:

Microsoft Excel 2000 Tutorials

Online Contents For This Course

We have made some of the video tutorials for

Microsoft Excel 2000

freely available to help you evaluate our training. Click on any of the linked lesson listings below to preview FREE!
   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.

Choose your media type:

Introduction
  Getting Started (00:31) T
  The Interface (01:29) T
  Menus (03:49) T
  Toolbars (03:22) T
  Formula Bar (01:02) T
  Columns & Rows (00:53) T
  Scroll Bars (02:06) T
  Sheet Tabs (00:45) T
  Status Bar (00:25) T
  Interface Review (00:41) T
  Workbooks & Worksheets (01:28) T
  Open and Close Workbooks (04:18) T
  Save Workbooks (03:31) T
  Getting Help (06:49) T
The Basics
  Select and Navigate Cells (04:25) T
  Enter Data (02:21) T
  Edit and Delete Data (03:21) T
  Cut / Copy and Paste (06:14) T
  Undo and Redo (03:59) T
  Drag and Drop (01:45) T
  Auto Fill (03:40) T
  AutoCorrect (04:12) T
Working With Worksheets
  Zoom Control (02:14) T
  Views (03:54) T
  Resize Rows and Columns (02:22) T
  Insert Cells (01:24) T
  Delete Cells (01:03) T
  Insert and Delete Rows and Columns (02:49) T
  Rename Worksheets (00:49) T
  Insert and Delete Worksheets (01:07) T
  Move and Copy Worksheets (03:17) T
  Hide and Unhide (03:14) T
Formatting Cells
  Text Formats (02:56) T
  Align and Text Wrap (06:55) T
  Alignment Effects (01:37) T
  Format Painter (01:35) T
  Borders and Shading (02:58) T
  Numbers Formats (03:03) T
  Date and Time Formats (02:47) T
  Custom Formats (03:38) T
  Autoformat (01:36) T
  Conditional Formating (02:53) T
  Styles (02:27) T
Basic Formulas
  Formula Structure (04:34) T
  Operators (00:43) T
  Creating Formulas (04:47) T
  Autofill Formulas (03:15) T
  Autosum (02:29) T
  Relative Reference (02:51) T
  Absolute Reference (02:20) T
  Function Wizard (02:43) T
Ready for Printing?
  Headers and Footers (03:39) T
  Print Preview (03:19) T
  Scaling the Print Area (03:54) T
  Set Print Area (02:27) T
  Margins (02:46) T
  Printing (02:44) T
Charts and Maps
  Creating a Chart (05:05) T
  Chart Wizard (06:56) T
  Chart Options (07:30) T
  The Legend (03:41) T
  The Series (04:59) T
  Chart Toolbar (04:27) T
  3D Charts (03:36) T
  Creating Maps (05:12) T
  Customizing Maps (03:17) T
  Labeling Maps (02:10) T
Advanced Formulas
  If Functions (06:27) T
  And / Or (04:31) T
  Nested If Functions (04:22) T
Using Excel as a Databse
  Create a Database (04:29) T
  Sort Data (05:14) T
  Filter Data (04:23) T
  Advance Filter (08:59) T
  Data Forms (04:37) T
  Database Functions (04:49) T
Linking and Protecting
  Formula Links (03:45) T
  Range Names (03:17) T
  Paste Special (03:59) T
  Protect Cells (03:36) T
  Protect Worksheets and Workbooks (04:40) T
  Passwords (05:17) T
Analysis
  Goal Seek and Solver (06:10) T
  Scenarios (03:32) T
  Pivot Tables (13:00) T
  Validation (05:10) T
  Auditing (06:35) T
  Outlining (05:33) T
Toolbars and Macros
  Customizing Toolbars (07:12) T
  Create a Macro (04:24) T
  Edit a Macro (03:37) T
  Create a Macro Button (01:47) T
Graphics and The Drawing Toolbar
  Insert a Picture (01:43) T
  Move / Resize and Crop (03:02) T
  Creating Shapes and Lines (02:59) T
  Arranging and Grouping (03:25) T
  Fills and Line Color (03:19) T
  Arrows (01:24) T
  AutoShapes (02:03) T
  Flip and Rotate (02:37) T
  Text boxes (02:19) T
  WordArt (04:57) T
  Shadow and 3D Effects (04:43) T

Course Information

Course:

Microsoft Excel 2000

Author: Lorie Flenner/NMG
SKU: 33101
ISBN: 1889347868
Release Date: 1999-11-22
Duration: 8 hrs / 103 tutorials
Captions: For Online University members only

Search within Captions

 

Subscription / Purchase Information

Visitors to VTC.com will be able to view all introductory videos for each training course.
Free Trial Members will gain access to first three chapters for each training course. Sign up for a Free Trial
Full Access Members have full access to VTC.com’s entire library of video tutorials. If you are already a member, please login here.

Learn More

Also Available in CD format

Single User: US$ 99.95Add to Cart

Multi User(10): US$ 500.00Add to Cart