Analytics in Excel

August 23-24, 2018.

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

Course highlights:

Using Excel tools and special functions to gain insights: PivotTables, PivotCharts, VLOOKUP, MATCH, and Data Tables.

Audience

This training is perfect for experienced business teams familiar with Excel. People whose roles are business analyst, data analyst, financial analyst, analytics manager, program or project manager and similar will feel very comfortable with the course content, pace, and challenge. This is not an introductory course nor should it be considered on a scale from beginner to advanced. This course is designed for those on business teams to gain immediate and practical skills.

Agenda

Day one: Fundamentals

Advanced Lookup and Array Formulas

Excel Tables

Error Checking

Building Interactive Elements

Dashboards

Day two: Theory and applications

Data Visualization Theory and Applications

Infographics

Advanced Excel Charts

Predictive Analytics

Exploratory Data Analysis

Instructor:

Jordan Goldmeier, Microsoft Excel MVP.
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.