2. Important Topics

• The topics you'll need to know in order to complete the upcoming Excel homeworks include:

  • FORMATTING

    • Numbers

    • Cells: background (pattern), font color, borders and alignment

    • Conditional Formatting

    • Dates

    • Merging and Centering Cells

  • FUNCTIONS

    • AVERAGE

    • SUM

    • MAX

    • MIN

    • PMT

    • ROUND

    • TODAY

    • AVERAGE

  • Printing

  • Absolute and Relative Cell References (Pay particular attention to this one; it's where many students lose points)

  • Sorting - on two columns

  • Working with multiple worksheets: referencing data from another sheet.

• Most of these topics are included in the required readings; some are not. Here's another site that might be helpful in finding information on a topic not included in the required readings. You're not required to read through each lesson, but you might find some of the individual lessons useful: Excel Tutorial

• If you liked the first two Audio Tutorials, here's a link to a Microsoft site that has many more audio tutorials covering various Excel topics: Excel 2003 Training from Microsoft Office OnLine.