We get data and make reports repeatedly. Often we forget to look at the same data in different ways. Due
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.
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