Microsoft Excel 2002 Tutorial - Training Videos

Training CDs > Business Tutorial Videos > MICROSOFT EXCEL 2002

Affordable Training you can depend on
This Microsoft Excel 2002 video tutorial utilizes an easy to follow training format that is both engaging and informative. Created to assist the beginners to intermediate users, the author uses a unique training method that brings a high degree of visual clarity to even the most complex applications. Being over 6.5 hours long these Microsoft Excel 2002 tutorials are extremely comprehensive and easy to follow. Video Training by Experts - Low Cost.

Not sure which Training CDs to buy?
The Online University allows unlimited access to the entire range of training titles for one low fee of only $30 per month. There is no fixed term, no limits, and you can cancel at any time. For corporate users and schools we also offer multi user accounts.
Find out more about the online video tutorials »

About the Free Video Online Training Course Demos
To allow you to evaluate the quality of the Microsoft Excel 2002 training course we have made the first 3 chapters of this tutorial available for free viewing online, the purchased version of this training course contains all the topics listed below. The free demos below have been compressed for faster playback over the internet, the audio and video quality of the purchased CD / DVD is far greater. To play the free demo videos you will need QuickTime,

THIS TUTORIAL COVERS THE FOLLOWING SUBJECTS

Description

This Microsoft Excel tutorial is for users of version 2002, and offers excellent tuition for the beginner / intermediate user that wishes to get more from Excel, learn how to create, edit and share date, use formulas, import and export data, in short this training CD teaches you all you need to know to use Excel in a commercial environment. Taught using narrated QuickTime movies and real life examples, users will find this form of training easy to use. Topics covered include: Autofill, Worksheets, Formulas, AutoSum, Functions, Pivot Tables, Charts, Text Boxes and much more. We also have a more current training CD : Microsoft Excel 2007 Fundamentals

Microsoft Excel 2002 Related Groups

Hide Description

The Blue Links below are free demos, when you purchase the video training CD / DVD the enitre content listings below are included , not just the free demo videos.

Introduction

Getting Started

Working With Worksheets

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

Create Page Headers and Footers
See a Print Preview
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 Tutorials - VIDEO INFO

» Studio quality audio and video
» Works on Pc or Mac
» Ideal for people that learn quicker by being shown
» Master complex application in days

Title	:	Microsoft Excel 2002
Instructor	:	Julia Kelly
Price	:	US$ 99.95
Duration	:	6.5 hours - 109 Movies
OS	:	Win Vista XP 98,2000,ME. Mac OS 9, OS X
Delivery Options	:	Ground / 2 day / Next Day
Product Code	:	33440

BENEFITS OF THIS TRAINING COURSE

Master Microsoft Excel 2002 in the shortest time possible
Self paced tutorial, training on video, at your own pace
Just sit back and watch, no books to read, just easy to follow lessons
Training can be viewed from any location, on PC or Mac
All training is self-contained; you don’t even need the application you are learning loaded on your machine
The most affordable way to learn, benefit from a world-leading expert
High quality content for a fraction of the cost of a classroom training course
The Tutorials can be rewound, fast forwarded or stopped at any time
Learn from the comfort of your own desk.