This article and video will outline one approach to generate a Goal Seek across multiple columns in Excel. As per the following screenshot, we have…
Creating a Three Dimension Data Table in Excel
This video will outline a way to create a three-dimension data table in Excel. It will be based on variables: unit price, units sold and number of sellers.
Goal: Create a what-if analysis using data table based on three variables.
Insert multiple rows using Excel VBA
Presently Excel only allows users to insert one row at a time. But what if we had the capacity to choose and insert numerous rows simultaneously? This video will outline one way, via Visual Basic for Applications or VBA, to insert multiple rows simultaneously into an Excel worksheet.
Using Excel Consolidate in Financial Modelling
This video will outline a macro-free approach to execute effective consolidation of data, which in this example will sum capital expenditure across three business units for strategic planning purposes.
Dynamic dependent drop-down list – advanced approach with LOOKUP
This approach uses the LOOKUP to produce a dynamic dependent drop-down list, which will cater to dependent lists of various input quantities. The application of a dynamic dependent drop-down list, can be applied in a variety of financial models and spreadsheet situations.
Excel Data Validation to prevent duplicate cells
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.