#DataAnalyticsTools
LightNews LightNews
excelguru.ca
On the first Monkey Shorts episode, I showed the first #PowerQuery setting I change when I install #Excel - the query load destination. 🐵🩳 www.youtube.com/watch?v=ZAY7...

#ExcelTipsAndTricks #BusinessIntelligenceTools #DataAnalyticsTools
Changing Excel's Power Query Load Defaults - Monkey Shorts Episode 001
In this episode, Ken shows the first Power Query setting he changes when he installs Excel.
www.youtube.com
November 6, 2026 at 5:09 PM
skillwave.training
On the first Monkey Shorts episode, @excelguru.ca showed the first #PowerQuery setting he changes when he installs #Excel - the query load destination. 🐵🩳 www.youtube.com/watch?v=ZAY7...

#ExcelTipsAndTricks #BusinessIntelligenceTools #DataAnalyticsTools
Changing Excel's Power Query Load Defaults - Monkey Shorts Episode 001
In this episode, Ken shows the first Power Query setting he changes when he installs Excel.
www.youtube.com
November 5, 2026 at 5:26 PM
excelguru.ca
The QuerySleuth feature of our Monkey Tools #Excel Add-in is a must-have for every #PowerQuery user. It automatically indents and wraps your M code, and highlights the syntax by colour. 🤓 (However, you can adjust these options as you prefer.)
Learn more at mkyt.ca/querysleuth

#DataAnalyticsTools
Monkey Tools Build better data models, faster Developed by Excelguru (Image of a cyborg monkey with its fist up for a fist bump) QuerySleuth This feature indents and beautifies your M code by default, although you can certainly toggle these settings if you prefer Power Query's default display styles! (Screenshot of QuerySleuth with sample M code that is indented and colour-coded) monkeytools.ca
October 21, 2026 at 5:15 PM
excelguru.ca
Unsure what Monkey Tools can actually do for you? 🐵⚒️
I have a FREE Using Monkey Tools course available through our @Skillwave.Training site, where I explain all the different tools and features that will help with your #DataModeling. Enroll today at mkyt.ca/course

#ExcelTools #DataAnalyticsTools
Using Monkey Tools Learn about all of the amazing features of Monkey Tools with our FREE course! "Honestly - it's just so impressive. So many moments of "Wow", or "That's Awesome". Favorite sections were the Biblio Monkey and the slowly changing dimension." John Garnier (5 stars) (Image of a cyborg monkey cheering with its fist raised and eyes closed) Register today at https://mkyt.ca/course
October 14, 2026 at 5:05 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
excelguru.ca
In this week's episode of Monkey Shorts 🐵🩳, I look at how we can split text into columns or rows using #PowerQuery, and why you may want to do the latter: www.youtube.com/watch?v=3hPM...

#Excel #PowerBI #DataAnalyticsTools #DataPreparation #DataTransformation
Splitting Records with Power Query - Monkey Shorts Episode 040
In this week's episode of Monkey Shorts, Ken looks at how we can split text into columns or rows using Power Query, and why you may want to do the latter.
www.youtube.com
August 21, 2026 at 5:02 PM
skillwave.training
In this week's episode of Monkey Shorts 🐵🩳, @excelguru.ca looks at how we can split text into columns or rows using #PowerQuery, and why you may want to do the latter: www.youtube.com/watch?v=3hPM...

#Excel #PowerBI #DataAnalyticsTools #DataPreparation #DataTransformation
Splitting Records with Power Query - Monkey Shorts Episode 040
In this week's episode of Monkey Shorts, Ken looks at how we can split text into columns or rows using Power Query, and why you may want to do the latter.
www.youtube.com
August 20, 2026 at 4:16 PM
excelguru.ca
Unsure what Monkey Tools can actually do for you? I have a FREE Using Monkey Tools course available through our @Skillwave.Training site. I explain all of the different tools and features that will help with your #DataModeling. Enroll today at mkyt.ca/course

#ExcelTools #DataAnalyticsTools
Using Monkey Tools Learn about all of the amazing features of Monkey Tools with our FREE course! "I found the approach of taking each feature and explaining everything about it very helpful... I feel that I have walked away with a great understanding of all the features and how they can be used." Kevin Duke (5 stars) (Image of a cyborg monkey cheering with his eyes closed and fist pumping in the air) Register today at https://mkyt.ca/course
August 19, 2026 at 4:40 PM
skillwave.training
Save yourself hours of time and manual effort! With #PowerQuery, you can master #DataCleaning and transformation in order to automate you #BusinessIntelligence in #Excel and #PowerBI. 🙌 Get started today with our FREE intro course: skw-t.com/pqfun
#DataPreparation #DataAnalysis #DataAnalyticsTools
Start Mastering Your Data with our Free Intro Course! Power Query Fundamentals for Excel and Power BI "It is thorough!" - Enrique M. "I loved being able to follow with examples and sample files." - Abdellah B. skillwave.training (Skillwave Training logo)
August 14, 2026 at 4:44 PM
excelguru.ca
I love hearing from happy students! 💖
If you want to learn how our army of monkeys can help you build better #Excel models, sign up for the free Using Monkey Tools course at mkyt.ca/course
🐒 Get your free 2-week Monkey Tools Pro trial at monkeytools.ca

