|
      Call Us at 317-881-3826
Or
Click here:
Chat Live: Instant
Message
USING
EXCEL 97
INTERMEDIATE
Netscape
4.05 & earlier & Microsoft IE 4.5 for
Macintosh Y2K Browser Bug
Working
in the Excel
Worksheet
- Opening a Saved Document
- Splitting Worksheets
- Freezing Panes
- How to Unfreeze Panes
- Hiding Rows and Columns
- Hiding Rows Using the Format Menu
- Hiding Columns Using the Mouse
|
- Inserting Single Columns
- Inserting Single Rows
- Inserting Multiple Columns
- Function Hot Keys
- Inserting Blocks of Cells
- Closing Excel
|
The
Function Wizard
- Welcome to the Function Wizard
- The Law of Averages
- Finding the Median
- What is Standard Deviation
- Creating Charts and Graphs
|
- Formatting Chart Properties
- Using Sheet Tabs in a Worksheet
- The Wonders of Auto Sum
- Finishing Touches
|
Excel and
the Internet
- Auto Outline Buttons
- Auto Outline Print Preview
- Working with Multiple Files
- Tiling Multiple Windows
|
- Adding Multiple Sheets
- Adding Multiple Cell Information
- Creating a Hyperlink
- Linking to the Internet
|
Formulas And
More
- Making Cell References Absolute
- Copying Formulas from Cell to Cell
- Removing Absolute Values
- The "IF" Statement
- The Function Wizard
|
- The Goal Seek Command
- Defining Cell Groups
- The "VLOOKUP" Function
- Discovering Trends
|
More
Customizing Options
- Arranging Your Windows
- Linking Cells in Separate Files
- Verifying Linked Cells
- Exploring the General Options
- Excel Add-Ins
- The Auto Format Function
|
- Checking Your Spelling
- Excel Color Options
- Customizing Your Cells
- Angling Cell Text
- More Cell Formatting Options
|
|