Pivot : Show Values As – Part 3
This article shows how to find difference from a specific value to other values in a Pivot Table. % Difference From is a very powerful way to understand your data more
This article shows how to find difference from a specific value to other values in a Pivot Table. % Difference From is a very powerful way to understand your data more
We continue to explore Show Values As options in Pivot Tables. We will see the practical application of these options as well. Estimated reading time 10 min
Why do we add formulas outside Pivot Tables? Because we think Pivot Table cannot do the calculation. Did you ever check if it can? Or did you just ASSUME? Here
Current fashion is about Big Data and Analytics. One related term is very popular – Excel Dashboards. Let us start understand the concept first and then explore the benefits and
ODB is like My Documents on the internet. You store your files there and share it with people. But how will you know as to who can edit what? Estimated
The question is simple. How to delete notes across all the slides in the most efficient way? The answer will not only surprise you, it will protect your interests. Estimated
The new Read Mode converts Word into a book reader. It is convenient, easy on the eyes and powerful. Estimated reading time 10 min
Here is a simple test. Suppose you have a presentation with 60+ slides. Many slides have notes. You want to send the presentation to a customer. But the notes contain
I created this Paste as Pivot utility (macro) along with Raj Chaudhuri. It helps you in copying cells from Pivot Table and pasting them as GetPivotData functions. You must read
Yes. You use Pivot Tables everyday. Now it is time to find out the real power and nuances. 5.5 hours video, exercises, samples, Q&A.
Learn Power BI using the concepts you already know in Excel. Fast transition, in-depth coverage and immediately usable.
