Calculating 'Percentage difference from' in pivot table

access_time 2024-11-12T12:20:32.271Z face Rajesh Pathak
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...

Allow entries in Excel that are not part of data validation

access_time 2024-11-10T12:58:10.43Z face Rajesh Pathak
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...

Insert slicers in Excel

access_time 2024-11-06T03:34:24.364Z face Rajesh Pathak
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 ...

CHART WITH DOUBLE X AND DOUBLE Y AXES

access_time 2024-10-15T12:44:07.382Z face Rajesh Pathak
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...
Launch your GraphyLaunch your Graphy
100K+ creators trust Graphy to teach online
Specialskills.in 2024 Privacy policy Terms of use Contact us Refund policy