آموزش آشنایی با صفحات گسترده و مدل‌سازی - آخرین آپدیت

Spreadsheets: A Tool for Thinking with Numbers Spreadsheets: A Tool for Thinking with Numbers

• 1.1 Objectives and a Little Spreadsheet History 1.1 Objectives and a Little Spreadsheet History

• 1.2 Navigating a spreadsheet and crafting formulas 1.2 Navigating a spreadsheet and crafting formulas

• 1.3 Using functions 1.3 Using functions

• 1.4 Using conditional expressions in formulas 1.4 Using conditional expressions in formulas

• 1.5 Common errors in spreadsheets 1.5 Common errors in spreadsheets

• 1.6 Differences between Sheets and Excel 1.6 Differences between Sheets and Excel

From Spreadsheet to Model From Spreadsheet to Model

• 2.0 Module Introduction 2.0 Module Introduction

• 2.1 Using assumptions and decision variables in spreadsheet models 2.1 Using assumptions and decision variables in spreadsheet models

• 2.2 Structuring a spreadsheet to model variables, objectives, and objective functions 2.2 Structuring a spreadsheet to model variables, objectives, and objective functions

• 2.3 Constructing simple cashflow model 2.3 Constructing simple cashflow model

• 2.4 What if analysis and sensitivity analysis 2.4 What-if analysis and sensitivity analysis

• 2.5 Limits to simple, deterministic models 2.5 Limits to simple, deterministic models

Addressing Uncertainty and Probability in Models Addressing Uncertainty and Probability in Models

• 3.0 Introduction 3.0 Introduction

• 3.1 Random variables and probability distributions 3.1 Random variables and probability distributions

• 3.2 Changes in discrete and continuous time 3.2 Changes in discrete and continuous time

• 3.3 Power, exponential, and log functions 3.3 Power, exponential, and log functions

• 3.4 Probability trees and decision trees 3.4 Probability trees and decision trees

• 3.5 Correlation and Regression 3.5 Correlation and Regression

Simulation and Optimization Simulation and Optimization

• 4.0 Introduction 4.0 Introduction

• 4.1 Monte Carlo Simulations 4.1 Monte Carlo Simulations

• 4.2 Linear Programming 4.2 Linear Programming

• 4.3 Next Steps, and Differences between Excel and Sheets 4.3 Next Steps, and Differences between Excel and Sheets