 |
Excel 2002 Video tutorial |
Menu:
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 pounds 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!
- Nearly 3 hours of high quality video recording!
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:
- A Computer!
- Internet Browser
- Macromedia FLASH plugin
- Set of Speakers
Buy all these video and more on one very inexpensive DVD