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

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: https://www.linkedin.com/in/gasperkamensek/
Website: https://excelolympics.com
Blog: https://excelunplugged.com
--------------------------------------------------------------
Join our Meetup group Saudi Arabia, Microsoft Excel & Power Platform Meetup
https://www.meetup.com/saudi-arabia-microsoft-excel-power-platform-meetup/
--------------------------------------------------------------
Buy Office365 (Affiliate Link):
https://click.linksynergy.com/link?id=kTx0J25Zvjs&offerid=780606.17637808982&type=2&murl=https%3A%2F%2Fwww.microsoft.com%2Fen-us%2Fp%2Fmicrosoft-365-family%2FCFQ7TTC0K5DM%2F007P
--------------------------------------------------------------
🌎 https://www.ExcelExciting.com
Connect to our forums feel free to ask queries & answer them
https://excelexciting.com/forums/
--------------------------------------------------------------
👍🏻 Like Facebook Page :
https://www.facebook.com/ExcelExciting/

👥Join The Facebook Group -
https://www.facebook.com/groups/ExcelExciting/

***********************************************************
#FarazShaikh #Gasper #ExcelMeetupKSA #ExcelExciting #MicrosoftCreators #ExcelTips #ProductivityHack #ExcelForWindows #ExcelTricks

Видео Custom functions in Power Query (and more) with Gašper Kamenšek канала Faraz Shaikh