Uploaded December 2020 | Updated November 2026, 5 days ago
This is the first live meetup for Saudi Arabia, Microsoft Excel & Power Platform.
Ken Puls was demonstrating how Excelguru's Monkey Tools add-in can help you build better Excel BI models faster, and audit models that you receive from others. Monkey Tools is targeted at modelers and analysts who work primarily in Excel, but also push their models into Power BI.
Download Monkey Tools :
xlguru.ca/monkeytools
ExcelExciting.com/resources
--------------------------------------------------------------
Join our Meetup group Saudi Arabia, Microsoft Excel & Power Platform Meetup
meetup.com/saudi-arabia-microsoft-excel-power-platform-meetup
00:00 Getting Ready
01:03 Introduction
04:50 Meeting Agenda
05:50 About the speaker
07:16 Connect with the speaker
08:45 Build Better Excel BI Models
10:43 My Modelling Philosophy
12:40 About Monkey Tools
15:32 The Monkey Tools Ribbon
16:54 Demo
18:03 Query Monkey
18:10 Connecting Excel Tables With Query Monkey
22:00 Query Sleuth In Monkey Tools
24:15 Create Calendar Table with Query Monkey
28:45 Create PivotTable with Monkey Tools
30:24 Create DAX Measures with Monkey Tools
33:46 Store DAX Measures with Monkey Tools
38:11 Create Parameter Table with Monkey Tools
39:49 Smart Folder Function in Monkey Tools
40:10 Smart Folder Query in Monkey Tools
46:49 Destination Sleuth in Monkey Tools
52:55 Time Sleuth in Monkey Tools
1:02:10 Pivot Sleuth in Monkey Tools
1:08:38 View Complex Model with Pivot Sleuth in Monkey Tools
1:09:18 DAX Sleuth in Monkey Tools
1:12:50 Model Summary Report in Monkey Tools
1:16:05 Model Memory Usage Report in Monkey Tools
1:16:34 Unused Items Report in Monkey Tools
1:16:59 Real world consulting project
1:20:00 Reviewing the Model Summary Report
1:21:50 Connecting Power BI Files to create Model Summary in Excel Workbook
1:24:46 Log a bug & feature suggestion in Monkey tools
1:25:20 Question & Answer
1:30:32 Monkey Tools Resources
1:32:30 Session Wrap-up
The broad set of features included in Monkey Tools will help you deal with things like:
• Creating Data Model connections for all Excel tables in seconds
• Injecting dynamic parameter tables and dynamic calendars into your data model with only a few clicks
• No-code creation of basic EXPLICIT Power Pivot measures
• Diagnosing the issues behind the irritating “Relationships May Be Needed” error when building a Power Pivot-based PivotTables
• Tracing query and DAX dependency trees
• Indenting both M and DAX queries
• Timing your query refresh speeds
• Documenting your Excel or Power BI based models
• And more!
--------------------------------------------------------------
🛒 Affiliate links :
- Support me with your Amazon purchases: amzn.to/3tR4AUN
- Buy Office365: bit.ly/3nKcbnk
📣 Disclosure: Affiliate links, which means there is no additional cost to you. I will receive a small commission if you make a purchase using the links. By doing so you're helping me keep my blog up and running and you're helping me provide for my family so for that I truly thank you for your support. Please only purchase the products if you believe they will add value to you.
--------------------------------------------------------------
🌎 ExcelExciting.com
Connect to our forums feel free to ask queries & answer them
excelexciting.com/forums
--------------------------------------------------------------
👍🏻 Like Facebook Page :
facebook.com/ExcelExciting
👥Join The Facebook Group -
facebook.com/groups/ExcelExciting
***********************************************************
Connect Ken Puls
facebook.com/xlguru
YouTube.com/KenPulsXLGuru
linkedin.com/in/kenpuls
twitter.com/kpuls
meetup.com/Vancouver-Power-BI-User-Group
***********************************************************
#FarazShaikh #KenPuls #ExcelMeetupKSA #ExcelExciting #MicrosoftCreators #ExcelTips #ProductivityHack #MadeWithCamtasia #ExcelForMac #ExcelForWindows #ExcelTricks
This is the first live meetup for Saudi Arabia, Microsoft Excel & Power Platform.
Ken Puls was demonstrating how Excelguru's Monkey Tools add-in can help you build better Excel BI models faster, and audit models that you receive from others. Monkey Tools is targeted at modelers and analysts who work primarily in Excel, but also push their models into Power BI.
Download Monkey Tools :
xlguru.ca/monkeytools
ExcelExciting.com/resources
--------------------------------------------------------------
Join our Meetup group Saudi Arabia, Microsoft Excel & Power Platform Meetup
meetup.com/saudi-arabia-microsoft-excel-power-platform-meetup
00:00 Getting Ready
01:03 Introduction
04:50 Meeting Agenda
05:50 About the speaker
07:16 Connect with the speaker
08:45 Build Better Excel BI Models
10:43 My Modelling Philosophy
12:40 About Monkey Tools
15:32 The Monkey Tools Ribbon
16:54 Demo
18:03 Query Monkey
18:10 Connecting Excel Tables With Query Monkey
22:00 Query Sleuth In Monkey Tools
24:15 Create Calendar Table with Query Monkey
28:45 Create PivotTable with Monkey Tools
30:24 Create DAX Measures with Monkey Tools
33:46 Store DAX Measures with Monkey Tools
38:11 Create Parameter Table with Monkey Tools
39:49 Smart Folder Function in Monkey Tools
40:10 Smart Folder Query in Monkey Tools
46:49 Destination Sleuth in Monkey Tools
52:55 Time Sleuth in Monkey Tools
1:02:10 Pivot Sleuth in Monkey Tools
1:08:38 View Complex Model with Pivot Sleuth in Monkey Tools
1:09:18 DAX Sleuth in Monkey Tools
1:12:50 Model Summary Report in Monkey Tools
1:16:05 Model Memory Usage Report in Monkey Tools
1:16:34 Unused Items Report in Monkey Tools
1:16:59 Real world consulting project
1:20:00 Reviewing the Model Summary Report
1:21:50 Connecting Power BI Files to create Model Summary in Excel Workbook
1:24:46 Log a bug & feature suggestion in Monkey tools
1:25:20 Question & Answer
1:30:32 Monkey Tools Resources
1:32:30 Session Wrap-up
The broad set of features included in Monkey Tools will help you deal with things like:
• Creating Data Model connections for all Excel tables in seconds
• Injecting dynamic parameter tables and dynamic calendars into your data model with only a few clicks
• No-code creation of basic EXPLICIT Power Pivot measures
• Diagnosing the issues behind the irritating “Relationships May Be Needed” error when building a Power Pivot-based PivotTables
• Tracing query and DAX dependency trees
• Indenting both M and DAX queries
• Timing your query refresh speeds
• Documenting your Excel or Power BI based models
• And more!
--------------------------------------------------------------
🛒 Affiliate links :
- Support me with your Amazon purchases: amzn.to/3tR4AUN
- Buy Office365: bit.ly/3nKcbnk
📣 Disclosure: Affiliate links, which means there is no additional cost to you. I will receive a small commission if you make a purchase using the links. By doing so you're helping me keep my blog up and running and you're helping me provide for my family so for that I truly thank you for your support. Please only purchase the products if you believe they will add value to you.
--------------------------------------------------------------
🌎 ExcelExciting.com
Connect to our forums feel free to ask queries & answer them
excelexciting.com/forums
--------------------------------------------------------------
👍🏻 Like Facebook Page :
facebook.com/ExcelExciting
👥Join The Facebook Group -
facebook.com/groups/ExcelExciting
***********************************************************
Connect Ken Puls
facebook.com/xlguru
YouTube.com/KenPulsXLGuru
linkedin.com/in/kenpuls
twitter.com/kpuls
meetup.com/Vancouver-Power-BI-User-Group
***********************************************************
#FarazShaikh #KenPuls #ExcelMeetupKSA #ExcelExciting #MicrosoftCreators #ExcelTips #ProductivityHack #MadeWithCamtasia #ExcelForMac #ExcelForWindows #ExcelTricks








