How to Create Waterfall and Stacked Waterfall Charts
An overview of Waterfall and Stacked Waterfall charts to show variances
Search
Modelyze Investments
- Dec 12, 2021
- 5 min
How to Custom Format Cells with Symbols in MS Excel
An overview of Custom Formatting in MS Excel and how Custom Formatting can be used to add symbols and text to numbers in cells
Modelyze Investments
- Mar 20, 2021
- 4 min
How 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 Investments
- Jan 16, 2021
- 2 min
How to Use the Lambda Function in MS Excel
An Overview of the Newly Created Lambda() Function in MS Excel in Beta Channel and Office Insider
Modelyze Investments
- Oct 26, 2020
- 7 min
How to Value Banks or Financial Services Firms
An overview of banks business model, value drivers, regulation, risks and valuation methodologies
Modelyze Investments
- Jun 29, 2020
- 2 min
How to Align Primary and Secondary Axis at Zero in MS Excel
A very simple method to align the 0 line of primary and secondary axis in MS Excel for a presentable display of results.
Modelyze Investments
- Jun 13, 2020
- 2 min
How to create dynamic formulas in Microsoft Excel which updates daily as you add data
An overview of dynamic ranges and dynamic formulas in MS Excel which updates automatically with added data
Modelyze Investments
- Jun 6, 2020
- 3 min
How to make chart data range dynamic in Microsoft Excel
An overview of the usage of dynamic data ranges in MS Excel charts for creation of dynamic charts with automatic updates