Advanced Excel tutorial using Power Query by Pavan Lalwani

Pavan Lalwani is associated with LinkedinLocal for Advanced Excel-Power Query. A free workshop was conducted in collaboration to all attendees across Globe.

Download

Power Query Tutorial for Beginners. Power Query.
ETL Tools. Advanced Excel. Macros. VBA. Data Cleaning.
Append, Merge, Functions, Formulas in excel.
Power BI. Automation.

****************COMMON QUESTIONS ************************************

******************SOCIAL MEDIA LINKS************************************

********************OTHER COURSES BY PAVAN LALWANI*****************

**************************************************************************************************
Message for Mr. Lalwani

Fascination is one word that describes my curiosity to understand the world around me

I have already created positive change in individuals and institutions that I have engaged and partnered with.

My Mission is to help professionals to take control of their skills and present them in a way that inspires, impress and build confidence in their abilities, products and services.

I enjoy contributing new ideas. I love training people and build them technically enhanced & professionally Confident about the Products and Services.

It doesn't even matter who you are and what you do !!

"Never let your memories be greater than your dreams"

Regards,
Pavan Lalwani
INDIA
***********************************************************************************************

[pintusharma]

Pavan, you are a very good teacher. Today, I know power query just because of you. God bless you !!!

[KETOlicious]

Hi Pavan, really appreciate all these videos & many congratulations for starting your own channel.. finally, I won't have to scroll through all those videos on tutorial points just to find yours..

Love your teaching techniques & it has helped me immensely in order to gain more experience in excel as well as Power BI. I would be happy to go for a paid course if there is any for advanced level of power query and power BI.

Thank you, your student from Sydney, Australia :)

[mohammadjaved]

i have learned so many things from you sir...
Like MS-Office, VBA, Power query, Tableau
Thank you...😇

[sudhakarsudhakar]

I ve subscribed your power bi videos. It really helped me to understand what power bi actually is. If added with real time projects, much more beneficial. Anyway no one I found that can teach as you do. Thank you

[benyameenperikala]

wonderful teaching and content. Thanks a lot Pavan Ji. Very useful

[Borah]

Thanks, Pavan, I am following your all video for a couple of years,

[sambarajkanaveni]

Great ....learning and updating from ur videos thank U verymuch please continue the same👍👍

[premprakashnayak]

Excellent... your videos always valuable...

[shellavillanueva]

it helps me little by little to understand power query

[ahamefulaemeh]

Hi Pavan, Thanks for the good work you are doing. You have really been a blessing to me via your online tutorials especially on Power Bi. Please how do I get these data set for practice in Power Query.? Is it possible? Please I need your feedback.

[sebastianmathew]

Hello pavan sir your presentation is excellent iam a great fan of you I learned excel from your videos only

[FygoonTech]

Thanks a ton for uploading this video 🥰 🥰 🥰, can you please make a video on what are the skills required for MIS executive.

[chikukevideos]

You are providing powerful knowledge in this situation. Salaam sir

[knowledgejockey]

Hey Pawan, I have been using Power Query since last couple of months. Can you share some advance level lectures showing the real power of the PowerQuery.

[MuhammadHamza-xexe]

Really Nyc Person Sir Pawan Love From Pakistan

Sir Please Mention the Excel topics for Data analyst I want to become a data analyst which excels topics must I should learn for become for data analyst Thank You

[supriyapatil]

Hi Pavan Sir, Just one correction, at 37:41 Total sales will change for other discounts as well if we use 1- discount condition. For eg. 1st value Discount was 0.4 but if we use 1-0.4 condition which was used to avoid 0 discount condition will now take 0.6 as discount value.
Any other ways we can avoid 0 value in multiplication operation


Thanks in advance 🙂

[lejophilip]

Hi Pawan, is there any techniques to lock a cell, eg : we have set 1 formula in a column, which should change based on data source which is copied in another sheet. I dont want formula in my cell to change. Anyways to lock it.

[MrBasu-iqmd]

Please make an excel power pivot video....🙏🏻🙏🏻

[sitikanthadas]

Pavan Sir, In Power Query Editor when you are removing any columns, the data which are dependent on removed column is not affected. In time stam 21:23, when you removed total no of days, age in years didn't affected although age in years is completly dependent on total no of days. I want to know why so ?

[najibullahrafi]

How can use random in Excel, which i want select according to female and male occurring specific number and to according to village also should be selected