Courses of Study 2020-2021 
    
    May 12, 2024  
Courses of Study 2020-2021 [ARCHIVED CATALOG]

Practical Spreadsheet Modeling Certificate


In eCornell Certificate Programs 

Most organizations are awash in data, but struggle to transform it into meaningful information.
In this certificate program you will master the ability to analyze data efficiently, convey information effectively, and build valuable, robust, reusable models to support decision-making in a professional environment.
Throughout the courses, you will work with realistic datasets in Excel to build reusable dashboards and models that enable you to evaluate decision alternatives.
You’ll start by converting a raw dataset into one that is complete, clean, and ready to use as an accurate data source. Using Excel’s built-in analysis tools, you’ll have the opportunity to develop user-friendly dashboards to enable discovery and diagnosis by members of your team. You will also build evaluation models that assess tradeoffs and incorporate the impact of uncertainty. Finally, you will use optimization functions and VBA-guided heuristics to find effective solutions to problems and aid in rapid decision-making.
You’ll come away from the program not only with advanced Excel knowledge, but with the tools to effectively communicate relevant insights to stakeholders.
Students should be familiar with fundamental spreadsheet concepts such as formulas and functions and be comfortable using basic summarization functions in order to be successful in this program.
 

Key Takeaways


  • Create a data set that is clean, organized, and ready for use
  • Build dashboards that partition, extract, visualize, and summarize data dynamically 
  • Develop models to evaluate and optimize decision alternatives
  • Create flexible selection and assignment tools using VBA with Excel

What You’ll Earn


  • Practical Spreadsheet Modeling Certificate from Cornell Engineering (School of Operations Research and Information Engineering)
  • 48 Professional Development Hours (4.8 CEUS)

Who Should Enroll


  • Finance Professionals
  • Data Analysts
  • Data Scientists
  • Business Analysts
  • Managers and Executives
  • Students who need in-depth Excel knowledge

Total Investment


  • $3,600 with monthly payment options available
  • 2 months to complete all the courses

How To Enroll


Additional enrollment information coming soon.