This is a series of articles about people like me who deliver demos, conduct workshops and speak at keynotes. I will share what I have learnt about delivering high-impact demos
In the previous article, we saw how to create custom sorting order using a separate month table.Now we will see how a new type of table called Time Table can
Here is the Power Pivot way of customizing sort order for any column. We will continue with the month sorting order example. Read the previous article first. Estimated reading time
If you use text month in a Power Pivot Table, it is sorted in alphabetical order. Here is the solution to the problem. Quick Solution time 2 min Detailed reading
Excel 2013 Professional edition contains two very powerful add-ins – Power Pivot and Power View. Unfortunately, most users who need these features do not even see these in their ribbon.
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!
Thank you for your support and encouragement. This vote is now closed. I have submitted a video which demonstrates the benefits of Power BI. This is a global competition held
This time I wanted to try a new style of writing. I created a presentation instead of the usual document like style. Download presentation and view Download the presentation (300kb)
If you use Pivot Table, then you need PowerPivot! Read on to find out why. If you have never used Pivot Table, you should not read this article. You must
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.
