A hands-on course in Excel 2000 for spreadsheet novices. Provides simple, step-by-step illustrated instruction in navigating around a worksheet, performing basic math operations, writing effective formulas, formatting labels and numbers, adjusting the width of columns, using relative and absolute cell addresses, using ranges and range names, calculating totals and averages, printing and saving workbooks. Data disk included.

Concepts you will master:

• Cell references
• Order of operations
• Cell ranges
• Relative and Absolute cell addressing
• Natural Language formulas

Skills you will learn:

• Moving the cell pointer
• Entering text
• Entering values and formulas
• Referencing cells in a formula
• Copying, moving and deleting cell data
• Formatting text
• Formatting values
• Adjusting column widths
• Creating an absolute cell reference
• Using the SUM() function
• Using the MIN(), MAX() and AVERAGE() functions
• Inserting rows and columns
• Creating and using range names
• Printing worksheets
• Saving, opening and closing files