Stop working for your data. Make your data work for you.

Recently, I looked at how Monarch builds range names when exporting to Excel, and then some examples of how we can use those range names in Excel functions. Today we’ll look at the process of having Monarch create an Excel dashboard report workbook and how we can begin to easily add dramatic functionality to that [...]

In the previous post, The Secret is in the Names, I wrote about how Monarch populates Excel files with useful named ranges when exporting data. Today we’ll look at how we can capitalize on those named ranges with specific Excel functions. In that previous post, the first point regarding the range names is that Monarch [...]