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 this article about GetPivotData in order to understand the background information.
Estimated reading time 8 min
Continue reading Paste as Pivot – New way to use Pivot table data
Yes. This is a simple rule of efficiency. Of course, this rule is in the context of Office tools. But you never know, try applying it to real life – may be it is equally useful there. Using the example of GetPivotData – we will learn this concept.
Continue reading Irritating feature = Extremely useful 🙂 GetPivotData
Achieve more with less effort by using Office 365 platform efficiently. Learn from the Efficiency Guru, Dr. Nitin Paranjape @drnitinp