#DataModeling #DataAnalyticsTools #PowerQuery
July 15, 2026 at 4:07 PM
excelguru.ca
Level up your #PowerQuery documentation game by adding Emojis and info icons to your Power Query steps. 😎The Data Monkey and I will show you how in this latest episode of Monkey Shorts! www.youtube.com/watch?v=PazQ...

#Excel #PowerBI #DataAnalyticsTools
Use Emojis in Power Query Step Names - Monkey Shorts Episode 018
Level up your Power Query documentation game by adding Emojis and info icons to your Power Query steps.
www.youtube.com
March 20, 2026 at 5:05 PM
excelguru.ca
Subscribe to the AKAs today at skw-t.com/aka, or get access included with our #SelfServiceBI (skw-t.com/ssbi) or #Excel Fundamentals (skw-t.com/excelfun) Academies.

#FinancialAnalytics #DataAnalysis #BusinessIntelligence #PowerPivot #DataAnalyticsTools
Ask Ken Anything
Get more than just a course – get access to an expert who will help you build real world solutions. The Ask Ken Anything (AKA) sessions are live, interactive coaching calls that are held twice each…
skw-t.com
February 24, 2026 at 5:37 PM
excelguru.ca
Not satisfied with Compact Form for your #Excel PivotTables? Tired of changing it to your preferred format every time you create one? There's a better way! In this video, I'll show you how to modify your #PivotTable defaults: www.youtube.com/watch?v=eCut...

#DataAnalyticsTools #BusinessIntelligence
Setting PivotTable Defaults - Monkey Shorts Episode 008
Not satisfied with Compact Form for your Excel PivotTables? Tired of changing it to your preferred format every time you create one? There's a better way! In this video, Ken shows you how to modify…
www.youtube.com
January 9, 2026 at 5:12 PM
excelguru.ca
In this Monkey Shorts video 🐵🩳, I'll show you how #PowerQuery's 'Column Profiling' tools work, and how I set my defaults for every day use: www.youtube.com/watch?v=QtOw...

#Excel #PowerBI #DataAnalyticsTools #DataPreparation #DataAnalysis #BusinessIntelligence
Column Profiling in Power Query - Monkey Shorts Episode 005
In this episode, Ken shows how Power Query's 'Column Profiling' tools work, and how he sets his defaults for every day use.
www.youtube.com
December 19, 2025 at 5:30 PM
excelguru.ca
Ever noticed that you have to refresh your #PowerQuery twice in order to get the changes to show up in your #Excel #PivotTable? In this episode of Monkey Shorts, I'll show you how to fix this issue. 👏
www.youtube.com/watch?v=gTtt...

#DataPreparation #DataAnalyticsTools #BusinessIntelligenceTools
One click refresh of Power Query based Pivot Tables - Monkey Shorts Episode 002
Ever noticed that you have to refresh your Power Query twice in order to get the changes to show up in your Pivot Table? In this Episode of Monkey Shorts, Ken will show you how to fix this issue.
www.youtube.com
November 28, 2025 at 9:46 PM
excelguru.ca
When you first open Query Sleuth in our Monkey Tools #Excel Add-in, you’ll notice that your queries are colour coded with up to four different colours: 🟠🟡🔵🟢 This adds a bit of extra insight around the query load destinations. Learn more at mkyt.ca/querysleuth

#PowerQuery #DataAnalyticsTools
Monkey Tools Build better data models, faster Developed by Excelguru (Image of a cyborg monkey with its fist up for a fist bump) Query Sleuth Queries are colour coded to add a bit of extra insight. By default: - Yellow = Query is loaded as a "Connection Only" - Green = Query is loaded to the data model - Blue = Query is loaded to an Excel table - Orange = Query is loaded to both the data model and an Excel table (Screenshot of the Query Sleuth dialog with a listing of colour coded queries) monkeytools.ca
November 5, 2025 at 5:16 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 Try it for FREE with our 2-week Pro Trial! Go to: monkeytools.ca
October 22, 2025 at 4:24 PM
excelguru.ca
🔎QuerySleuth is a must-have for every #PowerQuery user. Developed based on a real business need, we believe this form will add magic to your ability to trace query dependencies and precedents. And it does it all without locking your #Excel UI! Learn more: mkyt.ca/querysleuth

