Cross-tab data is where you have row headings as well as column headings. Consolidating (combining) multiple blocks of such data is a laborious process. Usually the rows and columns do
I am happy to announce a new, comprehensive course on Pivot Tables on Udemy. As a special benefit to blog readers, I am including a promo code for FREE access
This is a sneak preview of my upcoming Udemy course on Pivot Tables. This video explains the relationship between Pivot Tables and File Size. Watch this 6 minutes video and
I wrote an article about Data Audit using Pivot long back. Now, I have converted it to a comprehensive video. Have a look: How to perform Data Audit using Pivot
Yes. This is possible. Just add Pivot Charts from the Analyze (or Options) menu of Pivot Table. Multiple charts can be added. Choose different visualization for each chart to get
Refer to the previous post. We saw how Filter fields can be exploded into individual sheets and files. In this article, I am releasing a macro – which does all
Suppose you have Products in Filter area and Pivot Table shows Regional Sales by Month. There are 5 products. You want five sheets for each product separately- this is called
Please read the previous article first. Filters are not just for filtering. They also convey additional information. Very useful feature. Check this out. Estimated reading time 10 min
All of us use the Filter area in Pivot Tables. Do you know there is a more powerful way that has been available for 5 years? Learn it and use
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.
