大葉大學圖書館 |

Principles of financial modelling[electronic resource] :model design and best practices using Excel and VBA /

紀錄類型:	書目-電子資源 : Monograph/item
杜威分類號:	332.0285/554
書名/作者:	Principles of financial modelling : model design and best practices using Excel and VBA // by Michael Rees.
作者:	Rees, Michael,
出版者:	Hoboken, NJ : : Wiley,, 2018.
面頁冊數:	1 online resource.
附註:	Includes index.
標題:	Corporations - Finance
標題:	Finance - Mathematical models.
標題:	Visual Basic for Applications (Computer program language)
ISBN:	9781118903933
ISBN:	1118903935
ISBN:	9781118904008
ISBN:	1118904001
ISBN:	9781118903940
ISBN:	1118903943
內容註:	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.
電子資源:	https://onlinelibrary.wiley.com/doi/book/10.1002/9781118903933

Principles of financial modelling[electronic resource] :model design and best practices using Excel and VBA /
Rees, Michael,1964-

Principles of financial modellingmodel 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:

405277
Corporations
--Finance

LC Class. No.: HG106

Dewey Class. No.: 332.0285/554

Principles of financial modelling[electronic resource] :model design and best practices using Excel and VBA /
LDR:02626cmm a2200325 a 4500 001 522747
003 OCoLC
005 20221226072503.0
006 m o d
007 cr cnu---unuuu
008 230416s2018 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 662809
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 388557
630 0 0 $a Microsoft Office. $3 418039
650 0 $a Corporations $x Finance $x Mathematical models. $3 405277
650 0 $a Finance $x Mathematical models. $3 342179
650 0 $a Visual Basic for Applications (Computer program language) $3 663472
856 4 0 $u https://onlinelibrary.wiley.com/doi/book/10.1002/9781118903933