Microsoft Excel 2002 Tutorial

We hope you enjoyed the FREE lessons above. To view the complete contents, including ALL the lessons below, please purchase the CD.
CLICK HERE TO BUY THIS CD

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