Financial Modeling

How to Create Waterfall and Stacked Waterfall Charts

An overview of Waterfall and Stacked Waterfall charts to show variances

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

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

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

How to Value Banks or Financial Services Firms

An overview of banks business model, value drivers, regulation, risks and valuation methodologies

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.

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

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