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 andFinancial 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, andResearch 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
