Essentials Excel 2002 Level 1

PROJECT 1. GETTING STARTED WITH EXCEL. Lesson 1. Exploring the Excel Workspace. Lesson 2. Entering Text and Numbers. Lesson 3. Saving a Workbook. Lesson 4. Getting Help. Lesson 5. Entering a Formula. Lesson 6. Preparing a Worksheet for Printing. Lesson 7. Printing a Worksheet. Lesson 8. Closing a File and Exiting Excel. PROJECT 2. MODIFYING A WORKSHEET. Lesson 1. Opening an Existing Workbook. Lesson 2. Selecting Worksheet Items. Lesson 3. Using AutoFill. Lesson 4. Inserting and Deleting Rows and Columns. Lesson 5. Copying and Moving Cell Contents. Lesson 6. Using AutoSum. Lesson 7. Copying a Formula with Relative References. Lesson 8. Spell-Checking a Worksheet. PROJECT 3. IMPROVING THE APPEARANCE OF A WORKSHEET. Lesson 1. Formatting Numbers. Lesson 2. Aligning Cell Contents. Lesson 3. Changing Font and Font Size. Lesson 4. Applying Bold, Italic and Underline. Lesson 5. Adding Color. Lesson 6. Adding Borders. Lesson 7. Using Format Painter. Lesson 8. Removing Formatting. PROJECT 4. ENTERING FORMULA IN WELL-DESIGNED WORKSHEETS. Lesson 1. Working with Operators and Order of Precedence. Lesson 2. Using Type-and-Point to Enter Formulas. Lesson 3. Comparing Absolute and Relative Cell References. Lesson 4. Creating and Copying Formulas with Absolute or Relative Cell References. Lesson 5. Freezing and Splitting Worksheet Display. Lesson 6. Hiding and Unhiding Rows and Columns. Lesson 7. Displaying Formulas Instead of Formula Results. Lesson 8. Using Save as to Change the Filename, File Type or Storage Location. PROJECT 5. WORKING WITH FUNCTIONS. Lesson 1. Analyzing Data with AVERAGE, MAX and MIN. Lesson 2. Calculating a Loan Payment with PMT. Lesson 3. Creating a Loan Payment Table. Lesson 4. Evaluating Investment Plans with FV. Lesson 5. Using IF to Display Messages. Lesson 6. Using IF to Calculate.Mulbery, Keith is the author of 'Essentials Excel 2002 Level 1' with ISBN 9780130094780 and ISBN 0130094781.