Resources

Blogs
Best Practices

Benefits of Hiding Unused Columns After the Model Timeline

12 Sep,2024 | Shashank Tamta

It is a common occurrence for financial modelers to scroll through a model and encounter unused columns beyond the model's timeline in almost every worksheet. Hiding these extra columns after t ...

Read More
Financial Modeling

Leveraging Data Bars Conditional Formatting in Excel for Data Visualization

05 Sep,2024 | Ayush Gupta

For financial modelers, precision and clarity are critical when presenting data. Data bars in Excel offer a powerful way to visualize key financial metrics directly within your financial models. It ...

Read More
Financial Modeling

Optimizing Calculations with 2D Calculation Blocks

21 Aug,2024 | Tanushka Kanodia

2D calculation blocks offer a structured and efficient approach for performing repetitive calculations on rows and columns of data, reducing the need to replicate similar calculation blocks multipl ...

Read More
Case Studies
Real Estate

Real Estate Project Appraisal Model

Read More
Logistics

Corporate M&A Model

Read More
Real Estate

Rental reconciliation and collection analysis tool

Read More