#MonkeyTools

Ken Puls, FCPA, MS MVP

@excelguru.ca

1 month ago

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

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

Ken Puls, FCPA, MS MVP

@excelguru.ca

1 month ago

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

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

Ken Puls, FCPA, MS MVP

@excelguru.ca

2 months ago

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

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

Ken Puls, FCPA, MS MVP

@excelguru.ca

8 months ago

(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

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

Ken Puls, FCPA, MS MVP

@excelguru.ca

9 months ago

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.

Ken Puls, FCPA, MS MVP

@excelguru.ca

10 months ago

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.

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

Patrick Matthews

@matthewsp.bsky.social

11 months ago

sickos meme

SCreen grab from the MonkeyTools add-in for Excel, showing a complicated Excel LAMBDA expression

More #Excel LAMBDA nerdery aided and abetted by @excelguru.ca's fantastic #MonkeyTools

Daniel Schroeder | aka deadlydog

@danskingdom.com

11 months ago

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 ...

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

Skillwave Training

@skillwave.training

11 months ago

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.

Don't forget, the #MonkeyTools 5th anniversary special ends at midnight tonight! 🌟
Save 20% on an Annual or Lifetime Pro license at mkyt.ca/5years when you use code MONKEY5
Plus, anyone with a Lifetime or Annual license will be entered into a draw to win access to one of our courses!

Ken Puls, FCPA, MS MVP

@excelguru.ca

11 months ago

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.

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!

Ken Puls, FCPA, MS MVP

@excelguru.ca

11 months ago

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)

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

Ken Puls, FCPA, MS MVP

@excelguru.ca

11 months ago

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

🐒 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!

Ken Puls, FCPA, MS MVP

@excelguru.ca

11 months ago

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

🙉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.

Ken Puls, FCPA, MS MVP

@excelguru.ca

11 months ago

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

🐵 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.

Ken Puls, FCPA, MS MVP

@excelguru.ca

11 months ago

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

🐵 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.

Skillwave Training

@skillwave.training

11 months ago

5th Anniversary of Monkey tools Save 20% on an Annual or Lifetime Pro License! Use code: MONKEY5 Valid March 24-25, 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.

Today marks 5 years since @excelguru.ca's #MonkeyTools #Excel add-in was officially launched! 🥳He's offering a 20% discount on Annual or Lifetime Pro license purchases. From now until March 28, use code MONKEY5 at checkout - go to mkyt.ca/5years
Plus, get entered into a draw for a Skillwave course.🐵

Ken Puls, FCPA, MS MVP

@excelguru.ca

11 months ago

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.

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.🐵

Ken Puls, FCPA, MS MVP

@excelguru.ca

11 months ago

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.

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

Ken Puls, FCPA, MS MVP

@excelguru.ca

1 year ago

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

Ken Puls, FCPA, MS MVP

@excelguru.ca

1 year ago

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)

Ken Puls, FCPA, MS MVP

@excelguru.ca

1 year ago

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

Ken Puls, FCPA, MS MVP

@excelguru.ca

1 year ago

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

Ken Puls, FCPA, MS MVP

@excelguru.ca

1 year ago

Excel Feature Improvements Monkey Tools offers several Excel feature improvements to build a better user experience, but each can be turned off if desired.

#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:

Ken Puls, FCPA, MS MVP

@excelguru.ca

1 year ago

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
💖

Ken Puls, FCPA, MS MVP

@excelguru.ca

1 year ago

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...
💖

Ken Puls, FCPA, MS MVP

@excelguru.ca

1 year ago

If you've been considering a Lifetime License for our #MonkeyTools #Excel add-in, don't wait! The current price is $349 US, but it's going up to $399 US starting Sept 1, 2024. 🙊 You get unlimited access to all Monkeys, Sleuths, updates, and the ability to import from #PowerBI. Go to monkeytools.ca

Ken Puls, FCPA, MS MVP

@excelguru.ca

1 year ago

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 ...

Just used monkeytools.ca SCD2 Monkey to set up a Type 2 Slowly Changing Dimension for a data model... and it is taking me longer to write this message than it did to make it happen. Damn... I impress myself sometimes! 🤣 #MonkeyTools #Excel #PowerQuery #PowerPivot #UnleashAMonkeyToday