| 000 -LEADER |
|---|
| fixed length control field |
05070nam a2200493 i 4500 |
| 001 - CONTROL NUMBER |
|---|
| control field |
EBC5741757 |
| 003 - CONTROL NUMBER IDENTIFIER |
|---|
| control field |
MiAaPQ |
| 007 - PHYSICAL DESCRIPTION FIXED FIELD--GENERAL INFORMATION |
|---|
| fixed length control field |
cr cnu|||||||| |
| 008 - FIXED-LENGTH DATA ELEMENTS--GENERAL INFORMATION |
|---|
| fixed length control field |
190411s2019 enk o 001 0 eng d |
| 020 ## - INTERNATIONAL STANDARD BOOK NUMBER |
|---|
| Cancelled/invalid ISBN |
9781119520382 |
|
|---|
| International Standard Book Number |
9781119520375 (e-book) |
|
|---|
| International Standard Book Number |
9781119520344 (e-book) |
| 035 ## - SYSTEM CONTROL NUMBER |
|---|
| System control number |
(MiAaPQ)EBC5741757 |
|
|---|
| System control number |
(Au-PeEL)EBL5741757 |
|
|---|
| System control number |
(OCoLC)1089839286 |
| 040 ## - CATALOGING SOURCE |
|---|
| Original cataloging agency |
MiAaPQ |
| Language of cataloging |
eng |
| Description conventions |
rda |
| -- |
pn |
| Transcribing agency |
MiAaPQ |
| Modifying agency |
MiAaPQ |
| 050 #4 - LIBRARY OF CONGRESS CALL NUMBER |
|---|
| Classification number |
HF5548.4.M523 |
| Item number |
.F357 2019 |
| 082 0# - DEWEY DECIMAL CLASSIFICATION NUMBER |
|---|
| Classification number |
332.0285/554 |
| Edition number |
23 |
| 100 1# - MAIN ENTRY--PERSONAL NAME |
|---|
| Personal name |
Fairhurst, Danielle Stein, |
| Relator term |
author. |
| 245 10 - TITLE STATEMENT |
|---|
| Title |
Using Excel for business and financial modelling : |
| Remainder of title |
a practical guide / |
| Statement of responsibility, etc |
Danielle Stein Fairhurst. |
| 250 ## - EDITION STATEMENT |
|---|
| Edition statement |
Third edition. |
| 264 #1 - |
|---|
| -- |
Chichester, West Sussex : |
| -- |
Wiley, |
| -- |
2019. |
| 300 ## - PHYSICAL DESCRIPTION |
|---|
| Extent |
1 online resource (426 pages). |
| 336 ## - |
|---|
| -- |
text |
| -- |
txt |
| -- |
rdacontent |
| 337 ## - |
|---|
| -- |
computer |
| -- |
c |
| -- |
rdamedia |
| 338 ## - |
|---|
| -- |
online resource |
| -- |
cr |
| -- |
rdacarrier |
| 490 1# - SERIES STATEMENT |
|---|
| Series statement |
Wiley finance |
| 500 ## - GENERAL NOTE |
|---|
| General note |
Includes index. |
|
|---|
| General note |
Revised edition of the author's Using Excel for business analysis, 2012. |
| 505 8# - FORMATTED CONTENTS NOTE |
|---|
| Formatted contents note |
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. |
| 588 ## - |
|---|
| -- |
Description based on print version record. |
| 590 ## - LOCAL NOTE (RLIN) |
|---|
| Local note |
Electronic reproduction. Ann Arbor, MI : ProQuest, 2018. Available via World Wide Web. Access may be limited to ProQuest affiliated libraries. |
| 630 00 - SUBJECT ADDED ENTRY--UNIFORM TITLE |
|---|
| Uniform title |
Microsoft Excel (Computer file) |
| 650 #0 - SUBJECT ADDED ENTRY--TOPICAL TERM |
|---|
| Topical term or geographic name as entry element |
Corporations |
| General subdivision |
Finance. |
|
|---|
| Topical term or geographic name as entry element |
Corporations |
| General subdivision |
Finance |
| -- |
Computer programs. |
|
|---|
| Topical term or geographic name as entry element |
BUSINESS & ECONOMICS / Finance. |
| Source of heading or term |
bisacsh |
| 655 #4 - INDEX TERM--GENRE/FORM |
|---|
| Genre/form data or focus term |
Electronic books. |
| 776 08 - ADDITIONAL PHYSICAL FORM ENTRY |
|---|
| Display text |
Print version: |
| Main entry heading |
Fairhurst, Danielle Stein. |
| Title |
Using Excel for business and financial modelling : a practical guide. |
| Edition |
Third edition. |
| Place, publisher, and date of publication |
Chichester, West Sussex : Wiley, 2019 |
| Physical description |
426 pages |
| Series data for related item |
Wiley finance series. |
| International Standard Book Number |
9781119520382 |
| Record control number |
(DLC) 2019010808 |
| 797 2# - LOCAL ADDED ENTRY--CORPORATE NAME (RLIN) |
|---|
| Corporate name or jurisdiction name as entry element |
ProQuest (Firm) |
| 830 #0 - SERIES ADDED ENTRY--UNIFORM TITLE |
|---|
| Uniform title |
Wiley finance series. |
| 856 40 - ELECTRONIC LOCATION AND ACCESS |
|---|
| Uniform Resource Identifier |
https://ebookcentral.proquest.com/lib/kliuc-ebooks/detail.action?docID=5741757 |
| Public note |
Click to View |
| 942 ## - ADDED ENTRY ELEMENTS (KOHA) |
|---|
| Source of classification or shelving scheme |
|
| Koha item type |
E-book |
