ISM 3004 Lecture Notes - Lecture 6: Net Present Value, Transpose, Pivot Table

• School: University of Florida
• Department: Information Systems and Operations Management
• Course: ISM 3004
• Professor: Eric Olson

Document Summary

Scavenger hunt week 06 excel, part 2. Note: invest the time and effort required to learn every excel skills presented this week. Do(cid:374)"t li(cid:373)it (cid:455)ourself to the items listed below. They are intended to draw extra attention to certain ideas. Do(cid:374)"t ignore other techniques and ideas in the lectures! [06. 01: general, manipulate data, numeric- sum, average, financial, etc, text- conversion, extract portions of a string, etc, syntax. Ignores logical values and text: =min(, smallest value in a set of values. [06. 03: 50+ financial functions, accrued interest, depreciation, discount calculations, future value, net present value. Annual, monthly: for monthly =pmt(b3/12,b4,b5, amortization table, know how to use if() to handle situations where your formula must handle two different situations. [06. 06: two outcomes, o(cid:373)eti(cid:373)es life is si(cid:373)ple , =if(cid:894)a(cid:1009)/(cid:1010)(cid:1005), (cid:862)pass(cid:863),(cid:863)fail(cid:863)(cid:895, but what if there are more than two possible outcomes, good, better, best, nested if.