Formula Bar Monkey
Article Overview When writing formulas in Excel, users often create a lot of indented formulas. One of the things that kind of drives us nuts is when a cell containing a multi-line formula is selected, you only see the first line. It’s not immediately obvious that there are multiple lines unless you actually very specifically […]
Indent Formula Monkey
Article Overview When building Excel solutions, one of the things we really like to do is indent our formulas. It makes them more readable and easier to understand, which definitely helps in the debugging stage. Unfortunately, this is a manual process in Excel. You have to press Alt+Enter for every line break, and you have […]
Letify Monkey
Article Overview More and more, we’ve been taking advantage of the LET() function when writing our Excel formulas. We find that it makes the formulas easier to read, faster to calculate, and much easier to debug because you can control the final step and control an intermediate calculation very easily. However, it can be tricky […]
Excel Feature Improvements
Article Overview Monkey Tools offers several Excel feature improvements to build a better user experience. While the vast majority of these features are custom-built to expand Excel’s functionality, there are a few which actually replace Excel’s built-in functionality. Of course, while we believe our updated features are better than the defaults, you may want the […]
Connection Monkey
Article Overview The Connection Monkey is your one stop shop in order to connect to the various Excel workbooks or Power BI models that Monkey Tools can analyze. While many of Monkey Tools forms will automatically connect to the active workbook by default when opened, there are times you may wish to connect Monkey Tools […]
Options Monkey
Article Overview What is an application with Options? Monkey Tools is no difference, and we have a specific Options Monkey to help you control them all. This article discusses how this particular Monkey works, as well as explains what some of the options actually do. The Options Monkey’s Version Tab Version Info In this section, […]
Export Model Data
Coming Soon! Sorry, but this article isn’t quite ready yet. We promise that we’re working on it! In the mean time, we did feature this in the May 2022 “What’s New in Monkey Tools” video published on YouTube which you can watch below: Share: Facebook Twitter LinkedIn Related Posts
Export Model Components
Coming Soon! Sorry, but this article isn’t quite ready yet. We promise that we’re working on it! In the mean time – until we get this article updated – there is some documentation on this feature in our legacy Install and Features Guide. Download our Legacy Install & Features Guide Finding this feature… This feature […]
Import Monkey
Coming Soon! Sorry, but this article isn’t quite ready yet. We promise that we’re working on it! In the mean time – while you wait for us to write up the full article – you may want to check out the demo that Ken did of this feature on Reid Havens webcast. It is available […]
DAX Table Monkey
Article Overview While PivotTables and PivotCharts are a useful and valid way to summarize your data, sometimes you want a good old table. While it has been possible to do this with Power Pivot-backed data models since day 1 of Power Pivot, it has required some black magic and DAX knowledge to make it happen. […]