嶺東科技大學 |

[NT 42591] Language: 簡体中文

[NT 5635] Back

[NT 59884] Switch To: [NT 5556] Labeled | [NT 5559] MARC Mode | [NT 33762] ISBD

Principles of financial modelling : model design and best practices using Excel and VBA

[NT 42944] Record Type:	[NT 1579] Language materials, printed : [NT 40817] monographic
[NT 47348] Title Information:	model design and best practices using Excel and VBA
[NT 47261] Author:	ReesMichael, 1964-
[NT 47351] Place of Publication:	Hoboken
[NT 47263] Published:	Wiley;
[NT 47352] Year of Publication:	c2018
[NT 47264] Description:	xxix, 512 p. ill. : 25 cm.;
[NT 47266] Subject:	Visual Basic for Applications (Computer program language) -
[NT 47266] Subject:	Finance - Mathematical models. -
[NT 47266] Subject:	Corporations - Finance -
[NT 50961] ISBN:	978-1-118-90401-5bound
[NT 60779] Content Note:	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.

Principles of financial modelling : model design and best practices using Excel and VBA
Rees, Michael

Principles of financial modelling : model design and best practices using Excel and VBA / by Michael Rees - Hoboken : Wiley, c2018. - xxix, 512 p. ; ill. ; 25 cm..
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..
Includes index..
ISBN 978-1-118-90401-5
Visual Basic for Applications (Computer program language)FinanceCorporations -- Mathematical models. -- Finance

Principles of financial modelling : model design and best practices using Excel and VBA
LDR:02097cam a2200181 4500 001 334750
005 20180312101516.0
010 1 $a 978-1-118-90401-5 $b bound $d NT$3008
100 $a 20191219d m y0chib
101 0 $a eng
102 $a us
105 $a a a 001yy
200 1 $a Principles of financial modelling $e model design and best practices using Excel and VBA $f by Michael Rees
210 $a Hoboken $d c2018 $c Wiley
215 1 $a xxix, 512 p. $d 25 cm. $c ill.
320 $a Includes index.
327 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.
605 $a Microsoft Office. $2 lc $3 404885
605 $a Microsoft Excel (Computer file) $2 lc $3 271831
606 # $a Visual Basic for Applications (Computer program language) $2 lc $3 365985
606 # $a Finance $x Mathematical models. $2 lc $3 267680
606 # $a Corporations $x Finance $x Mathematical models. $2 lc $3 296620
676 $a 332.0285554
700 1 $a Rees $b Michael $f 1964- $3 404884
801 0 $a tw $b 嶺東科技大學圖書館