Using Excel for business and financial modelling : : a practical guide / / Danielle Stein Fairhurst.
Saved in:
Superior document: | Wiley finance |
---|---|
VerfasserIn: | |
Place / Publishing House: | Chichester, West Sussex : : Wiley,, 2019. |
Year of Publication: | 2019 |
Edition: | Third edition. |
Language: | English |
Series: | Wiley finance series.
|
Online Access: | |
Physical Description: | 1 online resource (426 pages). |
Notes: |
|
Tags: |
Add Tag
No Tags, Be the first to tag this record!
|
id |
5005741757 |
---|---|
ctrlnum |
(MiAaPQ)5005741757 (Au-PeEL)EBL5741757 (OCoLC)1089839286 |
collection |
bib_alma |
record_format |
marc |
spelling |
Fairhurst, Danielle Stein, author. Using Excel for business and financial modelling : a practical guide / Danielle Stein Fairhurst. Third edition. Chichester, West Sussex : Wiley, 2019. 1 online resource (426 pages). text txt rdacontent computer c rdamedia online resource cr rdacarrier Wiley finance Includes index. Revised edition of the author's Using Excel for business analysis, 2012. 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. Description based on print version record. Electronic reproduction. Ann Arbor, MI : ProQuest, 2018. Available via World Wide Web. Access may be limited to ProQuest affiliated libraries. Microsoft Excel (Computer file) Corporations Finance. Corporations Finance Computer programs. BUSINESS & ECONOMICS / Finance. bisacsh Electronic books. Print version: Fairhurst, Danielle Stein. Using Excel for business and financial modelling : a practical guide. Third edition. Chichester, West Sussex : Wiley, 2019 426 pages Wiley finance series. 9781119520382 (DLC) 2019010808 ProQuest (Firm) Wiley finance series. https://ebookcentral.proquest.com/lib/oeawat/detail.action?docID=5741757 Click to View |
language |
English |
format |
eBook |
author |
Fairhurst, Danielle Stein, |
spellingShingle |
Fairhurst, Danielle Stein, Using Excel for business and financial modelling : a practical guide / Wiley finance 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. |
author_facet |
Fairhurst, Danielle Stein, |
author_variant |
d s f ds dsf |
author_role |
VerfasserIn |
author_sort |
Fairhurst, Danielle Stein, |
title |
Using Excel for business and financial modelling : a practical guide / |
title_sub |
a practical guide / |
title_full |
Using Excel for business and financial modelling : a practical guide / Danielle Stein Fairhurst. |
title_fullStr |
Using Excel for business and financial modelling : a practical guide / Danielle Stein Fairhurst. |
title_full_unstemmed |
Using Excel for business and financial modelling : a practical guide / Danielle Stein Fairhurst. |
title_auth |
Using Excel for business and financial modelling : a practical guide / |
title_new |
Using Excel for business and financial modelling : |
title_sort |
using excel for business and financial modelling : a practical guide / |
series |
Wiley finance |
series2 |
Wiley finance |
publisher |
Wiley, |
publishDate |
2019 |
physical |
1 online resource (426 pages). |
edition |
Third edition. |
contents |
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. |
isbn |
9781119520375 9781119520344 9781119520382 |
callnumber-first |
H - Social Science |
callnumber-subject |
HF - Commerce |
callnumber-label |
HF5548 |
callnumber-sort |
HF 45548.4 M523 F357 42019 |
genre |
Electronic books. |
genre_facet |
Electronic books. |
url |
https://ebookcentral.proquest.com/lib/oeawat/detail.action?docID=5741757 |
illustrated |
Not Illustrated |
dewey-hundreds |
300 - Social sciences |
dewey-tens |
330 - Economics |
dewey-ones |
332 - Financial economics |
dewey-full |
332.0285/554 |
dewey-sort |
3332.0285 3554 |
dewey-raw |
332.0285/554 |
dewey-search |
332.0285/554 |
oclc_num |
1089839286 |
work_keys_str_mv |
AT fairhurstdaniellestein usingexcelforbusinessandfinancialmodellingapracticalguide |
status_str |
n |
ids_txt_mv |
(MiAaPQ)5005741757 (Au-PeEL)EBL5741757 (OCoLC)1089839286 |
carrierType_str_mv |
cr |
hierarchy_parent_title |
Wiley finance |
is_hierarchy_title |
Using Excel for business and financial modelling : a practical guide / |
container_title |
Wiley finance |
_version_ |
1792331001336168448 |
fullrecord |
<?xml version="1.0" encoding="UTF-8"?><collection xmlns="http://www.loc.gov/MARC21/slim"><record><leader>05055nam a2200481 i 4500</leader><controlfield tag="001">5005741757</controlfield><controlfield tag="003">MiAaPQ</controlfield><controlfield tag="005">20200520144314.0</controlfield><controlfield tag="006">m o d | </controlfield><controlfield tag="007">cr cnu||||||||</controlfield><controlfield tag="008">190411s2019 enk o 001 0 eng d</controlfield><datafield tag="020" ind1=" " ind2=" "><subfield code="z">9781119520382</subfield></datafield><datafield tag="020" ind1=" " ind2=" "><subfield code="a">9781119520375</subfield><subfield code="q">(electronic bk.)</subfield></datafield><datafield tag="020" ind1=" " ind2=" "><subfield code="a">9781119520344</subfield><subfield code="q">(electronic bk.)</subfield></datafield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(MiAaPQ)5005741757</subfield></datafield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(Au-PeEL)EBL5741757</subfield></datafield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(OCoLC)1089839286</subfield></datafield><datafield tag="040" ind1=" " ind2=" "><subfield code="a">MiAaPQ</subfield><subfield code="b">eng</subfield><subfield code="e">rda</subfield><subfield code="e">pn</subfield><subfield code="c">MiAaPQ</subfield><subfield code="d">MiAaPQ</subfield></datafield><datafield tag="050" ind1=" " ind2="4"><subfield code="a">HF5548.4.M523</subfield><subfield code="b">.F357 2019</subfield></datafield><datafield tag="082" ind1="0" ind2=" "><subfield code="a">332.0285/554</subfield><subfield code="2">23</subfield></datafield><datafield tag="100" ind1="1" ind2=" "><subfield code="a">Fairhurst, Danielle Stein,</subfield><subfield code="e">author.</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">Chichester, West Sussex :</subfield><subfield code="b">Wiley,</subfield><subfield code="c">2019.</subfield></datafield><datafield tag="300" ind1=" " ind2=" "><subfield code="a">1 online resource (426 pages).</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">computer</subfield><subfield code="b">c</subfield><subfield code="2">rdamedia</subfield></datafield><datafield tag="338" ind1=" " ind2=" "><subfield code="a">online resource</subfield><subfield code="b">cr</subfield><subfield code="2">rdacarrier</subfield></datafield><datafield tag="490" ind1="1" 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">Revised edition of the author's Using Excel for business analysis, 2012.</subfield></datafield><datafield tag="505" ind1="8" 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="588" ind1=" " ind2=" "><subfield code="a">Description based on print version record.</subfield></datafield><datafield tag="590" ind1=" " ind2=" "><subfield code="a">Electronic reproduction. Ann Arbor, MI : ProQuest, 2018. Available via World Wide Web. Access may be limited to ProQuest affiliated libraries.</subfield></datafield><datafield tag="630" ind1="0" 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="7"><subfield code="a">BUSINESS & ECONOMICS / Finance.</subfield><subfield code="2">bisacsh</subfield></datafield><datafield tag="655" ind1=" " ind2="4"><subfield code="a">Electronic books.</subfield></datafield><datafield tag="776" ind1="0" ind2="8"><subfield code="i">Print version:</subfield><subfield code="a">Fairhurst, Danielle Stein.</subfield><subfield code="t">Using Excel for business and financial modelling : a practical guide.</subfield><subfield code="b">Third edition.</subfield><subfield code="d">Chichester, West Sussex : Wiley, 2019 </subfield><subfield code="h">426 pages </subfield><subfield code="k">Wiley finance series.</subfield><subfield code="z">9781119520382 </subfield><subfield code="w">(DLC) 2019010808</subfield></datafield><datafield tag="797" ind1="2" ind2=" "><subfield code="a">ProQuest (Firm)</subfield></datafield><datafield tag="830" ind1=" " ind2="0"><subfield code="a">Wiley finance series.</subfield></datafield><datafield tag="856" ind1="4" ind2="0"><subfield code="u">https://ebookcentral.proquest.com/lib/oeawat/detail.action?docID=5741757</subfield><subfield code="z">Click to View</subfield></datafield></record></collection> |