Benchmark Series: Microsoft Excel 2007 Levels 1 and 2 with Windows Vista

Level 1.
Unit 1. Preparing and Formatting a Worksheet.
1. Preparing an Excel Workbook.
2. Inserting Formulas in a Worksheet.
3. Formatting an Excel Worksheet.
4. Enhancing a Worksheet. Unit 1 Performance Assessment.

Unit 2. Maintaining and Enhancing Workbooks.
5. Moving Data within and between Workbooks.
6. Maintaining Workbooks.
7. Creating a Chart in Excel.
8. Enhancing the Display of Workbooks. Unit 2 Performance Assessment.

Level 2. Unit 1. Advanced Formatting, Formulas, and Data Management.
1. Advanced Formatting Techniques.
2. Advanced Functions and Formulas.
3. Working with Tables.
4. Summarizing Data. Unit 1 Performance Assessment.

Unit 2. Managing and Integrating Data.
5. What-If Analysis Tools.
6. Protecting and Sharing Workbooks.
7. Automating Repetitive Tasks and Customizing Excel.
8. Importing and Exporting Data. Unit 2 Performance Assessment.

Nita Rutkosky has been an office technology instructor at Pierce College at Puyallup (Puyallup, WA) since 1978. She has taught a variety of courses including all levels of keyboarding, machine transcription, records management, business machines, word processing, and desktop publishing. In addition to this textbook, Ms. Rutkosky has authored and co-authored many computer application textbooks for Paradigm Publishing, Inc.

Audrey Rutkosky Roggenkamp has been teaching courses in the Business Information Technology department at Pierce College in Puyallup, including keyboarding, skill building, and Microsoft Office programs. In addition to this textbook, Ms. Roggenkamp has authored and co-authored many computer application textbooks for Paradigm Publishing, Inc.