Application |
Level |
Lesson |
Topic |

Excel | Level 1 | Lesson 1: Getting Started with Microsoft Office 2016 | Lesson 1: Getting Started with Microsoft Office 2016 |

Excel | Level 1 | Lesson 1: Getting Started with Microsoft Office 2016 | Topic A: Navigate the Excel User Interface |

Excel | Level 1 | Lesson 1: Getting Started with Microsoft Office 2016 | Topic B: Use Excel Commands |

Excel | Level 1 | Lesson 1: Getting Started with Microsoft Office 2016 | Topic C: Create and Save a Basic Workbook |

Excel | Level 1 | Lesson 1: Getting Started with Microsoft Office 2016 | Topic D: Enter Cell Data |

Excel | Level 1 | Lesson 1: Getting Started with Microsoft Office 2016 | Topic E: Use Excel Help |

Excel | Level 1 | Lesson 2: Performing Calculations | Lesson 2: Performing Calculations |

Excel | Level 1 | Lesson 2: Performing Calculations | Topic A: Create Worksheet Formulas |

Excel | Level 1 | Lesson 2: Performing Calculations | Topic B: Insert Functions |

Excel | Level 1 | Lesson 2: Performing Calculations | Topic C: Reuse Formulas and Functions |

Excel | Level 1 | Lesson 3: Modifying a Worksheet | Lesson 3: Modifying a Worksheet |

Excel | Level 1 | Lesson 3: Modifying a Worksheet | Topic A: Insert, Delete, and Adjust Cells, Columns and Rows |

Excel | Level 1 | Lesson 3: Modifying a Worksheet | Topic B: Search for and Replace Data |

Excel | Level 1 | Lesson 3: Modifying a Worksheet | Topic C: Use Proofing and Research Tools |

Excel | Level 1 | Lesson 4: Formatting a Worksheet | Lesson 4: Formatting a Worksheet |

Excel | Level 1 | Lesson 4: Formatting a Worksheet | Topic A: Apply Text Formats |

Excel | Level 1 | Lesson 4: Formatting a Worksheet | Topic B: Apply Number Formats |

Excel | Level 1 | Lesson 4: Formatting a Worksheet | Topic C: Align Cell Contents |

Excel | Level 1 | Lesson 4: Formatting a Worksheet | Topic D: Apply Styles and Themes |

Excel | Level 1 | Lesson 4: Formatting a Worksheet | Topic E: Apply Basic Conditional Formatting |

Excel | Level 1 | Lesson 4: Formatting a Worksheet | Topic F: Create and Use Templates |

Excel | Level 1 | Lesson 5: Printing Workbooks | Lesson 5: Printing Workbooks |

Excel | Level 1 | Lesson 5: Printing Workbooks | Topic A: Preview and Print a Workbook |

Excel | Level 1 | Lesson 5: Printing Workbooks | Topic B: Set Up the Page Layout |

Excel | Level 1 | Lesson 5: Printing Workbooks | Topic C: Configure Headers and Footers |

Excel | Level 1 | Lesson 6: Managing Workbooks | Lesson 6: Managing Workbooks |

Excel | Level 1 | Lesson 6: Managing Workbooks | Topic A: Manage Worksheets |

Excel | Level 1 | Lesson 6: Managing Workbooks | Topic B: Manage Workbook and Worksheet Views |

Excel | Level 1 | Lesson 6: Managing Workbooks | Topic C: Manage Workbook Properties |

Excel | Level 2 | Lesson 1: Working with Functions | Lesson 1: Working with Functions |

Excel | Level 2 | Lesson 1: Working with Functions | Topic A: Work with Ranges |

Excel | Level 2 | Lesson 1: Working with Functions | Topic B: Use Specialized Functions |

Excel | Level 2 | Lesson 1: Working with Functions | Topic C: Work with Logical Functions |

Excel | Level 2 | Lesson 1: Working with Functions | Topic D: Work with Date & Time Functions |

Excel | Level 2 | Lesson 1: Working with Functions | Topic E: Work with Text Functions |

Excel | Level 2 | Lesson 2: Working with Lists | Lesson 2: Working with Lists |

Excel | Level 2 | Lesson 2: Working with Lists | Topic A: Sort Data |

Excel | Level 2 | Lesson 2: Working with Lists | Topic B: Filter Data |

Excel | Level 2 | Lesson 2: Working with Lists | Topic C: Query Data with Database Functions |

Application | Level | Lesson | Topic |

Excel | Level 2 | Lesson 2: Working with Lists | Topic D: Outline and Subtotal Data |

