Microsoft Excel 365: Part 3

Lesson 1: Excel Online

• Topic A: Accessing and Using Excel Online
• Topic B: Features that Differ Between Excel Online and the Excel Desktop Application

Lesson 2: Worksheet Automation

• Topic A: Managing Workbook Properties
• Topic B: Working with Macros
• Topic C: Create and Use a Template
• Topic D: Use Data Validation in a Workbook

Lesson 3: Auditing and Error Checking

• Topic A: Tracing Cells
• Topic B: Error Checking
• Topic C: Evaluating Formulas and Using the Watch Window
• Topic D: Data List Outlines

Lesson 4: Data Analysis and Presentation

• Topic A: Quick Analysis Tool
• Topic B: Adding Sparklines
• Topic C: What-If Analysis
• Topic D: The Analysis ToolPak

Lesson 5: Working with Multiple Workbooks

• Topic A: Arrange Workbooks
• Topic B: Linking to Data in Multiple Workbooks
• Topic C: Consolidating Data

Lesson 6: Exporting and Sourcing Data

• Topic A: Exporting Data
• Topic B: Using Data Sources
• Topic C: Use a Microsoft Form for Data Collection