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 |