Excel | Level 2 | Lesson 3: Analyzing Data | Lesson 3: Analyzing Data |

Excel | Level 2 | Lesson 3: Analyzing Data | Topic A: Create and Modify Tables |

Excel | Level 2 | Lesson 3: Analyzing Data | Topic B: Apply Intermediate Conditional Formatting |

Excel | Level 2 | Lesson 3: Analyzing Data | Topic C: Apply Advanced Conditional Formatting |

Excel | Level 2 | Lesson 4: Visualizing Data with Charts | Lesson 4: Visualizing Data with Charts |

Excel | Level 2 | Lesson 4: Visualizing Data with Charts | Topic A: Create Charts |

Excel | Level 2 | Lesson 4: Visualizing Data with Charts | Topic B: Modify and Format Charts |

Excel | Level 2 | Lesson 4: Visualizing Data with Charts | Topic C: Use Advanced Chart Features |

Excel | Level 2 | Lesson 5: Analyzing Data with PivotTables and PivotCharts | Lesson 5: Analyzing Data with PivotTables and PivotCharts |

Excel | Level 2 | Lesson 5: Analyzing Data with PivotTables and PivotCharts | Topic A: Create a PivotTable |

Excel | Level 2 | Lesson 5: Analyzing Data with PivotTables and PivotCharts | Topic B: Analyze PivotTable Data |

Excel | Level 2 | Lesson 5: Analyzing Data with PivotTables and PivotCharts | Topic C: Present Data with PivotCharts |

Excel | Level 2 | Lesson 5: Analyzing Data with PivotTables and PivotCharts | Topic D: Filter Data by Using Timelines and Slicers |

Excel | Level 3 | Lesson 1: Working with Multiple Worksheets and Workbooks | Lesson 1: Working with Multiple Worksheets and Workbooks |

Excel | Level 3 | Lesson 1: Working with Multiple Worksheets and Workbooks | Topic A: Use Links and External References |

Excel | Level 3 | Lesson 1: Working with Multiple Worksheets and Workbooks | Topic B: Use 3-D References |

Excel | Level 3 | Lesson 1: Working with Multiple Worksheets and Workbooks | Topic C: Consolidate Data |

Excel | Level 3 | Lesson 2: Using Lookup Functions and Formula Auditing | Lesson 2: Using Lookup Functions and Formula Auditing |

Excel | Level 3 | Lesson 2: Using Lookup Functions and Formula Auditing | Topic A: Use Lookup Functions |

Excel | Level 3 | Lesson 2: Using Lookup Functions and Formula Auditing | Topic B: Trace Cells |

Excel | Level 3 | Lesson 2: Using Lookup Functions and Formula Auditing | Topic C: Watch and Evaluate Formulas |

Excel | Level 3 | Lesson 3: Sharing and Protecting Workbooks | Lesson 3: Sharing and Protecting Workbooks |

Excel | Level 3 | Lesson 3: Sharing and Protecting Workbooks | Topic A: Collaborate on a Workbook |

Excel | Level 3 | Lesson 3: Sharing and Protecting Workbooks | Topic B: Protect Worksheets and Workbooks |

Excel | Level 3 | Lesson 4: Automating Workbook Functionality | Lesson 4: Automating Workbook Functionality |

Excel | Level 3 | Lesson 4: Automating Workbook Functionality | Topic A: Apply Data Validation |

Excel | Level 3 | Lesson 4: Automating Workbook Functionality | Topic B: Search for Invalid Data and Formulas with Errors |

Excel | Level 3 | Lesson 4: Automating Workbook Functionality | Topic C: Work with Macros |

Excel | Level 3 | Lesson 5: Creating Sparklines and Mapping Data | Lesson 5: Creating Sparklines and Mapping Data |

Excel | Level 3 | Lesson 5: Creating Sparklines and Mapping Data | Topic A: Create Sparklines |

Excel | Level 3 | Lesson 5: Creating Sparklines and Mapping Data | Topic B: Map Data |

Excel | Level 3 | Lesson 6: Forecasting Data | Lesson 6: Forecasting Data |

Excel | Level 3 | Lesson 6: Forecasting Data | Topic A: Determine Potential Outcomes Using Data Tables |

Excel | Level 3 | Lesson 6: Forecasting Data | Topic B: Determine Potential Outcomes Using Scenarios |

Excel | Level 3 | Lesson 6: Forecasting Data | Topic C: Use the Goal Seek Feature |

Excel | Level 3 | Lesson 6: Forecasting Data | Topic D: Forecasting Data Trends |