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

Status: IN DEVELOPMENT