Custom functions in Power Query (and more) with Gašper Kamenšek @ExcelExciting
Custom functions in Power Query (and more) with Gašper Kamenšek  @ExcelExciting
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
Custom functions in Power Query (and more) with Gašper KamenšekVLOOKUP Data from Multiple sheets [Excel for mac & windows]Its NOT Excels fault for UK Covid19 Data Loss - Talk with Microsoft MVPsTOP 20 NOT discovered tips in Excel with Nurana NovruzovaHow Power Query has transformed my routine at work! with Alejandra HorvathCombine Multiple Row Values in One Cell (Excel for mac & windows)Create a Simple EMI Tracker in Excel | Visualize Your Monthly EMIs - Part 01Microsoft Fabric: One Platform, Infinite Possibilities with Pragati JainIntroducing the Measure Killer with Gregor BrunnerXLOOKUP Dynamic column can SAVE your life! Excel Mac & WindowsExcel Tells You This Month’s EMI - EMIBYMONTH Formula Explained - Part 02Un-Stack Data classic way using Excel Online & Excel Mac | Two Solution
Faraz Shaikh |

Custom functions in Power Query (and more) with Gašper Kamenšek

SHARE TO X SHARE TO REDDIT SHARE TO FACEBOOK WALLPAPER