Using Excel in Financial Modelling
Danielle Stein Fairhurst · 2019
This chapter looks at some of the practical tools, functions, and formulas commonly used in financial modelling in Excel. For use in business and financial modelling, the most useful functions fall into the categories of logical, aggregation, lookup, and financial. The chapter lists most commonly used functions in financial modeling. Working in Excel can be very time-consuming; increasing finance professional's speed and accuracy will increase productivity significantly. Excel users just starting out with Excel would be very comfortable with using the mouse for navigation and editing purposes. The chapter presents a small selection of some of the most common and particularly useful shortcuts that are invaluable when using Excel for financial modelling. Formula consistency is critical for fundamental best practice, both in financial modelling and any other sort of analysis using Excel, for that matter. In order to have consistent formulas across and down the block of data, the professional needs to understand how cell referencing works.