Weill Medical College of Cornell University · Courses
eCornell ORIE
5 courses with the subject eCornell ORIE, each shown exactly as we captured it from the college's catalog, with every element we hold. Where the wording looks broken, that is our reading of the catalog, not the college's text.
eCornell ORIE001SYNAI in Finance0
This live faculty-led program meets weekly on Monday, Wednesday, and Friday from 7PM to 9PM ET. The AI in Finance certificate prepares professionals to confidently apply AI technologies in the financial industry, connecting new tools to practical impact in their work. Taught by Cornell faculty and industry practitioners with expertise in engineering and business, the program is designed as a step-by-step progression that moves from foundational knowledge to applications, responsible AI practices, and strategic leadership. It concludes with a week-long leadership series that integrates insights from across the modules, enabling professionals to assess organizational readiness, identify opportunities, and design practical roadmaps for AI adoption.
Anyone who has ever had to deal with a messy dataset is familiar with the concept of "GIGO": Garbage-In, Garbage-Out. Even under the best of circumstances, you almost never get exactly what you want right from the start. The good news is that as long as a dataset has an underlying structure or pattern, we can usually turn the "mess" into something that is complete, clean, and ready to use in analysis. In this course, we will teach you how to make data usable by following a disciplined process of transforming, cleaning, and synthesizing data. You will practice getting your data ready by using filters and logical functions to identify errors and create a "clean" data set. By the time you complete this course you will have a clean dataset that is organized and ready for use in analysis.
This course will enable you to turn data into information. Beyond keeping a record of what happened, the main reason that businesses and individuals collect data is to get value from it. That value can only be realized when you harness the tools and capabilities to make sense of the data and draw insights about what to do moving forward. The purpose of this course is to build your proficiency with those tools and capabilities by using Excel's powerful built-in Pivot tools to partition, summarize, and visualize data quickly. You will also create your own customized dashboards using robust and user-friendly design practices.
eCornell ORIE573Developing Robust Models to Evaluate Decisions0
In Excel modeling, the flaw of averages creeps in when a single fixed number is used in all scenarios to represent an uncertain value to be revealed in the future. The actual outcome of that value could substantially impact the model metrics and resulting decisions. The purpose of this course is to give you hands-on practice in distinguishing situations where using fixed inputs can lead to poor estimates and decisions. You will also be equipped with a range of tools to incorporate uncertainty and simulation into Excel-based models. This will allow you to more accurately assess risk, understand system dynamics, and make better decisions. Statistician George Box is credited with the saying, "All models are wrong. Some are useful." This course is designed to help put you on the path to creating models that are useful by ensuring they convey the risks associated with different courses of action.
eCornell ORIE574Optimizing Decisions and Assessing Tradeoffs0
In this course, we move from building spreadsheet-based models that evaluate solutions to decision problems to the task of using those evaluation models to find the "best" solution(s) that we can. We will explore a number of different methods and built-in tools for finding "optimal" solutions. Surprisingly, different kinds of approaches lend themselves better to different kinds of decision problems. Important factors driving the choice of approach include the scale, scope, and mathematical complexity of the model. Excel is not the appropriate choice for every application. VBA (Visual Basic for Applications) is frequently used in implementing Directed Search Methods. For this course, since the focus is on finding optimal solutions to decision problems, we are going to be working with evaluation models that are already in place. However, because modeling choices related to how you organize the information on your worksheet can also play a role in how easy it is to solve a problem, those choices will be pointed out as we move through the different examples.
