In this post, I describe a quick way to list all the DAX formulas in your PowerPivot for Excel 2010 Data model.
Excel Tables make analyzing data, a breeze. It surprises me that it is not used as often as it should. It automatically “includes” new data you add to your spreadsheets, it automatically drags down formulas for you, it automatically formats the tables for you. In addition to that, you can use structured references that make your formulasContinue reading “Magically Format Tables in Excel using VBA”