#DataAnalyticsTools
Monkey Tools Build better data models, faster Developed by Excelguru (Image of a cyborg monkey with its fist up for a fist bump) QuerySleuth TreeView allows you to easily browse your queries. And you can quickly flip between showing precedents (the default view), dependents, or turn the tracking off entirely if needed. Plus, when looking at the M code of a query, any precedent queries are highlighted right in the code. (Screenshot of the TreeView in QuerySleuth with the various queries highlighted by colour code) monkektools.ca
October 15, 2025 at 4:15 PM
excelguru.ca
The Monkey Tools ribbon was designed with one goal in mind: to make you more efficient when building queries and/or data models. Learn how to customize or personalize the Monkey Tools tab at mkyt.ca/customtab

#Excel #PowerQuery #DataModeling #BusinessIntelligence #DataAnalyticsTools #DataAnalysis
Monkey Tools Build better data models, faster Developed by Excelguru (Image of a cyborg monkey with it's fist up for a fist bump) Customize the Monkey Tools Tab To add a custom group to our ribbon tab, right click any ribbon tab and choose Customize the Ribbon. This will launch an Excel Options screen, where you will need to: 1. Select the Monkey Tools tab on the right 2. Click New Group 3. Select the group 4. Click Rename... 5. Enter the name 6. Click OK Then you can add as many commands to the group as you like! (Screenshot of the Excel Options screen with the above-numbered items highlighted) monkeytools.ca
October 1, 2025 at 4:43 PM
excelguru.ca
Unsure what Monkey Tools can actually do for you? I have a FREE Using Monkey Tools course at @Skillwave.Training where I explain all of the different tools and features that will help with your #DataModeling. Enroll today at mkyt.ca/course

#ExcelTools #DataAnalyticsTools #BusinessIntelligenceTools
Using Monkey Tools Learn about all of the amazing features of Monkey Tools with our FREE course! (Image of a cyborg monkey jumping up with eyes closed and right fist raised in celebration) Test in speech bubble: "I found the approach of taking each feature and explaining everything about it very helpful... I feel that I have walked away with a great understanding of all the features and how they can be used." Kevin Duke (5 stars) Register today at https://mkyt.ca/course
September 24, 2025 at 4:32 PM
excelguru.ca
In this episode of Monkey Shorts, I look at how we can split text into columns or rows using #PowerQuery, and why you may want to do the latter. 🐒
www.youtube.com/watch?v=3hPM...

#Excel #PowerBI #DataPreparation #DataAnalyticsTools
Splitting Records with Power Query - Monkey Shorts Episode 040
In this week's episode of Monkey Shorts, Ken looks at how we can split text into columns or rows using Power Query, and why you may want to do the latter.
www.youtube.com
September 5, 2025 at 4:40 PM
excelguru.ca
Unsure what Monkey Tools can actually do for you? I have a FREE Using Monkey Tools course available through our @skillwave.training site. I explain all of the different tools and features that will help with your #DataModeling. Enroll today at mkyt.ca/course

#ExcelTools #DataAnalyticsTools
June 25, 2025 at 6:44 PM
excelguru.ca
Don't miss out - it's the last day of the "Halfway to Monkey Day" special on our Monkey Tools #Excel add-in. 🙉 You have until midnight tonight to save 20% on an Annual or Lifetime Pro license. Go to monkeytools.ca and add code MONKEYAROUND

#BusinessIntelligence #DataAnalyticsTools #PowerQuery #DAX
(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 20, 2025 at 2:12 PM
excelguru.ca
I 💙 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

#Excel #PowerQuery #DAX #DataAnalyticsTools #DataAnalysis #BusinessIntelligence
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? "I've been using Ken's Monkey Tools to manage my library of LAMBDA expressions, and it's made that part of my Excel so much easier to do. Totally recommend you do the same if you're an Excel power user." Patrick Matthews Try it for FREE with our 2-week Pro Trial! Go to: monkeytools.ca
May 14, 2025 at 4:16 PM
excelguru.ca
Unsure what Monkey Tools can actually do for you? I have a FREE Using Monkey Tools course at @skillwave.training. I explain all of the different tools and features that will help with your #DataModeling: buff.ly/S5AqNSK

#ExcelTools #DataAnalyticsTools
Using Monkey Tools course review by John Garnier: "Honestly - it's just so impressive. So many moments of 'Wow', or 'That's Awesome". Favorite sections were the Biblio Monkey and the slowly changing dimension." 5 stars
March 5, 2025 at 5:16 PM