Microsoft Excel 2002 Tutorial Video

Self Study, Microsoft Excel 2002 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 .

try for free

Microsoft Excel 2002 Tutorial CD / DVD

Creates the perfect self-paced learning environment
on your own desktop.

Professionally created, comprehensive video based training that's easy to follow. At an unbelievable price.

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.

Problems Playing the Demos?
Benefits
  • Professional Tuition by expert
  • Free Certificate with each Tutorial
  • Works on PC or Mac
Topics Covered on this Training Video Include:
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
UK & Europe
Apex Web Media
PO Box 398
Bolton, BL7 9RZ
United Kingdom
T: 01204 592071
USA & Canada
600 17th Street, Suite 2800, Denver CO 80202
Open 8am - 5pm M to F (EST)
Tel - Toll free 1866 402 1903 ( USA )
Tel 434-878-4158
Fax 1 207 433 4356