★ Want to automate Excel? Check out our training academy ★
[ Ссылка ]



★ Check out the blog post ★
[ Ссылка ]


★ About this video ★
Maybe you’ve built some queries in a test environment, and now it’s time to start using them for real. The obvious question arises: How to change source data location in Power Query?

0:00 Introduction
0:47 #1 Edit the source step
1:24 #2 Change the M code (formula bar)
1:45 #3 Change the M code (advanced editor)
2:09 #4 Data source settings
2:59 #5 Worksheet cell parameters
4:02 #6 Queries as parameters
4:34 #7 Power Query parameters
5:21 Conclusion


★ Download 30 most useful Excel VBA Macros ebook for FREE ★
[ Ссылка ]


★ Where to find Excel Off The Grid ★
Blog: [ Ссылка ]

Twitter: [ Ссылка ]


#MsExcel #PowerQuery

свернуть