Featured

The sales funnel chart is a marketing tool that raises many interesting questions. Today’s article is particular. Naturally we again offer a free Excel template and also we’d like to talk here about the professional background. The industry moves better than ever today. It doesn’t matter what business you’re in, what performed well a two years ago isn’t enough today. What is a sales funnel chart? The chart demonstrates when the sales funnel narrows in a bigger of smaller rate compared to average change. Funnel diagrams illustrate areas using multiple levels in a process.

How to use conditional formatting shapes? This is a very interesting area in Excel. Today we’ll show you all the tricks related to this subject. Formatting cells is a useful function. Can this function be extended? Is a shape fit to be the highlighted element of a professional chart template? Of course! Stay with us today and we’ll show you how all this is possible. As conclusion we can say that conditional formatting shapes is capable of doing way more things than most of us think. On the sample workbook you can find the VBA code which you can freely use and modify.

The Plan Actual Variance Chart template enables a very spectacular variance representation. Previously we have made a chart template in this subject and this time we will demonstrate the essential tool of company analysis and control from a completely different view. Because we have introduced the basics in details today will place emphasis strictly to the technical part of representation. Let’s start! On the picture below the Plan Actual Variance chart can be seen and in this article we will show you step by step the Excel knowledge needed for its creation. The described timespan will be the usual 12 months, which is one business year. We will show you by two examples the basis of logic for the calculation of differences.

The advanced score meter chart template is nothing else than such an application that helps us display each quality indicator in a different way till now. We have already seen several solutions on the net but these are all looked alike except for a very few. We keep ourselves to the previously written down principles meaning that on the Excel Dashboard School blog you will only see unique Excel templates and dashboards. The effectuation of the interval division that makes the score meter chart unique. We all know the classic scale with degrees ranging from week to excellent. We will use these and in a dynamic way! As a default we will be able to handle values between 0% and 100%.