Excel 2000 Step by Step

Part I Getting Acquainted

Lesson 1      Working In The Excel Environment

Quick Reference: Pg. 26

  1. Open and save a workbook
  2. Move around in a workbook, easily and fast
  3. Enter and edit text and numbers manually and automatically
  4. Using Quick Features
  5. Undo and redo changes
  6. Check Spelling
  7. Customizing Toolbars in Excel 2000

Lesson 2      Setting Up A Worksheet

Quick Reference: Pg. 46

  1. Add a keyword to the workbook properties
  2. Name worksheets
  3. Enter labels and adjust the layout
  4. Add comments and set data validation
  5. Change cell alignment and wrapping
  6. Preview and print a worksheet, define print area
  7. Adding a Picture, format inserted picture

Lesson 3      Adding Formulas

Quick Reference: Pg. 63

  1. Open an existing workbook using its file properties
  2. Making formulas easy with named cells and ranges
  3. Add calculation formulas to a worksheet
  4. Copy a formula to another cell. Using absolute and relative cell references
  5. Calculate a total using the SUM function
  6. Using the IF function

Lesson 4      Dressing Up A Worksheet

Quick Reference: Pg. 81

  1. Creating cell attributes individually and applying borders and shading
  2. Creating cell attributes using styles and the format painter
  3. Apply special and custom formatting for specific data input
  4. Establish conditional formatting
  5. Add custom headers and footers
  6. Save a worksheet as a template
  7. Edit a template

Part I Review         Pg. 83

Part II Organizing & Summarizing Your Data

Lesson 5      Consolidating Multiple Lists

Quick Reference: Pg. 99

  1. Open groups of workbooks
  2. View and arrange groups of workbooks
  3. Combine worksheets from several workbooks into a single workbook
  4. Consolidate multiple worksheets data into a single list

5.        Create a summary and chart the data

Lesson 6      Filtering To Find Information

Quick Reference: Pg. 113

  1. Filter a list to find specific information
  2. Calculate sums in a list
  3. Find totals and averages quickly using AutoCalculate
  4. Calculate a set of filtered records using the SUBTOTAL function
  5. Edit a function, copy and paste

Lesson 7      Organizing Data By Sorting And Subtotaling

Quick Reference: Pg. 133

  1. Sort a list of information
  2. Freeze panes to view information in a large list
  3. Insert two levels of subtotals
  4. Build an outline
  5. Paste a picture of a worksheet into Microsoft Word 2000
  6. Record and test a macro

Part II Review        Pg. 135