Microsoft Excel 2002 Tutorial Try for FREE
Select a tutorial category
Discounted Training Courses
Members of the VTC Online University have unlimited access to this tutorial. At the moment, you are in demo mode and only the first 3 chapters will play. But members have access to EVERY SINGLE TITLE IN OUR RANGE, i.e., over 40,000 tutorials on 400+ titles all with expert tutors. Where else can you get high quality one to one training for just $30.00 per month!
Benefits
:- 01. Unlimited viewing.
- 02. Downloadable working files.
- 03. Expert instructors.
- 04. Use at home / work or both.
- 05. Works on PC or Mac.
- 06. Telephone Tech support.
- 07. Cancel at any time.
- 08. 300+ courses for 1 low fee.
- 09. New titles added regularly.
- 10. 100% Guaranteed
Should you need any help, just call - contact details at the bottom of the page.
Unlimited Professional Training on over 400+ applications and programming languages for only $30.
The fastest and most cost effective way to learn! Forget boring books! No need for expensive classroom training - just easy to follow training videos that play right from your own computer. Login from home or office - the choice is yours. All courses are taught by world leading experts, unlimited access, on over 400 different subjects.Please Note:
You are in Demo mode which only allows access to the first 3 chapters of this Microsoft Excel 2002 training course and all the other titles listed on this site, this is to help you evaluate the quality of the training before joining. If you decide to join, you will instantly have totally UNLIMITED ACCESS to over 400 professionally created video tutorials, you will be able to access the content from any location and no restrictions are placed on the amount of content you can watch, you can also cancel at any time you wish. Over 4000 hours of training for just $30.00.
You are in Demo mode which only allows access to the first 3 chapters of this Microsoft Excel 2002 training course and all the other titles listed on this site, this is to help you evaluate the quality of the training before joining. If you decide to join, you will instantly have totally UNLIMITED ACCESS to over 400 professionally created video tutorials, you will be able to access the content from any location and no restrictions are placed on the amount of content you can watch, you can also cancel at any time you wish. Over 4000 hours of training for just $30.00.
Can also be Viewed using Flash
Topics covered on this course include:
Introduction
- About Excel Demo
- Open/ Save/Close Workbooks Demo
- What’s Inside the Workbook Demo
- Menus and Toolbars Demo
- What’s on a Worksheet Demo
- Getting Assistance from Excel Demo
Getting Started
- Select and Navigate Cells Demo
- Enter Data Demo
- Edit and Delete Data Demo
- Undo and Redo Demo
- Cut/Copy/Paste Demo
- About the Office Clipboard Demo
- Drag and Drop Demo
- AutoFill Demo
- More Ways to Enter Repetitive Data Demo
- AutoCorrect Demo
- Use a Data Entry Form Demo
- Validate Data During Entry Demo
Working With Worksheets
- Resize Rows and Columns Demo
- Insert and Delete Rows/Columns/Cells Demo
- Rename Worksheets Demo
- Move and Copy Worksheets Demo
- Insert and Delete Worksheets Demo
- Freeze and Split a Worksheet Demo
- Open Multiple Windows Demo
Simple Calculations
- Calculate Without a Formula
- Use AutoSum to Write Formulas
- Formula Structure
- Create Formulas
- Edit Formulas
- AutoFill Formulas
- Relative and Absolute References
- Functions
- Use the Function Wizard
- Name Cells and Ranges
- Use Names in Formulas
Using Advanced Functions
- AVERAGE/MAX/MIN
- SUMIF and COUNTIF
- VLOOKUP
- PMT
- NOW/ TODAY/CONCATENATE
- IF and Nested Functions
Organizing Data
- Sort Data
- Filter Data with AutoFilter
- AND and OR Filters
- Calculate Filtered Records
- PivotTables
- Consolidate Data
- Subtotal a Worksheet
Formatting Cells
- Text Formatting
- Align and Wrap Text
- Number Formats
- Date and Time Formats
- Custom Formats
- Borders and Shading
- Conditional Formatting
- Format Painter
- Styles
- AutoFormat a Table
- Transpose Tables and Merge Cells
- Format Several Worksheets Identically
- Save a File as a Template
Charting Data
- About Charts
- Create a Chart
- Resize and Relocate a Chart
- The Chart Toolbar
- Chart Options
- Legends/Titles/Axes
- Series Orientation and Order
- Create 3-D Charts
- Explode a Pie Chart
- Add Data Labels and a Data Table
- Trendlines
- Secondary Axes
- Format Chart Elements
Printing Data and Charts
- See a Print Preview
- Create Page Headers and Footers
- Set the Print Area
- Print a Selection
- Centering/ Margins/Gridlines
- Print on a Specific Number of Pages
- Print Multiple Worksheets/Copy/Collate Pages
- Print Row and Column Labels on Every Page
- Print Charts
Sharing and Protecting Data
- Share Data Between Workbooks
- Copying/Linking/Embedding Data
- Share Data with Other Programs
- Share a Workbook with Other Users
- Hide Worksheets
- Protect Cells
- Protect Worksheets and Workbooks
Analyzing Data
- Use Goal Seek to Find Answers
- Use Scenarios to Compare Alternatives
- Locate Worksheet Errors and Invalid Data
Customizing Excel
- Customize Your Toolbars
- Create a Custom Toolbar
- Automate with Macros
- Record a Macro
- Edit a Macro
- Assign a Macro to a Toolbar Button
- Create a Hyperlink to Open Another File
Graphics and The Drawing Toolbar
- Insert a Picture
- Move/Resize/Crop
- Draw Shapes and Lines
- Draw AutoShapes and Assign Macros
- Arrange and Group Drawing Objects
- Use Drawn Objects in Charts
- Create Text Boxes
- Create Worksheet Comments
If you would like to own this Microsoft Excel 2002 training title on CD, you may purchase it from our online store, because we don't have to use the same level of compression on the CDs as we do with the online, the audio and video playback is of a higher quality. For a single low payment you can buy this
After you have completed a tutorial, a 
In order to view the training, you must have the latest version of QuickTime installed. Please note that the online movies have been compressed for quicker downloads, CDs and DVDs have far higher audio and video quality.