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 |