What Microsoft Excel 2000 Basic Covers...

 
Lesson 1:  Getting Started
  • Opening Excel 2000
  • What is Excel?
  • The Office Assistant
  • Office Assistant Options
  • The Title Bar
  • The Menu Bar
  • The Standard Toolbar
  • The Formatting And Formula Toolbar
  • The Drawing Toolbar And Minimizing Excel
  • Maximizing Excel
  • Minimizing A Spreadsheet
  • Restoring A Spreadsheet
  • Maximizing A Spreadsheet
  • The Horizontal And Vertical Scrollbars
  • Hiding The Office Assistant
  • Multiple Worksheets
  • Adding A Worksheet
  • Renaming A Worksheet
  • Deleting A Worksheet
  • Putting It Into Practice
  • Closing The Workbook
  • The Save As Dialog Box
  • Review
Lesson 2:  Entering And Working With Data  
  • Entering Text Into A Spreadsheet
  • Moving The Cell Marker
  • Rotating Text
  • The Undo Button
  • More Formatting Options
  • Moving The Cell Marker
  • Entering Numerical Values In A Cell
  • The Name Box
  • Resizing Columns
  • Selecting Multiple Cells
  • Selecting Non-Adjacent Cells
  • Applying Formatting Changes To Multiple Cells
  • Deselecting A Range Of Cells
  • Inspecting Changes
  • Inserting Rows
  • Inserting A Column
  • Entering Formulas Into A Spreadsheet
  • The AutoFill Command
  • The Average Function
  • Formatting Decimal Places
  • The Number Tab
  • Office Assistant Tip
  • Inserting A Row
  • Revising A Formula
  • Sorting
  • Inserting Comments
  • Hiding A Comment
  • Deleting A Comment
  • The If Function
  • Selecting Multiple Cells With The Name Box
  • Using Absolute Cell References
  • The If Function
  • Reviewing Results
  • Saving Changes
  • Review
Lesson 3:  Inserting Objects And Formatting Cells
  • Opening Excel
  • Open Options
  • Changing The Zoom Percentage
  • The ClipArt Gallery
  • Selecting A ClipArt Category
  • Searching For ClipArt
  • Moving ClipArt Objects
  • Sizing A ClipArt Object
  • Ungrouping ClipArt
  • Inserting A Picture From File
  • Inserting WordArt
  • Editing WordArt
  • Sizing WordArt
  • The Text Envelope Feature
  • The AutoShapes Feature Adding Color To AutoShapes
  • Changing The Font
  • Line Color
  • Changing The Color Of Text
  • Changing Text Size
  • Changing The Indent Of Text In A Cell
  • Merge And Center
  • Creating A Flowchart
  • Drawing A Rectangle
  • Drawing An Oval
  • Changing The Color Of A Shape
  • Inserting Arrows
  • Changing Arrow Style
  • AutoShape Connectors
  • Making A Colored Shape Transparent
  • Adding Text To Objects
  • Adding Shadow To An Object
  • Making Objects 3-D
  • Closing And Saving
  • Review
Lesson 4:  Chart Creation And Formatting  
  • Opening Excel
  • Opening The Spreadsheet
  • Selecting A Range For Graphing
  • The F11 Key
  • Elements Of A Chart
  • The Legend
  • The X Axis
  • The Y Axis
  • The Y Axis
  • Deleting A Chart
  • The Chart Wizard
  • The Bar Chart
  • The Line Chart
  • The Pie Chart
  • Choosing A Chart Subtype
  • Previewing The Chart Type
  • Altering The Data Range
  • Adding A Title To A Chart
  • Showing Or Hiding Axis Labels
  • Altering Gridlines
  • Altering A Chart Legend
  • Data Labels
  • The Data Table
  • As Object Or New Sheet
  • Modifying The Chart's Appearance
  • Changing The Chart Area
  • Changing A Fill Effect Of The Chart Area
  • Changing The Chart Area Font Size
  • Changing The Chart Area Font Color
  • Formatting The Legend
  • Formatting The Chart Title
  • Formatting Data Series
  • Changing The Series Order Of A Chart
  • Adding A Picture From File To A Chart Wall
  • Formatting Gridlines
  • Object Linking
  • Other Chart Types
  • Copying A Chart To A Spreadsheet
  • Closing Excel
  • Review
Lesson 5:  Printing And Help
  • Opening An Existing Spreadsheet
  • Page Setup
  • Page Orientation
  • Scaling
  • Changing Paper Size
  • Adjusting The Margins
  • Centering The Spreadsheet On The Page
  • The Header And Footer
  • Creating A Custom Footer
  • Printing Gridlines
  • Printing In Black And White
  • Page Order
  • Print Preview
  • Print Preview Zoom
  • Changing Margins In Print Preview
  • Page Break Preview
  • Changing Back To Normal View
  • The Print Dialog Box
  • Changing The Number Of Copies
  • Collate
  • Print Area
  • Previewing The Print Area
  • Clearing The Print Area
  • Help
  • What's This?
  • Microsoft Excel Help
  • The Answer Wizard
  • The Contents Tab
  • The Index Tab
  • Review