#MonkeyTools
LightNews LightNews
excelguru.ca
Often, the reason for tracing a query’s dependency chain is to make a change to a child query, and you want to know which queries it could impact. With #MonkeyTools' Query Sleuth, you can do it right within the editor, without opening #PowerQuery! 🤯 Learn more at mkyt.ca/querysleuth

#Excel
Monkey Tools Build better data models, faster Developed by Excelguru Editing Queries with Query Sleuth: The Formula window supports editing and writing back to Power Query, without ever opening the Power Query editor. You can also "pin" your query, allowing you to make changes to multiple queries. (Screenshot of the QuerySleuth window showing the listed queries, the query editing window, and the various display and M code options) monkeytools.ca
November 4, 2026 at 4:48 PM
excelguru.ca
We're very proud of our Monkey Tools add-in, and love hearing from happy users! ❤️
Monkey Tools contains a set of tools to help you build better data models more quickly and follow #DataModeling best practices. Learn more about it at monkeytools.ca

#PowerQuery #DAX #DataAnalyticsTools #DataAnalysis
Monkey Tools Build better data models, faster Developed by Excelguru (Image of a cyborg monkey with its fist up for a fist bump) What do people think of Monkey Tools? "Monkey Tools is by far the best Excel Add-in available. Ken Puls has designed miracles for Power Query and Power BI. If you thought those 2 tools were great, just wait until you try them WITH Monkey Tools. You will never go back!" Sherry Barnes-Fox (headshot of Sherry) Try it for FREE with our 2-week Pro Trial! Go to: monkeytools.ca
September 16, 2026 at 4:15 PM
danskingdom.com
If you live in #Excel and haven't heard of #MonkeyTools, check it out. It's a productivity add-in for Excel. The free version contains most features, and it only manipulates native functionality, so other users will still be able to open your workbooks without issue: monkeytools.ca
What is Monkey Tools?
Monkey Tools is an Excel add-in which will help you build better Data Models, faster. Our Free version contains a ton of useful tools, but you'll be truly amazed at how much productivity you can gain ...
monkeytools.ca
March 31, 2025 at 8:04 PM
excelguru.ca
Curious what all of the various tools in our Monkey Tools #Excel add-in can do and how they work? Sign up for the FREE Using #MonkeyTools course and learn how to get the most from it! You'll also get copies of the example files so you can follow along. 🙊 Sign up today at mkyt.ca/course
Using Monkey Tools Learn about all of the amazing features of Monkey Tools with our FREE course! "Good examples, good chronology and knowledgeable explanations. Ken is good at breaking things down into easy to understand steps." Lynn Mathieson (5 stars) (Image of a cyborg monkey cheering with one fist in the air) Register today at https://mkyt.ca/course
February 4, 2026 at 5:12 PM
excelguru.ca
By default, #MonkeyTools' Query Sleuth displays every query in your solution in the navigation Treeview. 🌳 But if you have a complex solution, the Treeview can get quite busy. This is where the “End Points Only” option helps. Learn more about Query Sleuth at mkyt.ca/querysleuth.

#Excel #PowerQuery
Monkey Tools Build better data models, faster Developed by Excelguru (Image of a cyborg monkey with its fist up for a fist bump) QuerySleuth's "End Points Only" Option This option suppresses any queries which have no precedents or dependents. It can be very useful for eliminating noise, as well as tracing Connection Only queries that are not used at all. (Screenshot of the QuerySleuth dialog with the End Points Only option selected and two queries highlighted. A note says: Since "End Points Only" is checked, these two Connection Only queries are not referenced by anything and can therefore be removed.) monkeytools.ca
January 21, 2026 at 5:12 PM
excelguru.ca
Often, the reason we are trying to trace a query’s dependency chain is because we need to make a change to a child query, and want to know which queries it could impact. With #MonkeyTools' Query Sleuth, you can do it right in the editor, without opening #PowerQuery! 🤯 Learn more: mkyt.ca/querysleuth
Monkey Tools Build better data models, faster Developed by Excelguru (Image of a cyborg monkey with its fist up for a fist bump) Editing Queries with Query Sleuth The Formula window supports editing and writing back to Power Query, without ever opening the Power Query editor. You can also "pin" your query, allowing you to make changes to multiple queries. (Screenshot of the QuerySleuth dialog with part of a query highlighted in the editor area) monkeytools.ca
December 31, 2025 at 5:04 PM
excelguru.ca
Our "Halfway to Monkey Day" special continues until June 20! Save 20% on an Annual or Lifetime Pro license for our #MonkeyTools add-in. 🐵🛠 It's the only tool on the market which can import a model from #PowerBI back into #Excel!

