Carl H. Lindner College of BusinessCarl H. Lindner College of BusinessUniversity of Cincinnati

Carl H. Lindner College of Business
Business Analytics Training Class

Analytics in Excel

Introduction to Analytics in Excel               Dec 14 & 15

Highlights of this two day course:

  • 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



Register for Analytics in Excel
Future Training

Tableau Training Jan 25 & 26
Intermediate R Feb 8 & 9
Data Management for Analysts Mar 1 & 2
Text Mining with R Mar 8 & 9
MS Power BI  TBD
Python for Data Science TBD

Course Description:

Excel 2010 or newer recommended. 

This course will introduce intermediate-to-advanced tools in Excel with a business-application focus. 

In this course, we’ll discuss the theories and practices of data visualization, statistics, and reporting best practices in the spreadsheet environment. We’ll explore Excel features like charts, formulas and PivotTables in depth and weave them together to create descriptive analytics. We’ll discuss ways to handle large datasets and complex problems. And, we’ll go through ways we can bring interactivity to the spreadsheet without writing macros. For the experienced Excel user, this class will bring your skills to the next level. Bottom line: Attendees will learn the best ways to use Excel to solve business problems.

Instructor Bio:
Jordan Goldmeier is an internationally recognized analytics professional and data visualization expert, author, speaker, and CEO. He is the owner of Cambia Factor, a data consulting agency and the author of Advanced Excel Essentials and Dashboards for Excel. He has consulted with and provided training for NATO Training Mission, the Pentagon, Air Force and Navy, Financial Times, University of Cincinnati and others. His work has been cited by and quoted in the Associated Press, Bloomberg BusinessWeek, Dice News, and American Express OPEN Forum. He holds the prestigious MVP award from Microsoft since 2013 and is an owner and producer of Excel.TV, an online community devoted to sharing the stories, setbacks, and lessons from experts and practitioners in Excel, business intelligence, big data, and analytics.

Course Fee $695
U-Square Room 359
225 Calhoun Street
Cincinnati, OH 45219