Microsoft Excel 2002 Tutorials

Later Version Also Available
Did you know we also have the more recent:
Microsoft Excel 2007 Tutorials available »

Details

Highly Effective Microsoft Excel 2002 tutorials on video CD, learn from your own desk at a pace that suits you. Low cost high quality training at an affordable price. Works on PC and Mac.

 

These Microsoft Excel tutorials cover everything that the user needs to carry out a multitude of tasks using this spreadsheet application. Author Julia Kelly uses a step by step approach and practical examples to ensure that even the complete novice can follow, understand and then execute what as been taught, due to the unique format in which these tutorials are presented knowledge retention is extremely high and even the most complex tasks can be accomplished very quickly.Releated topics : Microsoft Excel 2007 Tutorials
Close
Microsoft Excel 2002 Training CD / DVD Contents
Professionally created, comprehensive training that's easy to follow at an unbelivable price.

See the quality for yourself. Try a FREE Demo.

The blue links below are Free Microsoft Excel 2002 Tutorial Videos.

Try for FREE - NOW
To help you evaluate this training CD / DVD the first 3 chapters are available for free, click on any of the links below for a FREE DEMO.

Read before watching the free videos
The sound quality and frame rate of free online tutorials has been reduced to allow for faster streaming. The quality on CD / DVD is far higher.
Quicktime
*QuickTime is needed to view the videos. Some titles have been converted to play via Flash.
This tutorial can also be viewed using Flash:
Click To View in Flash
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
We hope you enjoyed the free videos above. To watch all this course including the chapters below please purchase the CD.
$99.95
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 Training CD Information

Title : Microsoft Excel 2002
Tutor : Julia Kelly
Other tutorials and training by this author
Movies : 109 Lessons- Video run time: 6 Hours
Availability : Immediate Dispatch
Compatibility: Vista, 98, 2000, NT, XP, Mac OS, OSX
Released 2003-06-23
Price US / Canadian Sales $99.95

640 In Stock

Add to Cart

Why use this method of video training ?
  • Learn Microsoft Excel 2002 from an accredited expert in days.
  • Ideal for beginners, easy to follow videos that offer visual clarity.
  • Master a full application for a fraction of the cost of classroom based training.
  • Unique teaching method that offers accelerated learning and high retention.
  • Used by many large companies, schools, universities,
  • Learn from your own desk at a speed that suits you
  • Cost effective tuition from leading experts
  • You control the pace, training can be stopped, rewound or fast forwarded as required.

Associated Titles:

Free Certificate. Prove your credentials
online people


We now offer all customers a free certificate to verify they have undertaken a Microsoft Excel 2002 course, the unique certification number allows third parties to check the authenticity of your certificate online. After your purchase you can download your Microsoft Excel 2002 certificate without delay.

Online University Access all our Training for only $30.00

Not sure which training CD titles to purchase ? Why not join our Online University and have unlimited access to all our titles for one low price ?

online people

over 4000 hours of high quality online training for only $30.00. Unlimited access

learn from your own desk -expert tutorials - affordable tuition.
No minimum sign up period.
Want to see how good our online university is? - Why not try a free Demo

For low monthly fee you have unlimited access to all the 300+ training titles in our range, that's over 35,000 tutorials covering 4000 hours+! Watch when ever you like, from any computer - NO LIMITS.

Join Today and learn quicker and cheaper than you ever thought possible.

Become a expert without having to read a book or attend expensive training courses.

Where else can you find step-by-step training for over 300 software applications delivered to your own desk, from a leading expert, for less then a Dollar a day ?

Want to see how good our online university is? - Why not try a free Demo, and if all that's not enough, we add new video tutorials each month for no extra charge!

Free Newsletter

If you would like to be notified as we release new video tutorials, run special offers, or promotions.
Sign up now. Your details are kept secure and never sold rented or used by any other 3rd parties.

Microsoft Excel 2002 Related Product Groups:

Access Tutorials | Microsoft Office for the Mac | Apple iWork Tutorials | Microsoft Word |Excel Tutorials | FileMaker Pro | Microsoft Outlook Training | Microsoft Project 2007 | Microsoft PowerPoint | Microsoft Visio | Online Microsoft Excel 2002 Training Courses