Uploaded January 2021 | Updated November 2026, 2 days ago
This is the second live meetup for Saudi Arabia, Microsoft Excel & Power Platform.
00:00 Introduction
11:00 Connecting data online to Excel
43:00 Combine Multiple excel with Multiple sheets
01:09:00 Q&A Session
01:15:57 Wrap-up
Saudi Arabia Excel Meetup to hear from Gašper Kamenšek about the "Custom functions in Power Query (and more)".
Sometimes even the flexibility of Power Query is not enough to bring in all the data in one giant swoop.
You would still need a for or a while "loop" which are not native to M language. Two typical scenarios are to do something for each sheet within each workbook in a folder.
Custom functions are without a doubt one of the "Power Tools" within your Power Query toolbelt.
---------------------------
About the Speaker
---------------------------
Gašper Kamenšek is a BI Professional and a Microsoft MVP for Excel since 2016 from Slovenia.
He has provided training and speaks at conferences all over the world. Lead Author @ ExcelUnplugged.com (one of the top 40 blogs for Excel Worldwide) with over 250.000 visitors annually.
Speaker @ 60+ conferences
Trainer with 1000+ courses
Trainer with 7000+ attendees
Gašper is also the organizer of the Excel Olympics Excel conference in Slovenia.
I am delighted to welcome Gašper to the Saudi Arabia Microsoft Excel & Power Platform Meetup where we can all learn some amazing tips & tricks.
LinkedIn: linkedin.com/in/gasperkamensek
Website: excelolympics.com
Blog: excelunplugged.com
--------------------------------------------------------------
Join our Meetup group Saudi Arabia, Microsoft Excel & Power Platform Meetup
meetup.com/saudi-arabia-microsoft-excel-power-platform-meetup
--------------------------------------------------------------
🛒 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
***********************************************************
#FarazShaikh #Gasper #ExcelMeetupKSA #ExcelExciting #MicrosoftCreators #ExcelTips #ProductivityHack #ExcelForWindows #ExcelTricks
This is the second live meetup for Saudi Arabia, Microsoft Excel & Power Platform.
00:00 Introduction
11:00 Connecting data online to Excel
43:00 Combine Multiple excel with Multiple sheets
01:09:00 Q&A Session
01:15:57 Wrap-up
Saudi Arabia Excel Meetup to hear from Gašper Kamenšek about the "Custom functions in Power Query (and more)".
Sometimes even the flexibility of Power Query is not enough to bring in all the data in one giant swoop.
You would still need a for or a while "loop" which are not native to M language. Two typical scenarios are to do something for each sheet within each workbook in a folder.
Custom functions are without a doubt one of the "Power Tools" within your Power Query toolbelt.
---------------------------
About the Speaker
---------------------------
Gašper Kamenšek is a BI Professional and a Microsoft MVP for Excel since 2016 from Slovenia.
He has provided training and speaks at conferences all over the world. Lead Author @ ExcelUnplugged.com (one of the top 40 blogs for Excel Worldwide) with over 250.000 visitors annually.
Speaker @ 60+ conferences
Trainer with 1000+ courses
Trainer with 7000+ attendees
Gašper is also the organizer of the Excel Olympics Excel conference in Slovenia.
I am delighted to welcome Gašper to the Saudi Arabia Microsoft Excel & Power Platform Meetup where we can all learn some amazing tips & tricks.
LinkedIn: linkedin.com/in/gasperkamensek
Website: excelolympics.com
Blog: excelunplugged.com
--------------------------------------------------------------
Join our Meetup group Saudi Arabia, Microsoft Excel & Power Platform Meetup
meetup.com/saudi-arabia-microsoft-excel-power-platform-meetup
--------------------------------------------------------------
🛒 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
***********************************************************
#FarazShaikh #Gasper #ExcelMeetupKSA #ExcelExciting #MicrosoftCreators #ExcelTips #ProductivityHack #ExcelForWindows #ExcelTricks
![VLOOKUP Data from Multiple sheets [Excel for mac & windows]
In this video we will learn simple technique how to VLOOKUP data from multiple sheets in Microsoft Excel for Mac & Windows
00:00 Introduction
00:33 Understanding the scenario
01:27 Formula explaination
05:26 Possible errors
06:01 End Screen
🛒 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: The Talking Emoji 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 #ExcelTips #ProductivityHack #MadeWithCamtasia #ExcelForMac #ExcelForWindows #ExcelTricks VLOOKUP Data from Multiple sheets [Excel for mac & windows]](https://i.ytimg.com/vi/ROym3e-S4OQ/mqdefault.jpg)









![Un-Stack Data classic way using Excel Online & Excel Mac | Two Solution
We will learn how to Un-Stack Data classic way using Excel Online & Excel Mac with two easy Solution
🌎 www.ExcelExciting.com
👍🏻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 on particular subject for viewers in easy and fun way.
***********************************************************
You can check the following videos as well
Excel Power Query for Office 365 Mac 🖥 (Apple) | Phase 1
https://youtu.be/1VRrPPkMGs8
Excel Tip by the Excel Queen 👸🏻(Faraz & Leila) | https://youtu.be/6CEYKRIlppE
Easiest way to Unhide All Sheets with one line code [VBA MACRO] | https://youtu.be/cs8T8gYltvI
Excel New Version of XLOOKUP & How to use emojis 😀 | https://youtu.be/KAdbfLrpcQ0
XLOOKUP Get the lowest value Column Name in Excel | https://youtu.be/Cbu2ZlvVfXs
***********************************************************
#UnstackData #ExcelOnline #ExcelMac #ExcelTips #FarazExcelMaster #ExcelTrick #MicrosoftCreators #ExcelTips #ProductivityHack #Camtasia #FarazShaikh #ExcelExciting Un-Stack Data classic way using Excel Online & Excel Mac | Two Solution](https://i.ytimg.com/vi/UvrxmOrr8AQ/mqdefault.jpg)