![Trick to Create A Data Entry Table In Power Query for Excel
A simple technique to create a data entry table inside a power query for excel.
Copy Code: https://excelexciting.com/simple-trick-to-create-a-data-entry-table-in-excel-power-query/
Resources: https://excelexciting.com/resources/
🛒 Affiliate links :
- Support me with your Amazon purchases: https://amzn.to/3tR4AUN
- Buy Office365: https://bit.ly/3nKcbnk
📣 Disclosure: Affiliate links, which means there is no additional cost to you. I will receive a small commission if you make a purchase using the links. By doing so youre helping me keep my blog up and running and youre helping me provide for my family so for that I truly thank you for your support. Please only purchase the products if you believe they will add value to you.
🌎 https://www.ExcelExciting.com
Connect to our forums feel free to ask queries & answer them
https://excelexciting.com/forums/
👍🏻Faraz Shaikh - Excel Master
https://www.facebook.com/ExcelExciting/
👥Join The Facebook Group -
https://www.facebook.com/groups/ExcelExciting/
***********************************************************
DISCLAIMER: If any resemblance with any person, living or dead, is purely coincidental. There is absolutely no intention to hurt any person or group of persons or any section of society through this video. This video is created to impart my understanding of a particular subject for viewers in an easy and fun way.
***********************************************************
You can check the following videos as well
Change Multiple Value using Array Method [Excel for Mac & Windows]
https://youtu.be/c8d3xx8KVl8
Un-Stack Data classic way using Excel Online & Excel Mac | Two Solution
https://youtu.be/UvrxmOrr8AQ
Extract Number & Text from a Cell in Excel | Solution 01 by Power Query
https://youtu.be/GHQXgg2PR_k
How to Refresh Your Excel Power Query for Office 365 Mac 🖥 (Apple) | Phase 1
https://youtu.be/1VRrPPkMGs8
***********************************************************
#Excel #FarazShaikh #ExcelExciting #MicrosoftCreators #PowerQuery #PowerBI #ExcelTips #ProductivityHack #MadeWithCamtasia #ExcelForMac #ExcelForWindows #ExcelTricks Trick to Create A Data Entry Table In Power Query for Excel](https://i.ytimg.com/vi/bHPrRbcw6f0/mqdefault.jpg)
![Lookup last matching value in the column (Excel - Mac & Windows)
In this video, we will learn how to VLOOKUP the last record or lookup the last matching value in a column. In order to achieve the last record value, we will build a complex formula that will return our desired result.
⏱ Time Stamp
00:00 Intro
00:16 Understanding Dataset
00:40 Building the solution
03:40 Wrapping the solution in one cell
05:29 End
🛒 Affiliate links :
- Support me with your Amazon purchases: https://amzn.to/3tR4AUN
- Buy Office365: https://bit.ly/3nKcbnk
📣 Disclosure: Affiliate links, which means there is no additional cost to you. I will receive a small commission if you make a purchase using the links. By doing so youre helping me keep my blog up and running and youre helping me provide for my family 👨👩👧👦 so for that I truly thank you for your support. Please only purchase the products if you believe they will add value to you.
🌎 https://www.ExcelExciting.com
Connect to our forums feel free to ask queries & answer them
https://excelexciting.com/forums/
Join our Meetup group Saudi Arabia, Microsoft Excel & PowerPlatform Meetup
https://www.meetup.com/saudi-arabia-microsoft-excel-power-platform-meetup/
👍🏻 Like Facebook Page :
https://www.facebook.com/ExcelExciting/
👥Join The Facebook Group -
https://www.facebook.com/groups/ExcelExciting/
***********************************************************
You can check the following videos as well
VLOOKUP Data From Multiple Worksheets [Excel for mac & windows]
https://youtu.be/ROym3e-S4OQ
Trick to Create A Data Entry Table In Power Query for Excel
https://youtu.be/bHPrRbcw6f0
Change Multiple Value using Array Method [Excel for Mac & Windows]
https://youtu.be/c8d3xx8KVl8
Extract Number & Text from a Cell in Excel | Solution 02 by Power Query
https://youtu.be/iei5rMstlJ0
***********************************************************
#Excel #FarazShaikh #ExcelExciting #MicrosoftCreators #ExcelTips #ProductivityHack #MadeWithCamtasia #ExcelForMac #ExcelForWindows #ExcelTricks Lookup last matching value in the column (Excel - Mac & Windows)](https://i.ytimg.com/vi/bh9ELJflc_Y/mqdefault.jpg)
