Unit 1 Managing Workbook Options
Lesson 1.1 Managing Version History
Lesson 1.2 Collaborating Using Comments
Lesson 1.3 Translating Data
Lesson 1.4 Creating External References
Lesson 1.5 Protecting Your Data
Unit 2 Using Advanced Editing and Formatting Features
Lesson 2.1 Filling Data in a Series
Lesson 2.2 Using Custom Number Formats
Lesson 2.3 Setting Data Validation
Lesson 2.4 Outlining Data
Lesson 2.5 Using Conditional Formatting
Lesson 2.6 Recording and Running Macros
Lesson 2.7 Modifying and Copying Macros
Unit 3 Creating Custom Document Elements
Lesson 3.1 Using Logical Functions
Lesson 3.2 Building Nested Formulas
Lesson 3.3 Testing for Multiple Conditions
Lesson 3.4 Using Conditional Functions
Lesson 3.5 Using the LET Function
Lesson 3.6 Using Lookup Functions
Lesson 3.7 Working with Dates and Times
Lesson 3.8 Consolidating Data
Lesson 3.9 Performing What-If Analysis
Lesson 3.10 Performing Financial Calculations
Lesson 3.11 Using Functions to Sort and Filter Data
Unit 4 Using Advanced Word Features
Lesson 4.1 Creating Advanced Charts
Lesson 4.2 Creating More Advanced Charts
Lesson 4.3 Generating and Modifying PivotTables
Lesson 4.4 Configuring PivotTable Value Fields
Lesson 4.5 Creating PivotCharts