United States 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 | |
Email this Page
Send us FeedbackCourse 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.