Excel 2000 Intermediate

Lesson 1: Getting To Know The Worksheet Window, Introduction, 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, Introduction, 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, Introduction, 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, Introduction, 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, Introduction, 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