Cargando…

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

Descripción completa

Detalles Bibliográficos
Clasificación:Libro Electrónico
Autor principal: Fairhurst, Danielle Stein (Autor)
Formato: Electrónico eBook
Idioma:Inglés
Publicado: West Sussex, United Kingdom : John Wiley & Sons Ltd, 2019.
Edición:Third edition.
Colección:Wiley finance
Temas:
Acceso en línea:Texto completo

MARC

LEADER 00000cam a2200000 i 4500
001 EBOOKCENTRAL_on1089839286
003 OCoLC
005 20240329122006.0
006 m o d
007 cr |||||||||||
008 190305t20192019enka o 001 0 eng
010 |a  2019010808 
040 |a DLC  |b eng  |e rda  |e pn  |c DLC  |d DG1  |d N$T  |d EBLCP  |d MERER  |d YDX  |d OCLCF  |d BRX  |d UKAHL  |d SFB  |d DLC  |d OCLCO  |d OCLCQ  |d YDX  |d TEFOD  |d K6U  |d OCLCO  |d OCLCQ  |d OCLCO  |d VLB  |d OCLCL 
019 |a 1090728194  |a 1090879444 
020 |a 9781119520344  |q electronic book 
020 |a 1119520347  |q electronic book 
020 |a 9781119520375  |q electronic book 
020 |a 1119520371  |q electronic book 
020 |a 9781119520351  |q (electronic bk.) 
020 |a 1119520355  |q (electronic bk.) 
020 |z 9781119520382  |q paperback 
020 |z 111952038X  |q paperback 
029 1 |a AU@  |b 000065306711 
029 1 |a CHNEW  |b 001077414 
029 1 |a CHVBK  |b 582679648 
035 |a (OCoLC)1089839286  |z (OCoLC)1090728194  |z (OCoLC)1090879444 
037 |a AB67D352-97E5-40AC-8A08-1A5BDF22F9A0  |b OverDrive, Inc.  |n http://www.overdrive.com 
042 |a pcc 
050 1 4 |a HF5548.4.M523  |b F35 2019 
072 7 |a BUS  |x 027000  |2 bisacsh 
082 0 0 |a 332.0285/554  |2 23 
084 |a BUS027000  |2 bisacsh 
049 |a UAMI 
100 1 |a Fairhurst, Danielle Stein,  |e author. 
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 West Sussex, United Kingdom :  |b John Wiley & Sons Ltd,  |c 2019. 
264 4 |c Ã2019 
300 |a 1 online resource (xiii, 407 pages) :  |b illustrations (chiefly color) 
336 |a text  |b txt  |2 rdacontent 
337 |a computer  |b c  |2 rdamedia 
338 |a online resource  |b cr  |2 rdacarrier 
490 0 |a Wiley finance 
500 |a Revised edition of the author's Using Excel for business analysis, 2012. 
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. 
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"--  |c Provided by publisher. 
588 |a Description based on online resource; title from digital title page (viewed on May 14, 2020). 
505 0 |a What is financial modelling -- Building a model -- Best-practice principles of modelling -- Financial modelling techniques -- Using Excel in financial modelling -- Functions for financial modelling -- Tools for model displays -- Tools for financial modelling -- Common uses of tools in financial modelling -- Model review -- Stress testing, scenarios and sensitivity analysis in financial modelling -- Presenting model output. 
590 |a ProQuest Ebook Central  |b Ebook Central Academic Complete 
630 0 0 |a Microsoft Excel (Computer file) 
630 0 7 |a Microsoft Excel (Computer file)  |2 fast 
650 0 |a Corporations  |x Finance. 
650 0 |a Corporations  |x Finance  |x Computer programs. 
650 7 |a BUSINESS & ECONOMICS  |x Finance.  |2 bisacsh 
650 7 |a Corporations  |x Finance  |2 fast 
650 7 |a Corporations  |x Finance  |x Computer programs  |2 fast 
758 |i has work:  |a Using Excel for business analysis (Text)  |1 https://id.oclc.org/worldcat/entity/E39PCG6f8tF9RGBcwcXwVWcRXd  |4 https://id.oclc.org/worldcat/ontology/hasWork 
776 0 8 |i Print version:  |a Fairhurst, Danielle Stein.  |t Using Excel for business and financial modelling.  |b Third edition.  |d Hoboken : Wiley, 2019  |z 9781119520382  |w (DLC) 2019000634 
856 4 0 |u https://ebookcentral.uam.elogim.com/lib/uam-ebooks/detail.action?docID=5741757  |z Texto completo 
938 |a Askews and Holts Library Services  |b ASKH  |n AH36142005 
938 |a Askews and Holts Library Services  |b ASKH  |n AH36142006 
938 |a ProQuest Ebook Central  |b EBLB  |n EBL5741757 
938 |a EBSCOhost  |b EBSC  |n 2091776 
938 |a YBP Library Services  |b YANK  |n 16132367 
938 |a YBP Library Services  |b YANK  |n 16135347 
938 |a YBP Library Services  |b YANK  |n 16139969 
938 |a YBP Library Services  |b YANK  |n ci73380061 
994 |a 92  |b IZTAP