Description

Microsoft Excel provides a full suite of tools to analyze data and guide business decisions. Using these tools, you can aggregate data from different sources, make forecasts based on previous trends and determine ways of achieving desired outcomes. All of these tools are built-in to Excel 2016. NOTE: This is an advanced session. You should be familiar with the basic functions of Excel, as well as how to create formulas.

Assumptions

Before taking this module, participants should be able to:

Create basic Excel documents
Use formulas for Excel

Required Participant Prep Work

Take An Excel Basics session, or otherwise demonstrate the skills that would be taught in said session

Agenda

Importing Text Files
Pivot Tables:

Creating
Formatting
Slicers/Timelines

Forecast Sheet

Requirements
Running Forecast
Statistics

Query Builder

From Excel
From Web
Limiting Rows/Columns
Linking Queries

What If Analysis
Data Tables

Learning Outcomes

Use Pivot Tables to analyze categorical data
Import, format, and link data from multiple sources
Forecast future results from present data
Determine results of changes using What If Analysis
Analyze data with two unknowns using Data Tables

Browser not supported