Abstract available at http://www.geocities.com/vj36_m



Risk Analysts and Risk and Project Managers would obviously benefit from the chapters on creating "Risk Scenarios" and "Constrained Optimization."



Depreciation functions and the differences between them are taught in detail-- something of use to all finance professionals.



One chapter aims to quickly bring up-to-speed users who do not know about all the financial functions In Excel, especially the statistical, mathematical and other functions that are useful in financial analysis.(For example, Average, Permutations, etc.)







Contents

1 Writing Formulas

2 Copying/Cutting And Pasting Formulae

3 Paste Special

4 Inserting Functions

5 Tracing Cell References & Debugging Formula Errors

6 Loan Repayments

7 Discount Cash Flows

8 Securities Functions

9 Functions For Basic Statistics

10 Other Mathematics & Statistics Functions

11 Logical & Information Functions

12 ûmart¹Nested Functions That Respond To Formula Result

13 Add-Ins: Enhancing Excel

14 The SOLVER Tool For Constrained Linear Optimization

15 éf-Then¹Analysis: Scenarios And Goal Seek









Size of file: 1.74 MB