Most Excel users would be used to working with the concept of displaying negative numbers in a worksheet with a preceding - sign in front of the number, something a bit like this below, where I have an example of monthly sales and the diference month on month of those sales figures. The negative differences are easy to see. So, how about making the positive numbers just as identifiable with a + sign in front of the numbers. It is really easy in Excel to create these formats using the … [Read more...]
Excel Charting Tip- How To Create A Sales Funnel Or Pipeline Chart
You can download the file for this Excel Tip here. [ddownload id="8204"] See The Video. You can watch the video for this Excel tip here. Sales Funnel or Pipeline charts are increasingly used in Business Intelligence packages and are part of data visualisation on dashboards on a regular basis by most businesses. Even though they used regularly they are not actually pre built into Microsoft Excel. So how can we create one if we use Excel?. With a bit of creativity and the use … [Read more...]
Formula Friday- Find The Most Improved Sales Area With Excel
Download the practice File [ddownload id="7090"] Hello Excellers yet another week has gone and let's finish it with another Formula for Friday. Today we are diving into the arena of the Array Formula with a simple straightforward example where I will show you how to quickly calculate the most improved sales area from one month to the next. In our example we have four sales areas, looked after by four sales people. North, South, East and West Sales for two months- … [Read more...]
Recommended Excel Resources
