Self Study, Tutorial Video on CD - DVD. The tutor guides you using step-by-step examples. Learn directly from your own desk high quality training videos at an affordable price. Works on both 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

Associated Tutorials: Microsoft PowerPoint 2007 | Microsoft Excel - Statistics | Excel 2003 | Visual Basic for Excel - VBA | Microsoft Excel Automation | Microsoft Outlook Tutorial | Microsoft Excel Training DVD | QuickBooks 2012

Microsoft Excel 2002 Tutorial CD / DVD

When you order this Microsoft Excel 2002 Video Tutorial CD You'll Receive...
Over 6 hours of high quality video-based training that walks you through the program in easy to follow stages.

A training video that focuses on real life examples and teaches you
real life skills. These tutorials are structured to increase not only your skills but also your earning potential.

With this Training Video you will...
Learn Microsoft Excel 2002 from a leading expert and quickly master the skills required to work in a commercial environment.

Learn how to simplify your workflow and increase your productivity using tips and techniques of the pros. Ideal training for Beginners and Advanced users alike

Customer Comments
" ...actually started using your products at work and they were so effective that I bought a couple of titles for myself. "Mike Smithson, North Carolina

Microsoft Excel 2002 Tutorial CD / DVD

Create the best self-paced learning environment right on your own desktop.
Professionally created, comprehensive video based training that's easy to follow. At an unbelievable price.

Topics Covered on this Training Course

This Training is 6 Hours in Duration and Covers 109 Lessons.
Introduction Getting Started Working With Worksheets
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

Select Playback Format for the Free Demos:

Quicktime
Flash

Did You Know ?

We offer more than 700 video-based courses, and you can watch the first three chapters of every listed course for FREE with no obligation to buy.

Later Title Available
A more recent video tutorial is available
Microsoft Excel 2010 Tutorial »

About this Microsoft Excel 2002 Training CD

Title Microsoft Excel 2002
Tutor Julia Kelly
Other tutorials by Julia Kelly
Videos 109 Lessons- Video run time: 6 hours
Compatibility Vista, XP, Windows 7, Mac OSX
Released 2003
Availability Immediate Dispatch
Price US / Canadian Sales Only $99.95
Closed Captions Closed Captions are not Enabled on this title
240 in stock
Purchase Orders from Schools, Colleges, Government and Military Accepted

Mutli User Training Options

This training video is also available in Multi-user format, ideal for Schools, Universities, or Corporate users where training multiple delegates is the most cost effective way of training.

10 Multi User $500

Not Sure Which Titles to Buy? Unlimited Access to all -$30

Need to learn more than one topic? Get Unlimited Access to all the courses listed on this site for just $30!
Unlimited Access to over 70,000+ Training Videos

Not sure which training CD titles to purchase? Why not join our Online University and have unlimited access to all our tutorial videos for one low price of $30 per month.
No contract .
No minimum period.
No commitment on your part.

Within minutes you'll have instant, unlimited access to over 700 courses covering over 6000+ hours of training, all from the comfort of your own desk.

Need to learn from more than one location? Not a problem, you're free to access the training from anywhere you wish. It's highly cost effective learning with no limits. We also offer Multi User accounts for companies and schools who need to train multiple users.
Online Learning with No Limits

Why Is This Training Format So Effective?

  • Learn Microsoft Excel 2002 from an accredited expert in days.

Want to hear what our customers say about our products?

Related Training Videos

Microsoft Project Tutorial | FileMaker Tutorials | Excel Tutorial Videos | Online Microsoft Excel 2002 Training Courses

Prove your Knowledge - Free Certificate

Prove Your Credentials!
Free Certificate.