| Microsoft Excel 2002 Tutorials Online |
 |
View simillar products Business Applications training - Microsoft training -
|
Description 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. |
| Sample - Preview the First 3 chapters of Microsoft Excel 2002 video free. Free learning Microsoft Excel 2002 online. |
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
Credits
About the Author
|
|
