Microsoft Excel 2002
Author:Chris Rasmussen/NMG
Language:english
Category:Internet Web Design,Programming,
Lessons:0 | 0 hrs
Buy Now or get more information about Microsoft Excel 2002
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. Virtual Training Company 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 below.
Microsoft Excel 2002Microsoft 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
First 3 Lessons Free Online (Press the links below to open up the free lessons. The lessons will open in a popup window from this screen and play in Quicktime):

Microsoft Excel 2002

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

Create Page Headers and Footers
See a Print Preview
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

01 Introduction
0101 About Excel
0102 Open/ Save/Close Workbooks
0103 What’s Inside the Workbook
0104 Menus and Toolbars
0105 What’s on a Worksheet
0106 Getting Assistance from Excel

02 Getting Started
0201 Select and Navigate Cells
0202 Enter Data
0203 Edit and Delete Data
0204 Undo and Redo
0205 Cut/Copy/Paste
0206 About the Office Clipboard
0207 Drag and Drop
0208 AutoFill
0209 More Ways to Enter Repetitive Data
0210 AutoCorrect
0211 Use a Data Entry Form
0212 Validate Data During Entry

03 Working With Worksheets
0301 Resize Rows and Columns
0302 Insert and Delete Rows/Columns/Cells
0303 Rename Worksheets
0304 Move and Copy Worksheets
0305 Insert and Delete Worksheets
0306 Freeze and Split a Worksheet
0307 Open Multiple Windows

04 Simple Calculations
0401 Calculate Without a Formula
0402 Use AutoSum to Write Formulas
0403 Formula Structure
0404 Create Formulas
0405 Edit Formulas
0406 AutoFill Formulas
0407 Relative and Absolute References
0408 Functions
0409 Use the Function Wizard
0410 Name Cells and Ranges
0411 Use Names in Formulas

05 Using Advanced Functions
0501 AVERAGE/MAX/MIN
0502 SUMIF and COUNTIF
0503 VLOOKUP
0504 PMT
0505 NOW/ TODAY/CONCATENATE
0506 IF and Nested Functions

06 Organizing Data
0601 Sort Data
0602 Filter Data with AutoFilter
0603 AND and OR Filters
0604 Calculate Filtered Records
0605 PivotTables
0606 Consolidate Data
0607 Subtotal a Worksheet

07 Formatting Cells
0701 Text Formatting
0702 Align and Wrap Text
0703 Number Formats
0704 Date and Time Formats
0705 Custom Formats
0706 Borders and Shading
0707 Conditional Formatting
0708 Format Painter
0709 Styles
0710 AutoFormat a Table
0711 Transpose Tables and Merge Cells
0712 Format Several Worksheets Identically
0713 Save a File as a Template

08 Charting Data
0801 About Charts
0802 Create a Chart
0803 Resize and Relocate a Chart
0804 The Chart Toolbar
0805 Chart Options
0806 Legends/Titles/Axes
0807 Series Orientation and Order
0808 Create 3-D Charts
0809 Explode a Pie Chart
0810 Add Data Labels and a Data Table
0811 Trendlines
0812 Secondary Axes
0813 Format Chart Elements

09 Printing Data and Charts
0902 See a Print Preview
0901 Create Page Headers and Footers
0903 Set the Print Area
0904 Print a Selection
0905 Centering/ Margins/Gridlines
0906 Print on a Specific Number of Pages
0907 Print Multiple Worksheets/Copy/Collate Pages
0908 Print Row and Column Labels on Every Page
0909 Print Charts

10 Sharing and Protecting Data
1001 Share Data Between Workbooks
1002 Copying/Linking/Embedding Data
1003 Share Data with Other Programs
1004 Share a Workbook with Other Users
1005 Hide Worksheets
1006 Protect Cells
1007 Protect Worksheets and Workbooks

11 Analyzing Data
1101 Use Goal Seek to Find Answers
1102 Use Scenarios to Compare Alternatives
1103 Locate Worksheet Errors and Invalid Data

12 Customizing Excel
1201 Customize Your Toolbars
1202 Create a Custom Toolbar
1203 Automate with Macros
1204 Record a Macro
1205 Edit a Macro
1206 Assign a Macro to a Toolbar Button
1207 Create a Hyperlink to Open Another File

13 Graphics and The Drawing Toolbar
1301 Insert a Picture
1302 Move/Resize/Crop
1303 Draw Shapes and Lines
1304 Draw AutoShapes and Assign Macros
1305 Arrange and Group Drawing Objects
1306 Use Drawn Objects in Charts
1307 Create Text Boxes
1308 Create Worksheet Comments

Sponsors