If you use Office 365 Pro Plus and Excel 2016, you should see a new tab under File – Options. The Data tab. This has many useful features which help
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.
A simple but very useful method. All of us use AutoFilter in Excel. The dropdown shows unique values in the column. Sometimes we just want to see the rows with
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
Data Analysis and Reports has been a major theme for my articles so far. Here is a collection of 50+ articles, categorized and sorted in the recommended reading order. Enjoy!
Very common problem. Very easy solution. Deserves a separate article. This alone can save hundreds of thousands of person years of drudgery globally every day. This article shows the problem
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.
