Using Excel for business and financial modelling : a practical guide
"A hands-on guide to using Excel in the business context First published in 2012, Using Excel for Business and Financial Modelling contains step-by-step instructions of how to solve common business problems using financial models, including downloadable Excel templates, a list of shortcuts and...
Ausführliche Beschreibung
Gespeichert in:
| Werktitel: |
Using Excel for business analysis [Fairhurst, Danielle Stein] |
|---|
| Autor*in: |
Fairhurst, Danielle Stein [verfasserIn] |
|---|
| Format: |
E-Book |
|---|---|
| Sprache: |
Englisch |
| Erschienen: |
Hoboken: Wiley ; 2019 ©2019 |
|---|---|
| Ausgabe: |
Third edition |
| Schlagwörter: |
Microsoft Excel (Computer file) Corporations, Finance, Computer programs |
|---|---|
| Formangabe: |
Electronic books |
| Anmerkung: |
Includes index Machine generated contents note: 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 Product Design Design Issues The Workbook Anatomy of a Model Project Planning Your Model Model Layout Flowcharting Steps to Building a Model Information Requests Version-Control Documentation Summary Chapter 3: Best-Practice Principles of Modelling Document Your Assumptions Linking, Not Hardcoding Enter Data Only 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 Circular References Summary Chapter 5: Using Excel in Financial Modelling Formulas and Functions in Excel Excel Versions Handy Excel Shortcuts Cell Referencing Best Practices Named Ranges Basic Excel Functions Logical Functions Nesting Logical Functions Summary Chapter 6: Functions for Financial Modelling Aggregation Functions LOOKUP Functions Nesting Index and Matching OFFSET Function Regression Analysis Choose Function Working with Dates Financial Project Evaluation Functions Loan Calculations Summary Chapter 7: Tools for Model Display Basic Formatting Custom Formatting Conditional Formatting Sparklines Bulletproofing Your Model Customising the Display Settings Form Controls Summary Chapter 8: Tools for Financial Modelling Hiding Sections of a Model Array Formulas Goal Seeking Structured Reference Tables PivotTables Macros Summary Chapter 9: Common Uses of Tools in Financial Modelling Escalation Methods for Modelling Understanding Nominal and Effective (Real) Rates Calculating a Cumulative Sum (Running Totals) How to Calculate a Payback Period Weighted Average Cost of Capital (WACC) Building a Tiering Table Modelling Depreciation Methods Break-Even Analysis Summary Chapter 10: Model Review Rebuilding an Inherited Model Improving Model Performance Auditing a Financial Model Summary Appendix: QA Log Chapter 11: Stress Testing, Scenarios, and Sensitivity Analysis in Financial Modelling What are the Differences Between Scenario, Sensitivity, and What-If Analyses? Overview of Scenario Analysis Tools and Methods Advanced Conditional Formatting Comparing Scenario Methods Adding Probability to a Data Table 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 Handy Charting Hints Dynamic Named Ranges Charting with Two Different Axes and Chart Types Bubble Charts Creating a Dynamic Chart Waterfall Charts Summary Index Revised edition of the author's Using Excel for business analysis, 2012 |
|---|---|
| Umfang: |
1 Online-Ressource (1 online resource) |
| Reihe: |
Wiley finance |
|---|
| Links: |
Link aufrufen |
|---|---|
| ISBN: |
1-119-52034-7 1-119-52037-1 978-1-119-52034-4 978-1-119-52037-5 |
| DOI / URN: |
10.1002/9781119520344 |
|---|
| Katalog-ID: |
1679259504 |
|---|
| LEADER | 01000cam a22002652 4500 | ||
|---|---|---|---|
| 001 | 1679259504 | ||
| 003 | DE-627 | ||
| 005 | 20240812085612.0 | ||
| 007 | cr uuu---uuuuu | ||
| 008 | 191021s2019 xxu|||||o 00| ||eng c | ||
| 020 | |a 1119520347 |9 1-119-52034-7 | ||
| 020 | |a 1119520371 |9 1-119-52037-1 | ||
| 020 | |a 9781119520344 |c ePub |9 978-1-119-52034-4 | ||
| 020 | |a 9781119520375 |c ePDF |9 978-1-119-52037-5 | ||
| 020 | |z 111952038X | ||
| 020 | |z 9781119520382 | ||
| 024 | 7 | |a 10.1002/9781119520344 |2 doi | |
| 035 | |a (DE-627)1679259504 | ||
| 035 | |a (DE-599)KEP045126623 | ||
| 035 | |a (OCoLC)1148180080 | ||
| 035 | |a (WILEY)9781119520344 | ||
| 035 | |a (EBP)045126623 | ||
| 040 | |a DE-627 |b eng |c DE-627 |e rda | ||
| 041 | |a eng | ||
| 044 | |c XD-US | ||
| 050 | 0 | |a HF5548.4.M523 | |
| 072 | 7 | |a BUS 027000 |2 bisacsh | |
| 072 | 7 | |a BUS027000 |2 bisacsh | |
| 100 | 1 | |a Fairhurst, Danielle Stein |e verfasserin |4 aut | |
| 240 | 1 | 0 | |a Using Excel for business analysis |
| 245 | 1 | 0 | |a Using Excel for business and financial modelling |b a practical guide |c Danielle Stein Fairhurst |
| 250 | |a Third edition | ||
| 264 | 1 | |a Hoboken |b Wiley |c 2019 | |
| 264 | 4 | |c ©2019 | |
| 300 | |a 1 Online-Ressource (1 online resource) | ||
| 336 | |a Text |b txt |2 rdacontent | ||
| 337 | |a Computermedien |b c |2 rdamedia | ||
| 338 | |a Online-Ressource |b cr |2 rdacarrier | ||
| 490 | 0 | |a Wiley finance | |
| 500 | |a Includes index | ||
| 500 | |a Machine generated contents note: 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 Product Design Design Issues The Workbook Anatomy of a Model Project Planning Your Model Model Layout Flowcharting Steps to Building a Model Information Requests Version-Control Documentation Summary Chapter 3: Best-Practice Principles of Modelling Document Your Assumptions Linking, Not Hardcoding Enter Data Only 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 Circular References Summary Chapter 5: Using Excel in Financial Modelling Formulas and Functions in Excel Excel Versions Handy Excel Shortcuts Cell Referencing Best Practices Named Ranges Basic Excel Functions Logical Functions Nesting Logical Functions Summary Chapter 6: Functions for Financial Modelling Aggregation Functions LOOKUP Functions Nesting Index and Matching OFFSET Function Regression Analysis Choose Function Working with Dates Financial Project Evaluation Functions Loan Calculations Summary Chapter 7: Tools for Model Display Basic Formatting Custom Formatting Conditional Formatting Sparklines Bulletproofing Your Model Customising the Display Settings Form Controls Summary Chapter 8: Tools for Financial Modelling Hiding Sections of a Model Array Formulas Goal Seeking Structured Reference Tables PivotTables Macros Summary Chapter 9: Common Uses of Tools in Financial Modelling Escalation Methods for Modelling Understanding Nominal and Effective (Real) Rates Calculating a Cumulative Sum (Running Totals) How to Calculate a Payback Period Weighted Average Cost of Capital (WACC) Building a Tiering Table Modelling Depreciation Methods Break-Even Analysis Summary Chapter 10: Model Review Rebuilding an Inherited Model Improving Model Performance Auditing a Financial Model Summary Appendix: QA Log Chapter 11: Stress Testing, Scenarios, and Sensitivity Analysis in Financial Modelling What are the Differences Between Scenario, Sensitivity, and What-If Analyses? Overview of Scenario Analysis Tools and Methods Advanced Conditional Formatting Comparing Scenario Methods Adding Probability to a Data Table 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 Handy Charting Hints Dynamic Named Ranges Charting with Two Different Axes and Chart Types Bubble Charts Creating a Dynamic Chart Waterfall Charts Summary Index | ||
| 500 | |a Revised edition of the author's Using Excel for business analysis, 2012 | ||
| 520 | |a "A hands-on guide to using Excel in the business context First published in 2012, Using Excel for Business and Financial Modelling contains step-by-step instructions of how to solve common business problems using financial models, including downloadable Excel templates, a list of shortcuts and tons of practical tips and techniques you can apply straight away. Whilst there are many hundreds of tools, features and functions in Excel, this book focuses on the topics most relevant to finance professionals. It covers these features in detail from a practical perspective, but also puts them in context by applying them to practical examples in the real world. Learn to create financial models to help make business decisions whilst applying modelling best practice methodology, tools and techniques. Provides the perfect mix of practice and theory Helps you become a DIY Excel modelling specialist Includes updates for Excel 2019/365 and Excel for Mac May be used as an accompaniment to the authors online and face-to-face training courses Many people are often overwhelmed by the hundreds of tools in Excel, and this book gives clarity to the ones you need to know in order to perform your job more efficiently. This book also demystifies the technical, design, logic and financial skills you need for business and financial modelling"-- | ||
| 520 | |a "The book is a very hands-on guide to the use of Excel in a business context. First published in 2012, it contains step-by-step instructions of how to solve common business problems using financial models, including downloadable Excel templates as well as other supplementary content; a list of shortcuts and jam-packed with practical tips and techniques the reader can pick up and apply straight away to their work. Readers purchase the book for their own learning and it is also used as an accompaniment to the author's online and face to face training courses. Whilst there are many hundreds of tools, features and functions in Excel, this book focusses more on topics relevant to finance professionals. It covers these features in detail from a practical perspective, but also puts them in context by applying them to practical examples in the real world. Readers are often overwhelmed by the hundreds of tools in Excel and this book gives them clarity by showing them only the ones that they really need to know in order to perform their job more efficiently"-- | ||
| 520 | |a Ability to Think LogicallyThe "Ideal" Financial Modeller; What's the Typical Background for a Financial Modeller?; Training Courses; Summary; Chapter 2 Building a Model; Model Design; Practical Example 1: Assumptions Layout; Practical Example 2: Summary Categorisation; The Golden Rules for Model Design; Separate Inputs, Calculations, and Results, where Possible; Use Each Column for the Same Purpose; Use One Formula per Row or Column; Refer to the Left and Above; Use Multiple Worksheets; Include Documentation Sheets; Design Issues; The Workbook Anatomy of a Model; Workbook Anatomy Issues | ||
| 520 | |a Cover; Title Page; Copyright; Contents; Preface; Book Overview; Acknowledgements; 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; Is Excel Really the Best Option?; Evaluating Modelling Tools; 32-Bit versus 64-Bit Microsoft Excel; What Skills do You Need to be a Good Financial Modeller?; Spreadsheet and Technical Excel Skills; Industry Knowledge; Accounting Knowledge; Business Knowledge; Aesthetic Design Skills; Communication and Language Skills; Numeracy Skills | ||
| 520 | |a Error-Check ExerciseAllowing Tolerance for Error; Error-Check Alerts; Avoid Error Displays in Formulas; Circular References; How to Fix Circular References; Circular References in Interest Calculations; Enabling Iterative Calculations; Summary; Chapter 5 Using Excel in Financial Modelling; Formulas and Functions in Excel; Choose the Simplest Solution; Excel Versions; What is the Difference Between a Perpetual and a Subscription-Based Licence?; Excel Version Compatibility; Handy Excel Shortcuts; Windows Shortcuts; Mac Shortcuts; Cell Referencing Best Practices | ||
| 520 | |a In-Cell Comments"Red Triangle" Comments; Footnoting; Hyperlinks; Hardcoded Text; Linked Dynamic Text Assumptions Documentation; Practical Exercise 1; Practical Exercise 2; Practical Exercise 3; What Makes a Good Model?; Standards in Financial Modelling; Summary; Chapter 4 Financial Modelling Techniques; The Problem With Excel; Error Avoidance Strategies; Avoiding Simple Formula Errors; How Long Should a Formula Be?; Linking to External Files; Why You Should Use Named Ranges in External Links; Dealing with Links and the Potential Errors They Can Cause; Building Error Checks | ||
| 520 | |a Project Planning Your ModelHow Long Does it Take to Build a Financial Model?; Building a Model Under Pressure; Model Layout Flowcharting; Practical Exercise: Model Design Customer Support Pricing Model; Steps to Building a Model; The Streamlined Version; The Team Version; Information Requests; Version-Control Documentation; File Structure; Summary; Chapter 3 Best-Practice Principles of Modelling; Document Your Assumptions; Linking, Not Hardcoding; Enter Data Only Once; Avoid Bad Habits; Use Consistent Formulas; Format and Label Clearly; Methods and Tools of Assumptions Documentation | ||
| 630 | 2 | 0 | |a Microsoft Excel (Computer file) |
| 650 | 0 | |a Corporations |x Finance | |
| 650 | 0 | |a Corporations |x Finance |x Computer programs | |
| 650 | 4 | |a Microsoft Excel (Computer file) | |
| 650 | 4 | |a BUSINESS & ECONOMICS ; Finance | |
| 650 | 4 | |a Corporations ; Finance | |
| 650 | 4 | |a Corporations ; Finance ; Computer programs | |
| 655 | 0 | |a Electronic books | |
| 776 | 1 | |z 9781119520382 | |
| 776 | 0 | 8 | |i Erscheint auch als |n Druck-Ausgabe |a Fairhurst, Danielle Stein |t Using Excel for business and financial modelling |d Hoboken : Wiley, 2019 |w (DLC)2019000634 |
| 856 | 4 | 0 | |u https://onlinelibrary.wiley.com/doi/book/10.1002/9781119520344 |m X:WILEY |x Verlag |z lizenzpflichtig |
| 856 | 4 | 0 | |u https://doi.org/10.1002/9781119520344 |m X:WILEY |x Verlag |z lizenzpflichtig |
| 856 | 4 | 2 | |u https://swbplus.bsz-bw.de/bsz1679259504cov.jpg |m V:DE-576 |m X:WILEY |q image/jpeg |v 20191024160409 |3 Cover |
| 856 | 4 | 2 | |u https://www.gbv.de/dms/bowker/toc/9781119520382.pdf |m DE-601 |q pdf/application |v 2020-01-19 |x Aggregator |3 Inhaltsverzeichnis |
| 912 | |a ZDB-35-UBC | ||
| 912 | |a ZDB-35-WIC | ||
| 912 | |a GBV_ILN_62 | ||
| 912 | |a ISIL_DE-28 | ||
| 912 | |a SYSFLAG_1 | ||
| 912 | |a GBV_KXP | ||
| 912 | |a GBV_ILN_120 | ||
| 912 | |a ISIL_DE-715 | ||
| 912 | |a GBV_ILN_370 | ||
| 912 | |a ISIL_DE-1373 | ||
| 912 | |a GBV_ILN_2001 | ||
| 912 | |a ISIL_DE-21 | ||
| 912 | |a GBV_ILN_2020 | ||
| 912 | |a ISIL_DE-Ch1 | ||
| 912 | |a GBV_ILN_2111 | ||
| 912 | |a ISIL_DE-944 | ||
| 912 | |a GBV_ILN_2143 | ||
| 912 | |a ISIL_DE-Rav1 | ||
| 951 | |a BO | ||
| 953 | |2 045F |a 332.0285/554 | ||
| 980 | |2 62 |1 01 |x 0028 |b 3528436042 |h OLR-Wiley-EBS |k Vervielfältigungen (z.B. Kopien, Downloads) sind nur von einzelnen Kapiteln oder Seiten und nur zum eigenen wissenschaftlichen Gebrauch erlaubt. Die Weitergabe an Dritte sowie systematisches Downloaden sind untersagt. |k Temporär im Bestand der UB Rostock |y z |z 25-10-19 | ||
| 980 | |2 120 |1 01 |x 0715 |b 3528241578 |k Campusweiter Zugriff (Universität Oldenburg). - Vervielfältigungen (z.B. Kopien, Downloads) sind nur von einzelnen Kapiteln oder Seiten und nur zum eigenen wissenschaftlichen Gebrauch erlaubt. Keine Weitergabe an Dritte. Kein systematisches Downloaden durch Robots. |y z |z 25-10-19 | ||
| 980 | |2 120 |1 02 |x 0715 |b 3742713337 |c 00 |f --%%-- |d --%%-- |e g |j --%%-- |h alma |y z |z 26-08-20 | ||
| 980 | |2 370 |1 01 |x 4370 |b 3670924132 |h EBS Wiley gelöscht |k Vervielfältigungen (z.B. Kopien, Downloads) sind nur von einzelnen Kapiteln oder Seiten und nur zum eigenen wissenschaftlichen Gebrauch erlaubt. Keine Weitergabe an Dritte. Kein systematisches Downloaden durch Robots. |u i |y z |z 25-05-20 | ||
| 980 | |2 2001 |1 01 |x DE-21 |b 3526649723 |c 00 |f --%%-- |d --%%-- |e --%%-- |j n |y l01 |z 24-10-19 | ||
| 980 | |2 2020 |1 01 |x DE-Ch1 |b 4046987111 |c 00 |f --%%-- |d --%%-- |e --%%-- |j n |k Campuslizenz |y l01 |z 28-01-22 | ||
| 980 | |2 2111 |1 01 |x DE-944 |b 3602526119 |c 00 |f --%%-- |d eBook Wiley |e --%%-- |j n |k Elektronischer Volltext - Campuslizenz |y l01 |z 03-03-20 | ||
| 980 | |2 2143 |1 01 |x DE-Rav1 |b 3818582947 |c 00 |f --%%-- |d E-Book Wiley |e --%%-- |j n |y l01 |z 07-12-20 | ||
| 981 | |2 62 |1 01 |x 0028 |r https://onlinelibrary.wiley.com/doi/book/10.1002/9781119520344 | ||
| 981 | |2 120 |1 01 |x 0715 |r https://onlinelibrary.wiley.com/doi/book/10.1002/9781119520344 | ||
| 981 | |2 120 |1 02 |x 0715 |r http://49gbv-uob-primo.hosted.exlibrisgroup.com/openurl/49GBV_UOB/UOB_services_page?u.ignore_date_coverage=true&rft.mms_id=991015039827303501 | ||
| 981 | |2 370 |1 01 |x 4370 |y E-Book: Zugriff im HCU-Netz. Zugriff von außerhalb nur für HCU-Angehörige möglich |r https://onlinelibrary.wiley.com/doi/book/10.1002/9781119520344 | ||
| 981 | |2 2001 |1 01 |x DE-21 |r https://onlinelibrary.wiley.com/doi/book/10.1002/9781119520344 | ||
| 981 | |2 2020 |1 01 |x DE-Ch1 |r https://onlinelibrary.wiley.com/doi/book/10.1002/9781119520344 | ||
| 981 | |2 2111 |1 01 |x DE-944 |r https://onlinelibrary.wiley.com/doi/book/10.1002/9781119520344 | ||
| 981 | |2 2143 |1 01 |x DE-Rav1 |r https://onlinelibrary.wiley.com/doi/book/10.1002/9781119520344 | ||
| 982 | |2 2001 |1 01 |x DE-21 |8 00 |s s |a eBook-Wiley-UBCM-eBook-Collection-2018 | ||
| 983 | |2 120 |1 00 |x DE-715 |8 99 |a ww | ||
| 983 | |2 2111 |1 01 |x DE-944 |8 00 |0 (DE-627)1353370437 |a e-Book | ||
| 983 | |2 2143 |1 01 |x DE-Rav1 |8 00 |0 (DE-627)1343240476 |a eBook | ||
| 995 | |2 62 |1 01 |x 0028 |a OLR-Wiley-EBS | ||
| 995 | |2 120 |1 02 |x 0715 |a alma | ||
| 995 | |2 370 |1 01 |x 4370 |a EBS Wiley gelöscht | ||
| 995 | |2 370 |1 01 |x 4370 |a olr-ebook wiley | ||
| 995 | |2 370 |1 01 |x 4370 |a ACQ | ||
| author_variant |
d s f ds dsf |
|---|---|
| matchkey_str |
book:9781119520344:2019---- |
| oclc_num |
1148180080 |
| hierarchy_sort_str |
2019 |
| callnumber-subject-code |
HF |
| publishDate |
2019 |
| allfields |
1119520347 1-119-52034-7 1119520371 1-119-52037-1 9781119520344 ePub 978-1-119-52034-4 9781119520375 ePDF 978-1-119-52037-5 111952038X 9781119520382 10.1002/9781119520344 doi (DE-627)1679259504 (DE-599)KEP045126623 (OCoLC)1148180080 (WILEY)9781119520344 (EBP)045126623 DE-627 eng DE-627 rda eng XD-US HF5548.4.M523 BUS 027000 bisacsh BUS027000 bisacsh Fairhurst, Danielle Stein verfasserin aut Using Excel for business analysis Using Excel for business and financial modelling a practical guide Danielle Stein Fairhurst Third edition Hoboken Wiley 2019 ©2019 1 Online-Ressource (1 online resource) Text txt rdacontent Computermedien c rdamedia Online-Ressource cr rdacarrier Wiley finance Includes index Machine generated contents note: 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 Product Design Design Issues The Workbook Anatomy of a Model Project Planning Your Model Model Layout Flowcharting Steps to Building a Model Information Requests Version-Control Documentation Summary Chapter 3: Best-Practice Principles of Modelling Document Your Assumptions Linking, Not Hardcoding Enter Data Only 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 Circular References Summary Chapter 5: Using Excel in Financial Modelling Formulas and Functions in Excel Excel Versions Handy Excel Shortcuts Cell Referencing Best Practices Named Ranges Basic Excel Functions Logical Functions Nesting Logical Functions Summary Chapter 6: Functions for Financial Modelling Aggregation Functions LOOKUP Functions Nesting Index and Matching OFFSET Function Regression Analysis Choose Function Working with Dates Financial Project Evaluation Functions Loan Calculations Summary Chapter 7: Tools for Model Display Basic Formatting Custom Formatting Conditional Formatting Sparklines Bulletproofing Your Model Customising the Display Settings Form Controls Summary Chapter 8: Tools for Financial Modelling Hiding Sections of a Model Array Formulas Goal Seeking Structured Reference Tables PivotTables Macros Summary Chapter 9: Common Uses of Tools in Financial Modelling Escalation Methods for Modelling Understanding Nominal and Effective (Real) Rates Calculating a Cumulative Sum (Running Totals) How to Calculate a Payback Period Weighted Average Cost of Capital (WACC) Building a Tiering Table Modelling Depreciation Methods Break-Even Analysis Summary Chapter 10: Model Review Rebuilding an Inherited Model Improving Model Performance Auditing a Financial Model Summary Appendix: QA Log Chapter 11: Stress Testing, Scenarios, and Sensitivity Analysis in Financial Modelling What are the Differences Between Scenario, Sensitivity, and What-If Analyses? Overview of Scenario Analysis Tools and Methods Advanced Conditional Formatting Comparing Scenario Methods Adding Probability to a Data Table 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 Handy Charting Hints Dynamic Named Ranges Charting with Two Different Axes and Chart Types Bubble Charts Creating a Dynamic Chart Waterfall Charts Summary Index Revised edition of the author's Using Excel for business analysis, 2012 "A hands-on guide to using Excel in the business context First published in 2012, Using Excel for Business and Financial Modelling contains step-by-step instructions of how to solve common business problems using financial models, including downloadable Excel templates, a list of shortcuts and tons of practical tips and techniques you can apply straight away. Whilst there are many hundreds of tools, features and functions in Excel, this book focuses on the topics most relevant to finance professionals. It covers these features in detail from a practical perspective, but also puts them in context by applying them to practical examples in the real world. Learn to create financial models to help make business decisions whilst applying modelling best practice methodology, tools and techniques. Provides the perfect mix of practice and theory Helps you become a DIY Excel modelling specialist Includes updates for Excel 2019/365 and Excel for Mac May be used as an accompaniment to the authors online and face-to-face training courses Many people are often overwhelmed by the hundreds of tools in Excel, and this book gives clarity to the ones you need to know in order to perform your job more efficiently. This book also demystifies the technical, design, logic and financial skills you need for business and financial modelling"-- "The book is a very hands-on guide to the use of Excel in a business context. First published in 2012, it contains step-by-step instructions of how to solve common business problems using financial models, including downloadable Excel templates as well as other supplementary content; a list of shortcuts and jam-packed with practical tips and techniques the reader can pick up and apply straight away to their work. Readers purchase the book for their own learning and it is also used as an accompaniment to the author's online and face to face training courses. Whilst there are many hundreds of tools, features and functions in Excel, this book focusses more on topics relevant to finance professionals. It covers these features in detail from a practical perspective, but also puts them in context by applying them to practical examples in the real world. Readers are often overwhelmed by the hundreds of tools in Excel and this book gives them clarity by showing them only the ones that they really need to know in order to perform their job more efficiently"-- Ability to Think LogicallyThe "Ideal" Financial Modeller; What's the Typical Background for a Financial Modeller?; Training Courses; Summary; Chapter 2 Building a Model; Model Design; Practical Example 1: Assumptions Layout; Practical Example 2: Summary Categorisation; The Golden Rules for Model Design; Separate Inputs, Calculations, and Results, where Possible; Use Each Column for the Same Purpose; Use One Formula per Row or Column; Refer to the Left and Above; Use Multiple Worksheets; Include Documentation Sheets; Design Issues; The Workbook Anatomy of a Model; Workbook Anatomy Issues Cover; Title Page; Copyright; Contents; Preface; Book Overview; Acknowledgements; 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; Is Excel Really the Best Option?; Evaluating Modelling Tools; 32-Bit versus 64-Bit Microsoft Excel; What Skills do You Need to be a Good Financial Modeller?; Spreadsheet and Technical Excel Skills; Industry Knowledge; Accounting Knowledge; Business Knowledge; Aesthetic Design Skills; Communication and Language Skills; Numeracy Skills Error-Check ExerciseAllowing Tolerance for Error; Error-Check Alerts; Avoid Error Displays in Formulas; Circular References; How to Fix Circular References; Circular References in Interest Calculations; Enabling Iterative Calculations; Summary; Chapter 5 Using Excel in Financial Modelling; Formulas and Functions in Excel; Choose the Simplest Solution; Excel Versions; What is the Difference Between a Perpetual and a Subscription-Based Licence?; Excel Version Compatibility; Handy Excel Shortcuts; Windows Shortcuts; Mac Shortcuts; Cell Referencing Best Practices In-Cell Comments"Red Triangle" Comments; Footnoting; Hyperlinks; Hardcoded Text; Linked Dynamic Text Assumptions Documentation; Practical Exercise 1; Practical Exercise 2; Practical Exercise 3; What Makes a Good Model?; Standards in Financial Modelling; Summary; Chapter 4 Financial Modelling Techniques; The Problem With Excel; Error Avoidance Strategies; Avoiding Simple Formula Errors; How Long Should a Formula Be?; Linking to External Files; Why You Should Use Named Ranges in External Links; Dealing with Links and the Potential Errors They Can Cause; Building Error Checks Project Planning Your ModelHow Long Does it Take to Build a Financial Model?; Building a Model Under Pressure; Model Layout Flowcharting; Practical Exercise: Model Design Customer Support Pricing Model; Steps to Building a Model; The Streamlined Version; The Team Version; Information Requests; Version-Control Documentation; File Structure; Summary; Chapter 3 Best-Practice Principles of Modelling; Document Your Assumptions; Linking, Not Hardcoding; Enter Data Only Once; Avoid Bad Habits; Use Consistent Formulas; Format and Label Clearly; Methods and Tools of Assumptions Documentation Microsoft Excel (Computer file) Corporations Finance Corporations Finance Computer programs Microsoft Excel (Computer file) BUSINESS & ECONOMICS ; Finance Corporations ; Finance Corporations ; Finance ; Computer programs Electronic books 9781119520382 Erscheint auch als Druck-Ausgabe Fairhurst, Danielle Stein Using Excel for business and financial modelling Hoboken : Wiley, 2019 (DLC)2019000634 https://onlinelibrary.wiley.com/doi/book/10.1002/9781119520344 X:WILEY Verlag lizenzpflichtig https://doi.org/10.1002/9781119520344 X:WILEY Verlag lizenzpflichtig https://swbplus.bsz-bw.de/bsz1679259504cov.jpg V:DE-576 X:WILEY image/jpeg 20191024160409 Cover https://www.gbv.de/dms/bowker/toc/9781119520382.pdf DE-601 pdf/application 2020-01-19 Aggregator Inhaltsverzeichnis ZDB-35-UBC ZDB-35-WIC GBV_ILN_62 ISIL_DE-28 SYSFLAG_1 GBV_KXP GBV_ILN_120 ISIL_DE-715 GBV_ILN_370 ISIL_DE-1373 GBV_ILN_2001 ISIL_DE-21 GBV_ILN_2020 ISIL_DE-Ch1 GBV_ILN_2111 ISIL_DE-944 GBV_ILN_2143 ISIL_DE-Rav1 BO 045F 332.0285/554 62 01 0028 3528436042 OLR-Wiley-EBS Vervielfältigungen (z.B. Kopien, Downloads) sind nur von einzelnen Kapiteln oder Seiten und nur zum eigenen wissenschaftlichen Gebrauch erlaubt. Die Weitergabe an Dritte sowie systematisches Downloaden sind untersagt. Temporär im Bestand der UB Rostock z 25-10-19 120 01 0715 3528241578 Campusweiter Zugriff (Universität Oldenburg). - Vervielfältigungen (z.B. Kopien, Downloads) sind nur von einzelnen Kapiteln oder Seiten und nur zum eigenen wissenschaftlichen Gebrauch erlaubt. Keine Weitergabe an Dritte. Kein systematisches Downloaden durch Robots. z 25-10-19 120 02 0715 3742713337 00 --%%-- --%%-- g --%%-- alma z 26-08-20 370 01 4370 3670924132 EBS Wiley gelöscht Vervielfältigungen (z.B. Kopien, Downloads) sind nur von einzelnen Kapiteln oder Seiten und nur zum eigenen wissenschaftlichen Gebrauch erlaubt. Keine Weitergabe an Dritte. Kein systematisches Downloaden durch Robots. i z 25-05-20 2001 01 DE-21 3526649723 00 --%%-- --%%-- --%%-- n l01 24-10-19 2020 01 DE-Ch1 4046987111 00 --%%-- --%%-- --%%-- n Campuslizenz l01 28-01-22 2111 01 DE-944 3602526119 00 --%%-- eBook Wiley --%%-- n Elektronischer Volltext - Campuslizenz l01 03-03-20 2143 01 DE-Rav1 3818582947 00 --%%-- E-Book Wiley --%%-- n l01 07-12-20 62 01 0028 https://onlinelibrary.wiley.com/doi/book/10.1002/9781119520344 120 01 0715 https://onlinelibrary.wiley.com/doi/book/10.1002/9781119520344 120 02 0715 http://49gbv-uob-primo.hosted.exlibrisgroup.com/openurl/49GBV_UOB/UOB_services_page?u.ignore_date_coverage=true&rft.mms_id=991015039827303501 370 01 4370 E-Book: Zugriff im HCU-Netz. Zugriff von außerhalb nur für HCU-Angehörige möglich https://onlinelibrary.wiley.com/doi/book/10.1002/9781119520344 2001 01 DE-21 https://onlinelibrary.wiley.com/doi/book/10.1002/9781119520344 2020 01 DE-Ch1 https://onlinelibrary.wiley.com/doi/book/10.1002/9781119520344 2111 01 DE-944 https://onlinelibrary.wiley.com/doi/book/10.1002/9781119520344 2143 01 DE-Rav1 https://onlinelibrary.wiley.com/doi/book/10.1002/9781119520344 2001 01 DE-21 00 s eBook-Wiley-UBCM-eBook-Collection-2018 120 00 DE-715 99 ww 2111 01 DE-944 00 (DE-627)1353370437 e-Book 2143 01 DE-Rav1 00 (DE-627)1343240476 eBook 62 01 0028 OLR-Wiley-EBS 120 02 0715 alma 370 01 4370 EBS Wiley gelöscht 370 01 4370 olr-ebook wiley 370 01 4370 ACQ |
| spelling |
1119520347 1-119-52034-7 1119520371 1-119-52037-1 9781119520344 ePub 978-1-119-52034-4 9781119520375 ePDF 978-1-119-52037-5 111952038X 9781119520382 10.1002/9781119520344 doi (DE-627)1679259504 (DE-599)KEP045126623 (OCoLC)1148180080 (WILEY)9781119520344 (EBP)045126623 DE-627 eng DE-627 rda eng XD-US HF5548.4.M523 BUS 027000 bisacsh BUS027000 bisacsh Fairhurst, Danielle Stein verfasserin aut Using Excel for business analysis Using Excel for business and financial modelling a practical guide Danielle Stein Fairhurst Third edition Hoboken Wiley 2019 ©2019 1 Online-Ressource (1 online resource) Text txt rdacontent Computermedien c rdamedia Online-Ressource cr rdacarrier Wiley finance Includes index Machine generated contents note: 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 Product Design Design Issues The Workbook Anatomy of a Model Project Planning Your Model Model Layout Flowcharting Steps to Building a Model Information Requests Version-Control Documentation Summary Chapter 3: Best-Practice Principles of Modelling Document Your Assumptions Linking, Not Hardcoding Enter Data Only 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 Circular References Summary Chapter 5: Using Excel in Financial Modelling Formulas and Functions in Excel Excel Versions Handy Excel Shortcuts Cell Referencing Best Practices Named Ranges Basic Excel Functions Logical Functions Nesting Logical Functions Summary Chapter 6: Functions for Financial Modelling Aggregation Functions LOOKUP Functions Nesting Index and Matching OFFSET Function Regression Analysis Choose Function Working with Dates Financial Project Evaluation Functions Loan Calculations Summary Chapter 7: Tools for Model Display Basic Formatting Custom Formatting Conditional Formatting Sparklines Bulletproofing Your Model Customising the Display Settings Form Controls Summary Chapter 8: Tools for Financial Modelling Hiding Sections of a Model Array Formulas Goal Seeking Structured Reference Tables PivotTables Macros Summary Chapter 9: Common Uses of Tools in Financial Modelling Escalation Methods for Modelling Understanding Nominal and Effective (Real) Rates Calculating a Cumulative Sum (Running Totals) How to Calculate a Payback Period Weighted Average Cost of Capital (WACC) Building a Tiering Table Modelling Depreciation Methods Break-Even Analysis Summary Chapter 10: Model Review Rebuilding an Inherited Model Improving Model Performance Auditing a Financial Model Summary Appendix: QA Log Chapter 11: Stress Testing, Scenarios, and Sensitivity Analysis in Financial Modelling What are the Differences Between Scenario, Sensitivity, and What-If Analyses? Overview of Scenario Analysis Tools and Methods Advanced Conditional Formatting Comparing Scenario Methods Adding Probability to a Data Table 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 Handy Charting Hints Dynamic Named Ranges Charting with Two Different Axes and Chart Types Bubble Charts Creating a Dynamic Chart Waterfall Charts Summary Index Revised edition of the author's Using Excel for business analysis, 2012 "A hands-on guide to using Excel in the business context First published in 2012, Using Excel for Business and Financial Modelling contains step-by-step instructions of how to solve common business problems using financial models, including downloadable Excel templates, a list of shortcuts and tons of practical tips and techniques you can apply straight away. Whilst there are many hundreds of tools, features and functions in Excel, this book focuses on the topics most relevant to finance professionals. It covers these features in detail from a practical perspective, but also puts them in context by applying them to practical examples in the real world. Learn to create financial models to help make business decisions whilst applying modelling best practice methodology, tools and techniques. Provides the perfect mix of practice and theory Helps you become a DIY Excel modelling specialist Includes updates for Excel 2019/365 and Excel for Mac May be used as an accompaniment to the authors online and face-to-face training courses Many people are often overwhelmed by the hundreds of tools in Excel, and this book gives clarity to the ones you need to know in order to perform your job more efficiently. This book also demystifies the technical, design, logic and financial skills you need for business and financial modelling"-- "The book is a very hands-on guide to the use of Excel in a business context. First published in 2012, it contains step-by-step instructions of how to solve common business problems using financial models, including downloadable Excel templates as well as other supplementary content; a list of shortcuts and jam-packed with practical tips and techniques the reader can pick up and apply straight away to their work. Readers purchase the book for their own learning and it is also used as an accompaniment to the author's online and face to face training courses. Whilst there are many hundreds of tools, features and functions in Excel, this book focusses more on topics relevant to finance professionals. It covers these features in detail from a practical perspective, but also puts them in context by applying them to practical examples in the real world. Readers are often overwhelmed by the hundreds of tools in Excel and this book gives them clarity by showing them only the ones that they really need to know in order to perform their job more efficiently"-- Ability to Think LogicallyThe "Ideal" Financial Modeller; What's the Typical Background for a Financial Modeller?; Training Courses; Summary; Chapter 2 Building a Model; Model Design; Practical Example 1: Assumptions Layout; Practical Example 2: Summary Categorisation; The Golden Rules for Model Design; Separate Inputs, Calculations, and Results, where Possible; Use Each Column for the Same Purpose; Use One Formula per Row or Column; Refer to the Left and Above; Use Multiple Worksheets; Include Documentation Sheets; Design Issues; The Workbook Anatomy of a Model; Workbook Anatomy Issues Cover; Title Page; Copyright; Contents; Preface; Book Overview; Acknowledgements; 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; Is Excel Really the Best Option?; Evaluating Modelling Tools; 32-Bit versus 64-Bit Microsoft Excel; What Skills do You Need to be a Good Financial Modeller?; Spreadsheet and Technical Excel Skills; Industry Knowledge; Accounting Knowledge; Business Knowledge; Aesthetic Design Skills; Communication and Language Skills; Numeracy Skills Error-Check ExerciseAllowing Tolerance for Error; Error-Check Alerts; Avoid Error Displays in Formulas; Circular References; How to Fix Circular References; Circular References in Interest Calculations; Enabling Iterative Calculations; Summary; Chapter 5 Using Excel in Financial Modelling; Formulas and Functions in Excel; Choose the Simplest Solution; Excel Versions; What is the Difference Between a Perpetual and a Subscription-Based Licence?; Excel Version Compatibility; Handy Excel Shortcuts; Windows Shortcuts; Mac Shortcuts; Cell Referencing Best Practices In-Cell Comments"Red Triangle" Comments; Footnoting; Hyperlinks; Hardcoded Text; Linked Dynamic Text Assumptions Documentation; Practical Exercise 1; Practical Exercise 2; Practical Exercise 3; What Makes a Good Model?; Standards in Financial Modelling; Summary; Chapter 4 Financial Modelling Techniques; The Problem With Excel; Error Avoidance Strategies; Avoiding Simple Formula Errors; How Long Should a Formula Be?; Linking to External Files; Why You Should Use Named Ranges in External Links; Dealing with Links and the Potential Errors They Can Cause; Building Error Checks Project Planning Your ModelHow Long Does it Take to Build a Financial Model?; Building a Model Under Pressure; Model Layout Flowcharting; Practical Exercise: Model Design Customer Support Pricing Model; Steps to Building a Model; The Streamlined Version; The Team Version; Information Requests; Version-Control Documentation; File Structure; Summary; Chapter 3 Best-Practice Principles of Modelling; Document Your Assumptions; Linking, Not Hardcoding; Enter Data Only Once; Avoid Bad Habits; Use Consistent Formulas; Format and Label Clearly; Methods and Tools of Assumptions Documentation Microsoft Excel (Computer file) Corporations Finance Corporations Finance Computer programs Microsoft Excel (Computer file) BUSINESS & ECONOMICS ; Finance Corporations ; Finance Corporations ; Finance ; Computer programs Electronic books 9781119520382 Erscheint auch als Druck-Ausgabe Fairhurst, Danielle Stein Using Excel for business and financial modelling Hoboken : Wiley, 2019 (DLC)2019000634 https://onlinelibrary.wiley.com/doi/book/10.1002/9781119520344 X:WILEY Verlag lizenzpflichtig https://doi.org/10.1002/9781119520344 X:WILEY Verlag lizenzpflichtig https://swbplus.bsz-bw.de/bsz1679259504cov.jpg V:DE-576 X:WILEY image/jpeg 20191024160409 Cover https://www.gbv.de/dms/bowker/toc/9781119520382.pdf DE-601 pdf/application 2020-01-19 Aggregator Inhaltsverzeichnis ZDB-35-UBC ZDB-35-WIC GBV_ILN_62 ISIL_DE-28 SYSFLAG_1 GBV_KXP GBV_ILN_120 ISIL_DE-715 GBV_ILN_370 ISIL_DE-1373 GBV_ILN_2001 ISIL_DE-21 GBV_ILN_2020 ISIL_DE-Ch1 GBV_ILN_2111 ISIL_DE-944 GBV_ILN_2143 ISIL_DE-Rav1 BO 045F 332.0285/554 62 01 0028 3528436042 OLR-Wiley-EBS Vervielfältigungen (z.B. Kopien, Downloads) sind nur von einzelnen Kapiteln oder Seiten und nur zum eigenen wissenschaftlichen Gebrauch erlaubt. Die Weitergabe an Dritte sowie systematisches Downloaden sind untersagt. Temporär im Bestand der UB Rostock z 25-10-19 120 01 0715 3528241578 Campusweiter Zugriff (Universität Oldenburg). - Vervielfältigungen (z.B. Kopien, Downloads) sind nur von einzelnen Kapiteln oder Seiten und nur zum eigenen wissenschaftlichen Gebrauch erlaubt. Keine Weitergabe an Dritte. Kein systematisches Downloaden durch Robots. z 25-10-19 120 02 0715 3742713337 00 --%%-- --%%-- g --%%-- alma z 26-08-20 370 01 4370 3670924132 EBS Wiley gelöscht Vervielfältigungen (z.B. Kopien, Downloads) sind nur von einzelnen Kapiteln oder Seiten und nur zum eigenen wissenschaftlichen Gebrauch erlaubt. Keine Weitergabe an Dritte. Kein systematisches Downloaden durch Robots. i z 25-05-20 2001 01 DE-21 3526649723 00 --%%-- --%%-- --%%-- n l01 24-10-19 2020 01 DE-Ch1 4046987111 00 --%%-- --%%-- --%%-- n Campuslizenz l01 28-01-22 2111 01 DE-944 3602526119 00 --%%-- eBook Wiley --%%-- n Elektronischer Volltext - Campuslizenz l01 03-03-20 2143 01 DE-Rav1 3818582947 00 --%%-- E-Book Wiley --%%-- n l01 07-12-20 62 01 0028 https://onlinelibrary.wiley.com/doi/book/10.1002/9781119520344 120 01 0715 https://onlinelibrary.wiley.com/doi/book/10.1002/9781119520344 120 02 0715 http://49gbv-uob-primo.hosted.exlibrisgroup.com/openurl/49GBV_UOB/UOB_services_page?u.ignore_date_coverage=true&rft.mms_id=991015039827303501 370 01 4370 E-Book: Zugriff im HCU-Netz. Zugriff von außerhalb nur für HCU-Angehörige möglich https://onlinelibrary.wiley.com/doi/book/10.1002/9781119520344 2001 01 DE-21 https://onlinelibrary.wiley.com/doi/book/10.1002/9781119520344 2020 01 DE-Ch1 https://onlinelibrary.wiley.com/doi/book/10.1002/9781119520344 2111 01 DE-944 https://onlinelibrary.wiley.com/doi/book/10.1002/9781119520344 2143 01 DE-Rav1 https://onlinelibrary.wiley.com/doi/book/10.1002/9781119520344 2001 01 DE-21 00 s eBook-Wiley-UBCM-eBook-Collection-2018 120 00 DE-715 99 ww 2111 01 DE-944 00 (DE-627)1353370437 e-Book 2143 01 DE-Rav1 00 (DE-627)1343240476 eBook 62 01 0028 OLR-Wiley-EBS 120 02 0715 alma 370 01 4370 EBS Wiley gelöscht 370 01 4370 olr-ebook wiley 370 01 4370 ACQ |
| allfields_unstemmed |
1119520347 1-119-52034-7 1119520371 1-119-52037-1 9781119520344 ePub 978-1-119-52034-4 9781119520375 ePDF 978-1-119-52037-5 111952038X 9781119520382 10.1002/9781119520344 doi (DE-627)1679259504 (DE-599)KEP045126623 (OCoLC)1148180080 (WILEY)9781119520344 (EBP)045126623 DE-627 eng DE-627 rda eng XD-US HF5548.4.M523 BUS 027000 bisacsh BUS027000 bisacsh Fairhurst, Danielle Stein verfasserin aut Using Excel for business analysis Using Excel for business and financial modelling a practical guide Danielle Stein Fairhurst Third edition Hoboken Wiley 2019 ©2019 1 Online-Ressource (1 online resource) Text txt rdacontent Computermedien c rdamedia Online-Ressource cr rdacarrier Wiley finance Includes index Machine generated contents note: 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 Product Design Design Issues The Workbook Anatomy of a Model Project Planning Your Model Model Layout Flowcharting Steps to Building a Model Information Requests Version-Control Documentation Summary Chapter 3: Best-Practice Principles of Modelling Document Your Assumptions Linking, Not Hardcoding Enter Data Only 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 Circular References Summary Chapter 5: Using Excel in Financial Modelling Formulas and Functions in Excel Excel Versions Handy Excel Shortcuts Cell Referencing Best Practices Named Ranges Basic Excel Functions Logical Functions Nesting Logical Functions Summary Chapter 6: Functions for Financial Modelling Aggregation Functions LOOKUP Functions Nesting Index and Matching OFFSET Function Regression Analysis Choose Function Working with Dates Financial Project Evaluation Functions Loan Calculations Summary Chapter 7: Tools for Model Display Basic Formatting Custom Formatting Conditional Formatting Sparklines Bulletproofing Your Model Customising the Display Settings Form Controls Summary Chapter 8: Tools for Financial Modelling Hiding Sections of a Model Array Formulas Goal Seeking Structured Reference Tables PivotTables Macros Summary Chapter 9: Common Uses of Tools in Financial Modelling Escalation Methods for Modelling Understanding Nominal and Effective (Real) Rates Calculating a Cumulative Sum (Running Totals) How to Calculate a Payback Period Weighted Average Cost of Capital (WACC) Building a Tiering Table Modelling Depreciation Methods Break-Even Analysis Summary Chapter 10: Model Review Rebuilding an Inherited Model Improving Model Performance Auditing a Financial Model Summary Appendix: QA Log Chapter 11: Stress Testing, Scenarios, and Sensitivity Analysis in Financial Modelling What are the Differences Between Scenario, Sensitivity, and What-If Analyses? Overview of Scenario Analysis Tools and Methods Advanced Conditional Formatting Comparing Scenario Methods Adding Probability to a Data Table 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 Handy Charting Hints Dynamic Named Ranges Charting with Two Different Axes and Chart Types Bubble Charts Creating a Dynamic Chart Waterfall Charts Summary Index Revised edition of the author's Using Excel for business analysis, 2012 "A hands-on guide to using Excel in the business context First published in 2012, Using Excel for Business and Financial Modelling contains step-by-step instructions of how to solve common business problems using financial models, including downloadable Excel templates, a list of shortcuts and tons of practical tips and techniques you can apply straight away. Whilst there are many hundreds of tools, features and functions in Excel, this book focuses on the topics most relevant to finance professionals. It covers these features in detail from a practical perspective, but also puts them in context by applying them to practical examples in the real world. Learn to create financial models to help make business decisions whilst applying modelling best practice methodology, tools and techniques. Provides the perfect mix of practice and theory Helps you become a DIY Excel modelling specialist Includes updates for Excel 2019/365 and Excel for Mac May be used as an accompaniment to the authors online and face-to-face training courses Many people are often overwhelmed by the hundreds of tools in Excel, and this book gives clarity to the ones you need to know in order to perform your job more efficiently. This book also demystifies the technical, design, logic and financial skills you need for business and financial modelling"-- "The book is a very hands-on guide to the use of Excel in a business context. First published in 2012, it contains step-by-step instructions of how to solve common business problems using financial models, including downloadable Excel templates as well as other supplementary content; a list of shortcuts and jam-packed with practical tips and techniques the reader can pick up and apply straight away to their work. Readers purchase the book for their own learning and it is also used as an accompaniment to the author's online and face to face training courses. Whilst there are many hundreds of tools, features and functions in Excel, this book focusses more on topics relevant to finance professionals. It covers these features in detail from a practical perspective, but also puts them in context by applying them to practical examples in the real world. Readers are often overwhelmed by the hundreds of tools in Excel and this book gives them clarity by showing them only the ones that they really need to know in order to perform their job more efficiently"-- Ability to Think LogicallyThe "Ideal" Financial Modeller; What's the Typical Background for a Financial Modeller?; Training Courses; Summary; Chapter 2 Building a Model; Model Design; Practical Example 1: Assumptions Layout; Practical Example 2: Summary Categorisation; The Golden Rules for Model Design; Separate Inputs, Calculations, and Results, where Possible; Use Each Column for the Same Purpose; Use One Formula per Row or Column; Refer to the Left and Above; Use Multiple Worksheets; Include Documentation Sheets; Design Issues; The Workbook Anatomy of a Model; Workbook Anatomy Issues Cover; Title Page; Copyright; Contents; Preface; Book Overview; Acknowledgements; 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; Is Excel Really the Best Option?; Evaluating Modelling Tools; 32-Bit versus 64-Bit Microsoft Excel; What Skills do You Need to be a Good Financial Modeller?; Spreadsheet and Technical Excel Skills; Industry Knowledge; Accounting Knowledge; Business Knowledge; Aesthetic Design Skills; Communication and Language Skills; Numeracy Skills Error-Check ExerciseAllowing Tolerance for Error; Error-Check Alerts; Avoid Error Displays in Formulas; Circular References; How to Fix Circular References; Circular References in Interest Calculations; Enabling Iterative Calculations; Summary; Chapter 5 Using Excel in Financial Modelling; Formulas and Functions in Excel; Choose the Simplest Solution; Excel Versions; What is the Difference Between a Perpetual and a Subscription-Based Licence?; Excel Version Compatibility; Handy Excel Shortcuts; Windows Shortcuts; Mac Shortcuts; Cell Referencing Best Practices In-Cell Comments"Red Triangle" Comments; Footnoting; Hyperlinks; Hardcoded Text; Linked Dynamic Text Assumptions Documentation; Practical Exercise 1; Practical Exercise 2; Practical Exercise 3; What Makes a Good Model?; Standards in Financial Modelling; Summary; Chapter 4 Financial Modelling Techniques; The Problem With Excel; Error Avoidance Strategies; Avoiding Simple Formula Errors; How Long Should a Formula Be?; Linking to External Files; Why You Should Use Named Ranges in External Links; Dealing with Links and the Potential Errors They Can Cause; Building Error Checks Project Planning Your ModelHow Long Does it Take to Build a Financial Model?; Building a Model Under Pressure; Model Layout Flowcharting; Practical Exercise: Model Design Customer Support Pricing Model; Steps to Building a Model; The Streamlined Version; The Team Version; Information Requests; Version-Control Documentation; File Structure; Summary; Chapter 3 Best-Practice Principles of Modelling; Document Your Assumptions; Linking, Not Hardcoding; Enter Data Only Once; Avoid Bad Habits; Use Consistent Formulas; Format and Label Clearly; Methods and Tools of Assumptions Documentation Microsoft Excel (Computer file) Corporations Finance Corporations Finance Computer programs Microsoft Excel (Computer file) BUSINESS & ECONOMICS ; Finance Corporations ; Finance Corporations ; Finance ; Computer programs Electronic books 9781119520382 Erscheint auch als Druck-Ausgabe Fairhurst, Danielle Stein Using Excel for business and financial modelling Hoboken : Wiley, 2019 (DLC)2019000634 https://onlinelibrary.wiley.com/doi/book/10.1002/9781119520344 X:WILEY Verlag lizenzpflichtig https://doi.org/10.1002/9781119520344 X:WILEY Verlag lizenzpflichtig https://swbplus.bsz-bw.de/bsz1679259504cov.jpg V:DE-576 X:WILEY image/jpeg 20191024160409 Cover https://www.gbv.de/dms/bowker/toc/9781119520382.pdf DE-601 pdf/application 2020-01-19 Aggregator Inhaltsverzeichnis ZDB-35-UBC ZDB-35-WIC GBV_ILN_62 ISIL_DE-28 SYSFLAG_1 GBV_KXP GBV_ILN_120 ISIL_DE-715 GBV_ILN_370 ISIL_DE-1373 GBV_ILN_2001 ISIL_DE-21 GBV_ILN_2020 ISIL_DE-Ch1 GBV_ILN_2111 ISIL_DE-944 GBV_ILN_2143 ISIL_DE-Rav1 BO 045F 332.0285/554 62 01 0028 3528436042 OLR-Wiley-EBS Vervielfältigungen (z.B. Kopien, Downloads) sind nur von einzelnen Kapiteln oder Seiten und nur zum eigenen wissenschaftlichen Gebrauch erlaubt. Die Weitergabe an Dritte sowie systematisches Downloaden sind untersagt. Temporär im Bestand der UB Rostock z 25-10-19 120 01 0715 3528241578 Campusweiter Zugriff (Universität Oldenburg). - Vervielfältigungen (z.B. Kopien, Downloads) sind nur von einzelnen Kapiteln oder Seiten und nur zum eigenen wissenschaftlichen Gebrauch erlaubt. Keine Weitergabe an Dritte. Kein systematisches Downloaden durch Robots. z 25-10-19 120 02 0715 3742713337 00 --%%-- --%%-- g --%%-- alma z 26-08-20 370 01 4370 3670924132 EBS Wiley gelöscht Vervielfältigungen (z.B. Kopien, Downloads) sind nur von einzelnen Kapiteln oder Seiten und nur zum eigenen wissenschaftlichen Gebrauch erlaubt. Keine Weitergabe an Dritte. Kein systematisches Downloaden durch Robots. i z 25-05-20 2001 01 DE-21 3526649723 00 --%%-- --%%-- --%%-- n l01 24-10-19 2020 01 DE-Ch1 4046987111 00 --%%-- --%%-- --%%-- n Campuslizenz l01 28-01-22 2111 01 DE-944 3602526119 00 --%%-- eBook Wiley --%%-- n Elektronischer Volltext - Campuslizenz l01 03-03-20 2143 01 DE-Rav1 3818582947 00 --%%-- E-Book Wiley --%%-- n l01 07-12-20 62 01 0028 https://onlinelibrary.wiley.com/doi/book/10.1002/9781119520344 120 01 0715 https://onlinelibrary.wiley.com/doi/book/10.1002/9781119520344 120 02 0715 http://49gbv-uob-primo.hosted.exlibrisgroup.com/openurl/49GBV_UOB/UOB_services_page?u.ignore_date_coverage=true&rft.mms_id=991015039827303501 370 01 4370 E-Book: Zugriff im HCU-Netz. Zugriff von außerhalb nur für HCU-Angehörige möglich https://onlinelibrary.wiley.com/doi/book/10.1002/9781119520344 2001 01 DE-21 https://onlinelibrary.wiley.com/doi/book/10.1002/9781119520344 2020 01 DE-Ch1 https://onlinelibrary.wiley.com/doi/book/10.1002/9781119520344 2111 01 DE-944 https://onlinelibrary.wiley.com/doi/book/10.1002/9781119520344 2143 01 DE-Rav1 https://onlinelibrary.wiley.com/doi/book/10.1002/9781119520344 2001 01 DE-21 00 s eBook-Wiley-UBCM-eBook-Collection-2018 120 00 DE-715 99 ww 2111 01 DE-944 00 (DE-627)1353370437 e-Book 2143 01 DE-Rav1 00 (DE-627)1343240476 eBook 62 01 0028 OLR-Wiley-EBS 120 02 0715 alma 370 01 4370 EBS Wiley gelöscht 370 01 4370 olr-ebook wiley 370 01 4370 ACQ |
| allfieldsGer |
1119520347 1-119-52034-7 1119520371 1-119-52037-1 9781119520344 ePub 978-1-119-52034-4 9781119520375 ePDF 978-1-119-52037-5 111952038X 9781119520382 10.1002/9781119520344 doi (DE-627)1679259504 (DE-599)KEP045126623 (OCoLC)1148180080 (WILEY)9781119520344 (EBP)045126623 DE-627 eng DE-627 rda eng XD-US HF5548.4.M523 BUS 027000 bisacsh BUS027000 bisacsh Fairhurst, Danielle Stein verfasserin aut Using Excel for business analysis Using Excel for business and financial modelling a practical guide Danielle Stein Fairhurst Third edition Hoboken Wiley 2019 ©2019 1 Online-Ressource (1 online resource) Text txt rdacontent Computermedien c rdamedia Online-Ressource cr rdacarrier Wiley finance Includes index Machine generated contents note: 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 Product Design Design Issues The Workbook Anatomy of a Model Project Planning Your Model Model Layout Flowcharting Steps to Building a Model Information Requests Version-Control Documentation Summary Chapter 3: Best-Practice Principles of Modelling Document Your Assumptions Linking, Not Hardcoding Enter Data Only 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 Circular References Summary Chapter 5: Using Excel in Financial Modelling Formulas and Functions in Excel Excel Versions Handy Excel Shortcuts Cell Referencing Best Practices Named Ranges Basic Excel Functions Logical Functions Nesting Logical Functions Summary Chapter 6: Functions for Financial Modelling Aggregation Functions LOOKUP Functions Nesting Index and Matching OFFSET Function Regression Analysis Choose Function Working with Dates Financial Project Evaluation Functions Loan Calculations Summary Chapter 7: Tools for Model Display Basic Formatting Custom Formatting Conditional Formatting Sparklines Bulletproofing Your Model Customising the Display Settings Form Controls Summary Chapter 8: Tools for Financial Modelling Hiding Sections of a Model Array Formulas Goal Seeking Structured Reference Tables PivotTables Macros Summary Chapter 9: Common Uses of Tools in Financial Modelling Escalation Methods for Modelling Understanding Nominal and Effective (Real) Rates Calculating a Cumulative Sum (Running Totals) How to Calculate a Payback Period Weighted Average Cost of Capital (WACC) Building a Tiering Table Modelling Depreciation Methods Break-Even Analysis Summary Chapter 10: Model Review Rebuilding an Inherited Model Improving Model Performance Auditing a Financial Model Summary Appendix: QA Log Chapter 11: Stress Testing, Scenarios, and Sensitivity Analysis in Financial Modelling What are the Differences Between Scenario, Sensitivity, and What-If Analyses? Overview of Scenario Analysis Tools and Methods Advanced Conditional Formatting Comparing Scenario Methods Adding Probability to a Data Table 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 Handy Charting Hints Dynamic Named Ranges Charting with Two Different Axes and Chart Types Bubble Charts Creating a Dynamic Chart Waterfall Charts Summary Index Revised edition of the author's Using Excel for business analysis, 2012 "A hands-on guide to using Excel in the business context First published in 2012, Using Excel for Business and Financial Modelling contains step-by-step instructions of how to solve common business problems using financial models, including downloadable Excel templates, a list of shortcuts and tons of practical tips and techniques you can apply straight away. Whilst there are many hundreds of tools, features and functions in Excel, this book focuses on the topics most relevant to finance professionals. It covers these features in detail from a practical perspective, but also puts them in context by applying them to practical examples in the real world. Learn to create financial models to help make business decisions whilst applying modelling best practice methodology, tools and techniques. Provides the perfect mix of practice and theory Helps you become a DIY Excel modelling specialist Includes updates for Excel 2019/365 and Excel for Mac May be used as an accompaniment to the authors online and face-to-face training courses Many people are often overwhelmed by the hundreds of tools in Excel, and this book gives clarity to the ones you need to know in order to perform your job more efficiently. This book also demystifies the technical, design, logic and financial skills you need for business and financial modelling"-- "The book is a very hands-on guide to the use of Excel in a business context. First published in 2012, it contains step-by-step instructions of how to solve common business problems using financial models, including downloadable Excel templates as well as other supplementary content; a list of shortcuts and jam-packed with practical tips and techniques the reader can pick up and apply straight away to their work. Readers purchase the book for their own learning and it is also used as an accompaniment to the author's online and face to face training courses. Whilst there are many hundreds of tools, features and functions in Excel, this book focusses more on topics relevant to finance professionals. It covers these features in detail from a practical perspective, but also puts them in context by applying them to practical examples in the real world. Readers are often overwhelmed by the hundreds of tools in Excel and this book gives them clarity by showing them only the ones that they really need to know in order to perform their job more efficiently"-- Ability to Think LogicallyThe "Ideal" Financial Modeller; What's the Typical Background for a Financial Modeller?; Training Courses; Summary; Chapter 2 Building a Model; Model Design; Practical Example 1: Assumptions Layout; Practical Example 2: Summary Categorisation; The Golden Rules for Model Design; Separate Inputs, Calculations, and Results, where Possible; Use Each Column for the Same Purpose; Use One Formula per Row or Column; Refer to the Left and Above; Use Multiple Worksheets; Include Documentation Sheets; Design Issues; The Workbook Anatomy of a Model; Workbook Anatomy Issues Cover; Title Page; Copyright; Contents; Preface; Book Overview; Acknowledgements; 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; Is Excel Really the Best Option?; Evaluating Modelling Tools; 32-Bit versus 64-Bit Microsoft Excel; What Skills do You Need to be a Good Financial Modeller?; Spreadsheet and Technical Excel Skills; Industry Knowledge; Accounting Knowledge; Business Knowledge; Aesthetic Design Skills; Communication and Language Skills; Numeracy Skills Error-Check ExerciseAllowing Tolerance for Error; Error-Check Alerts; Avoid Error Displays in Formulas; Circular References; How to Fix Circular References; Circular References in Interest Calculations; Enabling Iterative Calculations; Summary; Chapter 5 Using Excel in Financial Modelling; Formulas and Functions in Excel; Choose the Simplest Solution; Excel Versions; What is the Difference Between a Perpetual and a Subscription-Based Licence?; Excel Version Compatibility; Handy Excel Shortcuts; Windows Shortcuts; Mac Shortcuts; Cell Referencing Best Practices In-Cell Comments"Red Triangle" Comments; Footnoting; Hyperlinks; Hardcoded Text; Linked Dynamic Text Assumptions Documentation; Practical Exercise 1; Practical Exercise 2; Practical Exercise 3; What Makes a Good Model?; Standards in Financial Modelling; Summary; Chapter 4 Financial Modelling Techniques; The Problem With Excel; Error Avoidance Strategies; Avoiding Simple Formula Errors; How Long Should a Formula Be?; Linking to External Files; Why You Should Use Named Ranges in External Links; Dealing with Links and the Potential Errors They Can Cause; Building Error Checks Project Planning Your ModelHow Long Does it Take to Build a Financial Model?; Building a Model Under Pressure; Model Layout Flowcharting; Practical Exercise: Model Design Customer Support Pricing Model; Steps to Building a Model; The Streamlined Version; The Team Version; Information Requests; Version-Control Documentation; File Structure; Summary; Chapter 3 Best-Practice Principles of Modelling; Document Your Assumptions; Linking, Not Hardcoding; Enter Data Only Once; Avoid Bad Habits; Use Consistent Formulas; Format and Label Clearly; Methods and Tools of Assumptions Documentation Microsoft Excel (Computer file) Corporations Finance Corporations Finance Computer programs Microsoft Excel (Computer file) BUSINESS & ECONOMICS ; Finance Corporations ; Finance Corporations ; Finance ; Computer programs Electronic books 9781119520382 Erscheint auch als Druck-Ausgabe Fairhurst, Danielle Stein Using Excel for business and financial modelling Hoboken : Wiley, 2019 (DLC)2019000634 https://onlinelibrary.wiley.com/doi/book/10.1002/9781119520344 X:WILEY Verlag lizenzpflichtig https://doi.org/10.1002/9781119520344 X:WILEY Verlag lizenzpflichtig https://swbplus.bsz-bw.de/bsz1679259504cov.jpg V:DE-576 X:WILEY image/jpeg 20191024160409 Cover https://www.gbv.de/dms/bowker/toc/9781119520382.pdf DE-601 pdf/application 2020-01-19 Aggregator Inhaltsverzeichnis ZDB-35-UBC ZDB-35-WIC GBV_ILN_62 ISIL_DE-28 SYSFLAG_1 GBV_KXP GBV_ILN_120 ISIL_DE-715 GBV_ILN_370 ISIL_DE-1373 GBV_ILN_2001 ISIL_DE-21 GBV_ILN_2020 ISIL_DE-Ch1 GBV_ILN_2111 ISIL_DE-944 GBV_ILN_2143 ISIL_DE-Rav1 BO 045F 332.0285/554 62 01 0028 3528436042 OLR-Wiley-EBS Vervielfältigungen (z.B. Kopien, Downloads) sind nur von einzelnen Kapiteln oder Seiten und nur zum eigenen wissenschaftlichen Gebrauch erlaubt. Die Weitergabe an Dritte sowie systematisches Downloaden sind untersagt. Temporär im Bestand der UB Rostock z 25-10-19 120 01 0715 3528241578 Campusweiter Zugriff (Universität Oldenburg). - Vervielfältigungen (z.B. Kopien, Downloads) sind nur von einzelnen Kapiteln oder Seiten und nur zum eigenen wissenschaftlichen Gebrauch erlaubt. Keine Weitergabe an Dritte. Kein systematisches Downloaden durch Robots. z 25-10-19 120 02 0715 3742713337 00 --%%-- --%%-- g --%%-- alma z 26-08-20 370 01 4370 3670924132 EBS Wiley gelöscht Vervielfältigungen (z.B. Kopien, Downloads) sind nur von einzelnen Kapiteln oder Seiten und nur zum eigenen wissenschaftlichen Gebrauch erlaubt. Keine Weitergabe an Dritte. Kein systematisches Downloaden durch Robots. i z 25-05-20 2001 01 DE-21 3526649723 00 --%%-- --%%-- --%%-- n l01 24-10-19 2020 01 DE-Ch1 4046987111 00 --%%-- --%%-- --%%-- n Campuslizenz l01 28-01-22 2111 01 DE-944 3602526119 00 --%%-- eBook Wiley --%%-- n Elektronischer Volltext - Campuslizenz l01 03-03-20 2143 01 DE-Rav1 3818582947 00 --%%-- E-Book Wiley --%%-- n l01 07-12-20 62 01 0028 https://onlinelibrary.wiley.com/doi/book/10.1002/9781119520344 120 01 0715 https://onlinelibrary.wiley.com/doi/book/10.1002/9781119520344 120 02 0715 http://49gbv-uob-primo.hosted.exlibrisgroup.com/openurl/49GBV_UOB/UOB_services_page?u.ignore_date_coverage=true&rft.mms_id=991015039827303501 370 01 4370 E-Book: Zugriff im HCU-Netz. Zugriff von außerhalb nur für HCU-Angehörige möglich https://onlinelibrary.wiley.com/doi/book/10.1002/9781119520344 2001 01 DE-21 https://onlinelibrary.wiley.com/doi/book/10.1002/9781119520344 2020 01 DE-Ch1 https://onlinelibrary.wiley.com/doi/book/10.1002/9781119520344 2111 01 DE-944 https://onlinelibrary.wiley.com/doi/book/10.1002/9781119520344 2143 01 DE-Rav1 https://onlinelibrary.wiley.com/doi/book/10.1002/9781119520344 2001 01 DE-21 00 s eBook-Wiley-UBCM-eBook-Collection-2018 120 00 DE-715 99 ww 2111 01 DE-944 00 (DE-627)1353370437 e-Book 2143 01 DE-Rav1 00 (DE-627)1343240476 eBook 62 01 0028 OLR-Wiley-EBS 120 02 0715 alma 370 01 4370 EBS Wiley gelöscht 370 01 4370 olr-ebook wiley 370 01 4370 ACQ |
| allfieldsSound |
1119520347 1-119-52034-7 1119520371 1-119-52037-1 9781119520344 ePub 978-1-119-52034-4 9781119520375 ePDF 978-1-119-52037-5 111952038X 9781119520382 10.1002/9781119520344 doi (DE-627)1679259504 (DE-599)KEP045126623 (OCoLC)1148180080 (WILEY)9781119520344 (EBP)045126623 DE-627 eng DE-627 rda eng XD-US HF5548.4.M523 BUS 027000 bisacsh BUS027000 bisacsh Fairhurst, Danielle Stein verfasserin aut Using Excel for business analysis Using Excel for business and financial modelling a practical guide Danielle Stein Fairhurst Third edition Hoboken Wiley 2019 ©2019 1 Online-Ressource (1 online resource) Text txt rdacontent Computermedien c rdamedia Online-Ressource cr rdacarrier Wiley finance Includes index Machine generated contents note: 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 Product Design Design Issues The Workbook Anatomy of a Model Project Planning Your Model Model Layout Flowcharting Steps to Building a Model Information Requests Version-Control Documentation Summary Chapter 3: Best-Practice Principles of Modelling Document Your Assumptions Linking, Not Hardcoding Enter Data Only 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 Circular References Summary Chapter 5: Using Excel in Financial Modelling Formulas and Functions in Excel Excel Versions Handy Excel Shortcuts Cell Referencing Best Practices Named Ranges Basic Excel Functions Logical Functions Nesting Logical Functions Summary Chapter 6: Functions for Financial Modelling Aggregation Functions LOOKUP Functions Nesting Index and Matching OFFSET Function Regression Analysis Choose Function Working with Dates Financial Project Evaluation Functions Loan Calculations Summary Chapter 7: Tools for Model Display Basic Formatting Custom Formatting Conditional Formatting Sparklines Bulletproofing Your Model Customising the Display Settings Form Controls Summary Chapter 8: Tools for Financial Modelling Hiding Sections of a Model Array Formulas Goal Seeking Structured Reference Tables PivotTables Macros Summary Chapter 9: Common Uses of Tools in Financial Modelling Escalation Methods for Modelling Understanding Nominal and Effective (Real) Rates Calculating a Cumulative Sum (Running Totals) How to Calculate a Payback Period Weighted Average Cost of Capital (WACC) Building a Tiering Table Modelling Depreciation Methods Break-Even Analysis Summary Chapter 10: Model Review Rebuilding an Inherited Model Improving Model Performance Auditing a Financial Model Summary Appendix: QA Log Chapter 11: Stress Testing, Scenarios, and Sensitivity Analysis in Financial Modelling What are the Differences Between Scenario, Sensitivity, and What-If Analyses? Overview of Scenario Analysis Tools and Methods Advanced Conditional Formatting Comparing Scenario Methods Adding Probability to a Data Table 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 Handy Charting Hints Dynamic Named Ranges Charting with Two Different Axes and Chart Types Bubble Charts Creating a Dynamic Chart Waterfall Charts Summary Index Revised edition of the author's Using Excel for business analysis, 2012 "A hands-on guide to using Excel in the business context First published in 2012, Using Excel for Business and Financial Modelling contains step-by-step instructions of how to solve common business problems using financial models, including downloadable Excel templates, a list of shortcuts and tons of practical tips and techniques you can apply straight away. Whilst there are many hundreds of tools, features and functions in Excel, this book focuses on the topics most relevant to finance professionals. It covers these features in detail from a practical perspective, but also puts them in context by applying them to practical examples in the real world. Learn to create financial models to help make business decisions whilst applying modelling best practice methodology, tools and techniques. Provides the perfect mix of practice and theory Helps you become a DIY Excel modelling specialist Includes updates for Excel 2019/365 and Excel for Mac May be used as an accompaniment to the authors online and face-to-face training courses Many people are often overwhelmed by the hundreds of tools in Excel, and this book gives clarity to the ones you need to know in order to perform your job more efficiently. This book also demystifies the technical, design, logic and financial skills you need for business and financial modelling"-- "The book is a very hands-on guide to the use of Excel in a business context. First published in 2012, it contains step-by-step instructions of how to solve common business problems using financial models, including downloadable Excel templates as well as other supplementary content; a list of shortcuts and jam-packed with practical tips and techniques the reader can pick up and apply straight away to their work. Readers purchase the book for their own learning and it is also used as an accompaniment to the author's online and face to face training courses. Whilst there are many hundreds of tools, features and functions in Excel, this book focusses more on topics relevant to finance professionals. It covers these features in detail from a practical perspective, but also puts them in context by applying them to practical examples in the real world. Readers are often overwhelmed by the hundreds of tools in Excel and this book gives them clarity by showing them only the ones that they really need to know in order to perform their job more efficiently"-- Ability to Think LogicallyThe "Ideal" Financial Modeller; What's the Typical Background for a Financial Modeller?; Training Courses; Summary; Chapter 2 Building a Model; Model Design; Practical Example 1: Assumptions Layout; Practical Example 2: Summary Categorisation; The Golden Rules for Model Design; Separate Inputs, Calculations, and Results, where Possible; Use Each Column for the Same Purpose; Use One Formula per Row or Column; Refer to the Left and Above; Use Multiple Worksheets; Include Documentation Sheets; Design Issues; The Workbook Anatomy of a Model; Workbook Anatomy Issues Cover; Title Page; Copyright; Contents; Preface; Book Overview; Acknowledgements; 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; Is Excel Really the Best Option?; Evaluating Modelling Tools; 32-Bit versus 64-Bit Microsoft Excel; What Skills do You Need to be a Good Financial Modeller?; Spreadsheet and Technical Excel Skills; Industry Knowledge; Accounting Knowledge; Business Knowledge; Aesthetic Design Skills; Communication and Language Skills; Numeracy Skills Error-Check ExerciseAllowing Tolerance for Error; Error-Check Alerts; Avoid Error Displays in Formulas; Circular References; How to Fix Circular References; Circular References in Interest Calculations; Enabling Iterative Calculations; Summary; Chapter 5 Using Excel in Financial Modelling; Formulas and Functions in Excel; Choose the Simplest Solution; Excel Versions; What is the Difference Between a Perpetual and a Subscription-Based Licence?; Excel Version Compatibility; Handy Excel Shortcuts; Windows Shortcuts; Mac Shortcuts; Cell Referencing Best Practices In-Cell Comments"Red Triangle" Comments; Footnoting; Hyperlinks; Hardcoded Text; Linked Dynamic Text Assumptions Documentation; Practical Exercise 1; Practical Exercise 2; Practical Exercise 3; What Makes a Good Model?; Standards in Financial Modelling; Summary; Chapter 4 Financial Modelling Techniques; The Problem With Excel; Error Avoidance Strategies; Avoiding Simple Formula Errors; How Long Should a Formula Be?; Linking to External Files; Why You Should Use Named Ranges in External Links; Dealing with Links and the Potential Errors They Can Cause; Building Error Checks Project Planning Your ModelHow Long Does it Take to Build a Financial Model?; Building a Model Under Pressure; Model Layout Flowcharting; Practical Exercise: Model Design Customer Support Pricing Model; Steps to Building a Model; The Streamlined Version; The Team Version; Information Requests; Version-Control Documentation; File Structure; Summary; Chapter 3 Best-Practice Principles of Modelling; Document Your Assumptions; Linking, Not Hardcoding; Enter Data Only Once; Avoid Bad Habits; Use Consistent Formulas; Format and Label Clearly; Methods and Tools of Assumptions Documentation Microsoft Excel (Computer file) Corporations Finance Corporations Finance Computer programs Microsoft Excel (Computer file) BUSINESS & ECONOMICS ; Finance Corporations ; Finance Corporations ; Finance ; Computer programs Electronic books 9781119520382 Erscheint auch als Druck-Ausgabe Fairhurst, Danielle Stein Using Excel for business and financial modelling Hoboken : Wiley, 2019 (DLC)2019000634 https://onlinelibrary.wiley.com/doi/book/10.1002/9781119520344 X:WILEY Verlag lizenzpflichtig https://doi.org/10.1002/9781119520344 X:WILEY Verlag lizenzpflichtig https://swbplus.bsz-bw.de/bsz1679259504cov.jpg V:DE-576 X:WILEY image/jpeg 20191024160409 Cover https://www.gbv.de/dms/bowker/toc/9781119520382.pdf DE-601 pdf/application 2020-01-19 Aggregator Inhaltsverzeichnis ZDB-35-UBC ZDB-35-WIC GBV_ILN_62 ISIL_DE-28 SYSFLAG_1 GBV_KXP GBV_ILN_120 ISIL_DE-715 GBV_ILN_370 ISIL_DE-1373 GBV_ILN_2001 ISIL_DE-21 GBV_ILN_2020 ISIL_DE-Ch1 GBV_ILN_2111 ISIL_DE-944 GBV_ILN_2143 ISIL_DE-Rav1 BO 045F 332.0285/554 62 01 0028 3528436042 OLR-Wiley-EBS Vervielfältigungen (z.B. Kopien, Downloads) sind nur von einzelnen Kapiteln oder Seiten und nur zum eigenen wissenschaftlichen Gebrauch erlaubt. Die Weitergabe an Dritte sowie systematisches Downloaden sind untersagt. Temporär im Bestand der UB Rostock z 25-10-19 120 01 0715 3528241578 Campusweiter Zugriff (Universität Oldenburg). - Vervielfältigungen (z.B. Kopien, Downloads) sind nur von einzelnen Kapiteln oder Seiten und nur zum eigenen wissenschaftlichen Gebrauch erlaubt. Keine Weitergabe an Dritte. Kein systematisches Downloaden durch Robots. z 25-10-19 120 02 0715 3742713337 00 --%%-- --%%-- g --%%-- alma z 26-08-20 370 01 4370 3670924132 EBS Wiley gelöscht Vervielfältigungen (z.B. Kopien, Downloads) sind nur von einzelnen Kapiteln oder Seiten und nur zum eigenen wissenschaftlichen Gebrauch erlaubt. Keine Weitergabe an Dritte. Kein systematisches Downloaden durch Robots. i z 25-05-20 2001 01 DE-21 3526649723 00 --%%-- --%%-- --%%-- n l01 24-10-19 2020 01 DE-Ch1 4046987111 00 --%%-- --%%-- --%%-- n Campuslizenz l01 28-01-22 2111 01 DE-944 3602526119 00 --%%-- eBook Wiley --%%-- n Elektronischer Volltext - Campuslizenz l01 03-03-20 2143 01 DE-Rav1 3818582947 00 --%%-- E-Book Wiley --%%-- n l01 07-12-20 62 01 0028 https://onlinelibrary.wiley.com/doi/book/10.1002/9781119520344 120 01 0715 https://onlinelibrary.wiley.com/doi/book/10.1002/9781119520344 120 02 0715 http://49gbv-uob-primo.hosted.exlibrisgroup.com/openurl/49GBV_UOB/UOB_services_page?u.ignore_date_coverage=true&rft.mms_id=991015039827303501 370 01 4370 E-Book: Zugriff im HCU-Netz. Zugriff von außerhalb nur für HCU-Angehörige möglich https://onlinelibrary.wiley.com/doi/book/10.1002/9781119520344 2001 01 DE-21 https://onlinelibrary.wiley.com/doi/book/10.1002/9781119520344 2020 01 DE-Ch1 https://onlinelibrary.wiley.com/doi/book/10.1002/9781119520344 2111 01 DE-944 https://onlinelibrary.wiley.com/doi/book/10.1002/9781119520344 2143 01 DE-Rav1 https://onlinelibrary.wiley.com/doi/book/10.1002/9781119520344 2001 01 DE-21 00 s eBook-Wiley-UBCM-eBook-Collection-2018 120 00 DE-715 99 ww 2111 01 DE-944 00 (DE-627)1353370437 e-Book 2143 01 DE-Rav1 00 (DE-627)1343240476 eBook 62 01 0028 OLR-Wiley-EBS 120 02 0715 alma 370 01 4370 EBS Wiley gelöscht 370 01 4370 olr-ebook wiley 370 01 4370 ACQ |
| language |
English |
| format_phy_str_mv |
Book |
| building |
62 120 370 2001:0 2020:0 2111:0 2143:0 |
| institution |
findex.gbv.de |
| selectbib_iln_str_mv |
62@ 120@ 370@ 2001@01 2020@01 2111@01 2143@01 |
| topic_facet |
Corporations Microsoft Excel (Computer file) BUSINESS & ECONOMICS ; Finance Corporations ; Finance Corporations ; Finance ; Computer programs Finance Computer programs |
| sw_local_iln_str_mv |
2001:eBook-Wiley-UBCM-eBook-Collection-2018 DE-21:eBook-Wiley-UBCM-eBook-Collection-2018 |
| isfreeaccess_bool |
false |
| authorswithroles_txt_mv |
Fairhurst, Danielle Stein @@aut@@ |
| publishDateDaySort_date |
2019-01-01T00:00:00Z |
| id |
1679259504 |
| signature_iln |
2111:eBook Wiley DE-944:eBook Wiley 2143:E-Book Wiley DE-Rav1:E-Book Wiley |
| signature_iln_str_mv |
2111:eBook Wiley DE-944:eBook Wiley 2143:E-Book Wiley DE-Rav1:E-Book Wiley |
| signature_iln_scis_mv |
2111:eBook Wiley DE-944:eBook Wiley 2143:E-Book Wiley DE-Rav1:E-Book Wiley |
| genre_facet |
Electronic books |
| language_de |
englisch |
| standort_str_mv |
--%%-- |
| callnumber-first |
H - Social Science |
| series2 |
Wiley finance |
| standort_iln_str_mv |
120:--%%-- 0715:--%%-- 2001:--%%-- DE-21:--%%-- 2020:--%%-- DE-Ch1:--%%-- 2111:--%%-- DE-944:--%%-- 2143:--%%-- DE-Rav1:--%%-- |
| author |
Fairhurst, Danielle Stein |
| spellingShingle |
Fairhurst, Danielle Stein misc HF5548.4.M523 misc Microsoft Excel (Computer file) misc Corporations misc BUSINESS & ECONOMICS ; Finance misc Corporations ; Finance misc Corporations ; Finance ; Computer programs 2001 eBook-Wiley-UBCM-eBook-Collection-2018 Using Excel for business and financial modelling a practical guide |
| authorStr |
Fairhurst, Danielle Stein |
| format |
eBook |
| delete_txt_mv |
keep |
| author_role |
aut |
| collection |
KXP GVK SWB |
| publishPlace |
Hoboken |
| remote_str |
true |
| abrufzeichen_iln_str_mv |
62@OLR-Wiley-EBS 120@alma 370@EBS Wiley gelöscht 370@olr-ebook wiley 370@ACQ |
| abrufzeichen_iln_scis_mv |
62@OLR-Wiley-EBS 120@alma 370@EBS Wiley gelöscht 370@olr-ebook wiley 370@ACQ |
| callnumber-label |
HF5548 |
| last_changed_iln_str_mv |
62@25-10-19 120@25-10-19 120@26-08-20 370@25-05-20 2001@24-10-19 2020@28-01-22 2111@03-03-20 2143@07-12-20 |
| illustrated |
Not Illustrated |
| notation_local_iln_str_mv |
120:ww DE-715:ww 2111:e-Book DE-944:e-Book 2143:eBook DE-Rav1:eBook |
| topic_title |
HF5548.4.M523 2001 01 DE-21 00 s eBook-Wiley-UBCM-eBook-Collection-2018 Using Excel for business and financial modelling a practical guide Danielle Stein Fairhurst Microsoft Excel (Computer file) Corporations Finance Corporations Finance Computer programs BUSINESS & ECONOMICS ; Finance Corporations ; Finance Corporations ; Finance ; Computer programs |
| publisher |
Wiley |
| publisherStr |
Wiley |
| topic |
misc HF5548.4.M523 misc Microsoft Excel (Computer file) misc Corporations misc BUSINESS & ECONOMICS ; Finance misc Corporations ; Finance misc Corporations ; Finance ; Computer programs 2001 eBook-Wiley-UBCM-eBook-Collection-2018 |
| topic_unstemmed |
misc HF5548.4.M523 misc Microsoft Excel (Computer file) misc Corporations misc BUSINESS & ECONOMICS ; Finance misc Corporations ; Finance misc Corporations ; Finance ; Computer programs 2001 eBook-Wiley-UBCM-eBook-Collection-2018 |
| topic_browse |
misc HF5548.4.M523 misc Microsoft Excel (Computer file) misc Corporations misc BUSINESS & ECONOMICS ; Finance misc Corporations ; Finance misc Corporations ; Finance ; Computer programs 2001 eBook-Wiley-UBCM-eBook-Collection-2018 |
| format_facet |
Elektronische Bücher Bücher Elektronische Ressource |
| standort_txtP_mv |
--%%-- |
| format_main_str_mv |
Text Buch |
| carriertype_str_mv |
cr |
| signature |
--%%-- eBook Wiley E-Book Wiley |
| signature_str_mv |
--%%-- eBook Wiley E-Book Wiley |
| isbn |
1119520347 9781119520344 1119520371 9781119520375 9781119520382 111952038X |
| edition |
Third edition |
| isfreeaccess_txt |
false |
| title |
Using Excel for business and financial modelling a practical guide |
| ctrlnum |
(DE-627)1679259504 (DE-599)KEP045126623 (OCoLC)1148180080 (WILEY)9781119520344 (EBP)045126623 |
| exemplarkommentar_str_mv |
62@Vervielfältigungen (z.B. Kopien, Downloads) sind nur von einzelnen Kapiteln oder Seiten und nur zum eigenen wissenschaftlichen Gebrauch erlaubt. Die Weitergabe an Dritte sowie systematisches Downloaden sind untersagt. 62@Temporär im Bestand der UB Rostock 120@Campusweiter Zugriff (Universität Oldenburg). - Vervielfältigungen (z.B. Kopien, Downloads) sind nur von einzelnen Kapiteln oder Seiten und nur zum eigenen wissenschaftlichen Gebrauch erlaubt. Keine Weitergabe an Dritte. Kein systematisches Downloaden durch Robots. 370@Vervielfältigungen (z.B. Kopien, Downloads) sind nur von einzelnen Kapiteln oder Seiten und nur zum eigenen wissenschaftlichen Gebrauch erlaubt. Keine Weitergabe an Dritte. Kein systematisches Downloaden durch Robots. 2020@Campuslizenz 2111@Elektronischer Volltext - Campuslizenz |
| title_full |
Using Excel for business and financial modelling a practical guide Danielle Stein Fairhurst |
| author_sort |
Fairhurst, Danielle Stein |
| callnumber-first-code |
H |
| lang_code |
eng |
| class_local |
120 00 DE-715 99 ww 2111 01 DE-944 00 (DE-627)1353370437 e-Book 2143 01 DE-Rav1 00 (DE-627)1343240476 eBook |
| isOA_bool |
false |
| recordtype |
marc |
| genre |
Electronic books |
| publishDateSort |
2019 |
| contenttype_str_mv |
txt |
| class_local_iln |
120:ww DE-715:ww 2111:e-Book DE-944:e-Book 2143:eBook DE-Rav1:eBook |
| author_browse |
Fairhurst, Danielle Stein |
| selectkey |
62:z 120:z 370:z 2001:l 2020:l 2111:l 2143:l |
| physical |
1 Online-Ressource (1 online resource) |
| class |
HF5548.4.M523 120 00 DE-715 99 ww 2111 01 DE-944 00 (DE-627)1353370437 e-Book 2143 01 DE-Rav1 00 (DE-627)1343240476 eBook |
| format_se |
Elektronische Bücher |
| countryofpublication_str_mv |
XD-US |
| author-letter |
Fairhurst, Danielle Stein |
| title_sub |
a practical guide |
| classname_local_iln_str_mv |
120: DE-715: 2111: DE-944: 2143: DE-Rav1: |
| doi_str_mv |
10.1002/9781119520344 |
| normlink |
1353370437 1343240476 |
| normlink_prefix_str_mv |
(DE-627)1353370437 (DE-627)1343240476 |
| title_sort |
using excel for business and financial modellinga practical guide |
| callnumber |
HF5548.4.M523 |
| title_auth |
Using Excel for business and financial modelling a practical guide |
| abstract |
"A hands-on guide to using Excel in the business context First published in 2012, Using Excel for Business and Financial Modelling contains step-by-step instructions of how to solve common business problems using financial models, including downloadable Excel templates, a list of shortcuts and tons of practical tips and techniques you can apply straight away. Whilst there are many hundreds of tools, features and functions in Excel, this book focuses on the topics most relevant to finance professionals. It covers these features in detail from a practical perspective, but also puts them in context by applying them to practical examples in the real world. Learn to create financial models to help make business decisions whilst applying modelling best practice methodology, tools and techniques. Provides the perfect mix of practice and theory Helps you become a DIY Excel modelling specialist Includes updates for Excel 2019/365 and Excel for Mac May be used as an accompaniment to the authors online and face-to-face training courses Many people are often overwhelmed by the hundreds of tools in Excel, and this book gives clarity to the ones you need to know in order to perform your job more efficiently. This book also demystifies the technical, design, logic and financial skills you need for business and financial modelling"-- "The book is a very hands-on guide to the use of Excel in a business context. First published in 2012, it contains step-by-step instructions of how to solve common business problems using financial models, including downloadable Excel templates as well as other supplementary content; a list of shortcuts and jam-packed with practical tips and techniques the reader can pick up and apply straight away to their work. Readers purchase the book for their own learning and it is also used as an accompaniment to the author's online and face to face training courses. Whilst there are many hundreds of tools, features and functions in Excel, this book focusses more on topics relevant to finance professionals. It covers these features in detail from a practical perspective, but also puts them in context by applying them to practical examples in the real world. Readers are often overwhelmed by the hundreds of tools in Excel and this book gives them clarity by showing them only the ones that they really need to know in order to perform their job more efficiently"-- Ability to Think LogicallyThe "Ideal" Financial Modeller; What's the Typical Background for a Financial Modeller?; Training Courses; Summary; Chapter 2 Building a Model; Model Design; Practical Example 1: Assumptions Layout; Practical Example 2: Summary Categorisation; The Golden Rules for Model Design; Separate Inputs, Calculations, and Results, where Possible; Use Each Column for the Same Purpose; Use One Formula per Row or Column; Refer to the Left and Above; Use Multiple Worksheets; Include Documentation Sheets; Design Issues; The Workbook Anatomy of a Model; Workbook Anatomy Issues Cover; Title Page; Copyright; Contents; Preface; Book Overview; Acknowledgements; 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; Is Excel Really the Best Option?; Evaluating Modelling Tools; 32-Bit versus 64-Bit Microsoft Excel; What Skills do You Need to be a Good Financial Modeller?; Spreadsheet and Technical Excel Skills; Industry Knowledge; Accounting Knowledge; Business Knowledge; Aesthetic Design Skills; Communication and Language Skills; Numeracy Skills Error-Check ExerciseAllowing Tolerance for Error; Error-Check Alerts; Avoid Error Displays in Formulas; Circular References; How to Fix Circular References; Circular References in Interest Calculations; Enabling Iterative Calculations; Summary; Chapter 5 Using Excel in Financial Modelling; Formulas and Functions in Excel; Choose the Simplest Solution; Excel Versions; What is the Difference Between a Perpetual and a Subscription-Based Licence?; Excel Version Compatibility; Handy Excel Shortcuts; Windows Shortcuts; Mac Shortcuts; Cell Referencing Best Practices In-Cell Comments"Red Triangle" Comments; Footnoting; Hyperlinks; Hardcoded Text; Linked Dynamic Text Assumptions Documentation; Practical Exercise 1; Practical Exercise 2; Practical Exercise 3; What Makes a Good Model?; Standards in Financial Modelling; Summary; Chapter 4 Financial Modelling Techniques; The Problem With Excel; Error Avoidance Strategies; Avoiding Simple Formula Errors; How Long Should a Formula Be?; Linking to External Files; Why You Should Use Named Ranges in External Links; Dealing with Links and the Potential Errors They Can Cause; Building Error Checks Project Planning Your ModelHow Long Does it Take to Build a Financial Model?; Building a Model Under Pressure; Model Layout Flowcharting; Practical Exercise: Model Design Customer Support Pricing Model; Steps to Building a Model; The Streamlined Version; The Team Version; Information Requests; Version-Control Documentation; File Structure; Summary; Chapter 3 Best-Practice Principles of Modelling; Document Your Assumptions; Linking, Not Hardcoding; Enter Data Only Once; Avoid Bad Habits; Use Consistent Formulas; Format and Label Clearly; Methods and Tools of Assumptions Documentation Includes index Machine generated contents note: 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 Product Design Design Issues The Workbook Anatomy of a Model Project Planning Your Model Model Layout Flowcharting Steps to Building a Model Information Requests Version-Control Documentation Summary Chapter 3: Best-Practice Principles of Modelling Document Your Assumptions Linking, Not Hardcoding Enter Data Only 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 Circular References Summary Chapter 5: Using Excel in Financial Modelling Formulas and Functions in Excel Excel Versions Handy Excel Shortcuts Cell Referencing Best Practices Named Ranges Basic Excel Functions Logical Functions Nesting Logical Functions Summary Chapter 6: Functions for Financial Modelling Aggregation Functions LOOKUP Functions Nesting Index and Matching OFFSET Function Regression Analysis Choose Function Working with Dates Financial Project Evaluation Functions Loan Calculations Summary Chapter 7: Tools for Model Display Basic Formatting Custom Formatting Conditional Formatting Sparklines Bulletproofing Your Model Customising the Display Settings Form Controls Summary Chapter 8: Tools for Financial Modelling Hiding Sections of a Model Array Formulas Goal Seeking Structured Reference Tables PivotTables Macros Summary Chapter 9: Common Uses of Tools in Financial Modelling Escalation Methods for Modelling Understanding Nominal and Effective (Real) Rates Calculating a Cumulative Sum (Running Totals) How to Calculate a Payback Period Weighted Average Cost of Capital (WACC) Building a Tiering Table Modelling Depreciation Methods Break-Even Analysis Summary Chapter 10: Model Review Rebuilding an Inherited Model Improving Model Performance Auditing a Financial Model Summary Appendix: QA Log Chapter 11: Stress Testing, Scenarios, and Sensitivity Analysis in Financial Modelling What are the Differences Between Scenario, Sensitivity, and What-If Analyses? Overview of Scenario Analysis Tools and Methods Advanced Conditional Formatting Comparing Scenario Methods Adding Probability to a Data Table 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 Handy Charting Hints Dynamic Named Ranges Charting with Two Different Axes and Chart Types Bubble Charts Creating a Dynamic Chart Waterfall Charts Summary Index Revised edition of the author's Using Excel for business analysis, 2012 |
| abstractGer |
"A hands-on guide to using Excel in the business context First published in 2012, Using Excel for Business and Financial Modelling contains step-by-step instructions of how to solve common business problems using financial models, including downloadable Excel templates, a list of shortcuts and tons of practical tips and techniques you can apply straight away. Whilst there are many hundreds of tools, features and functions in Excel, this book focuses on the topics most relevant to finance professionals. It covers these features in detail from a practical perspective, but also puts them in context by applying them to practical examples in the real world. Learn to create financial models to help make business decisions whilst applying modelling best practice methodology, tools and techniques. Provides the perfect mix of practice and theory Helps you become a DIY Excel modelling specialist Includes updates for Excel 2019/365 and Excel for Mac May be used as an accompaniment to the authors online and face-to-face training courses Many people are often overwhelmed by the hundreds of tools in Excel, and this book gives clarity to the ones you need to know in order to perform your job more efficiently. This book also demystifies the technical, design, logic and financial skills you need for business and financial modelling"-- "The book is a very hands-on guide to the use of Excel in a business context. First published in 2012, it contains step-by-step instructions of how to solve common business problems using financial models, including downloadable Excel templates as well as other supplementary content; a list of shortcuts and jam-packed with practical tips and techniques the reader can pick up and apply straight away to their work. Readers purchase the book for their own learning and it is also used as an accompaniment to the author's online and face to face training courses. Whilst there are many hundreds of tools, features and functions in Excel, this book focusses more on topics relevant to finance professionals. It covers these features in detail from a practical perspective, but also puts them in context by applying them to practical examples in the real world. Readers are often overwhelmed by the hundreds of tools in Excel and this book gives them clarity by showing them only the ones that they really need to know in order to perform their job more efficiently"-- Ability to Think LogicallyThe "Ideal" Financial Modeller; What's the Typical Background for a Financial Modeller?; Training Courses; Summary; Chapter 2 Building a Model; Model Design; Practical Example 1: Assumptions Layout; Practical Example 2: Summary Categorisation; The Golden Rules for Model Design; Separate Inputs, Calculations, and Results, where Possible; Use Each Column for the Same Purpose; Use One Formula per Row or Column; Refer to the Left and Above; Use Multiple Worksheets; Include Documentation Sheets; Design Issues; The Workbook Anatomy of a Model; Workbook Anatomy Issues Cover; Title Page; Copyright; Contents; Preface; Book Overview; Acknowledgements; 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; Is Excel Really the Best Option?; Evaluating Modelling Tools; 32-Bit versus 64-Bit Microsoft Excel; What Skills do You Need to be a Good Financial Modeller?; Spreadsheet and Technical Excel Skills; Industry Knowledge; Accounting Knowledge; Business Knowledge; Aesthetic Design Skills; Communication and Language Skills; Numeracy Skills Error-Check ExerciseAllowing Tolerance for Error; Error-Check Alerts; Avoid Error Displays in Formulas; Circular References; How to Fix Circular References; Circular References in Interest Calculations; Enabling Iterative Calculations; Summary; Chapter 5 Using Excel in Financial Modelling; Formulas and Functions in Excel; Choose the Simplest Solution; Excel Versions; What is the Difference Between a Perpetual and a Subscription-Based Licence?; Excel Version Compatibility; Handy Excel Shortcuts; Windows Shortcuts; Mac Shortcuts; Cell Referencing Best Practices In-Cell Comments"Red Triangle" Comments; Footnoting; Hyperlinks; Hardcoded Text; Linked Dynamic Text Assumptions Documentation; Practical Exercise 1; Practical Exercise 2; Practical Exercise 3; What Makes a Good Model?; Standards in Financial Modelling; Summary; Chapter 4 Financial Modelling Techniques; The Problem With Excel; Error Avoidance Strategies; Avoiding Simple Formula Errors; How Long Should a Formula Be?; Linking to External Files; Why You Should Use Named Ranges in External Links; Dealing with Links and the Potential Errors They Can Cause; Building Error Checks Project Planning Your ModelHow Long Does it Take to Build a Financial Model?; Building a Model Under Pressure; Model Layout Flowcharting; Practical Exercise: Model Design Customer Support Pricing Model; Steps to Building a Model; The Streamlined Version; The Team Version; Information Requests; Version-Control Documentation; File Structure; Summary; Chapter 3 Best-Practice Principles of Modelling; Document Your Assumptions; Linking, Not Hardcoding; Enter Data Only Once; Avoid Bad Habits; Use Consistent Formulas; Format and Label Clearly; Methods and Tools of Assumptions Documentation Includes index Machine generated contents note: 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 Product Design Design Issues The Workbook Anatomy of a Model Project Planning Your Model Model Layout Flowcharting Steps to Building a Model Information Requests Version-Control Documentation Summary Chapter 3: Best-Practice Principles of Modelling Document Your Assumptions Linking, Not Hardcoding Enter Data Only 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 Circular References Summary Chapter 5: Using Excel in Financial Modelling Formulas and Functions in Excel Excel Versions Handy Excel Shortcuts Cell Referencing Best Practices Named Ranges Basic Excel Functions Logical Functions Nesting Logical Functions Summary Chapter 6: Functions for Financial Modelling Aggregation Functions LOOKUP Functions Nesting Index and Matching OFFSET Function Regression Analysis Choose Function Working with Dates Financial Project Evaluation Functions Loan Calculations Summary Chapter 7: Tools for Model Display Basic Formatting Custom Formatting Conditional Formatting Sparklines Bulletproofing Your Model Customising the Display Settings Form Controls Summary Chapter 8: Tools for Financial Modelling Hiding Sections of a Model Array Formulas Goal Seeking Structured Reference Tables PivotTables Macros Summary Chapter 9: Common Uses of Tools in Financial Modelling Escalation Methods for Modelling Understanding Nominal and Effective (Real) Rates Calculating a Cumulative Sum (Running Totals) How to Calculate a Payback Period Weighted Average Cost of Capital (WACC) Building a Tiering Table Modelling Depreciation Methods Break-Even Analysis Summary Chapter 10: Model Review Rebuilding an Inherited Model Improving Model Performance Auditing a Financial Model Summary Appendix: QA Log Chapter 11: Stress Testing, Scenarios, and Sensitivity Analysis in Financial Modelling What are the Differences Between Scenario, Sensitivity, and What-If Analyses? Overview of Scenario Analysis Tools and Methods Advanced Conditional Formatting Comparing Scenario Methods Adding Probability to a Data Table 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 Handy Charting Hints Dynamic Named Ranges Charting with Two Different Axes and Chart Types Bubble Charts Creating a Dynamic Chart Waterfall Charts Summary Index Revised edition of the author's Using Excel for business analysis, 2012 |
| abstract_unstemmed |
"A hands-on guide to using Excel in the business context First published in 2012, Using Excel for Business and Financial Modelling contains step-by-step instructions of how to solve common business problems using financial models, including downloadable Excel templates, a list of shortcuts and tons of practical tips and techniques you can apply straight away. Whilst there are many hundreds of tools, features and functions in Excel, this book focuses on the topics most relevant to finance professionals. It covers these features in detail from a practical perspective, but also puts them in context by applying them to practical examples in the real world. Learn to create financial models to help make business decisions whilst applying modelling best practice methodology, tools and techniques. Provides the perfect mix of practice and theory Helps you become a DIY Excel modelling specialist Includes updates for Excel 2019/365 and Excel for Mac May be used as an accompaniment to the authors online and face-to-face training courses Many people are often overwhelmed by the hundreds of tools in Excel, and this book gives clarity to the ones you need to know in order to perform your job more efficiently. This book also demystifies the technical, design, logic and financial skills you need for business and financial modelling"-- "The book is a very hands-on guide to the use of Excel in a business context. First published in 2012, it contains step-by-step instructions of how to solve common business problems using financial models, including downloadable Excel templates as well as other supplementary content; a list of shortcuts and jam-packed with practical tips and techniques the reader can pick up and apply straight away to their work. Readers purchase the book for their own learning and it is also used as an accompaniment to the author's online and face to face training courses. Whilst there are many hundreds of tools, features and functions in Excel, this book focusses more on topics relevant to finance professionals. It covers these features in detail from a practical perspective, but also puts them in context by applying them to practical examples in the real world. Readers are often overwhelmed by the hundreds of tools in Excel and this book gives them clarity by showing them only the ones that they really need to know in order to perform their job more efficiently"-- Ability to Think LogicallyThe "Ideal" Financial Modeller; What's the Typical Background for a Financial Modeller?; Training Courses; Summary; Chapter 2 Building a Model; Model Design; Practical Example 1: Assumptions Layout; Practical Example 2: Summary Categorisation; The Golden Rules for Model Design; Separate Inputs, Calculations, and Results, where Possible; Use Each Column for the Same Purpose; Use One Formula per Row or Column; Refer to the Left and Above; Use Multiple Worksheets; Include Documentation Sheets; Design Issues; The Workbook Anatomy of a Model; Workbook Anatomy Issues Cover; Title Page; Copyright; Contents; Preface; Book Overview; Acknowledgements; 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; Is Excel Really the Best Option?; Evaluating Modelling Tools; 32-Bit versus 64-Bit Microsoft Excel; What Skills do You Need to be a Good Financial Modeller?; Spreadsheet and Technical Excel Skills; Industry Knowledge; Accounting Knowledge; Business Knowledge; Aesthetic Design Skills; Communication and Language Skills; Numeracy Skills Error-Check ExerciseAllowing Tolerance for Error; Error-Check Alerts; Avoid Error Displays in Formulas; Circular References; How to Fix Circular References; Circular References in Interest Calculations; Enabling Iterative Calculations; Summary; Chapter 5 Using Excel in Financial Modelling; Formulas and Functions in Excel; Choose the Simplest Solution; Excel Versions; What is the Difference Between a Perpetual and a Subscription-Based Licence?; Excel Version Compatibility; Handy Excel Shortcuts; Windows Shortcuts; Mac Shortcuts; Cell Referencing Best Practices In-Cell Comments"Red Triangle" Comments; Footnoting; Hyperlinks; Hardcoded Text; Linked Dynamic Text Assumptions Documentation; Practical Exercise 1; Practical Exercise 2; Practical Exercise 3; What Makes a Good Model?; Standards in Financial Modelling; Summary; Chapter 4 Financial Modelling Techniques; The Problem With Excel; Error Avoidance Strategies; Avoiding Simple Formula Errors; How Long Should a Formula Be?; Linking to External Files; Why You Should Use Named Ranges in External Links; Dealing with Links and the Potential Errors They Can Cause; Building Error Checks Project Planning Your ModelHow Long Does it Take to Build a Financial Model?; Building a Model Under Pressure; Model Layout Flowcharting; Practical Exercise: Model Design Customer Support Pricing Model; Steps to Building a Model; The Streamlined Version; The Team Version; Information Requests; Version-Control Documentation; File Structure; Summary; Chapter 3 Best-Practice Principles of Modelling; Document Your Assumptions; Linking, Not Hardcoding; Enter Data Only Once; Avoid Bad Habits; Use Consistent Formulas; Format and Label Clearly; Methods and Tools of Assumptions Documentation Includes index Machine generated contents note: 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 Product Design Design Issues The Workbook Anatomy of a Model Project Planning Your Model Model Layout Flowcharting Steps to Building a Model Information Requests Version-Control Documentation Summary Chapter 3: Best-Practice Principles of Modelling Document Your Assumptions Linking, Not Hardcoding Enter Data Only 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 Circular References Summary Chapter 5: Using Excel in Financial Modelling Formulas and Functions in Excel Excel Versions Handy Excel Shortcuts Cell Referencing Best Practices Named Ranges Basic Excel Functions Logical Functions Nesting Logical Functions Summary Chapter 6: Functions for Financial Modelling Aggregation Functions LOOKUP Functions Nesting Index and Matching OFFSET Function Regression Analysis Choose Function Working with Dates Financial Project Evaluation Functions Loan Calculations Summary Chapter 7: Tools for Model Display Basic Formatting Custom Formatting Conditional Formatting Sparklines Bulletproofing Your Model Customising the Display Settings Form Controls Summary Chapter 8: Tools for Financial Modelling Hiding Sections of a Model Array Formulas Goal Seeking Structured Reference Tables PivotTables Macros Summary Chapter 9: Common Uses of Tools in Financial Modelling Escalation Methods for Modelling Understanding Nominal and Effective (Real) Rates Calculating a Cumulative Sum (Running Totals) How to Calculate a Payback Period Weighted Average Cost of Capital (WACC) Building a Tiering Table Modelling Depreciation Methods Break-Even Analysis Summary Chapter 10: Model Review Rebuilding an Inherited Model Improving Model Performance Auditing a Financial Model Summary Appendix: QA Log Chapter 11: Stress Testing, Scenarios, and Sensitivity Analysis in Financial Modelling What are the Differences Between Scenario, Sensitivity, and What-If Analyses? Overview of Scenario Analysis Tools and Methods Advanced Conditional Formatting Comparing Scenario Methods Adding Probability to a Data Table 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 Handy Charting Hints Dynamic Named Ranges Charting with Two Different Axes and Chart Types Bubble Charts Creating a Dynamic Chart Waterfall Charts Summary Index Revised edition of the author's Using Excel for business analysis, 2012 |
| collection_details |
ZDB-35-UBC ZDB-35-WIC GBV_ILN_62 ISIL_DE-28 SYSFLAG_1 GBV_KXP GBV_ILN_120 ISIL_DE-715 GBV_ILN_370 ISIL_DE-1373 GBV_ILN_2001 ISIL_DE-21 GBV_ILN_2020 ISIL_DE-Ch1 GBV_ILN_2111 ISIL_DE-944 GBV_ILN_2143 ISIL_DE-Rav1 |
| title_short |
Using Excel for business and financial modelling |
| url |
https://onlinelibrary.wiley.com/doi/book/10.1002/9781119520344 https://doi.org/10.1002/9781119520344 https://swbplus.bsz-bw.de/bsz1679259504cov.jpg https://www.gbv.de/dms/bowker/toc/9781119520382.pdf |
| ausleihindikator_str_mv |
62 120 120:g 370 2001:- 2020:- 2111:- 2143:- |
| remote_bool |
true |
| callnumber-subject |
HF - Commerce |
| title_alt |
Using Excel for business analysis |
| mediatype_str_mv |
c |
| isOA_txt |
false |
| hochschulschrift_bool |
false |
| doi_str |
10.1002/9781119520344 |
| callnumber-a |
HF5548.4.M523 |
| up_date |
2024-08-13T04:09:50.142Z |
| fullrecord |
<?xml version="1.0" encoding="UTF-8"?><collection xmlns="http://www.loc.gov/MARC21/slim"><record><leader>01000cam a22002652 4500</leader><controlfield tag="001">1679259504</controlfield><controlfield tag="003">DE-627</controlfield><controlfield tag="005">20240812085612.0</controlfield><controlfield tag="007">cr uuu---uuuuu</controlfield><controlfield tag="008">191021s2019 xxu|||||o 00| ||eng c</controlfield><datafield tag="020" ind1=" " ind2=" "><subfield code="a">1119520347</subfield><subfield code="9">1-119-52034-7</subfield></datafield><datafield tag="020" ind1=" " ind2=" "><subfield code="a">1119520371</subfield><subfield code="9">1-119-52037-1</subfield></datafield><datafield tag="020" ind1=" " ind2=" "><subfield code="a">9781119520344</subfield><subfield code="c">ePub</subfield><subfield code="9">978-1-119-52034-4</subfield></datafield><datafield tag="020" ind1=" " ind2=" "><subfield code="a">9781119520375</subfield><subfield code="c">ePDF</subfield><subfield code="9">978-1-119-52037-5</subfield></datafield><datafield tag="020" ind1=" " ind2=" "><subfield code="z">111952038X</subfield></datafield><datafield tag="020" ind1=" " ind2=" "><subfield code="z">9781119520382</subfield></datafield><datafield tag="024" ind1="7" ind2=" "><subfield code="a">10.1002/9781119520344</subfield><subfield code="2">doi</subfield></datafield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(DE-627)1679259504</subfield></datafield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(DE-599)KEP045126623</subfield></datafield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(OCoLC)1148180080</subfield></datafield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(WILEY)9781119520344</subfield></datafield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(EBP)045126623</subfield></datafield><datafield tag="040" ind1=" " ind2=" "><subfield code="a">DE-627</subfield><subfield code="b">eng</subfield><subfield code="c">DE-627</subfield><subfield code="e">rda</subfield></datafield><datafield tag="041" ind1=" " ind2=" "><subfield code="a">eng</subfield></datafield><datafield tag="044" ind1=" " ind2=" "><subfield code="c">XD-US</subfield></datafield><datafield tag="050" ind1=" " ind2="0"><subfield code="a">HF5548.4.M523</subfield></datafield><datafield tag="072" ind1=" " ind2="7"><subfield code="a">BUS 027000</subfield><subfield code="2">bisacsh</subfield></datafield><datafield tag="072" ind1=" " ind2="7"><subfield code="a">BUS027000</subfield><subfield code="2">bisacsh</subfield></datafield><datafield tag="100" ind1="1" ind2=" "><subfield code="a">Fairhurst, Danielle Stein</subfield><subfield code="e">verfasserin</subfield><subfield code="4">aut</subfield></datafield><datafield tag="240" ind1="1" ind2="0"><subfield code="a">Using Excel for business analysis</subfield></datafield><datafield tag="245" ind1="1" ind2="0"><subfield code="a">Using Excel for business and financial modelling</subfield><subfield code="b">a practical guide</subfield><subfield code="c">Danielle Stein Fairhurst</subfield></datafield><datafield tag="250" ind1=" " ind2=" "><subfield code="a">Third edition</subfield></datafield><datafield tag="264" ind1=" " ind2="1"><subfield code="a">Hoboken</subfield><subfield code="b">Wiley</subfield><subfield code="c">2019</subfield></datafield><datafield tag="264" ind1=" " ind2="4"><subfield code="c">©2019</subfield></datafield><datafield tag="300" ind1=" " ind2=" "><subfield code="a">1 Online-Ressource (1 online resource)</subfield></datafield><datafield tag="336" ind1=" " ind2=" "><subfield code="a">Text</subfield><subfield code="b">txt</subfield><subfield code="2">rdacontent</subfield></datafield><datafield tag="337" ind1=" " ind2=" "><subfield code="a">Computermedien</subfield><subfield code="b">c</subfield><subfield code="2">rdamedia</subfield></datafield><datafield tag="338" ind1=" " ind2=" "><subfield code="a">Online-Ressource</subfield><subfield code="b">cr</subfield><subfield code="2">rdacarrier</subfield></datafield><datafield tag="490" ind1="0" ind2=" "><subfield code="a">Wiley finance</subfield></datafield><datafield tag="500" ind1=" " ind2=" "><subfield code="a">Includes index</subfield></datafield><datafield tag="500" ind1=" " ind2=" "><subfield code="a">Machine generated contents note: 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 Product Design Design Issues The Workbook Anatomy of a Model Project Planning Your Model Model Layout Flowcharting Steps to Building a Model Information Requests Version-Control Documentation Summary Chapter 3: Best-Practice Principles of Modelling Document Your Assumptions Linking, Not Hardcoding Enter Data Only 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 Circular References Summary Chapter 5: Using Excel in Financial Modelling Formulas and Functions in Excel Excel Versions Handy Excel Shortcuts Cell Referencing Best Practices Named Ranges Basic Excel Functions Logical Functions Nesting Logical Functions Summary Chapter 6: Functions for Financial Modelling Aggregation Functions LOOKUP Functions Nesting Index and Matching OFFSET Function Regression Analysis Choose Function Working with Dates Financial Project Evaluation Functions Loan Calculations Summary Chapter 7: Tools for Model Display Basic Formatting Custom Formatting Conditional Formatting Sparklines Bulletproofing Your Model Customising the Display Settings Form Controls Summary Chapter 8: Tools for Financial Modelling Hiding Sections of a Model Array Formulas Goal Seeking Structured Reference Tables PivotTables Macros Summary Chapter 9: Common Uses of Tools in Financial Modelling Escalation Methods for Modelling Understanding Nominal and Effective (Real) Rates Calculating a Cumulative Sum (Running Totals) How to Calculate a Payback Period Weighted Average Cost of Capital (WACC) Building a Tiering Table Modelling Depreciation Methods Break-Even Analysis Summary Chapter 10: Model Review Rebuilding an Inherited Model Improving Model Performance Auditing a Financial Model Summary Appendix: QA Log Chapter 11: Stress Testing, Scenarios, and Sensitivity Analysis in Financial Modelling What are the Differences Between Scenario, Sensitivity, and What-If Analyses? Overview of Scenario Analysis Tools and Methods Advanced Conditional Formatting Comparing Scenario Methods Adding Probability to a Data Table 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 Handy Charting Hints Dynamic Named Ranges Charting with Two Different Axes and Chart Types Bubble Charts Creating a Dynamic Chart Waterfall Charts Summary Index</subfield></datafield><datafield tag="500" ind1=" " ind2=" "><subfield code="a">Revised edition of the author's Using Excel for business analysis, 2012</subfield></datafield><datafield tag="520" ind1=" " ind2=" "><subfield code="a">"A hands-on guide to using Excel in the business context First published in 2012, Using Excel for Business and Financial Modelling contains step-by-step instructions of how to solve common business problems using financial models, including downloadable Excel templates, a list of shortcuts and tons of practical tips and techniques you can apply straight away. Whilst there are many hundreds of tools, features and functions in Excel, this book focuses on the topics most relevant to finance professionals. It covers these features in detail from a practical perspective, but also puts them in context by applying them to practical examples in the real world. Learn to create financial models to help make business decisions whilst applying modelling best practice methodology, tools and techniques. Provides the perfect mix of practice and theory Helps you become a DIY Excel modelling specialist Includes updates for Excel 2019/365 and Excel for Mac May be used as an accompaniment to the authors online and face-to-face training courses Many people are often overwhelmed by the hundreds of tools in Excel, and this book gives clarity to the ones you need to know in order to perform your job more efficiently. This book also demystifies the technical, design, logic and financial skills you need for business and financial modelling"--</subfield></datafield><datafield tag="520" ind1=" " ind2=" "><subfield code="a">"The book is a very hands-on guide to the use of Excel in a business context. First published in 2012, it contains step-by-step instructions of how to solve common business problems using financial models, including downloadable Excel templates as well as other supplementary content; a list of shortcuts and jam-packed with practical tips and techniques the reader can pick up and apply straight away to their work. Readers purchase the book for their own learning and it is also used as an accompaniment to the author's online and face to face training courses. Whilst there are many hundreds of tools, features and functions in Excel, this book focusses more on topics relevant to finance professionals. It covers these features in detail from a practical perspective, but also puts them in context by applying them to practical examples in the real world. Readers are often overwhelmed by the hundreds of tools in Excel and this book gives them clarity by showing them only the ones that they really need to know in order to perform their job more efficiently"--</subfield></datafield><datafield tag="520" ind1=" " ind2=" "><subfield code="a">Ability to Think LogicallyThe "Ideal" Financial Modeller; What's the Typical Background for a Financial Modeller?; Training Courses; Summary; Chapter 2 Building a Model; Model Design; Practical Example 1: Assumptions Layout; Practical Example 2: Summary Categorisation; The Golden Rules for Model Design; Separate Inputs, Calculations, and Results, where Possible; Use Each Column for the Same Purpose; Use One Formula per Row or Column; Refer to the Left and Above; Use Multiple Worksheets; Include Documentation Sheets; Design Issues; The Workbook Anatomy of a Model; Workbook Anatomy Issues</subfield></datafield><datafield tag="520" ind1=" " ind2=" "><subfield code="a">Cover; Title Page; Copyright; Contents; Preface; Book Overview; Acknowledgements; 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; Is Excel Really the Best Option?; Evaluating Modelling Tools; 32-Bit versus 64-Bit Microsoft Excel; What Skills do You Need to be a Good Financial Modeller?; Spreadsheet and Technical Excel Skills; Industry Knowledge; Accounting Knowledge; Business Knowledge; Aesthetic Design Skills; Communication and Language Skills; Numeracy Skills</subfield></datafield><datafield tag="520" ind1=" " ind2=" "><subfield code="a">Error-Check ExerciseAllowing Tolerance for Error; Error-Check Alerts; Avoid Error Displays in Formulas; Circular References; How to Fix Circular References; Circular References in Interest Calculations; Enabling Iterative Calculations; Summary; Chapter 5 Using Excel in Financial Modelling; Formulas and Functions in Excel; Choose the Simplest Solution; Excel Versions; What is the Difference Between a Perpetual and a Subscription-Based Licence?; Excel Version Compatibility; Handy Excel Shortcuts; Windows Shortcuts; Mac Shortcuts; Cell Referencing Best Practices</subfield></datafield><datafield tag="520" ind1=" " ind2=" "><subfield code="a">In-Cell Comments"Red Triangle" Comments; Footnoting; Hyperlinks; Hardcoded Text; Linked Dynamic Text Assumptions Documentation; Practical Exercise 1; Practical Exercise 2; Practical Exercise 3; What Makes a Good Model?; Standards in Financial Modelling; Summary; Chapter 4 Financial Modelling Techniques; The Problem With Excel; Error Avoidance Strategies; Avoiding Simple Formula Errors; How Long Should a Formula Be?; Linking to External Files; Why You Should Use Named Ranges in External Links; Dealing with Links and the Potential Errors They Can Cause; Building Error Checks</subfield></datafield><datafield tag="520" ind1=" " ind2=" "><subfield code="a">Project Planning Your ModelHow Long Does it Take to Build a Financial Model?; Building a Model Under Pressure; Model Layout Flowcharting; Practical Exercise: Model Design Customer Support Pricing Model; Steps to Building a Model; The Streamlined Version; The Team Version; Information Requests; Version-Control Documentation; File Structure; Summary; Chapter 3 Best-Practice Principles of Modelling; Document Your Assumptions; Linking, Not Hardcoding; Enter Data Only Once; Avoid Bad Habits; Use Consistent Formulas; Format and Label Clearly; Methods and Tools of Assumptions Documentation</subfield></datafield><datafield tag="630" ind1="2" ind2="0"><subfield code="a">Microsoft Excel (Computer file)</subfield></datafield><datafield tag="650" ind1=" " ind2="0"><subfield code="a">Corporations</subfield><subfield code="x">Finance</subfield></datafield><datafield tag="650" ind1=" " ind2="0"><subfield code="a">Corporations</subfield><subfield code="x">Finance</subfield><subfield code="x">Computer programs</subfield></datafield><datafield tag="650" ind1=" " ind2="4"><subfield code="a">Microsoft Excel (Computer file)</subfield></datafield><datafield tag="650" ind1=" " ind2="4"><subfield code="a">BUSINESS & ECONOMICS ; Finance</subfield></datafield><datafield tag="650" ind1=" " ind2="4"><subfield code="a">Corporations ; Finance</subfield></datafield><datafield tag="650" ind1=" " ind2="4"><subfield code="a">Corporations ; Finance ; Computer programs</subfield></datafield><datafield tag="655" ind1=" " ind2="0"><subfield code="a">Electronic books</subfield></datafield><datafield tag="776" ind1="1" ind2=" "><subfield code="z">9781119520382</subfield></datafield><datafield tag="776" ind1="0" ind2="8"><subfield code="i">Erscheint auch als</subfield><subfield code="n">Druck-Ausgabe</subfield><subfield code="a">Fairhurst, Danielle Stein</subfield><subfield code="t">Using Excel for business and financial modelling</subfield><subfield code="d">Hoboken : Wiley, 2019</subfield><subfield code="w">(DLC)2019000634</subfield></datafield><datafield tag="856" ind1="4" ind2="0"><subfield code="u">https://onlinelibrary.wiley.com/doi/book/10.1002/9781119520344</subfield><subfield code="m">X:WILEY</subfield><subfield code="x">Verlag</subfield><subfield code="z">lizenzpflichtig</subfield></datafield><datafield tag="856" ind1="4" ind2="0"><subfield code="u">https://doi.org/10.1002/9781119520344</subfield><subfield code="m">X:WILEY</subfield><subfield code="x">Verlag</subfield><subfield code="z">lizenzpflichtig</subfield></datafield><datafield tag="856" ind1="4" ind2="2"><subfield code="u">https://swbplus.bsz-bw.de/bsz1679259504cov.jpg</subfield><subfield code="m">V:DE-576</subfield><subfield code="m">X:WILEY</subfield><subfield code="q">image/jpeg</subfield><subfield code="v">20191024160409</subfield><subfield code="3">Cover</subfield></datafield><datafield tag="856" ind1="4" ind2="2"><subfield code="u">https://www.gbv.de/dms/bowker/toc/9781119520382.pdf</subfield><subfield code="m">DE-601</subfield><subfield code="q">pdf/application</subfield><subfield code="v">2020-01-19</subfield><subfield code="x">Aggregator</subfield><subfield code="3">Inhaltsverzeichnis</subfield></datafield><datafield tag="912" ind1=" " ind2=" "><subfield code="a">ZDB-35-UBC</subfield></datafield><datafield tag="912" ind1=" " ind2=" "><subfield code="a">ZDB-35-WIC</subfield></datafield><datafield tag="912" ind1=" " ind2=" "><subfield code="a">GBV_ILN_62</subfield></datafield><datafield tag="912" ind1=" " ind2=" "><subfield code="a">ISIL_DE-28</subfield></datafield><datafield tag="912" ind1=" " ind2=" "><subfield code="a">SYSFLAG_1</subfield></datafield><datafield tag="912" ind1=" " ind2=" "><subfield code="a">GBV_KXP</subfield></datafield><datafield tag="912" ind1=" " ind2=" "><subfield code="a">GBV_ILN_120</subfield></datafield><datafield tag="912" ind1=" " ind2=" "><subfield code="a">ISIL_DE-715</subfield></datafield><datafield tag="912" ind1=" " ind2=" "><subfield code="a">GBV_ILN_370</subfield></datafield><datafield tag="912" ind1=" " ind2=" "><subfield code="a">ISIL_DE-1373</subfield></datafield><datafield tag="912" ind1=" " ind2=" "><subfield code="a">GBV_ILN_2001</subfield></datafield><datafield tag="912" ind1=" " ind2=" "><subfield code="a">ISIL_DE-21</subfield></datafield><datafield tag="912" ind1=" " ind2=" "><subfield code="a">GBV_ILN_2020</subfield></datafield><datafield tag="912" ind1=" " ind2=" "><subfield code="a">ISIL_DE-Ch1</subfield></datafield><datafield tag="912" ind1=" " ind2=" "><subfield code="a">GBV_ILN_2111</subfield></datafield><datafield tag="912" ind1=" " ind2=" "><subfield code="a">ISIL_DE-944</subfield></datafield><datafield tag="912" ind1=" " ind2=" "><subfield code="a">GBV_ILN_2143</subfield></datafield><datafield tag="912" ind1=" " ind2=" "><subfield code="a">ISIL_DE-Rav1</subfield></datafield><datafield tag="951" ind1=" " ind2=" "><subfield code="a">BO</subfield></datafield><datafield tag="953" ind1=" " ind2=" "><subfield code="2">045F</subfield><subfield code="a">332.0285/554</subfield></datafield><datafield tag="980" ind1=" " ind2=" "><subfield code="2">62</subfield><subfield code="1">01</subfield><subfield code="x">0028</subfield><subfield code="b">3528436042</subfield><subfield code="h">OLR-Wiley-EBS</subfield><subfield code="k">Vervielfältigungen (z.B. Kopien, Downloads) sind nur von einzelnen Kapiteln oder Seiten und nur zum eigenen wissenschaftlichen Gebrauch erlaubt. Die Weitergabe an Dritte sowie systematisches Downloaden sind untersagt.</subfield><subfield code="k">Temporär im Bestand der UB Rostock</subfield><subfield code="y">z</subfield><subfield code="z">25-10-19</subfield></datafield><datafield tag="980" ind1=" " ind2=" "><subfield code="2">120</subfield><subfield code="1">01</subfield><subfield code="x">0715</subfield><subfield code="b">3528241578</subfield><subfield code="k">Campusweiter Zugriff (Universität Oldenburg). - Vervielfältigungen (z.B. Kopien, Downloads) sind nur von einzelnen Kapiteln oder Seiten und nur zum eigenen wissenschaftlichen Gebrauch erlaubt. Keine Weitergabe an Dritte. Kein systematisches Downloaden durch Robots.</subfield><subfield code="y">z</subfield><subfield code="z">25-10-19</subfield></datafield><datafield tag="980" ind1=" " ind2=" "><subfield code="2">120</subfield><subfield code="1">02</subfield><subfield code="x">0715</subfield><subfield code="b">3742713337</subfield><subfield code="c">00</subfield><subfield code="f">--%%--</subfield><subfield code="d">--%%--</subfield><subfield code="e">g</subfield><subfield code="j">--%%--</subfield><subfield code="h">alma</subfield><subfield code="y">z</subfield><subfield code="z">26-08-20</subfield></datafield><datafield tag="980" ind1=" " ind2=" "><subfield code="2">370</subfield><subfield code="1">01</subfield><subfield code="x">4370</subfield><subfield code="b">3670924132</subfield><subfield code="h">EBS Wiley gelöscht</subfield><subfield code="k">Vervielfältigungen (z.B. Kopien, Downloads) sind nur von einzelnen Kapiteln oder Seiten und nur zum eigenen wissenschaftlichen Gebrauch erlaubt. Keine Weitergabe an Dritte. Kein systematisches Downloaden durch Robots.</subfield><subfield code="u">i</subfield><subfield code="y">z</subfield><subfield code="z">25-05-20</subfield></datafield><datafield tag="980" ind1=" " ind2=" "><subfield code="2">2001</subfield><subfield code="1">01</subfield><subfield code="x">DE-21</subfield><subfield code="b">3526649723</subfield><subfield code="c">00</subfield><subfield code="f">--%%--</subfield><subfield code="d">--%%--</subfield><subfield code="e">--%%--</subfield><subfield code="j">n</subfield><subfield code="y">l01</subfield><subfield code="z">24-10-19</subfield></datafield><datafield tag="980" ind1=" " ind2=" "><subfield code="2">2020</subfield><subfield code="1">01</subfield><subfield code="x">DE-Ch1</subfield><subfield code="b">4046987111</subfield><subfield code="c">00</subfield><subfield code="f">--%%--</subfield><subfield code="d">--%%--</subfield><subfield code="e">--%%--</subfield><subfield code="j">n</subfield><subfield code="k">Campuslizenz</subfield><subfield code="y">l01</subfield><subfield code="z">28-01-22</subfield></datafield><datafield tag="980" ind1=" " ind2=" "><subfield code="2">2111</subfield><subfield code="1">01</subfield><subfield code="x">DE-944</subfield><subfield code="b">3602526119</subfield><subfield code="c">00</subfield><subfield code="f">--%%--</subfield><subfield code="d">eBook Wiley</subfield><subfield code="e">--%%--</subfield><subfield code="j">n</subfield><subfield code="k">Elektronischer Volltext - Campuslizenz</subfield><subfield code="y">l01</subfield><subfield code="z">03-03-20</subfield></datafield><datafield tag="980" ind1=" " ind2=" "><subfield code="2">2143</subfield><subfield code="1">01</subfield><subfield code="x">DE-Rav1</subfield><subfield code="b">3818582947</subfield><subfield code="c">00</subfield><subfield code="f">--%%--</subfield><subfield code="d">E-Book Wiley</subfield><subfield code="e">--%%--</subfield><subfield code="j">n</subfield><subfield code="y">l01</subfield><subfield code="z">07-12-20</subfield></datafield><datafield tag="981" ind1=" " ind2=" "><subfield code="2">62</subfield><subfield code="1">01</subfield><subfield code="x">0028</subfield><subfield code="r">https://onlinelibrary.wiley.com/doi/book/10.1002/9781119520344</subfield></datafield><datafield tag="981" ind1=" " ind2=" "><subfield code="2">120</subfield><subfield code="1">01</subfield><subfield code="x">0715</subfield><subfield code="r">https://onlinelibrary.wiley.com/doi/book/10.1002/9781119520344</subfield></datafield><datafield tag="981" ind1=" " ind2=" "><subfield code="2">120</subfield><subfield code="1">02</subfield><subfield code="x">0715</subfield><subfield code="r">http://49gbv-uob-primo.hosted.exlibrisgroup.com/openurl/49GBV_UOB/UOB_services_page?u.ignore_date_coverage=true&rft.mms_id=991015039827303501</subfield></datafield><datafield tag="981" ind1=" " ind2=" "><subfield code="2">370</subfield><subfield code="1">01</subfield><subfield code="x">4370</subfield><subfield code="y">E-Book: Zugriff im HCU-Netz. Zugriff von außerhalb nur für HCU-Angehörige möglich</subfield><subfield code="r">https://onlinelibrary.wiley.com/doi/book/10.1002/9781119520344</subfield></datafield><datafield tag="981" ind1=" " ind2=" "><subfield code="2">2001</subfield><subfield code="1">01</subfield><subfield code="x">DE-21</subfield><subfield code="r">https://onlinelibrary.wiley.com/doi/book/10.1002/9781119520344</subfield></datafield><datafield tag="981" ind1=" " ind2=" "><subfield code="2">2020</subfield><subfield code="1">01</subfield><subfield code="x">DE-Ch1</subfield><subfield code="r">https://onlinelibrary.wiley.com/doi/book/10.1002/9781119520344</subfield></datafield><datafield tag="981" ind1=" " ind2=" "><subfield code="2">2111</subfield><subfield code="1">01</subfield><subfield code="x">DE-944</subfield><subfield code="r">https://onlinelibrary.wiley.com/doi/book/10.1002/9781119520344</subfield></datafield><datafield tag="981" ind1=" " ind2=" "><subfield code="2">2143</subfield><subfield code="1">01</subfield><subfield code="x">DE-Rav1</subfield><subfield code="r">https://onlinelibrary.wiley.com/doi/book/10.1002/9781119520344</subfield></datafield><datafield tag="982" ind1=" " ind2=" "><subfield code="2">2001</subfield><subfield code="1">01</subfield><subfield code="x">DE-21</subfield><subfield code="8">00</subfield><subfield code="s">s</subfield><subfield code="a">eBook-Wiley-UBCM-eBook-Collection-2018</subfield></datafield><datafield tag="983" ind1=" " ind2=" "><subfield code="2">120</subfield><subfield code="1">00</subfield><subfield code="x">DE-715</subfield><subfield code="8">99</subfield><subfield code="a">ww</subfield></datafield><datafield tag="983" ind1=" " ind2=" "><subfield code="2">2111</subfield><subfield code="1">01</subfield><subfield code="x">DE-944</subfield><subfield code="8">00</subfield><subfield code="0">(DE-627)1353370437</subfield><subfield code="a">e-Book</subfield></datafield><datafield tag="983" ind1=" " ind2=" "><subfield code="2">2143</subfield><subfield code="1">01</subfield><subfield code="x">DE-Rav1</subfield><subfield code="8">00</subfield><subfield code="0">(DE-627)1343240476</subfield><subfield code="a">eBook</subfield></datafield><datafield tag="995" ind1=" " ind2=" "><subfield code="2">62</subfield><subfield code="1">01</subfield><subfield code="x">0028</subfield><subfield code="a">OLR-Wiley-EBS</subfield></datafield><datafield tag="995" ind1=" " ind2=" "><subfield code="2">120</subfield><subfield code="1">02</subfield><subfield code="x">0715</subfield><subfield code="a">alma</subfield></datafield><datafield tag="995" ind1=" " ind2=" "><subfield code="2">370</subfield><subfield code="1">01</subfield><subfield code="x">4370</subfield><subfield code="a">EBS Wiley gelöscht</subfield></datafield><datafield tag="995" ind1=" " ind2=" "><subfield code="2">370</subfield><subfield code="1">01</subfield><subfield code="x">4370</subfield><subfield code="a">olr-ebook wiley</subfield></datafield><datafield tag="995" ind1=" " ind2=" "><subfield code="2">370</subfield><subfield code="1">01</subfield><subfield code="x">4370</subfield><subfield code="a">ACQ</subfield></datafield></record></collection>
|
| fulltext |
Preface p. xi What is Financial Modelling? … What's the Difference Between a Spreadsheet and a Financial Model? … Types and Purposes of Financial Models … Too! Selection … What Skills Do You Need to Be a Good Financial Modeller? … The "Ideal" Financial Modeller … Summary … 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 Flowcharting … Steps to Building a Model … Information Requests … Version-Control Documentation … Summary … Best-Practice Principles of Modeling … Document Your Assumptions … Linking, Not Hardcoding … Enter Data Only 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 … Financial Modelling Techniques … The Problem with Excel … Error Avoidance Strategies … How Long Should a Formula Be? … Linking to External Files … Building Error Cheeks … Circular References … Summary … Using Excel in Financial Modelling … Formulas and Functions in Excel … Excel Versions … Handy Excel Shortcuts … Cell Referencing Best Practices … Named Ranges … Basic Excel Functions … Logical Functions … Nesting Logical Functions … Summary … Functions for Financial Modelling … Aggregation Functions … LOOKUP Functions … Nesting Index and Match … OFFSET Function … Regression Analysis … Choose Function … Working with Dates … Financial Project Evaluation Functions … Loan Calculations … Summary … Tools for Model Display … Basic Formatting … Custom Formatting … Conditional Formatting … Sparklines … Bulletproofing Your Model … Customising the Display Settings … Form Controls … Summary … Tools for Financial Modelling … Hiding Sections of a Model … Grouping … Array Formulas … Goal Seeking … Structured Reference Tables … PivotTables … Macros … Summary … Common Uses of Tools in Financial Modelling … Escalation Methods for Modelling … Understanding Nominal and Effective (Real) Rates … Calculating a Cumulative Sum (Running Totals) … How to Calculate a Payback Period … Weighted Average Cost of Capital (WACC) … Building a Tiering Table … Modelling Depreciation Methods … Break-Even Analysis … Summary … Model Review … Rebuilding an Inherited Model … Improving Model Performance … Auditing a Financial Model … Summary … Appendix: QA Log … Stress Testing, Scenarios, and Sensitivity Analysis in Financial Modelling … What are the Differences Between Scenario, Sensitivity, and What-If Analyses? … Overview of Scenario Analysis Tools and Methods … Advanced Conditional Formatting … Comparing Scenario Methods … Adding Probability to a Data Table … Summary … Present Mortal Output … Preparing an Oral Presentation for Model Results … Preparing a Graphic or Written Presentation for Model Results … Chart Types … Working with Charts … Handy Charting Hints … Dynamic Named Ranges … Charting with Two Different Axes and Chart Types … Bubble Charts … Creating a Dynamic Chart … Waterfall Charts … Summary … About the Author … About the Website … Index … |
| _version_ |
1807244004057677824 |
| fullrecord_marcxml |
<?xml version="1.0" encoding="UTF-8"?><collection xmlns="http://www.loc.gov/MARC21/slim"><record><leader>01000cam a22002652 4500</leader><controlfield tag="001">1679259504</controlfield><controlfield tag="003">DE-627</controlfield><controlfield tag="005">20240812085612.0</controlfield><controlfield tag="007">cr uuu---uuuuu</controlfield><controlfield tag="008">191021s2019 xxu|||||o 00| ||eng c</controlfield><datafield tag="020" ind1=" " ind2=" "><subfield code="a">1119520347</subfield><subfield code="9">1-119-52034-7</subfield></datafield><datafield tag="020" ind1=" " ind2=" "><subfield code="a">1119520371</subfield><subfield code="9">1-119-52037-1</subfield></datafield><datafield tag="020" ind1=" " ind2=" "><subfield code="a">9781119520344</subfield><subfield code="c">ePub</subfield><subfield code="9">978-1-119-52034-4</subfield></datafield><datafield tag="020" ind1=" " ind2=" "><subfield code="a">9781119520375</subfield><subfield code="c">ePDF</subfield><subfield code="9">978-1-119-52037-5</subfield></datafield><datafield tag="020" ind1=" " ind2=" "><subfield code="z">111952038X</subfield></datafield><datafield tag="020" ind1=" " ind2=" "><subfield code="z">9781119520382</subfield></datafield><datafield tag="024" ind1="7" ind2=" "><subfield code="a">10.1002/9781119520344</subfield><subfield code="2">doi</subfield></datafield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(DE-627)1679259504</subfield></datafield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(DE-599)KEP045126623</subfield></datafield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(OCoLC)1148180080</subfield></datafield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(WILEY)9781119520344</subfield></datafield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(EBP)045126623</subfield></datafield><datafield tag="040" ind1=" " ind2=" "><subfield code="a">DE-627</subfield><subfield code="b">eng</subfield><subfield code="c">DE-627</subfield><subfield code="e">rda</subfield></datafield><datafield tag="041" ind1=" " ind2=" "><subfield code="a">eng</subfield></datafield><datafield tag="044" ind1=" " ind2=" "><subfield code="c">XD-US</subfield></datafield><datafield tag="050" ind1=" " ind2="0"><subfield code="a">HF5548.4.M523</subfield></datafield><datafield tag="072" ind1=" " ind2="7"><subfield code="a">BUS 027000</subfield><subfield code="2">bisacsh</subfield></datafield><datafield tag="072" ind1=" " ind2="7"><subfield code="a">BUS027000</subfield><subfield code="2">bisacsh</subfield></datafield><datafield tag="100" ind1="1" ind2=" "><subfield code="a">Fairhurst, Danielle Stein</subfield><subfield code="e">verfasserin</subfield><subfield code="4">aut</subfield></datafield><datafield tag="240" ind1="1" ind2="0"><subfield code="a">Using Excel for business analysis</subfield></datafield><datafield tag="245" ind1="1" ind2="0"><subfield code="a">Using Excel for business and financial modelling</subfield><subfield code="b">a practical guide</subfield><subfield code="c">Danielle Stein Fairhurst</subfield></datafield><datafield tag="250" ind1=" " ind2=" "><subfield code="a">Third edition</subfield></datafield><datafield tag="264" ind1=" " ind2="1"><subfield code="a">Hoboken</subfield><subfield code="b">Wiley</subfield><subfield code="c">2019</subfield></datafield><datafield tag="264" ind1=" " ind2="4"><subfield code="c">©2019</subfield></datafield><datafield tag="300" ind1=" " ind2=" "><subfield code="a">1 Online-Ressource (1 online resource)</subfield></datafield><datafield tag="336" ind1=" " ind2=" "><subfield code="a">Text</subfield><subfield code="b">txt</subfield><subfield code="2">rdacontent</subfield></datafield><datafield tag="337" ind1=" " ind2=" "><subfield code="a">Computermedien</subfield><subfield code="b">c</subfield><subfield code="2">rdamedia</subfield></datafield><datafield tag="338" ind1=" " ind2=" "><subfield code="a">Online-Ressource</subfield><subfield code="b">cr</subfield><subfield code="2">rdacarrier</subfield></datafield><datafield tag="490" ind1="0" ind2=" "><subfield code="a">Wiley finance</subfield></datafield><datafield tag="500" ind1=" " ind2=" "><subfield code="a">Includes index</subfield></datafield><datafield tag="500" ind1=" " ind2=" "><subfield code="a">Machine generated contents note: 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 Product Design Design Issues The Workbook Anatomy of a Model Project Planning Your Model Model Layout Flowcharting Steps to Building a Model Information Requests Version-Control Documentation Summary Chapter 3: Best-Practice Principles of Modelling Document Your Assumptions Linking, Not Hardcoding Enter Data Only 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 Circular References Summary Chapter 5: Using Excel in Financial Modelling Formulas and Functions in Excel Excel Versions Handy Excel Shortcuts Cell Referencing Best Practices Named Ranges Basic Excel Functions Logical Functions Nesting Logical Functions Summary Chapter 6: Functions for Financial Modelling Aggregation Functions LOOKUP Functions Nesting Index and Matching OFFSET Function Regression Analysis Choose Function Working with Dates Financial Project Evaluation Functions Loan Calculations Summary Chapter 7: Tools for Model Display Basic Formatting Custom Formatting Conditional Formatting Sparklines Bulletproofing Your Model Customising the Display Settings Form Controls Summary Chapter 8: Tools for Financial Modelling Hiding Sections of a Model Array Formulas Goal Seeking Structured Reference Tables PivotTables Macros Summary Chapter 9: Common Uses of Tools in Financial Modelling Escalation Methods for Modelling Understanding Nominal and Effective (Real) Rates Calculating a Cumulative Sum (Running Totals) How to Calculate a Payback Period Weighted Average Cost of Capital (WACC) Building a Tiering Table Modelling Depreciation Methods Break-Even Analysis Summary Chapter 10: Model Review Rebuilding an Inherited Model Improving Model Performance Auditing a Financial Model Summary Appendix: QA Log Chapter 11: Stress Testing, Scenarios, and Sensitivity Analysis in Financial Modelling What are the Differences Between Scenario, Sensitivity, and What-If Analyses? Overview of Scenario Analysis Tools and Methods Advanced Conditional Formatting Comparing Scenario Methods Adding Probability to a Data Table 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 Handy Charting Hints Dynamic Named Ranges Charting with Two Different Axes and Chart Types Bubble Charts Creating a Dynamic Chart Waterfall Charts Summary Index</subfield></datafield><datafield tag="500" ind1=" " ind2=" "><subfield code="a">Revised edition of the author's Using Excel for business analysis, 2012</subfield></datafield><datafield tag="520" ind1=" " ind2=" "><subfield code="a">"A hands-on guide to using Excel in the business context First published in 2012, Using Excel for Business and Financial Modelling contains step-by-step instructions of how to solve common business problems using financial models, including downloadable Excel templates, a list of shortcuts and tons of practical tips and techniques you can apply straight away. Whilst there are many hundreds of tools, features and functions in Excel, this book focuses on the topics most relevant to finance professionals. It covers these features in detail from a practical perspective, but also puts them in context by applying them to practical examples in the real world. Learn to create financial models to help make business decisions whilst applying modelling best practice methodology, tools and techniques. Provides the perfect mix of practice and theory Helps you become a DIY Excel modelling specialist Includes updates for Excel 2019/365 and Excel for Mac May be used as an accompaniment to the authors online and face-to-face training courses Many people are often overwhelmed by the hundreds of tools in Excel, and this book gives clarity to the ones you need to know in order to perform your job more efficiently. This book also demystifies the technical, design, logic and financial skills you need for business and financial modelling"--</subfield></datafield><datafield tag="520" ind1=" " ind2=" "><subfield code="a">"The book is a very hands-on guide to the use of Excel in a business context. First published in 2012, it contains step-by-step instructions of how to solve common business problems using financial models, including downloadable Excel templates as well as other supplementary content; a list of shortcuts and jam-packed with practical tips and techniques the reader can pick up and apply straight away to their work. Readers purchase the book for their own learning and it is also used as an accompaniment to the author's online and face to face training courses. Whilst there are many hundreds of tools, features and functions in Excel, this book focusses more on topics relevant to finance professionals. It covers these features in detail from a practical perspective, but also puts them in context by applying them to practical examples in the real world. Readers are often overwhelmed by the hundreds of tools in Excel and this book gives them clarity by showing them only the ones that they really need to know in order to perform their job more efficiently"--</subfield></datafield><datafield tag="520" ind1=" " ind2=" "><subfield code="a">Ability to Think LogicallyThe "Ideal" Financial Modeller; What's the Typical Background for a Financial Modeller?; Training Courses; Summary; Chapter 2 Building a Model; Model Design; Practical Example 1: Assumptions Layout; Practical Example 2: Summary Categorisation; The Golden Rules for Model Design; Separate Inputs, Calculations, and Results, where Possible; Use Each Column for the Same Purpose; Use One Formula per Row or Column; Refer to the Left and Above; Use Multiple Worksheets; Include Documentation Sheets; Design Issues; The Workbook Anatomy of a Model; Workbook Anatomy Issues</subfield></datafield><datafield tag="520" ind1=" " ind2=" "><subfield code="a">Cover; Title Page; Copyright; Contents; Preface; Book Overview; Acknowledgements; 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; Is Excel Really the Best Option?; Evaluating Modelling Tools; 32-Bit versus 64-Bit Microsoft Excel; What Skills do You Need to be a Good Financial Modeller?; Spreadsheet and Technical Excel Skills; Industry Knowledge; Accounting Knowledge; Business Knowledge; Aesthetic Design Skills; Communication and Language Skills; Numeracy Skills</subfield></datafield><datafield tag="520" ind1=" " ind2=" "><subfield code="a">Error-Check ExerciseAllowing Tolerance for Error; Error-Check Alerts; Avoid Error Displays in Formulas; Circular References; How to Fix Circular References; Circular References in Interest Calculations; Enabling Iterative Calculations; Summary; Chapter 5 Using Excel in Financial Modelling; Formulas and Functions in Excel; Choose the Simplest Solution; Excel Versions; What is the Difference Between a Perpetual and a Subscription-Based Licence?; Excel Version Compatibility; Handy Excel Shortcuts; Windows Shortcuts; Mac Shortcuts; Cell Referencing Best Practices</subfield></datafield><datafield tag="520" ind1=" " ind2=" "><subfield code="a">In-Cell Comments"Red Triangle" Comments; Footnoting; Hyperlinks; Hardcoded Text; Linked Dynamic Text Assumptions Documentation; Practical Exercise 1; Practical Exercise 2; Practical Exercise 3; What Makes a Good Model?; Standards in Financial Modelling; Summary; Chapter 4 Financial Modelling Techniques; The Problem With Excel; Error Avoidance Strategies; Avoiding Simple Formula Errors; How Long Should a Formula Be?; Linking to External Files; Why You Should Use Named Ranges in External Links; Dealing with Links and the Potential Errors They Can Cause; Building Error Checks</subfield></datafield><datafield tag="520" ind1=" " ind2=" "><subfield code="a">Project Planning Your ModelHow Long Does it Take to Build a Financial Model?; Building a Model Under Pressure; Model Layout Flowcharting; Practical Exercise: Model Design Customer Support Pricing Model; Steps to Building a Model; The Streamlined Version; The Team Version; Information Requests; Version-Control Documentation; File Structure; Summary; Chapter 3 Best-Practice Principles of Modelling; Document Your Assumptions; Linking, Not Hardcoding; Enter Data Only Once; Avoid Bad Habits; Use Consistent Formulas; Format and Label Clearly; Methods and Tools of Assumptions Documentation</subfield></datafield><datafield tag="630" ind1="2" ind2="0"><subfield code="a">Microsoft Excel (Computer file)</subfield></datafield><datafield tag="650" ind1=" " ind2="0"><subfield code="a">Corporations</subfield><subfield code="x">Finance</subfield></datafield><datafield tag="650" ind1=" " ind2="0"><subfield code="a">Corporations</subfield><subfield code="x">Finance</subfield><subfield code="x">Computer programs</subfield></datafield><datafield tag="650" ind1=" " ind2="4"><subfield code="a">Microsoft Excel (Computer file)</subfield></datafield><datafield tag="650" ind1=" " ind2="4"><subfield code="a">BUSINESS & ECONOMICS ; Finance</subfield></datafield><datafield tag="650" ind1=" " ind2="4"><subfield code="a">Corporations ; Finance</subfield></datafield><datafield tag="650" ind1=" " ind2="4"><subfield code="a">Corporations ; Finance ; Computer programs</subfield></datafield><datafield tag="655" ind1=" " ind2="0"><subfield code="a">Electronic books</subfield></datafield><datafield tag="776" ind1="1" ind2=" "><subfield code="z">9781119520382</subfield></datafield><datafield tag="776" ind1="0" ind2="8"><subfield code="i">Erscheint auch als</subfield><subfield code="n">Druck-Ausgabe</subfield><subfield code="a">Fairhurst, Danielle Stein</subfield><subfield code="t">Using Excel for business and financial modelling</subfield><subfield code="d">Hoboken : Wiley, 2019</subfield><subfield code="w">(DLC)2019000634</subfield></datafield><datafield tag="856" ind1="4" ind2="0"><subfield code="u">https://onlinelibrary.wiley.com/doi/book/10.1002/9781119520344</subfield><subfield code="m">X:WILEY</subfield><subfield code="x">Verlag</subfield><subfield code="z">lizenzpflichtig</subfield></datafield><datafield tag="856" ind1="4" ind2="0"><subfield code="u">https://doi.org/10.1002/9781119520344</subfield><subfield code="m">X:WILEY</subfield><subfield code="x">Verlag</subfield><subfield code="z">lizenzpflichtig</subfield></datafield><datafield tag="856" ind1="4" ind2="2"><subfield code="u">https://swbplus.bsz-bw.de/bsz1679259504cov.jpg</subfield><subfield code="m">V:DE-576</subfield><subfield code="m">X:WILEY</subfield><subfield code="q">image/jpeg</subfield><subfield code="v">20191024160409</subfield><subfield code="3">Cover</subfield></datafield><datafield tag="856" ind1="4" ind2="2"><subfield code="u">https://www.gbv.de/dms/bowker/toc/9781119520382.pdf</subfield><subfield code="m">DE-601</subfield><subfield code="q">pdf/application</subfield><subfield code="v">2020-01-19</subfield><subfield code="x">Aggregator</subfield><subfield code="3">Inhaltsverzeichnis</subfield></datafield><datafield tag="912" ind1=" " ind2=" "><subfield code="a">ZDB-35-UBC</subfield></datafield><datafield tag="912" ind1=" " ind2=" "><subfield code="a">ZDB-35-WIC</subfield></datafield><datafield tag="912" ind1=" " ind2=" "><subfield code="a">GBV_ILN_62</subfield></datafield><datafield tag="912" ind1=" " ind2=" "><subfield code="a">ISIL_DE-28</subfield></datafield><datafield tag="912" ind1=" " ind2=" "><subfield code="a">SYSFLAG_1</subfield></datafield><datafield tag="912" ind1=" " ind2=" "><subfield code="a">GBV_KXP</subfield></datafield><datafield tag="912" ind1=" " ind2=" "><subfield code="a">GBV_ILN_120</subfield></datafield><datafield tag="912" ind1=" " ind2=" "><subfield code="a">ISIL_DE-715</subfield></datafield><datafield tag="912" ind1=" " ind2=" "><subfield code="a">GBV_ILN_370</subfield></datafield><datafield tag="912" ind1=" " ind2=" "><subfield code="a">ISIL_DE-1373</subfield></datafield><datafield tag="912" ind1=" " ind2=" "><subfield code="a">GBV_ILN_2001</subfield></datafield><datafield tag="912" ind1=" " ind2=" "><subfield code="a">ISIL_DE-21</subfield></datafield><datafield tag="912" ind1=" " ind2=" "><subfield code="a">GBV_ILN_2020</subfield></datafield><datafield tag="912" ind1=" " ind2=" "><subfield code="a">ISIL_DE-Ch1</subfield></datafield><datafield tag="912" ind1=" " ind2=" "><subfield code="a">GBV_ILN_2111</subfield></datafield><datafield tag="912" ind1=" " ind2=" "><subfield code="a">ISIL_DE-944</subfield></datafield><datafield tag="912" ind1=" " ind2=" "><subfield code="a">GBV_ILN_2143</subfield></datafield><datafield tag="912" ind1=" " ind2=" "><subfield code="a">ISIL_DE-Rav1</subfield></datafield><datafield tag="951" ind1=" " ind2=" "><subfield code="a">BO</subfield></datafield><datafield tag="953" ind1=" " ind2=" "><subfield code="2">045F</subfield><subfield code="a">332.0285/554</subfield></datafield><datafield tag="980" ind1=" " ind2=" "><subfield code="2">62</subfield><subfield code="1">01</subfield><subfield code="x">0028</subfield><subfield code="b">3528436042</subfield><subfield code="h">OLR-Wiley-EBS</subfield><subfield code="k">Vervielfältigungen (z.B. Kopien, Downloads) sind nur von einzelnen Kapiteln oder Seiten und nur zum eigenen wissenschaftlichen Gebrauch erlaubt. Die Weitergabe an Dritte sowie systematisches Downloaden sind untersagt.</subfield><subfield code="k">Temporär im Bestand der UB Rostock</subfield><subfield code="y">z</subfield><subfield code="z">25-10-19</subfield></datafield><datafield tag="980" ind1=" " ind2=" "><subfield code="2">120</subfield><subfield code="1">01</subfield><subfield code="x">0715</subfield><subfield code="b">3528241578</subfield><subfield code="k">Campusweiter Zugriff (Universität Oldenburg). - Vervielfältigungen (z.B. Kopien, Downloads) sind nur von einzelnen Kapiteln oder Seiten und nur zum eigenen wissenschaftlichen Gebrauch erlaubt. Keine Weitergabe an Dritte. Kein systematisches Downloaden durch Robots.</subfield><subfield code="y">z</subfield><subfield code="z">25-10-19</subfield></datafield><datafield tag="980" ind1=" " ind2=" "><subfield code="2">120</subfield><subfield code="1">02</subfield><subfield code="x">0715</subfield><subfield code="b">3742713337</subfield><subfield code="c">00</subfield><subfield code="f">--%%--</subfield><subfield code="d">--%%--</subfield><subfield code="e">g</subfield><subfield code="j">--%%--</subfield><subfield code="h">alma</subfield><subfield code="y">z</subfield><subfield code="z">26-08-20</subfield></datafield><datafield tag="980" ind1=" " ind2=" "><subfield code="2">370</subfield><subfield code="1">01</subfield><subfield code="x">4370</subfield><subfield code="b">3670924132</subfield><subfield code="h">EBS Wiley gelöscht</subfield><subfield code="k">Vervielfältigungen (z.B. Kopien, Downloads) sind nur von einzelnen Kapiteln oder Seiten und nur zum eigenen wissenschaftlichen Gebrauch erlaubt. Keine Weitergabe an Dritte. Kein systematisches Downloaden durch Robots.</subfield><subfield code="u">i</subfield><subfield code="y">z</subfield><subfield code="z">25-05-20</subfield></datafield><datafield tag="980" ind1=" " ind2=" "><subfield code="2">2001</subfield><subfield code="1">01</subfield><subfield code="x">DE-21</subfield><subfield code="b">3526649723</subfield><subfield code="c">00</subfield><subfield code="f">--%%--</subfield><subfield code="d">--%%--</subfield><subfield code="e">--%%--</subfield><subfield code="j">n</subfield><subfield code="y">l01</subfield><subfield code="z">24-10-19</subfield></datafield><datafield tag="980" ind1=" " ind2=" "><subfield code="2">2020</subfield><subfield code="1">01</subfield><subfield code="x">DE-Ch1</subfield><subfield code="b">4046987111</subfield><subfield code="c">00</subfield><subfield code="f">--%%--</subfield><subfield code="d">--%%--</subfield><subfield code="e">--%%--</subfield><subfield code="j">n</subfield><subfield code="k">Campuslizenz</subfield><subfield code="y">l01</subfield><subfield code="z">28-01-22</subfield></datafield><datafield tag="980" ind1=" " ind2=" "><subfield code="2">2111</subfield><subfield code="1">01</subfield><subfield code="x">DE-944</subfield><subfield code="b">3602526119</subfield><subfield code="c">00</subfield><subfield code="f">--%%--</subfield><subfield code="d">eBook Wiley</subfield><subfield code="e">--%%--</subfield><subfield code="j">n</subfield><subfield code="k">Elektronischer Volltext - Campuslizenz</subfield><subfield code="y">l01</subfield><subfield code="z">03-03-20</subfield></datafield><datafield tag="980" ind1=" " ind2=" "><subfield code="2">2143</subfield><subfield code="1">01</subfield><subfield code="x">DE-Rav1</subfield><subfield code="b">3818582947</subfield><subfield code="c">00</subfield><subfield code="f">--%%--</subfield><subfield code="d">E-Book Wiley</subfield><subfield code="e">--%%--</subfield><subfield code="j">n</subfield><subfield code="y">l01</subfield><subfield code="z">07-12-20</subfield></datafield><datafield tag="981" ind1=" " ind2=" "><subfield code="2">62</subfield><subfield code="1">01</subfield><subfield code="x">0028</subfield><subfield code="r">https://onlinelibrary.wiley.com/doi/book/10.1002/9781119520344</subfield></datafield><datafield tag="981" ind1=" " ind2=" "><subfield code="2">120</subfield><subfield code="1">01</subfield><subfield code="x">0715</subfield><subfield code="r">https://onlinelibrary.wiley.com/doi/book/10.1002/9781119520344</subfield></datafield><datafield tag="981" ind1=" " ind2=" "><subfield code="2">120</subfield><subfield code="1">02</subfield><subfield code="x">0715</subfield><subfield code="r">http://49gbv-uob-primo.hosted.exlibrisgroup.com/openurl/49GBV_UOB/UOB_services_page?u.ignore_date_coverage=true&rft.mms_id=991015039827303501</subfield></datafield><datafield tag="981" ind1=" " ind2=" "><subfield code="2">370</subfield><subfield code="1">01</subfield><subfield code="x">4370</subfield><subfield code="y">E-Book: Zugriff im HCU-Netz. Zugriff von außerhalb nur für HCU-Angehörige möglich</subfield><subfield code="r">https://onlinelibrary.wiley.com/doi/book/10.1002/9781119520344</subfield></datafield><datafield tag="981" ind1=" " ind2=" "><subfield code="2">2001</subfield><subfield code="1">01</subfield><subfield code="x">DE-21</subfield><subfield code="r">https://onlinelibrary.wiley.com/doi/book/10.1002/9781119520344</subfield></datafield><datafield tag="981" ind1=" " ind2=" "><subfield code="2">2020</subfield><subfield code="1">01</subfield><subfield code="x">DE-Ch1</subfield><subfield code="r">https://onlinelibrary.wiley.com/doi/book/10.1002/9781119520344</subfield></datafield><datafield tag="981" ind1=" " ind2=" "><subfield code="2">2111</subfield><subfield code="1">01</subfield><subfield code="x">DE-944</subfield><subfield code="r">https://onlinelibrary.wiley.com/doi/book/10.1002/9781119520344</subfield></datafield><datafield tag="981" ind1=" " ind2=" "><subfield code="2">2143</subfield><subfield code="1">01</subfield><subfield code="x">DE-Rav1</subfield><subfield code="r">https://onlinelibrary.wiley.com/doi/book/10.1002/9781119520344</subfield></datafield><datafield tag="982" ind1=" " ind2=" "><subfield code="2">2001</subfield><subfield code="1">01</subfield><subfield code="x">DE-21</subfield><subfield code="8">00</subfield><subfield code="s">s</subfield><subfield code="a">eBook-Wiley-UBCM-eBook-Collection-2018</subfield></datafield><datafield tag="983" ind1=" " ind2=" "><subfield code="2">120</subfield><subfield code="1">00</subfield><subfield code="x">DE-715</subfield><subfield code="8">99</subfield><subfield code="a">ww</subfield></datafield><datafield tag="983" ind1=" " ind2=" "><subfield code="2">2111</subfield><subfield code="1">01</subfield><subfield code="x">DE-944</subfield><subfield code="8">00</subfield><subfield code="0">(DE-627)1353370437</subfield><subfield code="a">e-Book</subfield></datafield><datafield tag="983" ind1=" " ind2=" "><subfield code="2">2143</subfield><subfield code="1">01</subfield><subfield code="x">DE-Rav1</subfield><subfield code="8">00</subfield><subfield code="0">(DE-627)1343240476</subfield><subfield code="a">eBook</subfield></datafield><datafield tag="995" ind1=" " ind2=" "><subfield code="2">62</subfield><subfield code="1">01</subfield><subfield code="x">0028</subfield><subfield code="a">OLR-Wiley-EBS</subfield></datafield><datafield tag="995" ind1=" " ind2=" "><subfield code="2">120</subfield><subfield code="1">02</subfield><subfield code="x">0715</subfield><subfield code="a">alma</subfield></datafield><datafield tag="995" ind1=" " ind2=" "><subfield code="2">370</subfield><subfield code="1">01</subfield><subfield code="x">4370</subfield><subfield code="a">EBS Wiley gelöscht</subfield></datafield><datafield tag="995" ind1=" " ind2=" "><subfield code="2">370</subfield><subfield code="1">01</subfield><subfield code="x">4370</subfield><subfield code="a">olr-ebook wiley</subfield></datafield><datafield tag="995" ind1=" " ind2=" "><subfield code="2">370</subfield><subfield code="1">01</subfield><subfield code="x">4370</subfield><subfield code="a">ACQ</subfield></datafield></record></collection>
|
| score |
7.012149 |