top of page
Search


How to Create Waterfall and Stacked Waterfall Charts
An overview of Waterfall and Stacked Waterfall charts to show variances

Modelyze Investments
Dec 13, 20213 min read
1


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
Dec 12, 20215 min read
0


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
Mar 20, 20214 min read
0


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
Jan 16, 20212 min read
0


How to Value Banks or Financial Services Firms
An overview of banks business model, value drivers, regulation, risks and valuation methodologies

Modelyze Investments
Oct 26, 20207 min read
0


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 29, 20202 min read
0


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 13, 20202 min read
0


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

Modelyze Investments
Jun 6, 20203 min read
0
bottom of page