Programa Especializado - Modelado comercial y financiero

Comienza el abr. 03

Programa Especializado - Modelado comercial y financiero

Build Business and Financial Models

Use spreadsheet models to make data-driven financial decisions

Sobre este Programa Especializado

Wharton's Business and Financial Modeling Specialization is designed to help you make informed business and financial decisions. These foundational courses will introduce you to spreadsheet models, modeling techniques, and common applications for investment analysis, company valuation, forecasting, and more. When you complete the Specialization, you'll be ready to use your own data to describe realities, build scenarios, and predict performance.

Creada por:

courses
5 courses

Sigue el orden sugerido o elige el tuyo.

projects
Proyectos

Diseñado para ayudarte a practicar y aplicar las habilidades que aprendiste.

certificates
Certificados

Resalta tus nuevas habilidades en tu currículum o LinkedIn.

Cursos
Beginner Specialization.
No prior experience required.
  1. CURSO 1

    Fundamentals of Quantitative Modeling

    Próxima sesión: abr. 3 — may. 8.
    Dedicación
    4 weeks of study, 1-3 hours/week
    Subtítulos
    English, Russian

    Acerca del Curso

    How can you put data to work for you? Specifically, how can numbers in a spreadsheet tell us about present and past business activities, and how can we use them to forecast the future? The answer is in building quantitative models, and this course is designed to help you understand the fundamentals of this critical, foundational, business skill. Through a series of short lectures, demonstrations, and assignments, you’ll learn the key ideas and process of quantitative modeling so that you can begin to create your own models for your own business or enterprise. By the end of this course, you will have seen a variety of practical commonly used quantitative models as well as the building blocks that will allow you to start structuring your own models. These building blocks will be put to use in the other courses in this Specialization.
  2. CURSO 2

    Introduction to Spreadsheets and Models

    Próxima sesión: mar. 27 — may. 1.
    Dedicación
    4 weeks of study, 1-3 hours/week
    Subtítulos
    English, Portuguese (Brazilian)

    Acerca del Curso

    The simple spreadsheet is one of the most powerful data analysis tools that exists, and it’s available to almost anyone. Major corporations and small businesses alike use spreadsheet models to determine where key measures of their success are now, and where they are likely to be in the future. But in order to get the most out of a spreadsheet, you have know how to use it. This course is designed to give you an introduction to basic spreadsheet tools and formulas so that you can begin harness the power of spreadsheets to map the data you have now and to predict the data you may have in the future. Through short, easy-to-follow demonstrations, you’ll learn how to use Excel or Sheets so that you can begin to build models and decision trees in future courses in this Specialization. Basic familiarity with, and access to, Excel or Sheets is required.
  3. CURSO 3

    Modeling Risk and Realities

    Próxima sesión: abr. 3 — may. 8.
    Dedicación
    4 semanas de estudio, 1-3 horas/semana.
    Subtítulos
    English, Portuguese (Brazilian)

    Acerca del Curso

    Useful quantitative models help you to make informed decisions both in situations in which the factors affecting your decision are clear, as well as in situations in which some important factors are not clear at all. In this course, you can learn how to create quantitative models to reflect complex realities, and how to include in your model elements of risk and uncertainty. You’ll also learn the methods for creating predictive models for identifying optimal choices; and how those choices change in response to changes in the model’s assumptions. You’ll also learn the basics of the measurement and management of risk. By the end of this course, you’ll be able to build your own models with your own data, so that you can begin making data-informed decisions. You’ll also be prepared for the next course in the Specialization.
  4. CURSO 4

    Decision-Making and Scenarios

    Próxima sesión: mar. 27 — may. 1.
    Dedicación
    4 semanas de estudio, 1-3 horas/semana.
    Subtítulos
    English

    Acerca del Curso

    This course is designed to show you how use quantitative models to transform data into better business decisions. You’ll learn both how to use models to facilitate decision-making and also how to structure decision-making for optimum results. Two of Wharton’s most acclaimed professors will show you the step-by-step processes of modeling common business and financial scenarios, so you can significantly improve your ability to structure complex problems and derive useful insights about alternatives. Once you’ve created models of existing realities, possible risks, and alternative scenarios, you can determine the best solution for your business or enterprise, using the decision-making tools and techniques you’ve learned in this course.
  5. CURSO 5

    Wharton Business and Financial Modeling Capstone

    Próxima sesión: mar. 27 — may. 8.
    Subtítulos
    English

    Sobre el Proyecto Final

    In this Capstone you will recommend a business strategy based on a data model you’ve constructed. Using a data set designed by Wharton Research Data Services (WRDS), you will implement quantitative models in spreadsheets to identify the best opportunities for success and minimizing risk. Using your newly acquired decision-making skills, you will structure a decision and present this course of action in a professional quality PowerPoint presentation which includes both data and data analysis from your quantitative models. Wharton Research Data Services (WRDS) is the leading data research platform and business intelligence tool for over 30,000 corporate, academic, government and nonprofit clients in 33 countries. WRDS provides the user with one location to access over 200 terabytes of data across multiple disciplines including Accounting, Banking, Economics, ESG, Finance, Insurance, Marketing, and Statistics.

Creadores

  • Universidad de Pensilvania

    The Wharton School of the University of Pennsylvania is recognized globally for intellectual leadership and ongoing innovation across every major discipline of business education.

    The University of Pennsylvania (commonly referred to as Penn) is a private university, located in Philadelphia, Pennsylvania, United States. A member of the Ivy League, Penn is the fourth-oldest institution of higher education in the United States, and considers itself to be the first university in the United States with both undergraduate and graduate studies.

  • Sergei Savin

    Sergei Savin

    Associate Professor of Operations, Information and Decisions
  • Senthil Veeraraghavan

    Senthil Veeraraghavan

    Associate Professor of Operations, Information and Decisions
  • Richard Waterman

    Richard Waterman

    Professor of Statistics
  • Richard Lambert

    Richard Lambert

    Professor of Accounting
  • Robert W. Holthausen

    Robert W. Holthausen

    Professor
  • Don Huesman

    Don Huesman

    Managing Director, Wharton Online

FAQs

More questions? Visit the Learner Help Center.