Principles of financial modelling model design and best practices using Excel and VBA
Material type:![Text](/opac-tmpl/lib/famfamfam/BK.png)
- 9781118904015
- 332.0285554 23 RE-P
- HG106 .R4397 2018
![](/opac-tmpl/bootstrap/itemtypeimg/bridge/book.png)
Item type | Home library | Collection | Shelving location | Call number | Status | Date due | Barcode | |
---|---|---|---|---|---|---|---|---|
![]() |
OPJGU Sonepat- Campus | General Books | Main Library | 332.0285554 RE-P (Browse shelf(Opens below)) | Available | 140487 |
Browsing OPJGU Sonepat- Campus shelves, Collection: General Books Close shelf browser (Hides shelf browser)
![]() |
![]() |
![]() |
![]() |
![]() |
![]() |
![]() |
||
332.0285513 BE-F Financial analytics with R building a laptop laboratory for data science | 332.0285554 BE-P Principles of finance with Excel | 332.0285554 HE-F Financial modelling and asset valuation with Excel | 332.0285554 RE-P Principles of financial modelling model design and best practices using Excel and VBA | 332.0285554 SE-F Financial analysis and modeling using Excel and VBA | 332.0285631 JA-Q Quantum machine learning and optimisation in finance : drive financial innovation with quantum-powered algorithms and optimisation strategies / | 332.03 MA-F Financial terms simplified |
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.
There are no comments on this title.