I like the way you teach , you know sir my english is not good but i am taking your lecture in english you why because the way you teach in english its too easy everyone can understand and learn as well. Best of luck sir From pakistan
Thank you for all these topics, i have done these topics from linkedin learning ... but i really can't grasp all of that .your lessons really helped me for my job
Dear Pawan, just saw your video tutorial on Advance Excel Power Query - Introduction. Thanks for explaining Power Query in so simple terms. I am using Excel 2016. As you mentioned in this video please guide me on how to get free ad-in of Power Query to use in Excel 2016.
sir, one thing to ask, i heard from ppl who master the financial modelling, that they use only keyboard to do all the work, or lets say they prefer to use only keyboard, and they.. discourage the use of mouse, as using both keyboard and muse simultaneously "wastes" the time.
Sir, How to use "EDATE" {EDATE(start_date, -1)} functionality in "Power Query in Excel" Means to calculate the previous date where, month is previous month but date is same e.g. I/p is 2 dec 2012 ==> O/p is 2 Oct 2012 I/p is 9 Jan 2011 ==> O/p is 9 Dec 2010 I/p is 4 apr 2013 ==> O/p is 4 May 2013
Dear Pavan, i have query for connecting the ERP data to excel.. can u guide me how to do it ? Any video regarding it, please share the link. Thanks in advance
I have 20 .csv file in a folder and i want merge all with power query...but problem is all file names are ending with .csv_ (i.e. reader7.csv_ and reader8.csv_ )...please help me how can i remove all underscores from all file simultaneously....because without removing underscore power query is not detecting format....
Sir, I have the following question pls give an answer.... after processing the data in Power query and loaded in excel sheet - and further unlinked from Power query the same table in not able to "convert to Range", is there any solution for the same issue i,e to convert to range pls provide.
Dear Lecture, I had a problem regarding to M code in Power Query. I want to know how can I write M code for identify "null" value and replace to "Missing" value base on another question. Example: question1 and question2 below: -If question1 answer 1 then question2 (replace "null" to "Missing") -If question1 answer 2 then question2="null" Thanks by advance for your help
@@PavanLalwani receive thanks for your reply , But can you answer my question please I have seen your playlist ms excel,VBA now bi query, so please tell me all are playlist is full course or should I join institute too.
@@PavanLalwani love you sir ,for videos because you are like god for me and those person who can not offer institute fees, after learniNg course I will definitely teach free ms office for those who really need. Thanks again sir, thanx thank you very Much
Thank you sir. It's really helpful but we want tutorial excel files. Please add google drive link using add excel example files in description. Upcoming videos.
hi sir i have question regarding Power-query after load and close i protect that sheet after protecting sheet Power-query not refreshing i tried this code but not work Sub UnprotectSheet() Dim pswStr As String pswStr = "123" On Error Resume Next Application.ScreenUpdating = False ActiveSheet.Unprotect Password:=pswStr ActiveWorkbook.RefreshAll ActiveSheet.Protect Password:=pswStr, DrawingObjects:=False, _ Contents:=True, Scenarios:=False, _ AllowFormattingCells:=True, AllowFormattingColumns:=True, _ AllowFormattingRows:=True, AllowInsertingColumns:=True, _ AllowInsertingRows:=True, AllowInsertingHyperlinks:=True, _ AllowDeletingColumns:=True, AllowDeletingRows:=True, _ AllowSorting:=True, AllowFiltering:=True, _ AllowUsingPivotTables:=True Selection.ClearContents Application.ScreenUpdating = True
Get Certified in Advanced Excel (Power Query):bit.ly/3LdiidF
Use coupon "TH-cam12" to get ‘’FLAT 12%’’ OFF at Checkout.
you are the best trainer for excel i have learned from your tutorials got the job. thank u sir.
Damn right. I can't find a better guy than him
Yes bro I also got job as MIS executive
@@GodOfIntelligence Bro pls guide to juniors how exactly not from IT background 🙏
I like the way you teach , you know sir my english is not good but i am taking your lecture in english you why because the way you teach in english its too easy everyone can understand and learn as well.
Best of luck sir
From pakistan
BRILLIANT TUTOR. KEEP UPDATE. WISH YOU SUCESS FUTURE MR LALWANI
Love u man..nice teaching
I love u as a teacher
Just love all your Power Query Tutorials! Got yourself a new Subscriber from Brasil!
Isn't it Brazil?
@@pawanjoshi2505 in your language is Brasil. I don't know why to English the grammar is Brazil...
@@felipedeamorimcarvalho8750 ok
After long time today I got ur new video............waiting next video sir
Thank you for making me addictive Pawan Sir
Very important.❤
Thank you for all these topics, i have done these topics from linkedin learning ... but i really can't grasp all of that .your lessons really helped me for my job
Thank you Pavan Sir ..... 🙏🏻🙏🏻
Thanks a lot sir.. ji..
Thanks for this video.
Hello brother
u r teaching skills are too good
I can easily understand
Thanks
@@PavanLalwani can you please tell me how to increase text size of combo box
Dear Pawan, just saw your video tutorial on Advance Excel Power Query - Introduction. Thanks for explaining Power Query in so simple terms. I am using Excel 2016. As you mentioned in this video please guide me on how to get free ad-in of Power Query to use in Excel 2016.
Really good
Finally he mentions his name . 😍😍
Nice teaching
Nice tutorials Pavan...
Good work, its really helpful, when next video
Nice video
Please make more videos for excel
sir, one thing to ask, i heard from ppl who master the financial modelling, that they use only keyboard to do all the work, or lets say they prefer to use only keyboard, and they.. discourage the use of mouse, as using both keyboard and muse simultaneously "wastes" the time.
Thanks Sir ji
could you pls upload the exercise files with your videos. without which its difficult to practice.
sir ek power query ki acchi si playlist upload karna.
kuch top complications lekar. Aur data cleaning ke bare me achhe se samjaha
This add on is not available on said link on this date
Sir, How to use "EDATE" {EDATE(start_date, -1)} functionality in "Power Query in Excel"
Means to calculate the previous date where, month is previous month but date is same
e.g.
I/p is 2 dec 2012 ==> O/p is 2 Oct 2012
I/p is 9 Jan 2011 ==> O/p is 9 Dec 2010
I/p is 4 apr 2013 ==> O/p is 4 May 2013
Hi sir, please make Power bi tutorials much. we all are waiting for next slides(Please provide file, which you used in explanation)
sir, I have a question, how can we get data from outlook to power query
Nice
Waiting for next vedio sir.
Your wait is over
Link for all videos in description
Very Nice. What platform you use for thus interactive touch. It it a TV or some projector screen. Very Interactive
Can Advanced Excel classes be held in Hindi?
Dear Pavan, i have query for connecting the ERP data to excel.. can u guide me how to do it ? Any video regarding it, please share the link.
Thanks in advance
I have Microsoft 2016 home and business versions but dnt have power pivot. Can anyone suggest ho to get install?
Is this playlist complete?
I have 20 .csv file in a folder and i want merge all with power query...but problem is all file names are ending with .csv_ (i.e. reader7.csv_ and reader8.csv_ )...please help me how can i remove all underscores from all file simultaneously....because without removing underscore power query is not detecting format....
Sir, I have the following question pls give an answer.... after processing the data in Power query and loaded in excel sheet - and further unlinked from Power query the same table in not able to "convert to Range", is there any solution for the same issue i,e to convert to range pls provide.
Hello Sir, Me a civil eng student, could you pls some related videos, It would be great help
thanks
Sir is this process called Data Cleaning ?
Dear Lecture,
I had a problem regarding to M code in Power Query.
I want to know how can I write M code for identify "null" value and replace to "Missing" value base on another question.
Example: question1 and question2 below:
-If question1 answer 1 then question2 (replace "null" to "Missing")
-If question1 answer 2 then question2="null"
Thanks by advance for your help
Best regard,
Socheat
1qqqqq1qq
Hi Mr. Pavan, I want to know one thing, what if I am not from India Can I buy this course from your website?
I want to take tutorial on power query. How to get in touch?
Hi sir I need SQL server sir
I want more video
Pls check link in description for all Videos
are you teaching advance excl?
Hi sir other videos can not see why please
Pls check link in description
@@PavanLalwani receive thanks for your reply , But can you answer my question please I have seen your playlist ms excel,VBA now bi query, so please tell me all are playlist is full course or should I join institute too.
@@ganesh5041 Not really required. These are same level of training given to corporate companies better than institute
@@PavanLalwani love you sir ,for videos because you are like god for me and those person who can not offer institute fees, after learniNg course I will definitely teach free ms office for those who really need.
Thanks again sir, thanx thank you very Much
Sir i have 2007 Microsoft
Thank you sir. It's really helpful but we want tutorial excel files. Please add google drive link using add excel example files in description. Upcoming videos.
Yes
This time we have taken care and link for all videos with files and certification in description
hi sir
i have question regarding Power-query
after load and close i protect that sheet
after protecting sheet Power-query not refreshing
i tried this code but not work
Sub UnprotectSheet()
Dim pswStr As String
pswStr = "123"
On Error Resume Next
Application.ScreenUpdating = False
ActiveSheet.Unprotect Password:=pswStr
ActiveWorkbook.RefreshAll
ActiveSheet.Protect Password:=pswStr, DrawingObjects:=False, _
Contents:=True, Scenarios:=False, _
AllowFormattingCells:=True, AllowFormattingColumns:=True, _
AllowFormattingRows:=True, AllowInsertingColumns:=True, _
AllowInsertingRows:=True, AllowInsertingHyperlinks:=True, _
AllowDeletingColumns:=True, AllowDeletingRows:=True, _
AllowSorting:=True, AllowFiltering:=True, _
AllowUsingPivotTables:=True
Selection.ClearContents
Application.ScreenUpdating = True
You look likes sonu nigam
Sonu nigam?
Sir Hindi language me q nahi bolte hai
Ye to introduction tha.. eska examples k sath tutorial kaha hai
In the description there is a link
email id