The best way to learn Excel is to treat data analysis like a daily habit. We keep hearing real estate stories such as my friend bought a flat at a certain price and sold it later at a higher price. Instead of reacting emotionally, you can break this down in seconds with Excel’s two functions.
- You can calculate the exact holding period with the YEARFRAC function.
- You can compute the annual growth rate with the RRI function.
I have recorded a short 1-minute video/reel with Krina Shah, CFA, where you can understand both finance and Excel. In my view, if we look at 50 random property cases, the long-term average growth usually ends up near 6% to 10%. This is noticeably lower than the NIFTY 50 Index, even though real estate involves higher concentration risk and low liquidity.
If you want more such tips, comment “Excel” and I will share two things with you:
- A 2-hour YouTube podcast that explains practical Excel usage.
- A completely free certificate course on Excel.
Originally posted on LinkedIn.
