Excel in Finance Lab

In this lab, we're going to provide a very brief overview of using Excel in the MFRM program.

First, we're going to look at Excel and how to organize a workbook. The emphasis here will be on the finance industry convention of using the first worksheet for assumptions and to explain the structure of the worksheet.

Second, we're going to discuss cell references, from the simple a1 format, to locked rows and columns (a$1:A$27), and named ranges.

Third, we're going to talk about getting data from outside sources, like Bloomberg or financial web sites, into Excel.

Finally, the "lab" part: you are going to build a financial calculator in Excel. If somebody finishes early enough, they'll have a chance to show their financial calculator to the class and earn a gold star.