Modern Pivot Monkey
Article Overview The Modern Pivot Monkey’s goal is to help you quickly take a classic PivotTable and create an upgraded Data Model-backed PivotTable, opening the abilities to: Leverage the power of DAX measures. Perform source data filtering and cleansing via Power Query. Expand the data model’s logic, enhancing the analytic output. In this article, we’ll […]
From Table or Range Monkey
Article Overview One of the things we have been asking the Excel team to do for a long time is give us the ability to provide a table name during the creation process. This is particularly important when using the Get Data From Table/Range feature, as this feature creates a generic table (or dynamic array) […]
Biblio Monkey
Article Overview If you’ve worked with Excel for any length of time, chances are pretty good that you have some favourite Power Queries, DAX Measures, VBA, or formulas. And if you are like many users, you store those in a Notepad document for easy copying and pasting. Biblio Monkey aims to change that for you, […]