38 - Convert Query to a Function in Power Query

In this video, I will show you how you can convert a query to a function. Doing this gives you a lot more flexibility as you can now use the code easily in the worksheet. I take an example of fetching the box office data and how you can create a function that can fetch the data based on the year you have entered ✅ Power Query Course Download files: https://trumpexcel.com/course-download-files/ ☕ If you find my Excel videos useful and would like to support me, you can buy me a coffee - https://www.buymeacoffee.com/SumitB Free Excel Course (Basic to Advanced) - https://trumpexcel.com/learn-excel/ Best Excel Books: https://trumpexcel.com/best-excel-books/ Subscribe to get awesome Excel Tips every week: https://www.youtube.com/user/trumpexcel?sub_confirmation=1 ------------------------------------------------------------------------------ 0:00 - Introduction 0:43 - Importing Data from Web 1:56 - Transforming Data in Query Editor 3:32 - Converting Query to Function using Advanced Editor 5:31 - Adding Parameter to the Function 7:36 - Saving the Function 9:01 - Creating a Table for Multiple Years 10:33 - Handling Privacy Settings 11:23 - Combining Data from Multiple Years ------------------------------------------------------------------------------ #Excel #ExcelTips #ExcelTutorial