Pivot Tables and File Size
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
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
Here is the list of articles I have written about Show Values As in Pivot table. This is a very important set of features but are mostly ignored.
Please read the earlier article about Pct Difference From in order to learn the background. This article shows how to take this one step further.
I am happy to announce that my first detailed training course is now up and running at Udemy. It is about Power BI. But it starts with what you already
You must read this article first: Grouping Text in Pivot Tables. This article explains how to combine multiple text items into a single group. This is used for classifying or
Although Power View and Power BI reports are similar, Microsoft is focusing on the later. Power BI platform is being separated out from Excel for many reasons. One of the
I work with many customers on Power BI. It is a new topic for many users and decision makers (not techies). The benefits of using Power BI are obvious and
This is a very old feature. But it is still very useful. Spend 10 minutes to learn where you should use and not use Range Names in Excel.
Watch this five minute video to understand what we “really” mean by Remove Duplicate Rows in Excel. The default option removes the duplicate rows automatically. Most of us want to
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.
