Calculate Future Amount based on Changing Rates in Excel

If you were offered a guaranteed interest rate for a couple of years but the rates changed depending on the year, how would you know know what the future value would be? Say you're investing $1000 and for year one the interest rate is 5%, year two is 4.5% and year three is 4%. This is basically compounded interest on top of each year. It's fairly easy to do manually and even easier to do with the FVSCHEDULE function. Another fun way to use this function is to find out what historical figures would be worth today based on an inflation adjusted amount. The video will cover how this could be done.

Compare Economic Data and Stocks with CORREL Function

If you're doing any investing whether it be stocks, bonds or ETFs you're going to do research. One of the avenues of research is to look at macro economic data to help you forecast. One great repository of economic data is the St. Louis Federal Reserve. They actually have an Excel Add-in where you can get decades past data and it's all free! Couple that with stock data you can get from Google or Yahoo finance, and you've got all the data you need to do some correlation analysis with macro economic data and individual stock data.

Use Power Query to Unpivot Report with Multiple Column Row Header Fields

If you've ever gotten a report, it's already been summarized with a specific format with a set of column or row headers (or maybe multiple layers of column or row headers). You'd think that it would take some time with multiple copy and paste steps to get the report view back into a table. With Power Query, you can revert this report back into a proper table so you can do some further analysis in just a few steps.