Getformula Function, Data Tables, Excel Implementation, and Organizational Structure

Learning Journal
Name
Institution
Due Date
Learning Journal
Book 1: Financial Modelling
Chapter 0: Summary
This chapter alongside several others seeks to showcase the importance of data tables in financial modeling. However, in this particular chapter, the author focuses specifically on the Getformula function. The Getformula function as the chapter indicates is used in annotating spreadsheets. This chapter contains several sections with the goal being to explain how the Getformula function is added to Excel notebook. The process is quite simple but different in subtle ways for Mac and Windows users. The first instance details the ways in which users on Mac and Windows could put the function into their excel notebook. For both users, the steps involve opening the VBA editor and then inserting text that activates the formula. While saving the excel workbook, however, it is crucial to saving with an acknowledgment of the formula. So, one is directed to save the file as a macro-enabled workbook and the procedure for Mac and Windows users are different. The Getformula has to be inserted into each excel workbook. However, it is possible to automate it such that the formula will be activated every time Excel is started.
Reflection
This chapter is crucial as it offers one an introduction or lays a foundation for what is to come later in the book. The Getformula function is indeed important while preparing excel sheets. It helps make work easier as one is computing and working out numbers in an excel sheet. So, the importance of this chapter goes beyond laying a foundation for the later chapters.
Question: What are some of the ways that the Getformula function can be used in data analysis?
Chapter 31: Summary
In this chapter, the book delves deeper into excel sheets. Here, data tables are discussed in depth and one is introduced to one-dimensional and two-dimensional excel data tables. As explained in the book, a one-dimensional data table does sensitivity analysis by varying one parameter. So, for this data table, if one wants to know how a single parameter interferes or leads to changes in two data sets, they place the parameter in the first column and have the two data sets in the top rows. Then, the next step involves varying the data values in the single parameter and noting the differences in the two data sets occupying the rows. So, while using the data table command, one only inserts the value for the Column Input Cell. Aside from the above, there is also the two-dimensional excel data table. For this data table, one measures the influence of two parameters. So, while using the data command, one sets a value for the Column Input Cell and the Row Input Cell. For data tables, the formula being calculated can be hidden instead of always appearing on the table.
Reflection
Data tables are a great tool that makes it easier for one to make use of different formulas. While creating excel sheets, there are two ways or approaches. One of them is to input everything and compute numbers elsewhere while inserting them into the worksheet. On the other hand, this chapter introduces the concept of using tables and formulas to fill out spreadsheets. The ideas are easy to understand and use in one’s persona...