Unbelievable analytics using Excel: Here is a quick overview of how we can analyze data more effectively using new Excel
This is a very common and dangerous inaccuracy. Big operational risk! Check all your dates imports after reading this article.
In the previous article, we saw how to create custom sorting order using a separate month table.Now we will see
Here is the Power Pivot way of customizing sort order for any table. Read the previous article first. Estimated reading
If you use text month in a Power Pivot Table, it is sorted in alphabetical order. Here is the solution