Excel – Data Analysis and Forecasting

Course length:  1-day

Course Overview

Excel is Microsoft’s powerful and easy-to-use spreadsheet program. This third part of Microsoft 365 Excel is intended to help all users get up to speed quickly on the advanced features of Excel.

By the end of this course, students should be comfortable in both the online and desktop environments, using automating functions, analyzing and presenting data, auditing and error checking their work, working in multiple workbooks, and accessing and distributing data.

Prerequisites

Excel Level 1 or equivalent knowledge

Excel Level 2 or equivalent knowledge

Outline

Worksheet Automation

• Managing Workbook Properties
• Working with Macros
• Create and Use a Template

Auditing and Error Checking

• Tracing Cells
• Error Checking
• Evaluating Formulas and Using the Watch Window and Camera Tool
• Data List Outlines

Data Analysis and Presentation

• Quick Analysis Tool
• Adding Sparklines
• What-If Analysis
• The Analysis ToolPak
• Solver Add-in
• Explore the Power Pivot Add-in

Working with Multiple Workbooks

• Arrange Workbooks
• Linking to Data in Multiple Workbooks
• Consolidating Data

Exporting and Sourcing Data

• Exporting Data
• Using Data Sources
• Using a Microsoft Form for Data Collection