|
所在平台: Coursera |
课程主页: https://www.coursera.org/learn/wharton-introduction-spreadsheets-models
课程评论：没有评论
课程名称：电子表格与模型基础介绍 课程简介： 电子表格是最强大的数据分析工具之一，几乎人人可用。无论是大型企业还是小型公司，都会使用电子表格模型来确定当前成功的关键指标以及未来的发展趋势。本课程旨在使学员掌握基本的电子表格工具和公式，从而利用电子表格的强大功能来分析现有数据并预测未来数据。通过简短易懂的演示，学员将学习如何使用Excel或Sheets，进而为今后课程中的模型和决策树构建打下基础。学员需具备使用Excel或Sheets的基础知识和访问权限。 课程大纲： 第一部分：电子表格：数字思考工具 本模块介绍电子表格的历史、基本功能及其模型创建的应用。学员将了解电子表格中的数据类型、数学运算符号、常用内置公式与函数、条件表达式、相对与绝对引用，并学习如何识别和修正循环引用。模块结束后，学员将能够理解电子表格的背景、导航电子表格、使用内置公式与函数、创建简单公式，识别并纠正常见错误。 第二部分：从电子表格到模型 这一模块将引导学员从电子表格转向模型创建，反映现实事件。学员将学习如何组织和布局模型元素、目标函数的类型及其应用，进行假设分析和情景分析、敏感度分析及其他经典模型。模块结束后，学员将能够设计反映假设、决策变量和结果的电子表格，创建基本现金流模型、评估小型商业机会、进行假设分析、识别敏感变量并使用线性规划模型和确定性模型。 第三部分：模型中的不确定性与概率 本模块介绍如何利用电子表格处理不确定性与概率。学员将学习随机变量、概率分布、幂函数、指数函数和对数函数的建模公式，以及计算概率树和决策树的模型；还将使用回归工具进行预测及多重回归。模块结束后，学员将能够通过电子表格统计函数测量变量之间的相关性，理解相关性计算结果，运用回归工具进行预测，并使用多重回归改进预测结果。 第四部分：模拟与优化 在这一模块中，学员将学习如何利用电子表格实施蒙特卡罗模拟和线性编程进行优化。学员将探讨蒙特卡罗模拟的目的，如何在电子表格中实现此类模拟，解决线性编程问题及其实施方式。模块结束后，学员将能够在电子表格中建模不确定性与风险，使用Excel的求解器优化资源，以实现期望的结果，还能识别Excel与Sheets的异同，为下一门商业与金融建模专业化课程做好准备。
Part: 1
Title:Spreadsheets: A Tool for Thinking with Numbers
Description:This module was designed to introduce you to the history of spreadsheets, their basic capabilities, and how they can be used to create models. You'll learn the different types of data used in spreadsheets, spreadsheet notations for mathematical operations, common built-in formulas and functions, conditional expressions, relative and absolute references, and how to identify and correct circular references. By the end of this module, you'll understand the context of spreadsheets, be able to navigate a spreadsheet, use built-in formulas and functions in spreadsheets, create your own simple formulas, and identify and correct common errors so you can put spreadsheets to work for you.
Part: 2
Title:From Spreadsheet to Model
Description:In this module, you'll move from spreadsheet to model, so you can begin to create your own models that reflect real-world events. You'll learn how to organize and lay out model elements, as well as the types of objective functions and their use. You'll also learn what-if analysis and scenarios, sensitivity analysis, and other classic models. By the end of this module, you'll be able to design a spreadsheet reflecting assumptions, decision variables, and outcomes, create a basic cashflow model, evaluate a small business opportunity, conduct what-if analysis, identify key variables using sensitivity analysis, and linear programming models and deterministic models.
Part: 3
Title:Addressing Uncertainty and Probability in Models
Description:This module was designed to introduce you to how you can use spreadsheets to address uncertainty and probability. You'll learn about random variables, probability distributions, power, exponential, and log functions in model formulas, models for calculating probability trees and decision trees, how to use regression tools to make predictions, as well as multiple regression. By the end of this module, you'll be able to measure correlations between variables using spreadsheet statistical functions, understand the results of functions that calculate correlations, use regression tools to make predictions, and improve forecasts with multiple regression.
Part: 4
Title: Simulation and Optimization
Description:In this module, you'll learn to use spreadsheets to implement Monte Carlo simulations as well as linear programs for optimization. You'll examine the purpose of Monte Carlo simulations, how to implement Monte Carlo simulations in spreadsheets, the types of problems you can address with linear programs and how to implement those linear programs in spreadsheets. By the end of this module, you'll be able to model uncertainty and risk in spreadsheets, and use Excel's solver to optimize resources to reach a desired outcome. You'll also be able to identify the similarities and differences between Excel and Sheets, and be prepared for the next course in the Business and Financial Modeling Specialization.
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 the 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.
