Unbelievable analytics using Excel: Here is a quick overview of how we can analyze data more effectively using new Excel
Here is the Power Pivot way of customizing sort order for any column. We will continue with the month sorting
If you use text month in a Power Pivot Table, it is sorted in alphabetical order. Here is the solution
Reports generated from business applications often become inputs to new reports. You end up spending too much time cleaning them
Let us explore numeric grouping in Pivot Table with the Ageing Analysis scenario. Estimated reading time 7 min Estimated time saving
Bin or Bucket Analysis is a common requirement. We will see how easy this is using Grouping feature of Pivot
Grouping in Pivot table is one method of spelling mistakes correction. Here is another option for correcting mistakes using VLOOKUP.
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.