SB AdvisoryMay 20, 2020 update: Keep up with the latest from Stony Brook about the coronavirus situation.  More information
Skip Navigation
Search

Computer with Excel Dashboard

Analytics with Excel

Do more with your organization's data, using a program you already have (and know how to use)  

You don't need to have advanced programming skills to learn how to use data for business decision-making. If you are an intermediate Excel user, our short online course will show you how this workhorse of a program can be used for sophisticated analytics.

Through hands-on examples, students will learn about building dashboards, interactive decision support, data visualization theory and applications, advanced charting, and predictive analytics. 

This class will be held synchronously online (see the technical requirements at right).

COURSE Outline

Day 1: Fundamentals of Using Excel for Analytics
  • Advanced Lookup & Array Formulas
  • Excel Tables and Structured References
  • Error Checking – Creating FAST spreadsheets  
  • Building Interactive Elements
  • Dashboards – Visualizing Data for Decision Makers
Day 2: Analytics Theory & Applications
  • Data Visualization Principles
  • Infographics
  • Advanced Excel Charts (Building Charts Not in Excel’s Library)
  • Predictive Analytics – Forecasting Models
  • Exploratory Data Analysis

REgistration Information

Analytics with Excel | MD042

Date: October 20-21, 2020 from 8:30 am to 4:30 pm
Course Length: 16 hours
Location: Research and Support Services Building, Room 109
Course Fee: $795 (10% discount for Early Bird registration)

 

REGISTER NOW

 


 Technical Requirements

  • Computer running Windows 8 or newer
  • Excel 2016/2019 or Excel for Office 365
  • Ability to download and save files
  • Internet access

INSTRUCTOR

Jordan Goldmeier
Jordan Goldmeier | Chief Data Therapist

Jordan is an internationally recognized data scientist and visualization expert, author, and speaker. He wrote   Dashboards for Excel  and   Advanced Excel Essentials , and provides technical editing to articles on Excel development and data science. He has consulted with and provided training for NATO Training Command, the Pentagon, and Financial Times and the University of Cincinnati’s Center for Business Analytics.  

Industry-specific corporations collage

Representing Your Organization?
CCE offers customized corporate and industry-specific programs.
View our Program and Course Options