Modelyze InvestmentsDec 13, 20213 min readHow to Create Waterfall and Stacked Waterfall ChartsAn overview of Waterfall and Stacked Waterfall charts to show variances
Modelyze InvestmentsDec 12, 20215 min readHow to Custom Format Cells with Symbols in MS ExcelAn overview of Custom Formatting in MS Excel and how Custom Formatting can be used to add symbols and text to numbers in cells
Modelyze InvestmentsMar 20, 20214 min readHow to Create Dynamic Charts with Drop Down Lists and Name Managers?An overview of a Dynamic Chart that adjusts based on user input date ranges and user defined input from a drop-down lists
Modelyze InvestmentsJan 16, 20212 min readHow to Use the Lambda Function in MS ExcelAn Overview of the Newly Created Lambda() Function in MS Excel in Beta Channel and Office Insider
Modelyze InvestmentsOct 26, 20207 min readHow to Value Banks or Financial Services FirmsAn overview of banks business model, value drivers, regulation, risks and valuation methodologies
Modelyze InvestmentsJun 29, 20202 min readHow to Align Primary and Secondary Axis at Zero in MS ExcelA very simple method to align the 0 line of primary and secondary axis in MS Excel for a presentable display of results.
Modelyze InvestmentsJun 13, 20202 min readHow to create dynamic formulas in Microsoft Excel which updates daily as you add dataAn overview of dynamic ranges and dynamic formulas in MS Excel which updates automatically with added data
Modelyze InvestmentsJun 6, 20203 min readHow to make chart data range dynamic in Microsoft ExcelAn overview of the usage of dynamic data ranges in MS Excel charts for creation of dynamic charts with automatic updates