Application of the advanced features of Excel will provide the user to analyze real estate and finance functions to solve complex calculations and build dynamic models to enhance decision making. The formula are conveniently located on the Formula Tab and organized into six categories including, Financial, Logical, Text, Date & Time, Lookup & Reference, and Math & Trig.
This article provides a reference guide to understanding how to build formulas and the my favorite functions and formulas used in developing the financial models.