About A library with many useful functions for assisting on EXCEL VBA coding ...

Excel VBA Functions Package for Business Data Analysts. VBA has a reputation among some for being a "step child" programming language, however it enables practitioners to deliver real value to their ...

Build a custom Excel function library in minutes! Learn how to use VBA, create a personal macro workbook, and design a custom ribbon tab.

In this guide, I will start with VBA basics and give you practical examples of utilizing custom functions to unlock a whole new level of Excel mastery.

Greg Galloway has done some really cool things on the Analysis Services Stored Procedure Project which I’ll be blogging about soon, but in the meantime as part of his research he’s found an ...

Some of you may be aware that a few VBA functions have been implemented as native MDX functions to improve performance. I blogged about this a few years ago, but I’ve now received an up-to-date lis… ...