語系:
繁體中文
English
說明(常見問題)
圖資館首頁
登入
回首頁
到查詢結果
[ subject:"Visual Basic for Applications (Computer program language)" ]
切換:
標籤
|
MARC模式
|
ISBD
Principles of financial modellingmodel design and best practices using Excel and VBA /
紀錄類型:
書目-電子資源 : Monograph/item
正題名/作者:
Principles of financial modellingby Michael Rees.
其他題名:
model design and best practices using Excel and VBA /
作者:
Rees, Michael,
出版者:
Hoboken, NJ :Wiley,2018.
面頁冊數:
1 online resource.
附註:
Includes index.
標題:
CorporationsFinance
電子資源:
https://onlinelibrary.wiley.com/doi/book/10.1002/9781118903933
ISBN:
9781118903933$q(electronic bk.)
Principles of financial modellingmodel 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: 9781118903933$q(electronic bk.)Subjects--Uniform Titles:
Microsoft Excel (Computer file)
Subjects--Topical Terms:
266246
Corporations
--Finance
LC Class. No.: HG106
Dewey Class. No.: 332.0285/554
Principles of financial modellingmodel design and best practices using Excel and VBA /
LDR
:02626cmm a2200325 a 4500
001
628052
003
OCoLC
005
20221226072503.0
006
m o d
007
cr cnu---unuuu
008
230202s2018 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
754722
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
190780
630
0 0
$a
Microsoft Office.
$3
204942
650
0
$a
Corporations
$x
Finance
$x
Mathematical models.
$3
266246
650
0
$a
Finance
$x
Mathematical models.
$3
183782
650
0
$a
Visual Basic for Applications (Computer program language)
$3
755311
856
4 0
$u
https://onlinelibrary.wiley.com/doi/book/10.1002/9781118903933
筆 0 讀者評論
全部
電子館藏
館藏
1 筆 • 頁數 1 •
1
條碼號
館藏地
館藏流通類別
資料類型
索書號
使用類型
借閱狀態
預約狀態
備註欄
附件
000000219125
電子館藏
1圖書
電子書
EB HG106 2018
一般使用(Normal)
在架
0
1 筆 • 頁數 1 •
1
多媒體
多媒體檔案
https://onlinelibrary.wiley.com/doi/book/10.1002/9781118903933
評論
新增評論
分享你的心得
Export
取書館別
處理中
...
變更密碼
登入