Learn Microsoft Excel 2002

Unlimited Online Training and Tutorials

Microsoft Excel 2002 Online Video Training and Tutorials by Julia Kelly consists of approximately 6.5 hours of training over 109 lessons. Start learning right now, free. Just click any lesson below to begin.

Course Outline For:

Microsoft Excel 2002

Start learning Microsoft Excel 2002 right away, Free! Click on the highlighted lesson links below to view the lessons immediately. You will require Quicktime. If you have any problems viewing the lessons, click here

Introduction

About Excel

Open/ Save/Close Workbooks

WhatÌs Inside the Workbook

Menus and Toolbars

WhatÌs on a Worksheet

Getting Assistance from Excel

Getting Started

Select and Navigate Cells

About the Office Clipboard

Drag and Drop

AutoFill

More Ways to Enter Repetitive Data

AutoCorrect

Use a Data Entry Form

Validate Data During Entry

Working With Worksheets

Resize Rows and Columns

Insert and Delete Rows/Columns/Cells

Rename Worksheets

Move and Copy Worksheets

Insert and Delete Worksheets

Freeze and Split a Worksheet

Open Multiple Windows

More lessons below ...

Would you like to continue? You can have instant access to the rest of this training for just $30.00

Subscribe Now!

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

Microsoft Excel 2002 Video Training Detail:

Instructor:	Julia Kelly
Course Lessons:	109 Total Lessons
Course Duration:	6.5hrs total
First Release Date:	2003-06-23
Course Price:	N/A - Included with membership
Monthly Membership:	$30 month to month
Annual Membership:	$250 annually
Courses Included:	ALL Training Titles

Sign Up Now and Start Learning!

Course 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.

Sign Up Now and Start Learning!

WHY BECOME A MEMBER?

This is the easiest, best, most cost effective way to learn Microsoft Excel 2002 from VTC Instructor Julia Kelly?

Huge Learning Library Included - Access to one course includes access to our entire learning library of over 400 courses with 55,000+ lessons.

Superior Teaching Methods - No Books or classrooms! Combined video and audio delivered on your PC or Mac in bite size lessons - superior learning and retention. Many courses includes downloadable work files!

Flexible Learning - Learn on your schedule, at your pace... starting 60 seconds from now if you like!

Certifications - Downloadable (and third party verifiable) Certificates of Completion with each course you complete.

No Long Term Commitment - You CAN subscribe for a year to save $$, but you are also welcome to go month to month and cancel or suspend at anytime, no questions asked.

Proven Worldwide - Tens of thousands of students, professionals, small businesses, big businesses, schools, and governments around the globe use our training - Over 400 new members join every day.

Sign Up Now and Start Learning!

Students | Small Business | Big Business | Government | Schools

Try ANY Course Free | Available Courses | Complete F.A.Q. | Multi-User Accounts | Training on CDRom