Don't miss out, go to monkeytools.ca and use code MONKEYAROUND
(Image of 2 monkeys facing each other and reaching towards the centre, both sitting on a leaf) June 14 is halfway to International Monkey Day! Use this code to save 20% on an Annual or Lifetime Monkey Tools License: MONKEYAROUND Got to monkeytools.ca An Excel add-in by Excelguru (Excelguru logo) Valid June 13-20, 2025
June 18, 2025 at 5:07 PM
excelguru.ca
This may be my favourite course to deliver! I recorded a bunch of new videos, most to help students leverage my #MonkeyTools add-in when they're working with a data model, but some also cover #DAX concepts that have come up in several of the 'Ask Ken Anything' support calls that are included.
skillwave.training Skillwave Training @skillwave.training · Jun 4
We've just added 15 new lessons to @excelguru.ca's #SelfServiceBI Academy! Are you ready to take your reporting to the next level with #Excel and #PowerBI? Learn how to build robust #BusinessIntelligence solutions, and get live support from Ken. Next kick-off is June 11, go to skw-t.com/ssbi
June 4, 2025 at 4:39 PM
excelguru.ca
By default, #MonkeyTools' Query Sleuth displays every query in your solution in the navigation Treeview. 🌳 But if you have a complex solution, the Treeview can get quite busy. This is where the “End Points Only” option helps. Learn more about Query Sleuth at mkyt.ca/querysleuth.

#Excel #PowerQuery
Monkey Tools Build better data models, faster Developed by Excelguru (Image on right of a cyborg monkey with its arm up for a fist bump) QuerySleuth's "End Points Only" Option This option suppresses any queries which have no precedents or dependents. It can be very useful for eliminating noise, as well as tracing Connection Only queries that are not used at all. (Screenshot of the QuerySleuth screen highlighting Connection Only queries and text saying: Since "End Points Only" is checked, these two Connection Only queries are not referenced by anything and can therefore be removed.
April 16, 2025 at 4:09 PM
excelguru.ca
Today is the last day of our #MonkeyTools 5th anniversary special! 🥳
Until midnight tonight, save 20% on an Annual or Lifetime Pro license, just go to mkyt.ca/5years and use code MONKEY5
Plus, anyone with a Lifetime or Annual license has a chance to win access a @skillwave.training course!
5th Anniversary of Monkey Tools Save 20% on an Annual or Lifetime Pro License Use code: MONKEY5 Valid March 24-28, 2025 monkeytools.ca 5th Anniversary of Monkey Tools Your chance to win! All Lifetime Pro Licenses = Entry for 1 year of Self Service BI Academy (a $995 value) All Annual Pro Licenses = Entry for 1 year of Power Query Academy ($350 value) Anyone with an active Lifetime or Annual license on March 28, 2025 will be automatically entered into the draw.
March 28, 2025 at 4:21 PM
excelguru.ca
Here's our final installment of our 5 cool things you can do with #MonkeyTools series, and it's a banger! 🙉
5️⃣ You can import #PowerBI files into an #Excel workbook!
PS, you have until midnight to save 20% on an Annual or Lifetime Pro license. Go to mkyt.ca/5years and apply code MONKEY5
5th Anniversary of Monkey Tools 5 Cool Things You Can do with Monkey Tools #5: Import Power BI Desktop files into an Excel workbook (screenshot of Import Monkey dialog)
March 28, 2025 at 8:43 AM
excelguru.ca
🐒 This #MonkeyTools tip is perfect to help answer forum questions:
4️⃣ Create a new query from a sample of M code, which gets indented automatically.
Save 20% on an Annual or Lifetime license until March 28. Go to mkyt.ca/5years and use code MONKEY5. You could also win a @skillwave.training course!
5th Anniversary of Monkey Tools 5 Cool Things You Can do with Monkey Tools #4: Simple creation of queries to build healthy Power Pivot models (Screenshot of Create Query from M Code tool) monkeytools.ca
March 27, 2025 at 7:32 PM
excelguru.ca
🙉Continuing our series on 5 cool things you can do with #MonkeyTools:
3️⃣ Store your formulas, queries, measures, LAMBAs, and more so you can easily reuse them in any workbook!
Save 20% on an Annual or Lifetime Pro license until Mach 28. Go to mkyt.ca/5years and use code MONKEY5.
5th Anniversary of Monkey Tools 5 Cool Things You Can do with Monkey Tools #3: Storing formulas, queries, measures, LAMBDAs, and more for easy use in other workbooks (screenshot of BiblioMonkey) monkeytools.ca
March 26, 2025 at 4:07 PM
excelguru.ca
🐵 5 cool things you can do with #MonkeyTools:
2️⃣ We've added an option to Centre Across Selection onto the #Excel merge menu!

Until March 28, save 20% on an Annual or Lifetime Pro license with code MONKEY5, go to mkyt.ca/5years
You'll also be entered into a draw for a @skillwave.training course.
5th Anniversary of Monkey Tools 5 cool things you can do with Monkey Tools #2: Centre Across Selection on your #Excel merge menu (gotta love the little things!) (Screenshot of the merge options on the Excel ribbon) monkeytools.ca
March 25, 2025 at 4:24 PM
excelguru.ca
🐵 5 cool things you can do with #MonkeyTools:
1️⃣ Name your #Excel table right when you create it!

