Category: VBA / Macros
August 16, 2016
Power BI Passes VBA in Popularity
Observations, Trends, and Wild Speculation
April 16, 2015
Jump between pivots with context
Design, Usability, and Appearance
October 2, 2014
5 Interactive Chart Techniques Come Together
Cube Formulas
August 5, 2014
A Neat Trick/Macro for More Readable Pivots
Design, Usability, and Appearance
July 17, 2014
Adding tables to a Power Pivot model from VBA (in Excel 2013)
Excel 2013
June 10, 2014
Manipulating Relationships in VBA (in 2013)
Relationships
November 12, 2013
Custom Toooltips in Dashboards!
Creative Visualizations
October 2, 2012
Display User’s Slicer Selections: A Macro to Automatically Create the Formulas
Design, Usability, and Appearance
September 18, 2012
Combine Multiple Worksheets/Workbooks into a Single PowerPivot Table
Importing Data
July 26, 2012
Implementing a Dynamic Top X via slicers in Excel 2013 using DAX queries and Excel Macros
DAX