|
|
|
|
| LEADER |
06051nmm a2200781 u 4500 |
| 001 |
EB001953225 |
| 003 |
EBX01000000000000001116127 |
| 005 |
00000000000000.0 |
| 007 |
cr||||||||||||||||||||| |
| 008 |
210123 ||| eng |
| 020 |
|
|
|a 9781118132852
|
| 020 |
|
|
|a 1119062454
|
| 020 |
|
|
|a 1119062446
|
| 020 |
|
|
|a 1119199239
|
| 020 |
|
|
|a 9781119199236
|
| 020 |
|
|
|a 1118132874
|
| 020 |
|
|
|a 9781118132876
|
| 020 |
|
|
|a 9781119062455
|
| 020 |
|
|
|a 9781119062448
|
| 020 |
|
|
|a 1118132858
|
| 050 |
|
4 |
|a HF5548.4.M523
|
| 100 |
1 |
|
|a Fairhurst, Danielle Stein
|
| 245 |
0 |
0 |
|a Using Excel for business analysis
|b a guide to financial modelling fundamentals
|c Danielle Stein Fairhurst
|
| 246 |
3 |
1 |
|a Guide to financial modelling fundamentals
|
| 260 |
|
|
|a Singapore
|b John Wiley & Sons
|c 2012
|
| 300 |
|
|
|a 1 online resource
|
| 505 |
0 |
|
|a Chapter 10: Model ReviewRebuilding an Inherited Model; Auditing a Financial Model; Appendix 10.1: QA Log; Summary; Chapter 11: Stress-Testing, Scenarios, and Sensitivity Analysis in Financial Modelling; What's the Difference between Scenario, Sensitivity, and What-If Analysis?; Overview of Scenario Analysis Tools and Methods; Advanced Conditional Formatting; Comparing Scenario Methods; Summary; Chapter 12: Presenting Model Output; Preparing an Oral Presentation for Model Results; Preparing a Graphic or Written Presentation for Model Results; Chart Types; Working with Charts
|
| 505 |
0 |
|
|a Includes bibliographical references and index
|
| 505 |
0 |
|
|a Chapter 3: Best Practice Principles of ModellingDocument Your Assumptions; Linking, Not Hard Coding; Only Enter Data Once; Avoid Bad Habits; Use Consistent Formulas; Format and Label Clearly; Methods and Tools of Assumptions Documentation; Linked Dynamic Text Assumptions Documentation; What Makes a Good Model?; Summary; Chapter 4: Financial Modelling Techniques; The Problem with Excel; Error Avoidance Strategies; How Long Should a Formula Be?; Linking to External Files; Building Error Checks; Avoid Error Displays in Formulas; Circular References; Summary
|
| 505 |
0 |
|
|a Intro; Contents; Title; Copyright; Dedication; Preface; Chapter 1: What is Financial Modelling?; What's the Difference between a Spreadsheet and a Financial Model?; Types and Purposes of Financial Models; Tool Selection; What Skills Do you Need to Be a Good Financial Modeller?; The Ideal Financial Modeller; Summary; Chapter 2: Building a Model; Model Design; The Golden Rules for Model Design; Design Issues; The Workbook Anatomy of a Model; Project Planning Your Model; Model Layout Flow Charting; Steps to Building a Model; Information Requests; Version-Control Documentation; Summary
|
| 505 |
0 |
|
|a Bulletproofing Your ModelCustomising the Display Settings; Form Controls; Summary; Chapter 8: Tools for Financial Modelling; Hiding Sections of a Model; Grouping; Array Formulas; Goal Seeking; Pivot Tables; Macros; User-Defined Functions (UDFs); Summary; Chapter 9: Common Uses of Tools in Financial Modelling; Escalation Methods for Modelling; Understanding Nominal and Effective (Real) Rates; Calculating Cumulative Totals; How to Calculate a Payback Period; Weighted Average Cost of Capital (WACC); Building a Tiering Table; Modelling Depreciation Methods; Break-Even Analysis; Summary
|
| 505 |
0 |
|
|a Chapter 5: Using Excel in Financial ModellingFormulas and Functions in Excel; Excel Versions; Handy Excel Shortcuts; Basic Excel Functions; Logical Functions; Nesting: Combining Simple Functions to Create Complex Formulas; Cell Referencing Best Practices; Named Ranges; Summary; Chapter 6: Functions for Financial Modelling; Aggregation Functions; LOOKUP Formulas; Other Useful Functions; Working with Dates; Financial Project Evaluation Functions; Loan Calculations; Summary; Chapter 7: Tools for Model Display; Basic Formatting; Custom Formatting; Conditional Formatting; Sparklines
|
| 653 |
|
|
|a BUSINESS & ECONOMICS / Management Science / bisacsh
|
| 653 |
|
|
|a Corporations / Finance / Data processing / fast
|
| 653 |
|
|
|a BUSINESS & ECONOMICS / Management / bisacsh
|
| 653 |
|
|
|a Microsoft Excel (Computer file) / fast
|
| 653 |
|
|
|a Unternehmen / gnd
|
| 653 |
|
|
|a Programm / gnd / http://d-nb.info/gnd/4047394-6
|
| 653 |
|
|
|a Finanzierung / gnd / http://d-nb.info/gnd/4017182-6
|
| 653 |
|
|
|a BUSINESS & ECONOMICS / Organizational Behavior / bisacsh
|
| 653 |
|
|
|a Microsoft Excel (Computer file) / http://id.loc.gov/authorities/names/n86025775
|
| 653 |
|
|
|a Corporations / Finance / Data processing / http://id.loc.gov/authorities/subjects/sh85032939
|
| 653 |
|
|
|a BUSINESS & ECONOMICS / Industrial Management / bisacsh
|
| 041 |
0 |
7 |
|a eng
|2 ISO 639-2
|
| 989 |
|
|
|b OREILLY
|a O'Reilly
|
| 776 |
|
|
|z 9781118132852
|
| 776 |
|
|
|z 9781118132876
|
| 776 |
|
|
|z 9781118132869
|
| 776 |
|
|
|z 1118132858
|
| 776 |
|
|
|z 1118132866
|
| 776 |
|
|
|z 1118132874
|
| 776 |
|
|
|z 9781119062448
|
| 776 |
|
|
|z 1119062446
|
| 776 |
|
|
|z 1119062454
|
| 776 |
|
|
|z 9781119062455
|
| 776 |
|
|
|z 9781118132845
|
| 776 |
|
|
|z 111813284X
|
| 856 |
4 |
0 |
|u https://learning.oreilly.com/library/view/~/9781118132876/?ar
|x Verlag
|3 Volltext
|
| 082 |
0 |
|
|a 005.54
|
| 082 |
0 |
|
|a 670
|
| 082 |
0 |
|
|a 658
|
| 082 |
0 |
|
|a 500
|
| 082 |
0 |
|
|a 302.3
|
| 082 |
0 |
|
|a 300
|
| 082 |
0 |
|
|a 338
|
| 082 |
0 |
|
|a 332
|
| 082 |
0 |
|
|a 330
|
| 520 |
|
|
|a "A clear, concise, and easy-to-use guide to financial modelling suitable for practitioners at every level. Using a fundamental approach to financial modelling that's accessible to both new and experienced professionals, Using Excel for Business Analysis: A Guide to Financial Modelling Fundamentals + Website offers practical guidance for anyone looking to build financial models for business proposals, to evaluate opportunities, or to craft financial reports. Comprehensive in nature, the book covers the principles and best practices of financial modelling, including the Excel tools, formulas, and functions to master, and the techniques and strategies necessary to eliminate errors."--Publisher's website
|