UNIT 1 - Introduction to Excel Lesson 1 - Getting Started with Excel Lesson 2 - Creating a Workbook Lesson 3 - Using Editing and Style Tools Lesson 4 - Exploring Home Tab Commands UNIT 2 - Working with Formulas and Functions Lesson 5 - Exploring Formula Basics Lesson 6 - Working with 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 - Inserting Shapes Lesson 11 - Using Images and SmartArt Graphics UNIT 4 - Expanding Uses of Workbook Data Lesson 12 - Using 3-D References Lesson 13 - Working with Tables Lesson 14 - Using Named Ranges and Structured References UNIT 5 - Auditing, Analyzing, and Consolidating Data Lesson 15 - Using Auditing Tools Lesson 16 - Using What-if Analysis Lesson 17 - Consolidating and Linking Workbooks UNIT 6 - Exploring Data and Table Features Lesson 18 - Using External Data Sources Lesson 19 - Exploring List Ranges Lesson 20 - Using Data Tables and PivotTables UNIT 7 - Exploring Macros, Template, and Workgroups Lesson 21 - Working with Macros Lesson 22 - Using Templates Lesson 23 - Using Workgroup Features
