McGraw-Hill Technology Education’s Professional Approach Series presents exercises in real-life business situations so students get hands-on experience working on actual projects--the best way to prepare them for the on-the-job challenges they'll face. Each lesson contains up to 25 skill-applications and 5 end-of-unit skill-applications that take students from simple to complex situations. The Office 2003 texts complete instruction in all skill sets and activities for the appropriate Microsoft Office Specialist Certification (MOS) Exams.
Unit 1: Introduction to Excel
Lesson 1: Getting Started with Excel
Lesson 2: Creating a Workbook
Lesson 3: Using Editing and Formatting Tools
Lesson 4: Working with Cells, Columns, Rows, and Sheets
Unit 2: Working with Formulas and Functions
Lesson 5: Working with Simple Formulas
Lesson 6: Working with Math & Trig, Statistical, and Date & Time Functions
Lesson 7: Using Logical and Financial Functions
Lesson 8: Rounding and Nesting Functions
Unit 3: Enhancing Worksheet Appearance
Lesson 9: Building Charts
Lesson 10: Using AutoShapes, WordArt, and Comments
Lesson 11: Using Images, Diagrams, and Research
Unit 4: Improving Uses of Worksheet Data
Lesson 12: Working with Multiple Worksheets
Lesson 13: Working with Lists
Lesson 14: Using Worksheet Templates
Unit 5 Increasing Productivity
Lesson 15 Working with Ranges and Lookup & Reference Functions
Lesson 16 Creating Worksheet and Workbook Templates
Lesson 17 Working with Macros
Unit 6 Using Analysis, Linking, and Workgroup Features
Lesson 18 Using Auditing Tools
Lesson 19 Using What-If Analysis
Lesson 20 Using Data Consolidation and Linking
Lesson 21 Using Workgroup Features
Unit 7 Using Data and List Features
Lesson 22 Using Data from Other Sources
Lesson 23 Using Lists and Database Features
Lesson 24 Using Data Tables and PivotTables
Appendix