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
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
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, @excelguru.ca shows you how to modify your #PivotTable defaults: www.youtube.com/watch?v=eCut...
#DataAnalyticsTools
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
In this Monkey Shorts video 🐵🩳, @excelguru.ca shows how #PowerQuery's 'Column Profiling' tools work, and how he sets his defaults for every day use: www.youtube.com/watch?v=QtOw...
#Excel #PowerBI #DataAnalyticsTools #DataPreparation #DataAnalysis #BusinessIntelligence
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
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 Monkey Shorts, @excelguru.ca will show you how to fix this issue. 👏
www.youtube.com/watch?v=gTtt...
#DataPreparation #DataAnalyticsTools #BusinessIntelligence
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
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) 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
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) 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
🔎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 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
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
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
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
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
In this 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 #DataPreparation #DataAnalyticsTools
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
(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
Today is the last day of the "Halfway to Monkey Day" special on @excelguru.ca's 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 apply 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
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
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
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
What is Power Query?
#PowerQuery is a data connection technology that enables you to discover, connect, combine, and refine data sources for #DataAnalysis. It add ETL capability to #Excel and #PowerBI. 💪 Start learning today with our FREE introductory course: skw-t.com/pqfun
#DataAnalyticsTools #DataPreparation
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
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
In this Monkey Shorts episode, I show how #PowerQuery's 'Column Profiling' tools work, and how I set my defaults for every day use. Watch on YouTube: https://buff.ly/4fHhaMD
#Excel #PowerBI #DataAnalysis #DataAnalyticsTools
In this Monkey Shorts episode, @excelguru.ca shows how #PowerQuery's 'Column Profiling' tools work, and how he sets his defaults for every day use. Watch on YouTube: www.youtube.com/watch?v=QtOw...
#Excel #PowerBI #DataAnalysis #DataAnalyticsTools
The Monkey Tools ribbon was designed with one goal in mind: to make you more efficient when building queries and/or data models. But what if you want to customize or personalize the Monkey Tools tab? Learn how at mkyt.ca/customtab
#Excel #PowerQuery #DataModeling #DataAnalyticsTools #DataAnalysis
In this Monkey Shorts 🐵🩳 episode, I show the first #PowerQuery setting I change when I install #Excel - the load defaults. Watch on YouTube: https://buff.ly/3VezmWv
#DataAnalyticsTools #DataAnalysis #BusinessIntelligence
In this Monkey Shorts 🐵🩳 episode, @excelguru.ca shows the first #PowerQuery setting he changes when he installs #Excel - the load defaults: https://buff.ly/3VezmWv
#DataAnalyticsTools #DataAnalysis #BusinessIntelligence
