{"product_id":"using-excel-for-business-and-financial-modelling-isbn-9781119520382","title":"Using Excel for Business and Financial Modelling","description":"\u003cp\u003e\u003cb\u003eA hands-on guide to using Excel in the business context\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eFirst published in 2012, \u003ci\u003eUsing Excel for Business and Financial Modelling\u003c\/i\u003e 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.\u003c\/p\u003e \u003cp\u003eWhilst 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.\u003c\/p\u003e \u003cp\u003e• Provides the perfect mix of practice and theory\u003c\/p\u003e \u003cp\u003e• Helps you become a DIY Excel modelling specialist\u003c\/p\u003e \u003cp\u003e• Includes updates for Excel 2019\/365 and Excel for Mac\u003c\/p\u003e \u003cp\u003e• May be used as an accompaniment to the author’s online and face-to-face training courses\u003c\/p\u003e \u003cp\u003eMany 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.\u003c\/p\u003e \u003cp\u003ePreface xi\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 1 What is Financial Modelling? 1\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eWhat’s the Difference Between a Spreadsheet and a Financial Model? 3\u003c\/p\u003e \u003cp\u003eTypes and Purposes of Financial Models 5\u003c\/p\u003e \u003cp\u003eTool Selection 6\u003c\/p\u003e \u003cp\u003eWhat Skills Do You Need to Be a Good Financial Modeller? 17\u003c\/p\u003e \u003cp\u003eThe “Ideal” Financial Modeller 23\u003c\/p\u003e \u003cp\u003eSummary 27\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 2 Building a Model 29\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eModel Design 29\u003c\/p\u003e \u003cp\u003eThe Golden Rules for Model Design 31\u003c\/p\u003e \u003cp\u003eDesign Issues 32\u003c\/p\u003e \u003cp\u003eThe Workbook Anatomy of a Model 33\u003c\/p\u003e \u003cp\u003eProject Planning Your Model 36\u003c\/p\u003e \u003cp\u003eModel Layout Flowcharting 37\u003c\/p\u003e \u003cp\u003eSteps to Building a Model 39\u003c\/p\u003e \u003cp\u003eInformation Requests 47\u003c\/p\u003e \u003cp\u003eVersion-Control Documentation 49\u003c\/p\u003e \u003cp\u003eSummary 50\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 3 Best-Practice Principles of Modelling 51\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eDocument Your Assumptions 51\u003c\/p\u003e \u003cp\u003eLinking, Not Hardcoding 52\u003c\/p\u003e \u003cp\u003eEnter Data Only Once 53\u003c\/p\u003e \u003cp\u003eAvoid Bad Habits 53\u003c\/p\u003e \u003cp\u003eUse Consistent Formulas 53\u003c\/p\u003e \u003cp\u003eFormat and Label Clearly 54\u003c\/p\u003e \u003cp\u003eMethods and Tools of Assumptions Documentation 55\u003c\/p\u003e \u003cp\u003eLinked Dynamic Text Assumptions Documentation 62\u003c\/p\u003e \u003cp\u003eWhat Makes a Good Model? 65\u003c\/p\u003e \u003cp\u003eSummary 67\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 4 Financial Modelling Techniques 69\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eThe Problem with Excel 69\u003c\/p\u003e \u003cp\u003eError Avoidance Strategies 71\u003c\/p\u003e \u003cp\u003eHow Long Should a Formula Be? 76\u003c\/p\u003e \u003cp\u003eLinking to External Files 78\u003c\/p\u003e \u003cp\u003eBuilding Error Checks 81\u003c\/p\u003e \u003cp\u003eCircular References 85\u003c\/p\u003e \u003cp\u003eSummary 90\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 5 Using Excel in Financial Modelling 91\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eFormulas and Functions in Excel 91\u003c\/p\u003e \u003cp\u003eExcel Versions 94\u003c\/p\u003e \u003cp\u003eHandy Excel Shortcuts 100\u003c\/p\u003e \u003cp\u003eCell Referencing Best Practices 104\u003c\/p\u003e \u003cp\u003eNamed Ranges 107\u003c\/p\u003e \u003cp\u003eBasic Excel Functions 110\u003c\/p\u003e \u003cp\u003eLogical Functions 114\u003c\/p\u003e \u003cp\u003eNesting Logical Functions 117\u003c\/p\u003e \u003cp\u003eSummary 125\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 6 Functions for Financial Modelling 127\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eAggregation Functions 127\u003c\/p\u003e \u003cp\u003eLOOKUP Functions 139\u003c\/p\u003e \u003cp\u003eNesting Index and Match 150\u003c\/p\u003e \u003cp\u003eOFFSET Function 153\u003c\/p\u003e \u003cp\u003eRegression Analysis 158\u003c\/p\u003e \u003cp\u003eChoose Function 164\u003c\/p\u003e \u003cp\u003eWorking with Dates 165\u003c\/p\u003e \u003cp\u003eFinancial Project Evaluation Functions 171\u003c\/p\u003e \u003cp\u003eLoan Calculations 177\u003c\/p\u003e \u003cp\u003eSummary 183\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 7 Tools for Model Display 185\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eBasic Formatting 185\u003c\/p\u003e \u003cp\u003eCustom Formatting 186\u003c\/p\u003e \u003cp\u003eConditional Formatting 191\u003c\/p\u003e \u003cp\u003eSparklines 195\u003c\/p\u003e \u003cp\u003eBulletproofing Your Model 199\u003c\/p\u003e \u003cp\u003eCustomising the Display Settings 203\u003c\/p\u003e \u003cp\u003eForm Controls 210\u003c\/p\u003e \u003cp\u003eSummary 226\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 8 Tools for Financial Modelling 227\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eHiding Sections of a Model 227\u003c\/p\u003e \u003cp\u003eGrouping 233\u003c\/p\u003e \u003cp\u003eArray Formulas 234\u003c\/p\u003e \u003cp\u003eGoal Seeking 240\u003c\/p\u003e \u003cp\u003eStructured Reference Tables 242\u003c\/p\u003e \u003cp\u003ePivotTables 245\u003c\/p\u003e \u003cp\u003eMacros 254\u003c\/p\u003e \u003cp\u003eSummary 263\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 9 Common Uses of Tools in Financial Modelling 265\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eEscalation Methods for Modelling 265\u003c\/p\u003e \u003cp\u003eUnderstanding Nominal and Effective (Real) Rates 270\u003c\/p\u003e \u003cp\u003eCalculating a Cumulative Sum (Running Totals) 274\u003c\/p\u003e \u003cp\u003eHow to Calculate a Payback Period 275\u003c\/p\u003e \u003cp\u003eWeighted Average Cost of Capital (WACC) 278\u003c\/p\u003e \u003cp\u003eBuilding a Tiering Table 282\u003c\/p\u003e \u003cp\u003eModelling Depreciation Methods 286\u003c\/p\u003e \u003cp\u003eBreak-Even Analysis 295\u003c\/p\u003e \u003cp\u003eSummary 300\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 10 Model Review 301\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eRebuilding an Inherited Model 301\u003c\/p\u003e \u003cp\u003eImproving Model Performance 312\u003c\/p\u003e \u003cp\u003eAuditing a Financial Model 317\u003c\/p\u003e \u003cp\u003eSummary 323\u003c\/p\u003e \u003cp\u003eAppendix: QA Log 323\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 11 Stress Testing, Scenarios, and Sensitivity Analysis in Financial Modelling 325\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eWhat are the Differences Between Scenario, Sensitivity, and What-If Analyses? 326\u003c\/p\u003e \u003cp\u003eOverview of Scenario Analysis Tools and Methods 328\u003c\/p\u003e \u003cp\u003eAdvanced Conditional Formatting 337\u003c\/p\u003e \u003cp\u003eComparing Scenario Methods 340\u003c\/p\u003e \u003cp\u003eAdding Probability to a Data Table 350\u003c\/p\u003e \u003cp\u003eSummary 351\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 12 Presenting Model Output 353\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003ePreparing an Oral Presentation for Model Results 353\u003c\/p\u003e \u003cp\u003ePreparing a Graphic or Written Presentation for Model Results 355\u003c\/p\u003e \u003cp\u003eChart Types 358\u003c\/p\u003e \u003cp\u003eWorking with Charts 367\u003c\/p\u003e \u003cp\u003eHandy Charting Hints 374\u003c\/p\u003e \u003cp\u003eDynamic Named Ranges 376\u003c\/p\u003e \u003cp\u003eCharting with Two Different Axes and Chart Types 382\u003c\/p\u003e \u003cp\u003eBubble Charts 384\u003c\/p\u003e \u003cp\u003eCreating a Dynamic Chart 387\u003c\/p\u003e \u003cp\u003eWaterfall Charts 391\u003c\/p\u003e \u003cp\u003eSummary 395\u003c\/p\u003e \u003cp\u003eAbout the Author 397\u003c\/p\u003e \u003cp\u003eAbout the Website 399\u003c\/p\u003e \u003cp\u003eIndex 403\u003c\/p\u003e \u003cp\u003e\u003cb\u003eDANIELLE STEIN FAIRHURST\u003c\/b\u003e is the Principal of Plum Solutions, a Sydney-based consultancy specialising in financial modelling and analysis. Her extensive experience as a financial analyst enables her to help her clients create meaningful financial models. She is regularly engaged as a speaker, course facilitator, financial modelling consultant, and analyst.\u003c\/p\u003e \u003cp\u003ePraise for \u003cb\u003eUsing Excel for Business and Financial Modelling\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003e\u003cb\u003eThird Edition\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003e\"Highly recommended. I wish I had this book when I was learning Excel! This handy guide covers everything you need to know about modeling business problems and analyzing data.\"\u003cbr\u003e\u003cb\u003e—Purna Chandra Rao Duggirala (Chandoo),\u003c\/b\u003e Microsoft Excel MVP; Founder, Chandoo.org\u003c\/p\u003e \u003cp\u003e\"Danielle's expertise and experience shines through in a very readable book, introducing the key concepts and considerations inherent in financial modelling. From novice to advanced modeller alike, readers are presented with many useful tips, tools, techniques, and pragmatic examples to refer to time and time again. Readily digestible, this book plugs a gaping academic hole that illustrates the risks and rewards of taking a spreadsheet by the throat and converting it into a robust, transparent, and flexible decision-making device. It will help you to 'Excel'.\"\u003cbr\u003e\u003cb\u003e—Liam Bastick,\u003c\/b\u003e Managing Director, SumProduct, and Excel MVP\u003c\/p\u003e \u003cp\u003e\"Danielle has done an incredible job of explaining all the component parts of financial modelling and demystifying what is often seen as a complex and difficult area. Her book contains useful insights of benefit to everyone performing business analysis in Excel - regardless of their level of experience. It's the book I wish had been available when I started my career.\"\u003cbr\u003e\u003cb\u003e—Kenny Whitelaw-Jones,\u003c\/b\u003e Partner, Gridlines\u003c\/p\u003e","brand":"Wiley","offers":[{"title":"Default Title","offer_id":47990442492133,"sku":"NP9781119520382","price":79.0,"currency_code":"USD","in_stock":false}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/1842\/7735\/files\/9781119520382.jpg?v=1761787847","url":"https:\/\/k12savings.com\/es\/products\/using-excel-for-business-and-financial-modelling-isbn-9781119520382","provider":"K12savings","version":"1.0","type":"link"}