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)
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 | 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.
Representing Your Organization?
CCE offers customized corporate and industry-specific programs.
View our Program and Course Options