United States
Microsoft Excel 2002 Tutorials
Online Contents For This Title
We have made some of the video tutorials for Microsoft Excel 2002 freely available to help you evaluate our training.
Click on any of the linked lesson listings below to preview FREE!
Title Description
Microsoft Excel 2002 offers tools that make it easy to access, connect, and analyze critical data, proving that Excel spreadsheets are no longer just for financial professionals. Virtual Training Company author Julia Kelly will instruct users on how to use this powerful spreadsheet program. Excel 2002 allows users to find and format data more quickly by utilizing context sensitive options as tasks are being performed. The new Error Checking smart tag feature allows users to fix, or ignore an error. Document Recovery automatically saves current workbooks, protecting your work. Refreshable queries allow users to integrate live data from the Web, or any other source. To get started, simply click on one of the movie topics below.
Choose your media type:
|
Introduction
|
||
| About Excel | (07:02) | |
| Open/ Save/Close Workbooks | (03:20) | |
| What’s Inside the Workbook | (04:11) | |
| Menus and Toolbars | (04:19) | |
| What’s on a Worksheet | (03:02) | |
| Getting Assistance from Excel | (03:17) | |
|
Getting Started
|
||
| Select and Navigate Cells | (04:26) | |
| Enter Data | (03:13) | |
| Edit and Delete Data | (03:39) | |
| Undo and Redo | (02:59) | |
| Cut/Copy/Paste | (03:03) | |
| About the Office Clipboard | (03:19) | |
| Drag and Drop | (03:21) | |
| AutoFill | (04:10) | |
| More Ways to Enter Repetitive Data | (03:33) | |
| AutoCorrect | (03:41) | |
| Use a Data Entry Form | (02:58) | |
| Validate Data During Entry | (03:36) | |
|
Working With Worksheets
|
||
| Resize Rows and Columns | (04:20) | |
| Insert and Delete Rows/Columns/Cells | (05:04) | |
| Rename Worksheets | (03:39) | |
| Move and Copy Worksheets | (03:11) | |
| Insert and Delete Worksheets | (02:35) | |
| Freeze and Split a Worksheet | (03:31) | |
| Open Multiple Windows | (03:32) | |
|
Simple Calculations
|
||
| Calculate Without a Formula | (03:04) | |
| Use AutoSum to Write Formulas | (03:38) | |
| Formula Structure | (05:33) | |
| Create Formulas | (03:57) | |
| Edit Formulas | (03:07) | |
| AutoFill Formulas | (05:08) | |
| Relative and Absolute References | (02:59) | |
| Functions | (04:14) | |
| Use the Function Wizard | (04:15) | |
| Name Cells and Ranges | (03:21) | |
| Use Names in Formulas | (03:37) | |
|
Using Advanced Functions
|
||
| AVERAGE/MAX/MIN | (02:53) | |
| SUMIF and COUNTIF | (03:55) | |
| VLOOKUP | (04:23) | |
| PMT | (04:23) | |
| NOW/ TODAY/CONCATENATE | (04:38) | |
| IF and Nested Functions | (04:32) | |
|
Organizing Data
|
||
| Sort Data | (04:42) | |
| Filter Data with AutoFilter | (03:25) | |
| AND and OR Filters | (03:45) | |
| Calculate Filtered Records | (04:50) | |
| PivotTables | (05:57) | |
| Consolidate Data | (03:50) | |
| Subtotal a Worksheet | (04:58) | |
|
Formatting Cells
|
||
| Text Formatting | (04:58) | |
| Align and Wrap Text | (04:19) | |
| Number Formats | (05:15) | |
| Date and Time Formats | (03:29) | |
| Custom Formats | (04:13) | |
| Borders and Shading | (05:17) | |
| Conditional Formatting | (04:24) | |
| Format Painter | (03:53) | |
| Styles | (05:32) | |
| AutoFormat a Table | (02:42) | |
| Transpose Tables and Merge Cells | (03:10) | |
| Format Several Worksheets Identically | (03:07) | |
| Save a File as a Template | (04:35) | |
|
Charting Data
|
||
| About Charts | (04:31) | |
| Create a Chart | (04:16) | |
| Resize and Relocate a Chart | (03:42) | |
| The Chart Toolbar | (03:14) | |
| Chart Options | (03:21) | |
| Legends/Titles/Axes | (03:13) | |
| Series Orientation and Order | (03:10) | |
| Create 3-D Charts | (03:57) | |
| Explode a Pie Chart | (04:02) | |
| Add Data Labels and a Data Table | (04:35) | |
| Trendlines | (03:15) | |
| Secondary Axes | (03:24) | |
| Format Chart Elements | (04:28) | |
|
Printing Data and Charts
|
||
| Create Page Headers and Footers | (03:38) | |
| See a Print Preview | (04:51) | |
| Set the Print Area | (03:27) | |
| Print a Selection | (03:00) | |
| Centering/ Margins/Gridlines | (03:27) | |
| Print on a Specific Number of Pages | (02:22) | |
| Print Multiple Worksheets/Copy/Collate Pages | (02:22) | |
| Print Row and Column Labels on Every Page | (02:22) | |
| Print Charts | (02:22) | |
|
Sharing and Protecting Data
|
||
| Share Data Between Workbooks | (01:02) | |
| Copying/Linking/Embedding Data | (01:02) | |
| Share Data with Other Programs | (01:02) | |
| Share a Workbook with Other Users | (01:02) | |
| Hide Worksheets | (02:18) | |
| Protect Cells | (02:18) | |
| Protect Worksheets and Workbooks | (05:46) | |
|
Analyzing Data
|
||
| Use Goal Seek to Find Answers | (02:18) | |
| Use Scenarios to Compare Alternatives | (04:33) | |
| Locate Worksheet Errors and Invalid Data | (04:54) | |
|
Customizing Excel
|
||
| Customize Your Toolbars | (04:09) | |
| Create a Custom Toolbar | (05:15) | |
| Automate with Macros | (03:31) | |
| Record a Macro | (05:01) | |
| Edit a Macro | (05:04) | |
| Assign a Macro to a Toolbar Button | (04:50) | |
| Create a Hyperlink to Open Another File | (04:10) | |
|
Graphics and The Drawing Toolbar
|
||
| Insert a Picture | (04:52) | |
| Move/Resize/Crop | (05:39) | |
| Draw Shapes and Lines | (05:03) | |
| Draw AutoShapes and Assign Macros | (04:31) | |
| Arrange and Group Drawing Objects | (04:39) | |
| Use Drawn Objects in Charts | (02:47) | |
| Create Text Boxes | (04:41) | |
| Create Worksheet Comments | (03:46) | |
|
Credits
|
||
| About the Author | (01:23) | |
This title is just part of the entire VTC collection of over 625 courses, 66,000 video tutorials (12,500+ free), available to you for just $30 a month.
View All Titles 
Email this Page
Send us FeedbackTutorial Information
| Title: | Microsoft Excel 2002 |
| Author: | Julia Kelly |
| SKU: | 33440 |
| ISBN: | 1932072403 |
| Release Date: | 2003-06-23 |
| Duration: | 6.5 hrs / 110 lessons |
| Captions: | No |
| Compatibility: |
Vista/XP/2000, OS X, Linux QuickTime 7, Flash 8 |
Subscription / Purchase Information
This title is just part of the entire VTC collection of over 625 courses, 65,000 video tutorials (12,500+ free), available to you for just $30 a month.
Purchase/Add to CartSelect Bandwidth
Now Shipping
Client Testimonials
I just finished Brian Whites InDesign CS2 course. It was the best one I have worked on so far. He did an excellent job--VERY thorough.
Michael Richards