Training CD Header Image Computer Training CD Image Computer Training CD Image Computer Training CD Image Computer Training CD Image Computer Training CD Image Computer Training CD Image
Computer Training CD Image Computer Training CD Image
Computer Training CD Image
Computer Training CD Image Computer Training CD Image Computer Training CD Image Computer Training CD Image Computer Training CD Image
Computer Training CD Image Computer Training CD Image
Computer Training CD Image Computer Training CD Image
Products Search
All Training Products
New Releases
Top Sellers

Adobe
Animation & 3D
Applications
Business
Computer Tech
Databases
Documentary History
Download Software
Educational
General Interest
Graphics & Page Layout
Internet
Macromedia
Microsoft Office
Multimedia & Video
Online Technical
Online General
Operating System
PDF & Downloads
Programming
Software & Design
Technical
Vocational Career
Web Design

Webmaster Resources
Free Downloads
Website Promotions
Dictionary Terms
Forum Links
Articles
Free Training Quizzes
About / Demos
SiteMap
Order Info
Online Course Login
Amazon eMall
Add to Favorites


Newsletter Signup
Microsoft Office|
>> Microsoft Excel 2002

Microsoft Excel 2002

Microsoft Excel 2002: With Microsoft Excel 2000, you can take advantage of comprehensive tools to create spreadsheets and share them on the Web for universal viewing and collaboration. Excel allows you to easily analyze data with charts, Microsoft PivotTable, and graphs. You can even use automatic formatting to create data-rich spreadsheets. In this tutorial, you are guided from basic thorough advanced techniques by author Lorie Flenner. She easily explains need-to-know topics such as columns and rows, workbooks and worksheets, basic and advanced formulas, and even how to insert graphics. If you need to know Excel, why not start now? Simply click a topic below.

Listed below are all of the chapter and lesson contents for the Microsoft Excel 2002
Try For Free Right Now
To help you evaluate our training, we have made some of the tutorials for Microsoft Excel 2002 freely available. Click on any of the linked lesson listings below to preview Free!

Microsoft Excel 2002

Format:CD

Duration:
8 hrs / 157
In Stock


Our Price: 129.95 Sale $99.95 Quantity
To view the Free Tutorials listed below, you must have Quicktime installed. Please note that the online free samples have been compressed for quicker downloads. Purchased CDs have higher sound and video quality. Monitor resolution needs to be set to at least 1024 by 768 to view the entire movie.
Introduction
Getting Started
The Interface
Menus
Toolbars
Formula Bar
Columns & Rows
Scroll Bars
Sheet Tabs
Status Bar
Interface Review
Workbooks & Worksheets
Open and Close Workbooks
Save Workbooks
Getting Help

The Basics
Select and Navigate Cells
Enter Data
Edit and Delete Data
Cut / Copy and Paste
Undo and Redo
Drag and Drop
Auto Fill
AutoCorrect

Working With Worksheets
Zoom Control
Views
Resize Rows and Columns
Insert Cells
Delete Cells
Insert and Delete Rows and Columns
Rename Worksheets
Insert and Delete Worksheets
Move and Copy Worksheets
Hide and Unhide

Formatting Cells
Text Formats
Align and Text Wrap
Alignment Effects
Format Painter
Borders and Shading
Numbers Formats
Date and Time Formats
Custom Formats
Autoformat
Conditional Formating
Styles

Basic Formulas
Formula Structure
Operators
Creating Formulas
Autofill Formulas
Autosum
Relative Reference
Absolute Reference
Function Wizard

Ready for Printing?
Headers and Footers
Print Preview
Scaling the Print Area
Set Print Area
Margins
Printing

Charts and Maps
Creating a Chart
Chart Wizard
Chart Options
The Legend
The Series
Chart Toolbar
3D Charts
Creating Maps
Customizing Maps
Labeling Maps

Advanced Formulas
If Functions
And / Or
Nested If Functions

Using Excel as a Databse
Create a Database
Sort Data
Filter Data
Advance Filter
Data Forms
Database Functions

Linking and Protecting
Formula Links
Range Names
Paste Special
Protect Cells
Protect Worksheets and Workbooks
Passwords

Analysis
Goal Seek and Solver
Scenarios
Pivot Tables
Validation
Auditing
Outlining

Toolbars and Macros
Customizing Toolbars
Create a Macro
Edit a Macro
Create a Macro Button

Graphics and The Drawing Toolbar
Insert a Picture
Move / Resize and Crop
Creating Shapes and Lines
Arranging and Grouping
Fills and Line Color
Arrows
AutoShapes
Flip and Rotate
Text boxes
WordArt
Shadow and 3D Effects
Featured Computer Training Products

Application Training: Flash MX Software Training, Dreamweaver MX Software Training, Fireworks MX Software Training
Computer Skills Development
: Computer Basics Training, Everything Desktop (Microsoft Training), Everything Handheld
Business Skills Development Training: Everything Quick Business, Everything OSHA, Everything HR/Legal, Everything Management Skills, Everything Sales Skills, Everything Basic Finance
Certification Training Everything MCSE, Everything MCSD, Everything O/S 390, Everything Programming, Everything Cisco, Everything UNIX, Everything Oracle, Computer Technician Training, Network Technician Training

Banner


CD Software Sale 1000s of Titles CD-ROM