語系:
繁體中文
English
說明(常見問題)
回圖書館首頁
手機版館藏查詢
登入
回首頁
切換:
標籤
|
MARC模式
|
ISBD
Principles of financial modelling = ...
~
Rees, Michael, (1964-)
FindBook
Google Book
Amazon
博客來
Principles of financial modelling = model design and best practices using Excel and VBA /
紀錄類型:
書目-電子資源 : Monograph/item
正題名/作者:
Principles of financial modelling/ by Michael Rees.
其他題名:
model design and best practices using Excel and VBA /
作者:
Rees, Michael,
出版者:
Hoboken, NJ :Wiley, : 2018.,
面頁冊數:
1 online resource.
附註:
Includes index.
內容註:
Introduction to modelling, core themes and best practices -- Models of models -- Using models in decision support -- Core competencies and best practices : meta-themes -- Model design and planning -- Defining sensitivity and flexibility requirements -- Database versus formulae-driven approaches -- Designing the workbook structure -- Model building, testing and auditing -- Creating transparency: formula structure, flow and format -- Building robust and transparent formulae -- Choosing Excel functions for transparency, flexibility and efficiency -- Dealing with circularity -- Model review, auditing and validation -- Sensitivity and scenario analysis, simulation and optimisation -- Sensitivity and scenario analysis : core techniques -- Using goalseek and solver -- Using VBA macros to conduct sensitivity and scenario analyses -- Introduction to simulation and optimisation -- The modelling of risk and uncertainty, and using simulation -- Excel functions and functionality -- Core arithmetic and logical functions -- Array functions and formulae -- Mathematical functions -- Financial functions -- Statistical functions -- Information functions -- Date and time functions -- Text functions and functionality -- Lookup and reference functions -- Filters, database functions and pivottables -- Selected short-cuts and other features -- Foundations of VBA and macros -- Getting started -- Working with objects and ranges -- Controlling execution -- Writing robust code -- Manipulation and analysis of data sets with VBA -- User-defined functions.
標題:
Corporations - Finance -
電子資源:
https://onlinelibrary.wiley.com/doi/book/10.1002/9781118903933
ISBN:
9781118903933
Principles of financial modelling = model design and best practices using Excel and VBA /
Rees, Michael,1964-
Principles of financial modelling
model design and best practices using Excel and VBA /[electronic resource] :by Michael Rees. - 1st ed. - Hoboken, NJ :Wiley,2018. - 1 online resource.
Includes index.
Introduction to modelling, core themes and best practices -- Models of models -- Using models in decision support -- Core competencies and best practices : meta-themes -- Model design and planning -- Defining sensitivity and flexibility requirements -- Database versus formulae-driven approaches -- Designing the workbook structure -- Model building, testing and auditing -- Creating transparency: formula structure, flow and format -- Building robust and transparent formulae -- Choosing Excel functions for transparency, flexibility and efficiency -- Dealing with circularity -- Model review, auditing and validation -- Sensitivity and scenario analysis, simulation and optimisation -- Sensitivity and scenario analysis : core techniques -- Using goalseek and solver -- Using VBA macros to conduct sensitivity and scenario analyses -- Introduction to simulation and optimisation -- The modelling of risk and uncertainty, and using simulation -- Excel functions and functionality -- Core arithmetic and logical functions -- Array functions and formulae -- Mathematical functions -- Financial functions -- Statistical functions -- Information functions -- Date and time functions -- Text functions and functionality -- Lookup and reference functions -- Filters, database functions and pivottables -- Selected short-cuts and other features -- Foundations of VBA and macros -- Getting started -- Working with objects and ranges -- Controlling execution -- Writing robust code -- Manipulation and analysis of data sets with VBA -- User-defined functions.
ISBN: 9781118903933Subjects--Uniform Titles:
Microsoft Excel (Computer file)
Subjects--Topical Terms:
654846
Corporations
--Finance
LC Class. No.: HG106
Dewey Class. No.: 332.0285/554
Principles of financial modelling = model design and best practices using Excel and VBA /
LDR
:02626cmm a2200325 a 4500
001
2311520
003
OCoLC
005
20221226072503.0
006
m o d
007
cr cnu---unuuu
008
230722s2018 nju o 001 0 eng
020
$a
9781118903933
$q
(electronic bk.)
020
$a
1118903935
$q
(electronic bk.)
020
$a
9781118904008
$q
(ePub)
020
$a
1118904001
$q
(ePub)
020
$a
9781118903940
$q
(ePDF)
020
$a
1118903943
$q
(ePDF)
020
$z
9781118904015
$q
(cloth)
035
$a
1028605404
040
$a
DLC
$b
eng
$c
DLC
$d
OCLCO
$d
OCLCQ
$d
DG1
$d
OCLCF
$d
MERER
$d
UPM
$d
UAB
$d
OCLCQ
041
0
$a
eng
050
1 0
$a
HG106
082
0 0
$a
332.0285/554
$2
23
100
1
$a
Rees, Michael,
$d
1964-
$3
2204652
245
1 0
$a
Principles of financial modelling
$h
[electronic resource] :
$b
model design and best practices using Excel and VBA /
$c
by Michael Rees.
250
$a
1st ed.
260
$a
Hoboken, NJ :
$b
Wiley,
$c
2018.
300
$a
1 online resource.
500
$a
Includes index.
505
0
$a
Introduction to modelling, core themes and best practices -- Models of models -- Using models in decision support -- Core competencies and best practices : meta-themes -- Model design and planning -- Defining sensitivity and flexibility requirements -- Database versus formulae-driven approaches -- Designing the workbook structure -- Model building, testing and auditing -- Creating transparency: formula structure, flow and format -- Building robust and transparent formulae -- Choosing Excel functions for transparency, flexibility and efficiency -- Dealing with circularity -- Model review, auditing and validation -- Sensitivity and scenario analysis, simulation and optimisation -- Sensitivity and scenario analysis : core techniques -- Using goalseek and solver -- Using VBA macros to conduct sensitivity and scenario analyses -- Introduction to simulation and optimisation -- The modelling of risk and uncertainty, and using simulation -- Excel functions and functionality -- Core arithmetic and logical functions -- Array functions and formulae -- Mathematical functions -- Financial functions -- Statistical functions -- Information functions -- Date and time functions -- Text functions and functionality -- Lookup and reference functions -- Filters, database functions and pivottables -- Selected short-cuts and other features -- Foundations of VBA and macros -- Getting started -- Working with objects and ranges -- Controlling execution -- Writing robust code -- Manipulation and analysis of data sets with VBA -- User-defined functions.
588
$a
Description based on print version record.
630
0 0
$a
Microsoft Excel (Computer file)
$3
543656
$3
543656
630
0 0
$a
Microsoft Office.
$3
560179
650
0
$a
Corporations
$x
Finance
$x
Mathematical models.
$3
654846
650
0
$a
Finance
$x
Mathematical models.
$3
578740
650
0
$a
Visual Basic for Applications (Computer program language)
$3
2205205
856
4 0
$u
https://onlinelibrary.wiley.com/doi/book/10.1002/9781118903933
筆 0 讀者評論
館藏地:
全部
電子資源
出版年:
卷號:
館藏
1 筆 • 頁數 1 •
1
條碼號
典藏地名稱
館藏流通類別
資料類型
索書號
使用類型
借閱狀態
預約狀態
備註欄
附件
W9450134
電子資源
11.線上閱覽_V
電子書
EB HG106
一般使用(Normal)
在架
0
1 筆 • 頁數 1 •
1
多媒體
評論
新增評論
分享你的心得
Export
取書館
處理中
...
變更密碼
登入