Excel

This is an attempt to list and explain the key concepts of developing financial models (also applicable to any other…

Making a waterfall chart is a powerful yet simple, visually attractive and compact way of visualizing the cost structure of…

A traditional sensitivity analysis involves testing a limited number of scenarios (e.g. base, upside and downside). Each scenario is a…

Very few people think of Excel as being able to produce professional-quality business charts. But this is true - Excel…

In this post I have collected a handful of techniques for working with data in Excel: looking up values, matching…

Data tables is a powerful tool to analyze sensitivities in Excel financial models. A conventional data table is a one-…

My publication on this obscure to the many yet a useful and powerful feature of Excel shows how array formulas…

Very few people think of Excel as being able to produce professional-quality business charts. But this is true - Excel…

This is a comprehensive Dashboard Template for typical kinds of Analysis including Sales Analysis, Variance Analysis, etc.

This is the second part of my publication explaining an advanced and little-known method of using data tables for sensitivity…

This is an unlocked version of the same utility published on my page. In this version you can access and…

Have you noticed that CRM systems can be expensive? Maybe you want to track some very simple information but don't…

In the modern work environment to benefit the most from the events (Christmas Dinner, team-building sessions, client conferences), organizers are…

This project finance model is an advance version of the model you can find under the following link: https://marketplace.corporatefinanceinstitute.com/financial-model-templates/project-finance-model-base/ It…

This project finance model is an advance version of the model you can find under the following link: https://www.eloquens.com/tool/XvxKFxl5/finance/project-finance-models/project-finance-model-unlimited-scenarios It…

This is an an Excel template designed to provide sales order management. The template has all the features required to…