Excel

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

The file explains the general principles of building financial models, gives a comprehensive example of a demo financial model and…

A conventional data table is a one- or two-dimensional table showing the results of a calculation (model outputs) at various…

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

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

This is an introductory part to creating professional charts which:   - defines key chart elements and explains how to…

The attached file: - defines key chart elements and explains how to edit them - demonstrates how to deal with…

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

This is a full version of my data table publication which explains how to:   - link several data tables…

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…