LEADER 06092nam 2200553 450 001 9910467063403321 005 20200520144314.0 010 $a1-119-52035-5 010 $a1-119-52034-7 010 $a1-119-52037-1 035 $a(CKB)4100000007817182 035 $a(MiAaPQ)EBC5741757 035 $a(CaSebORM)9781119520382 035 $a(Au-PeEL)EBL5741757 035 $a(OCoLC)1089839286 035 $a(EXLCZ)994100000007817182 100 $a20190411d2019 uy 0 101 0 $aeng 135 $aurcnu|||||||| 181 $ctxt$2rdacontent 182 $cc$2rdamedia 183 $acr$2rdacarrier 200 10$aUsing Excel for business and financial modelling $ea practical guide /$fDanielle Stein Fairhurst 205 $aThird edition. 210 1$aChichester, West Sussex :$cWiley,$d2019. 215 $a1 online resource (426 pages) 225 1 $aWiley finance 300 $aIncludes index. 300 $aRevised edition of the author's Using Excel for business analysis, 2012. 311 $a1-119-52038-X 327 $aMachine 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. 330 $aA 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 author?s 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. 410 0$aWiley finance series. 606 $aCorporations$xFinance 606 $aCorporations$xFinance$xComputer programs 606 $aBUSINESS & ECONOMICS / Finance$2bisacsh 608 $aElectronic books. 615 0$aCorporations$xFinance. 615 0$aCorporations$xFinance$xComputer programs. 615 7$aBUSINESS & ECONOMICS / Finance. 676 $a332.0285/554 700 $aFairhurst$b Danielle Stein$0867143 801 0$bMiAaPQ 801 1$bMiAaPQ 801 2$bMiAaPQ 906 $aBOOK 912 $a9910467063403321 996 $aUsing Excel for business and financial modelling$92106684 997 $aUNINA LEADER 02027nam 2200613Ia 450 001 9910450149903321 005 20200520144314.0 010 $a1-280-44711-7 010 $a9786610447114 010 $a1-84642-177-2 010 $a1-4175-5277-8 035 $a(CKB)1000000000002136 035 $a(OCoLC)228040417 035 $a(CaPaEBR)ebrary5000366 035 $a(SSID)ssj0000138780 035 $a(PQKBManifestationID)11129920 035 $a(PQKBTitleCode)TC0000138780 035 $a(PQKBWorkID)10102209 035 $a(PQKB)11125069 035 $a(MiAaPQ)EBC3015829 035 $a(Au-PeEL)EBL3015829 035 $a(CaPaEBR)ebr5000366 035 $a(CaONFJC)MIL44711 035 $a(EXLCZ)991000000000002136 100 $a20001204d2001 uy 0 101 0 $aeng 135 $aurcn||||||||| 181 $ctxt 182 $cc 183 $acr 200 10$aDiet intervention and autism$b[electronic resource] $eimplementing the gluten free and casein free diet for autistic children and adults : a practical guide for parents /$fMarilyn Le Breton ; foreword by Rosemary Kessick 210 $aLondon ;$aPhiladelphia $cJessica Kingsley Publishers$d2001 215 $a1 online resource (234 p.) 300 $aBibliographic Level Mode of Issuance: Monograph 311 $a1-85302-935-1 320 $aIncludes bibliographical references (p. 222-225) and index. 606 $aAutism in children$xNutritional aspects 606 $aAutism$xNutritional aspects 606 $aCasein-free diet 606 $aGluten-free diet 608 $aElectronic books. 615 0$aAutism in children$xNutritional aspects. 615 0$aAutism$xNutritional aspects. 615 0$aCasein-free diet. 615 0$aGluten-free diet. 676 $a616.89/820654 700 $aLe Breton$b Marilyn$f1966-$0884657 801 0$bMiAaPQ 801 1$bMiAaPQ 801 2$bMiAaPQ 906 $aBOOK 912 $a9910450149903321 996 $aDiet intervention and autism$92149024 997 $aUNINA LEADER 03547nam 2200529 450 001 9910141581503321 005 20230621142722.0 035 $a(CKB)2670000000356652 035 $a(SSID)ssj0000985802 035 $a(PQKBManifestationID)11575115 035 $a(PQKBTitleCode)TC0000985802 035 $a(PQKBWorkID)10932778 035 $a(PQKB)10644602 035 $a(OCoLC)881120918 035 $a(WaSeSS)Ind00073754 035 $a(EXLCZ)992670000000356652 100 $a20160829h20132013 uy 0 101 0 $ager 135 $aurmn#nnn||||| 181 $ctxt$2rdacontent 182 $cc$2rdamedia 183 $acr$2rdacarrier 200 14$aDas arztrechtliche system als Grenze der arbeitsteiligen Medizin $ezugleich ein Beitrag zur privatrechtsdogmatischen integration des Arztrechts /$fBenedikt Ballhausen 210 1$aGöttingen :$cUniversitätsverlag Göttingen,$d2013. 210 4$d©2013 215 $a1 online resource (vii, 328 pages) $cdigital, PDF file(s) 225 0 $aOpen Access e-Books 225 0 $aKnowledge Unlatched 225 1 $aGöttinger Schriften zum Medizinrecht ;$vBand 14 320 $aIncludes bibliographical references (pages [281]-325) 330 $aModern medicine is increasingly characterised by the division of labour. Therefore, this process as well as the concepts of delegation and substitution need to be clarified on a juridical basis. Accordingly, this dissertation is an approach to answer relevant questions of medical law, such as: Which concrete medical processes can be carried out based on the division of labour without risking legal steps regarding liability or pay to be taken? Based on distinct principles of medical law, the author thus develops a systematic framework for the division of medical labour. In this regard, an applicable and simultaneously docmatically substantiated method is focussed. 330 $aDie moderne Medizin ist zunehmend gepra?gt von arbeitsteiligen Prozessen. Was aber genau versteht das Arztrecht unter Arbeitsteilung, Delegation oder Substitution? Welche Ta?tigkeiten ko?nnen im Einzelfall konkret arbeitsteilig durchgefu?hrt werden, ohne dass sich der Arzt vergu?tungs- und haftungsrechtlichen Risiken aussetzt? Diese Arbeit versucht auf diese dra?ngenden Fragen des Arztrechts Antworten zu geben. Dabei entwickelt der Autor basierend auf den von ihm herausgearbeiteten arztrechtlichen Prinzipien eine systematische Grenze der arbeitsteiligen Medizin. In diesem Grenzsystem liegt zugleich ein Beitrag zur aktuell im Zuge des Patientenrechtegesetzes fortschreitenden privatrechtsdogmatischen Integration des Arztrechts. Ferner wird dieses System anhand von ausgewa?hlten Einzelfragen des Arztvergu?tungs- und Arzthaftungsrechts u?berpru?ft und weiterentwickelt. Auf diese Weise soll ein praxistauglicher und gleichzeitig dogmatisch abgesicherter Lo?sungsansatz fu?r die Grenze der arbeitsteiligen Medizin pra?sentiert werden. 410 0$aGöttinger Schriften zum Medizinrecht ;$vBand 14. 606 $aMedical laws and legislation$zGermany 606 $aMedical care$xLaw and legislation$zGermany 615 0$aMedical laws and legislation 615 0$aMedical care$xLaw and legislation 676 $a344.430412 686 $a347.446$2Moys 700 $aBallhausen$b Benedikt$0802000 801 0$bPQKB 801 2$bAuAdUSA 801 2$bUkMaJRU 906 $aBOOK 912 $a9910141581503321 996 $aDas arztrechtliche system als Grenze der arbeitsteiligen Medizin$92182312 997 $aUNINA