When you need to find and extract a column of data from one table and place it in another, use the VLOOKUP function. This function works in any version of ...

From Tuts+ Computer Skills

Discusses how to download two companies' stock returns from Yahoo Finance, and calculate (a) the variance and standard deviation of each stock, and (b) the ...

From Codible

Predict who survives the Titanic disaster using Excel. Logistic regression allows us to predict a categorical outcome using categorical and numeric data.

From Data Analysis Videos

This video will show you how to calculate the bond price and yield to maturity in a financial calculator. If you need to find the Present value by hand please watch ...

From I Hate Math Group, Inc

VLOOKUP (lookup_value, table_array, col_index_num, [range_lookup]) lookup_value (required) The value you want to look up. The value you want to look up ...

From Excel Superstar

Warning: This video is long and boring! But, if you're preparing for a real estate technical interview, you'll likely find value in it. Watch me complete what is an ...

From Spencer Burton

Explaining the VLOOKUP function's optional 4th argument, range_lookup, and its role in returning an accurate lookup result. I'm a Microsoft Excel MVP ...

From Tom Urtis

In this video I show how to calculate the present value of an annuity. In addition to converting the series of payments via the traditional discounting method I'll ...

From Alanis Business Academy

An overview of bond premiums and discounts under the straight-line amortization method, to accompany http://www.principlesofaccounting.com Chapter 13, ...

From Larry Walther

Learn how to calculate the annual percentage rate on a payday loan. In Canada, payday loans are not allowed to be compounded (if they were, the effective ...

From Money School

In this video, Kosol Kiatreungwattana of the National Renewable Energy Laboratory explains levelized cost of energy, or LCOE, and why it's important.

From NREL Learning

For an experienced SF Bay Area real estate agent visit http://iLiveInTheBayArea.com Like me on Facebook: http://fb.com/iLiveInTheBayArea Thumbs up, favorite, ...

From Davide Pio - CCIM, LEED AP