Until March 28, 2025, save 20% on an Annual or Lifetime Pro license with code MONKEY5, go to mkyt.ca/5years
You'll also be entered into a draw for a @skillwave.training course.
5th Anniversary of Monkey Tools 5 cool things you can do with Monkey Tools #1: Name your Excel tables when creating them (Screenshot of the Create Table/Named Range dialog) monkeytools.ca
March 24, 2025 at 8:22 PM
excelguru.ca
Today marks 5 years since our #MonkeyTools #Excel add-in was officially launched! 🥳To celebrate, we're offering a 20% discount on Annual or Lifetime licenses. From now until March 28, use code MONKEY5 at checkout - go to mkyt.ca/5years

Plus, you get a chance to win a @skillwave.training course.🐵
5th Anniversary of Monkey tools Save 20% on an Annual or Lifetime Pro License! Use code: MONKEY5 Valid March 24-28, 2025 monkeytools.ca 5th Anniversary of Monkey Tools Your chance to win! All Lifetime Pro Licenses = Entry for 1 year of Self Service BI Academy (a $995 US value) All Annual Pro Licenses = entry for 1 year of Power Query Academy (a $350 US value) Anyone with an active Lifetime or Annual license on March 28, 2025 will automatically be entered into the draws.
March 24, 2025 at 3:31 PM
excelguru.ca
Often, we trace a query’s dependency chain because we need to make a change to a child query, and want to know which queries it could impact. With #MonkeyTools' Query Sleuth, you can do it right within the editor, without ever opening #PowerQuery! Learn more: buff.ly/TZrROfZ
Monkey Tools Build better data models, faster Developed by Excelguru Editing Queries with Query Sleuth: The Formula window supports editing and writing back to Power Query, without ever opening the Power Query editor. You can also "pin" your query, allowing you to make changes to multiple queries.
March 19, 2025 at 4:55 PM
excelguru.ca
When #DataModeling in #Excel, do you prefer to create a separate (disconnected) table for measures? Get the Measure Table Monkey to do it! Just provide a table name, click OK, and then hide a column. Learn more: mkyt.ca/measuretbl
#PowerQuery#MonkeyTools
Monkey Tools: Build better data models, faster Developed by Excelguru Measure Table Monkey: Many modelers like to store their measures on a single "Measures" table in the data model. If you're one of them, you may appreciate the ability to quickly add a disconnected measure table to your date model for this purpose. Thanks to the Measure Table Monkey, this is quite easy!!
March 12, 2025 at 4:16 PM
excelguru.ca
Curious what all of the various tools in our Monkey Tools #Excel add-in can do and how they work? Sign up for the FREE Using #MonkeyTools course and learn how to get the most from it! You'll also get copies of my example files, so you can follow along. 🙊 Sign up today at https://buff.ly/4i8kpzg
January 22, 2025 at 5:31 PM
excelguru.ca
I'm honoured that Monkey Tools was chosen a finalist in the Best #Excel Add-in category for the 2025 Global Excel Awards!

If you're a #MonkeyTools fan, we'd love if you'd and cast a vote to help us win. 🙏 Voting is open until Jan 19, mkyt.ca/vote2025

(Repost, date incorrect in original image)
January 16, 2025 at 8:58 PM
excelguru.ca
As you may have heard, Monkey Tools is a finalist in the Best #Excel Add-in category for the 2025 Global Excel Awards! 🥳

If you're a #MonkeyTools fan, you can cast a vote to help us win. 🐵 Voting is open until January 19, 2025. Just go to mkyt.ca/vote2025

#ExcelTool #BusinessIntelligenceTools
January 9, 2025 at 8:33 PM
excelguru.ca
Of all the thing I thought I'd be doing in early 2025, installing a French version of Windows with a French version of Office wasn't exactly on my bingo card - and yet... 🤔 As of version 1.0.9138.30898, I think I've finally got #MonkeyTools BiblioMonkey inserting localized LAMBA/Formulas properly
January 8, 2025 at 5:37 PM
excelguru.ca
#MonkeyTools 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. Learn more:
Excel Feature Improvements
Monkey Tools offers several Excel feature improvements to build a better user experience, but each can be turned off if desired.
buff.ly
December 23, 2024 at 6:16 PM
excelguru.ca
I'm super excited that Monkey Tools has been nominated as one of the 2025 finalists for BEST Microsoft #Excel Add-in! 🙊
If you love #MonkeyTools, you can help us out by voting for it here: https://buff.ly/3ZGepoZ
💖
December 19, 2024 at 5:32 PM
excelguru.ca
I'm excited to say that monkeytools.ca has been nominated as one of the 2025 finalists for BEST Microsoft #Excel Add-in. 🙊
If you love #MonkeyTools, we could really use your help... please consider voting for it here: globalexcelsummit.com/global-excel...
💖
December 12, 2024 at 6:31 PM