Essentials

Marianne Fox—Series editor and coauthor of essentials Excel 2002 Level 1, Level 2, and Level 3. Marianne Fox is an Indiana CPA with B.S. and M.B.A. degrees in Accounting from Indiana University. For more than 20 years, she has enjoyed teaching full-time—initially in Indiana University's School of Business; since 1988 in the College of Business Administration at Butler University. As the co-owner of an Indiana-based consulting firm, Marianne has extensive experience consulting and training in the corporate and continuing education environments. Since 1984, she has coauthored more than 35 computer-related books; and has given presentations on accounting, computer applications, and instructional development topics at a variety of seminars and conferences. Lawrence C. Metzelaar—Series editor and coauthor of essentials Excel 2002 Level 1, Level 2, and Level 3. Lawrence C. Metzelaar earned a B.S. in Business Administration and Computer Science from the University of Maryland, and an Ed.M. and C.A.G.S. in Human Problem Solving from Boston University. Lawrence has more than 30 years of experience with military and corporate mainframe and microcomputer systems. He has taught computer science and Management Information Systems (MIS) courses at the University of Hawaii, Control Data Institute, Indiana University, and Purdue University; currently, he is a full-time faculty member in the College of Business Administration at Butler University. As the co-owner of an Indiana-based consulting firm, he has extensive experience consulting and training in the corporate and continuing education environments. Since 1984, he has co-authored more than 35 computer-related books; and has given presentations on computer applications and instructional development topics at a variety of seminars and conferences. Linda Bird—Author of essentials PowerPoint® and Level 2. Linda Bird specializes in corporate training and support through her company, Software Solutions. She has successfully trained users representing more than 75 businesses, including several Fortune 500 companies. She custom designs many of her training materials. Her clients include Appalachian Electric Power Co., Goodyear, Pillsbury, Rockwell, and Shell Chemical. Her background also includes teaching at Averett College and overseeing computer training for a business training organization. Using her training experience as a springboard, Linda has written numerous books on PowerPoint, Word, Excel, Access, and Windows. Additionally, she has written more than 20 instructor's manuals and contributed to books on a variety of desktop application programs. She has also penned more than 150 magazine articles, as well as monthly how-to columns on PowerPoint and Excel for Smart Computing magazine. Linda, a graduate of the University of Wisconsin, lives near the Great Smoky Mountains in Tennessee with her husband, Lonnie, and daughters, Rebecca and Sarah. Besides authoring books, Linda home-educates her daughters. If she's not writing, you can probably find her trekking around the mountains (or horseback riding) with her family. Keith Mulbery—Author of essentials Word 2002 Level 1, Level 2, and Level 3. Keith Mulbery is an associate professor in the Information Systems Department at Utah Valley State College, where he teaches computer applications courses and assists with curriculum development. Keith received his B.S. and M.Ed. (majoring in Business Education) from Southwestern Oklahoma State University. Keith has written several Word and WordPerfect textbooks. His previous book, MOUS essentials Word 2000, received the Utah Valley State College Board of Trustees Award of Excellence in January 2001. In addition, he was the developmental editor of essentials Word 2000 intermediate and essentials Word 2000 advanced. Keith also conducts hands-on computer application workshops at the local, state, and national levels, including at the National Business Education Association convention. Dawn Parrish Wood—Author of essentials Access 2002 Level 1, Level 2, and Level 3. Dawn Parrish Wood is an independent contractor, and provides software training through her own business, Software Support. She teaches customized courses to local businesses and individuals in order to upgrade employee skills and knowledge of computers. Dawn has written materials for these specialized courses for her own use. She also provides software consultation to local businesses. Previously, she was the computer coordinator/lead instructor for the Business & Industry Services division at Valdosta Technical Institute in Valdosta, Georgia. The majority of the coursework she taught was in continuing education. Prior to teaching, she worked as a technical support representative and technical writer for a software firm. She lives in Valdosta, Georgia, with her husband, Kenneth, and their two daughters, Micaela (4 1/2 years) and Kendra (2 1/2 years). Both girls have been her superlative students, learning more on the computer every day.

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.
Lesson 7. Using NOW to Display the Current Date.
Lesson 8. Using Dates in Calculations.
PROJECT 6. SORTING, FILTERING AND EDITING LISTS.

Lesson 1. Using an Excel List as a Database.
Lesson 2. Sorting Records on the Content of One Field.
Lesson 3. Sorting Records on the Contents of Two or More Fields.
Lesson 4. Using AutoFilter with One Search Condition.
Lesson 5. Using Custom AutoFilter with OR Search Criteria.
Lesson 6. Using Custom AutoFilter with AND Search Criteria.
Lesson 7. Adding and Deleting Records Using a Form.
Lesson 8. Editing Records Using a Form.
PROJECT 7. WORKING WITH CHARTS.

Lesson 1. Identifying Common Chart Types and Features.
Lesson 2. Using Chart Wizard to Create an Embedded Pie Chart.
Lesson 3. Using Chart Wizard to Create an Embedded Column Chart.
Lesson 4. Changing the Chart Type.
Lesson 5. Charting Non-Adjacent Data Series.
Lesson 6. Modifying Chart Formats.
Lesson 7. Adding, Reordering and Deleting a Data Series.
Lesson 8. Creating and Printing a Combination Chart.
PROJECT 8. DEVELOPING A MULTIPLE-SHEET WORKBOOK.

Lesson 1. Copying Data from Another Application.
Lesson 2. Inserting, Moving, Renaming Worksheets.
Lesson 3. Editing Multiple Worksheets Simultaneously.
Lesson 4. Subtotaling Data.
Lesson 5. Linking Worksheets.
Lesson 6. Applying Conditional Formatting.
Lesson 7. Setting a Print Area.
Lesson 8. Saving a Worksheet with Chart as a Web Page.