Analytics in Excel

Microsoft Data Analytics in Excel logo

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

  • Excel data visualization beyond the basic charting tools.
  • Descriptive analytics methods for analyzing data and generating insights.
  • How to use Excel for prescriptive analytics.
  • 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.

                                          Analytics in Excel Course Outline
Day One Day Two    

Fundamentals

  • Advanced Lookup and Array Formulas
  • Excel Tables
  • Error Checking
  • Building Interactive Elements
  • Dashboards

Theory and Applications

  • Data Visualization Theory and Applications
  • Infographics
  • Advanced Excel Charts
  • Predictive Analytics
  • Exploratory Data Analysis
 
Jordan Goldmeier, Excel Instructor headshot

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.

Testimonials

  • Learned what I needed for the workplace
  • Instructor was extremely knowledgable and very effective.  Super engaging for an otherwise boring topic
  • Great course for using Excel to visualize and dashboard data
  • Did a great job of checking for understanding, especially when covering complex material
  • I learned new things every minute of the class.  Well worth my time and money!

 

Course Fee: $895 includes breakfasts, lunches, refreshments, and free parking for both days.

Location:
Room TBD
Lindner College of Business
2906 Woodside Drive
Cincinnati, OH 45221

This training can also be delivered at your location

For more information about these classes, or for custom training classes, please contact
Headshot of Larry Porter

Larry Porter

Training , Marketing and Sponsorship Manager

513-556-4742