Featured posts
Free Excel add-ins and tools on Excel Dashboard School! If you want to boost your work productivity just download and use our 100% free tools. Merge, Split and Compare your spreadsheets ASAP. Our utility provide various tools. We provide also effective text processing functions, Worksheet and Workbook Tools. Last but not least the tool is fully support the formula audit in Excel.
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.
Customer service is a marketing field where we have to make quick decisions so we can intervene on time. Probably the planning time for the first bigger dashboard project was almost longer than the actual creation. Two drop-down lists and we can use a spectacular data visualization. This is enough to show you each and every little detail! We note here for the sake of interest that the free excel dashboard template can process a huge data set. In the report there are data for more than 8000 outgoing calls!
What is dashboard widget? We hear and talk a lot about it in our everyday Excel work. Maybe many don’t know what this phrase exactly means. Widgets are supplements, mini applications that Excel does not include as a default. Do you need new ideas? From gauge chart it is never enough! The quarter style widget is not too frequent but can be excellently use. Just imagine that you have created the dashboard and you notice at the end that you run out of place on the worksheet.
We have good news for the Excel community! No more traffic jams if you use our free templates! Just work or learn using our fully editable and free (as always) Excel Traffic light template. Setting up your business goals is a primary element of deciding on the business that’s most suitable for you. Using these key performance indicators you can measure business or employee performance. One of the most liked technic is conditional formatting. The traffic light report is a versatile tool and the creation of it is not at all difficult. The traffic light has three statuses. The three different colors indicate (red, yellow and green) that the operation of a given indicator is acceptable or not. We apply a new method besides the VLOOKUP and SUMIF formulas.
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%.