Unit 1: Introduction To Excel Lesson 1: Getting Started with Excel Lesson 2: Developing a New Workbook Lesson 3: Editing and Formatting Worksheets Unit 2: Working With Formulas And Functions Lesson 4: Creating Simple Formulas Lesson 5: Using Logical and Financial Functions Lesson 6: Using Advanced Functions Unit 3: Improving Uses Of Worksheet Information Lesson 7: Building Charts Lesson 8: Adding Design Elements to a Worksheet Lesson 9: Working with Multiple Worksheets and Workbooks Unit 4: Increasing Productivity Lesson 10: Working with Range Names Lesson 11: Using and Building Templates Lesson 12: Working with Macros Unit 5: Using Analysis, Linking, And Workgroup Features Lesson 13: Using Auditing Tools Lesson 14: Using Analysis Tools Lesson 15: Using Data Consolidation and Linking Lesson 16: Using Workgroup Features Unit 6: Using Data And List Features Lesson 17: Using Data from Other Sources Lesson 18: Using Lists and Database Features Lesson 19: Using Data and PivotTables Portfolio Builder Appendices A Windows Tutorial B File Management C Speech Recognition D Proofreaders Marks E MOS Certification