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 2003

Microsoft Excel 2003

Microsoft Excel 2003: Microsoft Excel 2002 offers tools that make it easy to access, connect, and analyze critical data, proving that Excel spreadsheets are no longer just for financial professionals. Discovery Computer Training author Julia Kelly will instruct users on how to use this powerful spreadsheet program. Excel 2002 allows users to find and format data more quickly by utilizing context sensitive options as tasks are being performed. The new Error Checking smart tag feature allows users to fix, or ignore an error. Document Recovery automatically saves current workbooks, protecting your work. Refreshable queries allow users to integrate live data from the Web, or any other source. To get started, simply click on one of the movie topics belowListed below are all of the chapter and lesson contents for the Microsoft Excel 2003
Try For Free Right Now
To help you evaluate our training, we have made some of the tutorials for Microsoft Excel 2003 freely available. Click on any of the linked lesson listings below to preview Free!

Microsoft Excel 2003

Format:CD

Duration:
6.5 hrs / 109
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
About Excel
Open/ Save/Close Workbooks
What’s Inside the Workbook
Menus and Toolbars
What’s on a Worksheet
Getting Assistance from Excel

Getting Started
Select and Navigate Cells
Enter Data
Edit and Delete Data
Undo and Redo
Cut/Copy/Paste
About the Office Clipboard
Drag and Drop
AutoFill
More Ways to Enter Repetitive Data
AutoCorrect
Use a Data Entry Form
Validate Data During Entry

Working With Worksheets
Resize Rows and Columns
Insert and Delete Rows/Columns/Cells
Rename Worksheets
Move and Copy Worksheets
Insert and Delete Worksheets
Freeze and Split a Worksheet
Open Multiple Windows

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
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