top of page
Search
Modelyze Investments
Dec 13, 20213 min read
How to Create Waterfall and Stacked Waterfall Charts
An overview of Waterfall and Stacked Waterfall charts to show variances
1
Modelyze Investments
Dec 12, 20215 min read
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
0
Modelyze Investments
Mar 20, 20214 min read
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
0
Modelyze Investments
Jan 16, 20212 min read
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
0
Modelyze Investments
Oct 26, 20207 min read
How to Value Banks or Financial Services Firms
An overview of banks business model, value drivers, regulation, risks and valuation methodologies
0
Modelyze Investments
Jun 29, 20202 min read
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.
0
Modelyze Investments
Jun 13, 20202 min read
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
0
Modelyze Investments
Jun 6, 20203 min read
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
0
bottom of page