skip to content
Using Excel for business and financial modelling : a practical guide Preview this item
ClosePreview this item
Checking...

Using Excel for business and financial modelling : a practical guide

Author: Danielle Stein Fairhurst
Publisher: Hoboken : Wiley, 2019.
Series: Wiley finance series.
Edition/Format:   eBook : Document : English : Third editionView all editions and formats
Summary:
"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
Rating:

(not yet rated) 0 with reviews - Be the first.

Subjects
More like this

Find a copy online

Links to this item

Find a copy in the library

&AllPage.SpinnerRetrieving; Finding libraries that hold this item...

Details

Genre/Form: Electronic books
Additional Physical Format: Print version:
Fairhurst, Danielle Stein, author.
Using Excel for business and financial modelling
Hoboken : Wiley, 2019
(DLC) 2019000634
Material Type: Document, Internet resource
Document Type: Internet Resource, Computer File
All Authors / Contributors: Danielle Stein Fairhurst
ISBN: 9781119520344 1119520347 9781119520375 1119520371
OCLC Number: 1089839286
Notes: Revised edition of the author's Using Excel for business analysis, 2012.
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.
Description: 1 online resource.
Contents: 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 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 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 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 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
Series Title: Wiley finance series.
Other Titles: Using Excel for business analysis.
Responsibility: Danielle Stein Fairhurst.

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"--

Reviews

User-contributed reviews
Retrieving GoodReads reviews...
Retrieving DOGObooks reviews...

Tags

Be the first.
Confirm this request

You may have already requested this item. Please select Ok if you would like to proceed with this request anyway.

Linked Data


Primary Entity

<http://www.worldcat.org/oclc/1089839286> # Using Excel for business and financial modelling : a practical guide
    a schema:MediaObject, schema:Book, schema:CreativeWork ;
    library:oclcnum "1089839286" ;
    library:placeOfPublication <http://id.loc.gov/vocabulary/countries/nju> ;
    schema:about <http://experiment.worldcat.org/entity/work/data/8974952244#Topic/corporations_finance_computer_programs> ; # Corporations--Finance--Computer programs
    schema:about <http://experiment.worldcat.org/entity/work/data/8974952244#CreativeWork/microsoft_excel_computer_file> ; # Microsoft Excel (Computer file)
    schema:about <http://experiment.worldcat.org/entity/work/data/8974952244#Topic/corporations_finance> ; # Corporations--Finance
    schema:about <http://experiment.worldcat.org/entity/work/data/8974952244#Topic/business_&_economics_finance> ; # BUSINESS & ECONOMICS / Finance
    schema:about <http://dewey.info/class/332.0285554/e23/> ;
    schema:author <http://experiment.worldcat.org/entity/work/data/8974952244#Person/fairhurst_danielle_stein> ; # Danielle Stein Fairhurst
    schema:bookEdition "Third edition." ;
    schema:bookFormat schema:EBook ;
    schema:datePublished "2019" ;
    schema:description ""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"--"@en ;
    schema:description ""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"--"@en ;
    schema:description "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"@en ;
    schema:exampleOfWork <http://worldcat.org/entity/work/id/8974952244> ; # Using Excel for business analysis.
    schema:genre "Electronic books"@en ;
    schema:inLanguage "en" ;
    schema:isPartOf <http://experiment.worldcat.org/entity/work/data/8974952244#Series/wiley_finance> ; # Wiley finance
    schema:isPartOf <http://experiment.worldcat.org/entity/work/data/8974952244#Series/wiley_finance_series> ; # Wiley finance series.
    schema:isSimilarTo <http://worldcat.org/entity/work/data/8974952244#CreativeWork/using_excel_for_business_and_financial_modelling> ;
    schema:name "Using Excel for business and financial modelling : a practical guide"@en ;
    schema:productID "1089839286" ;
    schema:url <http://public.eblib.com/choice/PublicFullRecord.aspx?p=5741757> ;
    schema:url <http://dx.doi.org/10.1002/9781119520344> ;
    schema:url <http://search.ebscohost.com/login.aspx?direct=true&scope=site&db=nlebk&db=nlabk&AN=2091776> ;
    schema:workExample <http://worldcat.org/isbn/9781119520375> ;
    schema:workExample <http://worldcat.org/isbn/9781119520344> ;
    wdrs:describedby <http://www.worldcat.org/title/-/oclc/1089839286> ;
    .


Related Entities

<http://experiment.worldcat.org/entity/work/data/8974952244#CreativeWork/microsoft_excel_computer_file> # Microsoft Excel (Computer file)
    a schema:CreativeWork ;
    schema:name "Microsoft Excel (Computer file)" ;
    .

<http://experiment.worldcat.org/entity/work/data/8974952244#Person/fairhurst_danielle_stein> # Danielle Stein Fairhurst
    a schema:Person ;
    schema:familyName "Fairhurst" ;
    schema:givenName "Danielle Stein" ;
    schema:name "Danielle Stein Fairhurst" ;
    .

<http://experiment.worldcat.org/entity/work/data/8974952244#Series/wiley_finance> # Wiley finance
    a bgn:PublicationSeries ;
    schema:hasPart <http://www.worldcat.org/oclc/1089839286> ; # Using Excel for business and financial modelling : a practical guide
    schema:name "Wiley finance" ;
    .

<http://experiment.worldcat.org/entity/work/data/8974952244#Series/wiley_finance_series> # Wiley finance series.
    a bgn:PublicationSeries ;
    schema:hasPart <http://www.worldcat.org/oclc/1089839286> ; # Using Excel for business and financial modelling : a practical guide
    schema:name "Wiley finance series." ;
    .

<http://experiment.worldcat.org/entity/work/data/8974952244#Topic/business_&_economics_finance> # BUSINESS & ECONOMICS / Finance
    a schema:Intangible ;
    schema:name "BUSINESS & ECONOMICS / Finance"@en ;
    .

<http://experiment.worldcat.org/entity/work/data/8974952244#Topic/corporations_finance> # Corporations--Finance
    a schema:Intangible ;
    schema:name "Corporations--Finance"@en ;
    .

<http://experiment.worldcat.org/entity/work/data/8974952244#Topic/corporations_finance_computer_programs> # Corporations--Finance--Computer programs
    a schema:Intangible ;
    schema:name "Corporations--Finance--Computer programs"@en ;
    .

<http://worldcat.org/entity/work/data/8974952244#CreativeWork/using_excel_for_business_and_financial_modelling>
    a schema:CreativeWork ;
    rdfs:label "Using Excel for business and financial modelling" ;
    schema:description "Print version:" ;
    schema:isSimilarTo <http://www.worldcat.org/oclc/1089839286> ; # Using Excel for business and financial modelling : a practical guide
    .

<http://worldcat.org/entity/work/id/8974952244> # Using Excel for business analysis.
    schema:name "Using Excel for business analysis." ;
    .

<http://worldcat.org/isbn/9781119520344>
    a schema:ProductModel ;
    schema:isbn "1119520347" ;
    schema:isbn "9781119520344" ;
    .

<http://worldcat.org/isbn/9781119520375>
    a schema:ProductModel ;
    schema:isbn "1119520371" ;
    schema:isbn "9781119520375" ;
    .


Content-negotiable representations

Close Window

Please sign in to WorldCat 

Don't have an account? You can easily create a free account.