| |
|
|
What
Microsoft Excel 2000 Intermediate Covers...
|
| |
|
| Lesson
1: Getting To Know The Worksheet Window |
- Opening Excel
- Splitting Your Worksheet Vertically
- Splitting Your Worksheet Horizontally
- Removing The Split Bars From Your
Worksheet
- Freezing Panes
- Unfreezing Panes
- Freezing Multiple Panes
- Unfreezing Multiple Panes
|
- Hiding Columns And Rows Using The
Format Menu
- Hiding Columns And Rows Using Your
Mouse
- Inserting Columns And Rows
- Removing A Column
- Inserting Multiple Columns
- Inserting Cells
- Cell Descriptions
- Review
|
| Lesson
2: The Function Wizard |
|
- The Function Wizard
- Calculating An Average
- Calculating A Median
- Calculating A Standard Deviation
- Creating A Chart
- Formatting Chart Components
- Changing The Fill Color
- The Gradient Tab
- Selecting A Gradient
- The Texture Tab
- The Pattern Tab
|
- The Picture Tab
- The Data Labels Tab
- The Options Tab
- Rotating Your Pie Chart
- Separating The Pieces Of A Pie Chart
- Saving Your Chart
- Using The Sheet Tabs
- The Wonders Of AutoSum
- Improving The Appearance Of Your Chart
- Review
|
| Lesson
3: Excel And The Internet |
- The Auto Outline Feature
- Expanding Information In An Outline
- Viewing The Print Preview Of Your
Outline
- Clearing The Outline
- Opening Multiple Worksheets Simultaneously
- Displaying Multiple Worksheets Simultaneously
|
- Inserting Multiple Sheets
- Adding Information To Multiple Tabs
- Linking Cells To Files
- Linking Cells To The Internet
- Review
|
| Lesson
4: Formulas And More |
|
- Creating Absolute Values
- Copying Cell Formulas
- Removing Absolute Cell References
- Creating An IF Statement
- Copying An IF Statement
- More On AutoSum
|
- Using Goal Seek
- Naming A Group Of Cells
- Using VLOOKUP
- Copying A Formula Into A Block Of
Cells
- Applying The TREND Function
- Review
|
| Lesson
5: More Customizing Options |
- Opening Multiple Documents Simultaneously
- Viewing Two Documents At Once
- Linking Cells Changing Cell Formulas
- Verifying Linked Cells
- Customizing Worksheets
- Viewing Add-Ins
- AutoFormat Features
- The Spell Checker
|
- Selecting Background Colors
- Formatting Cell Properties
- Representing Numbers
- Text Alignment
- Font Options
- Applying A Border
- Review
|