From the course: Excel: Financial Functions in Depth
Join today to access over 23,200 courses taught by industry experts.
From the course: Excel: Financial Functions in Depth
Start my 1-month free trial Buy for my team
Calculate exchange rates with Currencies data types
“
- [Instructor] Now, the other data type that you might find useful for working with finance is the currency data type. So let's have a look at how to use that. So let's say you put in a whole lot of currency pairs like this. Let's put in Canadian. You can put in some slashes, it doesn't need to be all exactly the same. See if I've spelled all of those right, and if I go into here and you can see there's a bit of a disclaimer there, you can get rid of that if you like or it's just a good reminder and go in convert to currency. So you can see there that that has converted these currency pairs to the currencies data type in Excel, which means that we can go in and extract the rate automatically. Now, that is going to update every time I refresh but you can change the refresh settings here and let me do it for all of them. I like to make it so that it's on either manual or on file open. If you have it on automatic, it can…
Contents
-
- Perform financial analysis in Excel 43s
- What you should know 1m 28s
- Disclaimer 38s
-
- PMT: Calculate a loan payment 4m 12s
- (Locked) PPMT and IPMT: Calculate the principal and interest payments 3m 15s
- (Locked) Splitting interest and principal payments 3m 24s
- (Locked) CUMPRINC and CUMIPMT: Cumulative principal and interest 3m 2s
- (Locked) EFFECT and NOMINAL: Nominal and effective interest rates 3m 16s
- (Locked) ACCRINT and ACCRINTM: Calculate accrued investments interest 2m 36s
- (Locked) RATE: Discover the interest rate of an annuity 2m 11s
- (Locked) PDURATION: Calculate the periods to reach a goal 1m 54s
- (Locked) NPER: Calculate the number of periods in an investment 2m 31s
-
- SLN: Depreciation using the straight line method 3m
- (Locked) DB: Depreciation using the declining balance method 3m 35s
- (Locked) DDB: Depreciation using the double-declining balance method 2m 39s
- (Locked) SYD: Calculate depreciation for a specified period 1m 22s
- (Locked) VDB: Declining balance depreciation for a partial period 2m 17s
- (Locked) Comparing depreciation functions 5m 37s
-
- (Locked) FV: Future value of an investment 3m 14s
- (Locked) FVSCHEDULE: Future value with variable returns 1m 4s
- (Locked) Escalating with compounding interest or growth rates 3m 3s
- (Locked) PV: Present value of an investment 54s
- (Locked) NPV: Net present value of an investment 4m 58s
- (Locked) XNPV: Net present value given irregular inputs 2m 12s
- (Locked) IRR: Internal rate of return 1m 24s
- (Locked) XIRR: Internal rate of return for irregular cash flows 1m 7s
- (Locked) MIRR: Internal rate of return for mixed cash flows 56s
- (Locked) RRI: The interest rate for the growth of an investment 1m 3s
-
- (Locked) STOCKHISTORY: Get historical stock prices 3m 40s
- (Locked) Live stock prices with Stocks data types 2m 51s
- (Locked) Calculate exchange rates with Currencies data types 4m 3s
- (Locked) FIELDVALUE: Get field data 3m 7s
- (Locked) STOCKHISTORY with data types 2m 13s
- (Locked) Charting STOCKHISTORY with data types 6m 1s
-
- (Locked) EOMONTH, EDATE, and timing flags 4m 50s
- (Locked) Calculate pro data rental costs with date functions 4m 9s
- (Locked) IF: Building logical comparisons 5m 21s
- (Locked) Calculating the payback period 4m 27s
- (Locked) Using RATE or RRI for compound annual growth rate (CAGR) 4m 46s
- (Locked) Creating a debt schedule 4m 50s
- (Locked) Using SLN and IF to calculate depreciation 3m 10s
- (Locked) Creating a depreciation schedule 3m 51s
- (Locked) Using dynamic arrays to create a depreciation waterfall 6m 15s
- (Locked) Calculating weighted average cost of capital (WACC) 6m 21s
- (Locked) Using NPV to calculate a discounted cash flow (DCF) 4m 34s
-
- (Locked) Where to learn more about Excel 1m 11s
)
