Profectus Academy

In this channel you would get interesting and new perspectives and tips about financial modeling, data analytics and MS Excel.

I would also occasionally share insights about interview preparation techniques mainly focused on finance roles.

Building financial model with Dynamic Array | The BEST framework
Building financial model with Dynamic Array | The BEST framework
Circular reference in dynamic arrays
Circular reference in dynamic arrays
Ultimate guide to think like a financial modeler | Evolving from accounting to financial modeling
Ultimate guide to think like a financial modeler | Evolving from accounting to financial modeling
Financial Modeling with Lambdas - upgrade to 2025 way of making models
Financial Modeling with Lambdas - upgrade to 2025 way of making models
Why you should avoid IRR?
Why you should avoid IRR?
Automate calculations in MS Word
Automate calculations in MS Word
Dos and DONTs for dynamic arrays | Never mix legacy approach with dynamic arrays
Dos and DONTs for dynamic arrays | Never mix legacy approach with dynamic arrays
Mastering vector operations in MS Excel
Mastering vector operations in MS Excel
How to determine SWP in volatile returns environment?
How to determine SWP in volatile returns environment?
How to model depreciation under straight line method?
How to model depreciation under straight line method?
IDC circularity solved!! Modelling interest during construction without circular reference
IDC circularity solved!! Modelling interest during construction without circular reference
How to do mid-year discounting in MS Excel using the NPV function? | Mid-year discounting formula
How to do mid-year discounting in MS Excel using the NPV function? | Mid-year discounting formula
Why does XIRR give wrong answer? | Is XIRR returning 0% or 2.98023E-09? | Learn the alternative
Why does XIRR give wrong answer? | Is XIRR returning 0% or 2.98023E-09? | Learn the alternative
1 Cell referencing
1 Cell referencing
How to repeat set of values varying number of times in MS Excel
How to repeat set of values varying number of times in MS Excel
How to automatically add numbering to text in a single cell in MS Excel?
How to automatically add numbering to text in a single cell in MS Excel?
Introduction to equity and business valuation - Part 1
Introduction to equity and business valuation - Part 1
How to add data labels to waterfall chart created with Up down bars?
How to add data labels to waterfall chart created with Up down bars?
How to connect slicer to waterfall charts in MS Excel?
How to connect slicer to waterfall charts in MS Excel?
How to create waterfall charts in MS Excel
How to create waterfall charts in MS Excel
How to change the colors of all the bars in MS Excel waterfall chart? | Use arrows instead of bars
How to change the colors of all the bars in MS Excel waterfall chart? | Use arrows instead of bars
What is the difference between Value and NumberValue function
What is the difference between Value and NumberValue function
Find number of days employees worked in a month
Find number of days employees worked in a month
Trim function not working? No-break space could be the reason
Trim function not working? No-break space could be the reason
MS Excel 101: Text functions in MS Excel
MS Excel 101: Text functions in MS Excel
How to apply slicer on formulas in MS Excel
How to apply slicer on formulas in MS Excel
How to value life insurance company? | Embedded value and distance to market cap
How to value life insurance company? | Embedded value and distance to market cap
Mathematical thinking for MS Excel, financial modelling and programming
Mathematical thinking for MS Excel, financial modelling and programming
XLOOKUP vs Lookup vs Index Match? Xlookup performance issues
XLOOKUP vs Lookup vs Index Match? Xlookup performance issues
When and how to use Scan() and Reduce() functions in MS Excel? | Build dynamic cork screw models
When and how to use Scan() and Reduce() functions in MS Excel? | Build dynamic cork screw models