How to Enable the Formula Bar in Power Query Editor in Excel

preview_player
Показать описание
You do not need to know M language to accomplish great things with Power Query. However, it is essential to keep an eye on the formula bar and check the code generated automatically by Power Query. There are situations where Power Query may not guess quite right what we intend it to do. Also, by paying attention to what's going on in the formula bar, you get acquainted with the Power Query programming language, which will give you extra powers as a Power Query user.
----------------------
My Contact information:
Celia Alves - Microsoft MVP & Certified Excel Expert, Solutions Developer
Twitter: @celia_excel
Instagram: @solveandexcel

--------------------------
Learn Excel and connect with a community of Excel professionals and enthusiasts:

#Excel #solveandexcel #microsoft365 #toronto #torontobusiness #mvpbuz #communityrocks #wit
Рекомендации по теме
Комментарии
Автор

Thank you so much Celia, regards from Cali-Colombia

alvarorodriguezlasso
Автор

Thanks you verymuch mdam
I saw your vedio
Then clear my problem

balreddy_k
Автор

Why doesn't my Power query formula bar autofill when I start typing function name to recommend accordingly. I am using Microsoft Office Home and Student 2019 version

chiragbc
Автор

Mam, i do not get any recommended formula

abdullahalmasud