個案資料
了解個案內容與學習目標,選擇授課教師及使用課程。
Good Modeling Practices in Microsoft Excel
內容大綱
The purpose of this note is to illustrate the use of good modelling practices in Microsoft Excel. An effective spreadsheet model can be a valuable decision-making tool for businesses wanting to improve or expand their operations. To do so, a model must provide information relevant to the decision maker.
學習目標
Upon completion of this note, students will be able to:<ul><li>Clearly state inputs and assumptions; </li><li>Separate model inputs from analysis;</li><li>Reliably perform analyses; and </li><li>Create a spreadsheet designed to enable understanding and use of the model by other users.</li><ul>