Excel 2002 Video tutorial
After
taking this course; the power of Excel 2002 will be yours to
command. With Excel you can create eye popping graphs and charts
(even 3D), have Excel voice synthesize your tables, or save hours
summarizing data. At the conclusion of this course you'll feel
confident using Excel 2002 and understand how to use it
to maximize productivity.
Why pay hundreds of dollars for classroom training that goes in
one ear and then comes out the other?
Why pay for a dull book which you put down after two chapters?
The advantages of our Excel 2002 Video tutorial are:
- You will learn more about Excel 2002 than from any other Excel
2002 tutorial.
- The Excel 2002 tutorial is video based - you'll see exactly
what buttons we press in the order you're supposed to press them!
- No better value Excel 2002 tutorial on the net.
- Nearly 3 hours of high quality video recording!
- Once you've installed the Excel 2002 tutorial you don't
need an internet connection to view the video tutorial.
- Plus we'll throw in Excel 2000 video tutorial for FREE at
over 4 hours long.
Excel 2002 Class Index
Getting Started
- Identify What You Can Do with Excel
- Enter Data in a Worksheet
- Entering Data
- Edit Data
- Change the Appearance of Data
- Save a Workbook
- Obtain Help
Editing Your Worksheet
- Move Data to Other Cells
- Copy Data to Other Cells
- Fill Cells with a Series of Data
- Insert and Delete Rows and Columns
- Undo and Redo an Entry
- Find and Replace Numbers
- Enter Data in a Range
- Verify Data in a Range
Performing Calculations
- Sum a Range of Data
- Use a Built-in Function
- Copy a Formula
- Create an Absolute Reference
Formatting
- Specify Numeric Format
- Create a Custom Numeric Format
- Change Font Size and Type
- Apply Styles
- Add Borders and Colors to Cells
- Find and Replace Formats
- Change Column Width and Row Height
- Align Cell Contents
- Merge and Center Cells
- Apply an AutoFormat
Working with Multiple Worksheets
- Format Worksheet Tabs
- Reposition Worksheets in a Workbook
- Copy Worksheets
- Change the Number of Worksheets
Creating and Modifying Charts
- Create a Chart
- Modify Chart Items
- Format a Chart
- Change the Chart Type
Setting Page Display and Printing Options
- Freeze Rows and Columns
- Set Print Titles
- Set Page Margins
- Create a Header and Footer
- Change Page Orientation
- Insert and Remove a Page Break
- Print a Range
What you need to use the Excel 2002 tutorial
Please ensure your computer system meets these requirements in order
to use the Excel 2002 tutorial:
Bonuses
You will Receive all of our video tutorials on one DVD with this tutorial.
|
