SB AdvisoryApril 4, 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 | MD042

Date: May 20, 21, 2020
Course Length: 2 Days (16 hours)
Course Fee: $795 (10% discount for Early Bird registration)

REGISTER NOW

 

This two-day course takes students through hands-on examples in building dashboards, interactive decision support, data visualization theory and applications, advanced charting, and predictive analytics.

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
Requirements
  • Students should bring a laptop with Windows 8 or newer on it
  • Excel 2016/2019 or Excel for Office 365
  • Ability to download and save files
  • Internet access

Instructor:

Jordan GoldmeierJordan 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

ARE YOU A CORPORATION?
CCE offers customized corporate and industry-specific programs.
View our Program and Course Options

 

Programs & Courses

Programs & Courses