Tools

LEADER 03528cam 22004818i 4500

001 ssj0001979144;

003 WaSeSS;

005 20220914051132.0;

006 m d ;

007 cr n ;

008 180125s2018 nju s 001 0 eng d;

010 a| 2017057631;

020 a| 9781118904015 (cloth);

035 a| (WaSeSS)ssj0001979144;

042 a| pcc;

049 a| EREEa| NEHH;

050 00 a| HG106b| .R443 2018;

082 00 a| 332.0285/5542| 23;

100 1 a| Rees, Michael,d| 1964-?| UNAUTHORIZED;

245 10 a| Principles of financial modellingh| [electronic resource] :b| model design and best practices using Excel and VBA /c| by Michael Rees.;

260 a| Hoboken :b| Wiley,c| [2018];

263 a| 1804;

300 a| pages cm;

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.;

506 a| Available only to authorized users.;

538 a| Mode of access: World Wide Web;

630 00 a| Microsoft Excel (Computer file)=| ^A361104;

630 00 a| Microsoft Office.=| ^A391185;

650 0 a| Financex| Mathematical models.=| ^A51853;

650 0 a| Corporationsx| Financex| Mathematical models.=| ^A118305;

650 0 a| Visual Basic for Applications (Computer program language)=| ^A1305051;

655 0 a| Electronic books.=| ^A491897;

856 40 z| Full text available from Ebook Central - Academic Completeu| https://ebookcentral.proquest.com/lib/eastcarolina/detail.action?docID=5326886;

949 a| CLICK ON WEB ADDRESSw| ASISh| JOYNER188;

949 a| CLICK ON WEB ADDRESSw| ASISh| HSL77;

949 a| CLICK ON WEB ADDRESSw| ASISh| JMUSIC60;

596 a| 1 3 4;

998 a| 5869429;

999 a| CLICK ON WEB ADDRESSw| ASISc| 1i| 5869429-1001l| JNETm| JOYNERr| Ys| Yt| JNESSBKu| 7/18/2022x| EBOOKz| JERESOURCE;

999 a| CLICK ON WEB ADDRESSw| ASISc| 1i| 5869429-2001l| HSLELECm| HSLr| Ys| Yt| HEBKu| 7/18/2022x| EBOOKz| HERESOURCE;

999 a| CLICK ON WEB ADDRESSw| ASISc| 1i| 5869429-3001l| MNETm| JMUSICr| Ys| Yt| MNESSBKu| 7/18/2022x| EBOOKz| JERESOURCE;

Principles of financial modelling model design and best practices using Excel and VBA / by Michael Rees.

Author/creator	Rees, Michael, 1964-
Format	Electronic
Publication Info	Hoboken : Wiley, [2018]
Description	pages cm
Supplemental Content	Full text available from Ebook Central - Academic Complete
Subjects	Microsoft Excel (Computer file) Microsoft Office. Finance--Mathematical models. Corporations--Finance. --Mathematical models. Visual Basic for Applications (Computer program language)

Contents	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.
General note	Includes index.
Access restriction	Available only to authorized users.
Technical details	Mode of access: World Wide Web
Genre/form	Electronic books.
LCCN	2017057631
ISBN	9781118904015 (cloth)

Principles of financial modelling model design and best practices using Excel and VBA / by Michael Rees.

Click here for more information about this title