Excel supports two date systems, the 1900 and 1904 date system, which can pose potential problems in financial modelling. The 1900 date system is synonymous with Microsoft Excel for Windows, whilst Excel for Mac © (Apple) apply the 1904 date system.
Here are some great Excel keyboard shortcuts, which all financial modelling professionals should know about. All of these Excel Ctrl shortcuts can greatly improve the speed, efficiency and accuracy when building or editing financial models.
This financial model illustrates the potential problems or pitfalls with the Excel VLOOKUP function in financial analysis. In this example, we are using a VLOOKUP to reference the Last price for the following Dow Jones Industrial Average stocks.
In some financial models, such as cash payments spreadsheet, there is an inherent need to safeguard unique invoice number inputs.
Put simply, spreadsheet must be prevented from inputting duplicate cell values. Excel Data Validation is a fast, effective and macro-free solution, which will improve the financial model and prevent erroneous, duplicate input cells.