Donna L. Haeger is a Professor of Practice in the Charles H. Dyson School of Applied Economics and Management at Cornell University. She teaches introductory and advanced spreadsheet-modeling courses for applied decision-making. These courses leverage Microsoft Excel as a business analytics tool. Prior to teaching at Cornell, she taught courses in management theory, organizational behavior and marketing. With over twenty years in industry, her corporate experience includes work in investments, banking, and corporate finance. Dr. Haeger is the business analytics concentration coordinator and chaired the task force responsible for launching the concentration. Her research interests are at the intersection of organizational behavior and digitization. She explores technology in the workplace, leadership, teams, and management. Her contributions relate to influence and intergenerational exchanges in an effort to blend human systems. Haeger presents her research at the Academy of Management and other leadership associations. She also enjoys mentoring students interested in undergraduate research, especially when the products serve to better communities. She currently sits on the board of directors for Consumer Credit Counseling Services of Rochester which specializes in spreading financial literacy to communities.
To successfully and quickly solve business problems you need more than just intuition; you need solutions based on data. Data analytics is essential for any successful business. It helps us frame problems, make comparisons, forecast outcomes, and make decisions. You can use simple but very effective tools to analyze your data and make better, more informed decisions.
In this course, you will explore spreadsheet-modeling for applied decision making. You will work with data sets and navigate in an Excel 2016 Workbook. You will examine data cleaning and modeling concepts, practice core Excel skills, and explore ways to apply data management techniques to the spreadsheet system by using its math and logic capabilities to their full potential. By performing data management, you can improve the structure and usefulness of your data.
In order to execute the most informed business analyses, we need the right tools for making predictions from data. Excel provides powerful predictive analytic tools that let the user forecast trends and make predictions with historical data.
In this course, you will conduct financial analyses by comparing loan scenarios using financial functions, identifying what values are needed to achieve a desired result, and quickly identifying how changes in your data will impact outcomes. You will leave this course with the ability to leverage reliable historical data to generate simulations and make predictions.