This blog article provides step-by-step instructions of calculating 'percentage difference from' using Excel pivot table. We will get percentages as result after completing this calculation. The 'percentage difference from' calculation calculates the percentage difference of one item from another it...
This blog article provides step-by-step instructions of allowing entries in Excel worksheet which are not yet part of the data validation. This trick will allow to enter data beyond data validation range. Data validation is used mostly to restrict the type of data. Data validation won't allow to ent...
Slicers are visual filter buttons which enable us to quickly filter data in an interactive way. This blog article contains detailed step-by-step instructions . This is one of the eBooks from the original course on Excel data analysis using Excel pivot table. Slicers can be used both in normal Excel ...
In this blog, you can learn creating Excel charts with double X and double Y axes. Excel charts are quite dynamic in nature, and you can use Excel charts in your advantage by learning the right tricks. I have created an interesting program which covers the basics of creating charts in detail and the...