Business
AnalyticsCornell

Certificate Program

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.

Organizations go to great lengths to collect data to inform business decisions. However, given the volume of data, it can become difficult to sift through and find the needed answers. In this course you will gain exposure to the challenges of working with data and learn how you can use Excel to efficiently harvest data to make business decisions. Using Excel as a tool you will be able to quickly answer business questions by applying criteria to your data using Excel's logic functions, quickly retrieve information from a large set of data, and visually enhance your data.

You are required to have completed the following course or have equivalent experience before taking this course:

• Getting Started with Spreadsheet Modeling and Business Analytics

When your audience can quickly and efficiently understand what the data is telling them without having to scour every row and column, they can gain insights from your analysis more efficiently. In this course, you will apply the power of Excel pivot tables to see your data from multiple perspectives, use data visualization techniques that effectively communicate your analysis to your audience, create charts that quickly and clearly visualize your analysis, and apply the principles of graphical integrity to your charts.

You are required to have completed the following course or have equivalent experience before taking this course:

• Getting Started with Spreadsheet Modeling and Business Analytics

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.

Students are required to use a Desktop (PC or Mac) version of Microsoft Excel (2016 or later) to complete some assignments in this course. Excel for Web (Online) and Excel for Mobile will not suffice.

You are required to have completed the following course or have equivalent experience before taking this course:

• Getting Started with Spreadsheet Modeling and Business Analytics

Most decisions are made based on the desire to find the best way to do something. Solving complex business problems related to organizational goals can be a challenge. The ability to do this can be maximized with a little preparation and the power of Excel. When you use data in your analysis to prescribe what should happen next, you're performing prescriptive analytics. With this knowledge, you can build models and generate results that maximize outcomes by actually suggesting a course of action. In this course you will gain the skills needed to execute efficient and effective decisions backed by your data analysis.

Students are required to use a Desktop (PC or Mac) version of Microsoft Excel (2016 or later) to complete some assignments in this course. Excel for Web (Online) and Excel for Mobile will not suffice.

You are required to have completed the following course or have equivalent experience before taking this course:

• Getting Started with Spreadsheet Modeling and Business Analytics

Have you ever had to do an analysis of data but found that the data you needed was not all in one place? It could be online, in separate Excel files, or you might find that it's in different formats. It could take hours to convert and organize everything you need. In this course you will learn Excel's options for data management and modeling to relate data from multiple sources quickly and create interactive dashboards that answer dozens of questions. You will be able to import data from different Excel workbook files into one file or even import data in different formats like Notepad for the web and different databases.

Students are required to use a Desktop (PC or Mac) version of Microsoft Excel (2016 or later) to complete some assignments in this course. Excel for Web (Online) and Excel for Mobile will not suffice.

You are required to have completed the following course or have equivalent experience before taking this course:

• Getting Started with Spreadsheet Modeling and Business Analytics

Symposium sessions feature three days of live, highly interactive virtual Zoom sessions that will explore today’s most pressing topics. The Leadership Symposium offers you a unique opportunity to engage in real-time conversations with peers and experts from the Cornell community and beyond. Using the context of your own experiences, you will take part in reflections and small-group discussions to build on the skills and knowledge you have gained from your courses.

Join us for the next Symposium in which we’ll discuss the ways that leaders across industries have continued engaging their teams over the past two years while pivoting in strategic ways. You will support your coursework by applying your knowledge and experiences to relevant topics for leaders. Throughout this Symposium, you will examine different areas of leadership, including innovation, strategy, and engagement. By participating in relevant and engaging discussions, you will discover a variety of perspectives and build connections with your fellow participants from various industries.

All sessions are held on Zoom.

Future dates are subject to change. You may participate in as many sessions as you wish. Attending Symposium sessions is not required to successfully complete any certificate program. Once enrolled in your courses, you will receive information about upcoming events. Accessibility accommodations will be available upon request.