Financial Model User Guide - Advanced Renewable Energy Model

Lukas Duldinger, CFA, RVA 151 minute read

This Financial Model User Guide supplements the underlying financial model and video courses by Renewables Valuation Institute.Students and users of the financial model can gain maximum value from using...

How to use the Name Manager in Excel?

Lukas Duldinger, CFA, RVA 3 minute read

The Name Manager in Excel is a powerful tool for creating references to certain cells and ranges. Using the Name Manager to create different macros in VBA, i.e., to break circular references, is best...

How to break a circular reference in Excel?

Lukas Duldinger, CFA, RVA 5 minute read

Circular Reference Warning: "There are one or more circular references where a formula refers to its own cell either directly or indirectly. This might cause them to calculate incorrectly. Try removing or...

Goal Seek in VBA: How to automate Goal Seek in Excel?

Lukas Duldinger, CFA, RVA 6 minute read

Goal Seek in VBA: Goal Seek is a handy Excel function that helps to determine the required input value needed to achieve a targeted output value - and this process can be automated using a VBA macro!Goal...

How to find a circular reference in Excel?

Lukas Duldinger, CFA, RVA 7 minute read

Excel circular references occur when a formula refers back to its own cell or a cell that directly or indirectly depends on it. Finding and fixing circular references is important because they can cause...