Title Language  : 

Find a Course... Try for Free!

 

Microsoft Excel 2000 Tutorials

Course Content
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.
QT To view the Free Tutorials listed below, you must have QuickTime installed. Please note that the online free samples have been compressed for quicker downloads. Purchased CDs have higher sound and video quality.
Monitor resolution needs to be set to at least 1024 by 768 to view the entire movie.

лл Hide This
Introduction
 Getting Started (00:31)
 The Interface (01:29)
 Menus (03:49)
 Toolbars (03:22)
 Formula Bar (01:02)
 Columns & Rows (00:53)
 Scroll Bars (02:06)
 Sheet Tabs (00:45)
 Status Bar (00:25)
 Interface Review (00:41)
 Workbooks & Worksheets (01:28)
 Open and Close Workbooks (04:18)
 Save Workbooks (03:31)
 Getting Help (06:49)
The Basics
 Select and Navigate Cells (04:25)
 Enter Data (02:21)
 Edit and Delete Data (03:21)
 Cut / Copy and Paste (06:14)
 Undo and Redo (03:59)
 Drag and Drop (01:45)
 Auto Fill (03:40)
 AutoCorrect (04:12)
Working With Worksheets
 Zoom Control (02:14)
 Views (03:54)
 Resize Rows and Columns (02:22)
 Insert Cells (01:24)
 Delete Cells (01:03)
 Insert and Delete Rows and Columns (02:49)
 Rename Worksheets (00:49)
 Insert and Delete Worksheets (01:07)
 Move and Copy Worksheets (03:17)
 Hide and Unhide (03:14)
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 Feedback
Tutorial Information / Pricing
Title: Microsoft Excel 2000
Author: Lorie Flenner/NMG
SKU: 33101
ISBN: 1889347868
Duration: 8 hrs / 103 Lessons
Compatibility: Win XP, 2000, 98, NT, Mac OS X, OS 9

Online University Access all our Training for only 30
The Online University provides unlimited 24/7 access to ALL of VTC's incredible training content for the low fixed price of just $30/month (USD)
SIGNUP LEARN MORE »

Get this title on CD
Single User: US$ 99.95 - Purchase CD / Add to Cart

Multi User (10): US$ 500.00 - Purchase CD / Add to Cart

Select Bandwidth
Click "High Bandwidth" if you want to view movies at the highest quality available. Click "Low Bandwidth" if on a slow dial-up connection (28 Kbps and such). The low bandwidth movies are slightly more compressed and smaller in file size, allowing for faster streaming.

Select:

Select Category

Special Groups

Publisher or Products