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) | ||
| Align and Text Wrap | (06:55) | ||
| Alignment Effects | (01:37) | ||
| Format Painter | (01:35) | ||
| Borders and Shading | (02:58) | ||
| Numbers Formats | (03:03) | ||
| Date and Time Formats | (02:47) | ||
| Custom Formats | (03:38) | ||
| Autoformat | (01:36) | ||
| Conditional Formating | (02:53) | ||
| Styles | (02:27) | ||
|
Basic Formulas
|
|||
| Formula Structure | (04:34) | ||
| Operators | (00:43) | ||
| Creating Formulas | (04:47) | ||
| Autofill Formulas | (03:15) | ||
| Autosum | (02:29) | ||
| Relative Reference | (02:51) | ||
| Absolute Reference | (02:20) | ||
| Function Wizard | (02:43) | ||
|
Ready for Printing?
|
|||
| Headers and Footers | (03:39) | ||
| Print Preview | (03:19) | ||
| Scaling the Print Area | (03:54) | ||
| Set Print Area | (02:27) | ||
| Margins | (02:46) | ||
| Printing | (02:44) | ||
|
Charts and Maps
|
|||
| Creating a Chart | (05:05) | ||
| Chart Wizard | (06:56) | ||
| Chart Options | (07:30) | ||
| The Legend | (03:41) | ||
| The Series | (04:59) | ||
| Chart Toolbar | (04:27) | ||
| 3D Charts | (03:36) | ||
| Creating Maps | (05:12) | ||
| Customizing Maps | (03:17) | ||
| Labeling Maps | (02:10) | ||
|
Advanced Formulas
|
|||
| If Functions | (06:27) | ||
| And / Or | (04:31) | ||
| Nested If Functions | (04:22) | ||
|
Using Excel as a Databse
|
|||
| Create a Database | (04:29) | ||
| Sort Data | (05:14) | ||
| Filter Data | (04:23) | ||
| Advance Filter | (08:59) | ||
| Data Forms | (04:37) | ||
| Database Functions | (04:49) | ||
|
Linking and Protecting
|
|||
| Formula Links | (03:45) | ||
| Range Names | (03:17) | ||
| Paste Special | (03:59) | ||
| Protect Cells | (03:36) | ||
| Protect Worksheets and Workbooks | (04:40) | ||
| Passwords | (05:17) | ||
|
Analysis
|
|||
| Goal Seek and Solver | (06:10) | ||
| Scenarios | (03:32) | ||
| Pivot Tables | (13:00) | ||
| Validation | (05:10) | ||
| Auditing | (06:35) | ||
| Outlining | (05:33) | ||
|
Toolbars and Macros
|
|||
| Customizing Toolbars | (07:12) | ||
| Create a Macro | (04:24) | ||
| Edit a Macro | (03:37) | ||
| Create a Macro Button | (01:47) | ||
|
Graphics and The Drawing Toolbar
|
|||
| Insert a Picture | (01:43) | ||
| Move / Resize and Crop | (03:02) | ||
| Creating Shapes and Lines | (02:59) | ||
| Arranging and Grouping | (03:25) | ||
| Fills and Line Color | (03:19) | ||
| Arrows | (01:24) | ||
| AutoShapes | (02:03) | ||
| Flip and Rotate | (02:37) | ||
| Text boxes | (02:19) | ||
| WordArt | (04:57) | ||
| Shadow and 3D Effects | (04:43) | ||
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 |
Subscription / Purchase Information
This course is just part of the entire VTC collection of over 782 courses, 81,350 video tutorials (20,800+ free), available to you for just $30 a month.
View All Courses Subscribe Learn More