Please use this identifier to cite or link to this item:
http://localhost/handle/Hannan/3240
Full metadata record
| DC Field | Value | Language |
|---|---|---|
| dc.contributor.author | Rees, Michael, ; 1964- ; | en_US |
| dc.date.accessioned | 2013 | en_US |
| dc.date.accessioned | 2020-05-17T08:59:05Z | - |
| dc.date.available | 2020-05-17T08:59:05Z | - |
| dc.date.issued | 2018 | en_US |
| dc.identifier.isbn | 9781118904015 (cloth) ; | en_US |
| dc.identifier.uri | http://localhost/handle/Hannan/3240 | - |
| dc.description | en_US | |
| dc.description | Online version: ; Rees, Michael, 1964- author. ; Principles of financial modelling ; Hoboken : Wiley, [2018] ; 9781118903940 ; (DLC) 2018011916. ; | en_US |
| dc.description | en_US | |
| dc.description | en_US | |
| dc.description | en_US | |
| dc.description | en_US | |
| dc.description | en_US | |
| dc.description | en_US | |
| dc.description.statementofresponsibility | by Michael Rees. | en_US |
| dc.description.tableofcontents | 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. ; | en_US |
| dc.format.extent | pages cm. ; | en_US |
| dc.format.extent | Includes index. ; | en_US |
| dc.publisher | Wiley, | en_US |
| dc.relation.haspart | 9781118904015.pdf | en_US |
| dc.subject | Microsoft Excel (Computer file) ; | en_US |
| dc.subject | Microsoft Office. ; | en_US |
| dc.subject | Finance ; Mathematical models. ; | en_US |
| dc.subject | Corporations ; Finance ; Mathematical models. ; | en_US |
| dc.subject | Visual Basic for Applications (Computer program language) ; | en_US |
| dc.subject.ddc | 332.0285/554 ; 23 ; | en_US |
| dc.subject.lcc | HG106 ; .R4397 2018 ; | en_US |
| dc.title | Principles of financial modelling | en_US |
| dc.title.alternative | model design and best practices using Excel and VBA / | en_US |
| dc.type | Book | en_US |
| dc.publisher.place | Hoboken : | en_US |
| Appears in Collections: | مدیریت بازرگانی ، کسب و کار | |
Files in This Item:
| File | Description | Size | Format | |
|---|---|---|---|---|
| 9781118904015.pdf | 26.56 MB | Adobe PDF |  Preview File |
Full metadata record
| DC Field | Value | Language |
|---|---|---|
| dc.contributor.author | Rees, Michael, ; 1964- ; | en_US |
| dc.date.accessioned | 2013 | en_US |
| dc.date.accessioned | 2020-05-17T08:59:05Z | - |
| dc.date.available | 2020-05-17T08:59:05Z | - |
| dc.date.issued | 2018 | en_US |
| dc.identifier.isbn | 9781118904015 (cloth) ; | en_US |
| dc.identifier.uri | http://localhost/handle/Hannan/3240 | - |
| dc.description | en_US | |
| dc.description | Online version: ; Rees, Michael, 1964- author. ; Principles of financial modelling ; Hoboken : Wiley, [2018] ; 9781118903940 ; (DLC) 2018011916. ; | en_US |
| dc.description | en_US | |
| dc.description | en_US | |
| dc.description | en_US | |
| dc.description | en_US | |
| dc.description | en_US | |
| dc.description | en_US | |
| dc.description.statementofresponsibility | by Michael Rees. | en_US |
| dc.description.tableofcontents | 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. ; | en_US |
| dc.format.extent | pages cm. ; | en_US |
| dc.format.extent | Includes index. ; | en_US |
| dc.publisher | Wiley, | en_US |
| dc.relation.haspart | 9781118904015.pdf | en_US |
| dc.subject | Microsoft Excel (Computer file) ; | en_US |
| dc.subject | Microsoft Office. ; | en_US |
| dc.subject | Finance ; Mathematical models. ; | en_US |
| dc.subject | Corporations ; Finance ; Mathematical models. ; | en_US |
| dc.subject | Visual Basic for Applications (Computer program language) ; | en_US |
| dc.subject.ddc | 332.0285/554 ; 23 ; | en_US |
| dc.subject.lcc | HG106 ; .R4397 2018 ; | en_US |
| dc.title | Principles of financial modelling | en_US |
| dc.title.alternative | model design and best practices using Excel and VBA / | en_US |
| dc.type | Book | en_US |
| dc.publisher.place | Hoboken : | en_US |
| Appears in Collections: | مدیریت بازرگانی ، کسب و کار | |
Files in This Item:
| File | Description | Size | Format | |
|---|---|---|---|---|
| 9781118904015.pdf | 26.56 MB | Adobe PDF | Preview File |
Full metadata record
| DC Field | Value | Language |
|---|---|---|
| dc.contributor.author | Rees, Michael, ; 1964- ; | en_US |
| dc.date.accessioned | 2013 | en_US |
| dc.date.accessioned | 2020-05-17T08:59:05Z | - |
| dc.date.available | 2020-05-17T08:59:05Z | - |
| dc.date.issued | 2018 | en_US |
| dc.identifier.isbn | 9781118904015 (cloth) ; | en_US |
| dc.identifier.uri | http://localhost/handle/Hannan/3240 | - |
| dc.description | en_US | |
| dc.description | Online version: ; Rees, Michael, 1964- author. ; Principles of financial modelling ; Hoboken : Wiley, [2018] ; 9781118903940 ; (DLC) 2018011916. ; | en_US |
| dc.description | en_US | |
| dc.description | en_US | |
| dc.description | en_US | |
| dc.description | en_US | |
| dc.description | en_US | |
| dc.description | en_US | |
| dc.description.statementofresponsibility | by Michael Rees. | en_US |
| dc.description.tableofcontents | 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. ; | en_US |
| dc.format.extent | pages cm. ; | en_US |
| dc.format.extent | Includes index. ; | en_US |
| dc.publisher | Wiley, | en_US |
| dc.relation.haspart | 9781118904015.pdf | en_US |
| dc.subject | Microsoft Excel (Computer file) ; | en_US |
| dc.subject | Microsoft Office. ; | en_US |
| dc.subject | Finance ; Mathematical models. ; | en_US |
| dc.subject | Corporations ; Finance ; Mathematical models. ; | en_US |
| dc.subject | Visual Basic for Applications (Computer program language) ; | en_US |
| dc.subject.ddc | 332.0285/554 ; 23 ; | en_US |
| dc.subject.lcc | HG106 ; .R4397 2018 ; | en_US |
| dc.title | Principles of financial modelling | en_US |
| dc.title.alternative | model design and best practices using Excel and VBA / | en_US |
| dc.type | Book | en_US |
| dc.publisher.place | Hoboken : | en_US |
| Appears in Collections: | مدیریت بازرگانی ، کسب و کار | |
Files in This Item:
| File | Description | Size | Format | |
|---|---|---|---|---|
| 9781118904015.pdf | 26.56 MB | Adobe PDF | Preview File |