No video :(

Advanced Excel tutorial using Power Query by Pavan Lalwani

Подписаться 206 тыс.

Просмотров 56 тыс.

50% 1

Pavan Lalwani is associated with LinkedinLocal for Advanced Excel-Power Query. A free workshop was conducted in collaboration to all attendees across Globe.
Download
drive.google.c...
Power Query Tutorial for Beginners. Power Query.
ETL Tools. Advanced Excel. Macros. VBA. Data Cleaning.
Append, Merge, Functions, Formulas in excel.
Power BI. Automation.
🔴 Full Power BI Course: bit.ly/2CxoZYm
***************COMMON QUESTIONS ***********************************
What is Power BI: bit.ly/2CxoZYm
Download Power BI: bit.ly/3hWC6me
Install Power BI: bit.ly/3hWC6me
Upgrade Power BI: bit.ly/3hWC6me
*****************SOCIAL MEDIA LINKS***********************************
Website: pavanlalwani.com/
Twitter: / pavan55470690
LinkedIn: / pavanlalwani
Instagram: / pavanlalwani
Facebook: / pavanlalwanitrainer
*******************OTHER COURSES BY PAVAN LALWANI****************
✔️Tableau :www.udemy.com/...
✔️UFT :www.udemy.com/...
✔️MicroStrategy :www.udemy.com/...
✔️LoadRunner :www.udemy.com/...
✔️Alteryx: :www.udemy.com/...
🔴Subscribe : www.youtube.co...
**************************************************************************************************
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
***********************************************************************************************

Опубликовано:

19 авг 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 86

@PavanLalwani Год назад

Explore our courses on : learn.pavanlalwani.com/courses/

@pintusharma3939 2 года назад

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

@PavanLalwani 2 года назад

Glad to hear that. All the best Buddy

@mohammadjaved421 3 года назад

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

@KETOlicious 3 года назад

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 :)

@PavanLalwani 2 года назад

Thanks Gunjan

@benyameenperikala6932 6 месяцев назад

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

@2Borah 3 года назад

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

@sebastianmathew156 4 года назад

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

@PavanLalwani 4 года назад

Thank you Sebastian.. all the best keep learning and sharing knowledge

@premprakashnayak2636 2 года назад

Excellent... your videos always valuable...

@talhakhalid4937 3 года назад

Love from Pakistan, great work sir

@shellavillanueva9947 2 года назад

it helps me little by little to understand power query

@ahamefulaemeh6746 Год назад

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.

@sudhakarsudhakar529 3 года назад

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

@sambarajkanaveni7312 3 года назад

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

@ask7066 2 года назад

Thank you so much I learn a lot 😊

@helendroza3833 3 года назад

Thank you Pawan - God bless!!!

@PavanLalwani 3 года назад

Thanks Helen

@chikukevideos1527 4 года назад

You are providing powerful knowledge in this situation. Salaam sir

@PavanLalwani 4 года назад

Salaam Welcome

@ramakantpatil2011 3 года назад

Great.....Great....Great...PawanJiii

@nishantjadhav1231 4 года назад

Thank you for sharing on RU-vid...

@PavanLalwani 4 года назад

Welcome

@RockingHindu 3 года назад

Excellent tutorial

@MaMuNAcademY 4 года назад

Excellent Sir

@PavanLalwani 4 года назад

Thank you :)

@najibullahrafi9926 8 месяцев назад

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

@MuhammadHamza-xe6xe 3 года назад

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

@supriyapatil3399 Год назад

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 🙂

@taizoondean689 3 года назад

Thank you sir

@c.k.abdulmajeed7783 3 года назад

Very good

@indradutta4136 2 года назад

I have faced one issue while merging query's from two different files creating connection. It gives multiple duplicate values even if we have removed duplicate using remove duplicate in power query. Please help me to get a solution in this issue.

@MrBasu-iq6md 2 года назад

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

@user-ms9id7ty7y 7 месяцев назад

Sir, I am not able to find your earlier video "Excel Power Query Full Course " is there any other source ?

@FygoonTech 4 года назад

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

@PavanLalwani 4 года назад

Surely Mohamed

@shellavillanueva9947 2 года назад

why I can not highlight all, then i cannot merged the columns

@knowledgejockey2378 3 года назад

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.

@lejophilip8497 3 года назад

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.

@ashutoshsamal8227 4 года назад

Sir can you launch a full advanced excel and Power query...please🙏

@PavanLalwani 4 года назад

Yes Ashutosh, Your support required to promote this channel. Please share links in your groups.

@saketkumar9852 3 года назад

@@PavanLalwani this will be my pleasure ❤️

@saketkumar9852 3 года назад

How can I contact u, plz saketkr1.30@gmail.com 9711731924

@narenderkumararya7498 8 месяцев назад

can we make a pivot table from the folder if save here multiple sheet.

@PavanLalwani 8 месяцев назад

Yes

@saikatmukherjee6951 3 года назад

Sir r u calculating the age on the basis of present day....otherwise the diffrenc btw order date & siping date is not 1 yr in max case

@official_mahendra221 10 месяцев назад

plz add timelaps

@alihassan-bv3ph Год назад

Financial reporting can automatic

@PavanLalwani Год назад

Hi Ali, Yes, definitely we can do automatic financial reporting.

@sitikanthadas5300 3 года назад

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 ?

@chikukevideos1527 4 года назад

Can you make videos on MIs ex.

@PavanLalwani 4 года назад

Sure

@rajeshsinghchauhan7535 4 года назад

Hiii sir from where I can learn Ms Excel (basic to advance), power BI , Excel vba, tableau, SQL Plz sir reply

@PavanLalwani 4 года назад

www.tutorialspoint.com/videotutorials/profile/Pavan-Lalwani Here you can get my all courses.

@chikukevideos1527 4 года назад

You have provided link of power bi and other things but sir it is not free🙂

@jyothirmaivagvala2657 4 года назад

Hi sir, unable to get the practice files from the link given in the description. It is showing as 404 error.

@mahimahesh536 4 года назад

Hi Jyothi, Is the link working in the description or showing the same...Even I tried but in vain..

@PavanLalwani 4 года назад

Now check. Someone deleted that

@roshansharma9383 4 года назад

Hi Sir, Can you please upload the XLOOPUP and XMATCH videos.

@PavanLalwani 4 года назад

Sure . Will do soon

@talhakhalid4937 Год назад

Brother, why you delete/private 6 hours vedio on power query

@PavanLalwani Год назад

The series will extend on mobile app platform with coming soon live QnA

@kanaujaachary7246 2 года назад

Sir I have a doubt. If we use 1 minus discount then the value will be 60% discount in the 1st row rather than 40%. I think it is wrong. It is correct for 0% discount but for others it is wrong.

@darjasouchkova3608 2 года назад

I saw it too, Have you solved it or receive any answer from Pavan?

@hemantsarode7326 2 года назад

I tried and agree with Achary. Requesting Pavan to please share the solution

@chikukevideos1527 4 года назад

I am confused about power bi and power query. Is it same

@PavanLalwani 4 года назад

Not really. See 14.1 video

@mahimahesh536 4 года назад

Hi Pavan Lalwani can you please help us here the link given in the description is not working

@PavanLalwani 4 года назад

Ok pls check now

@sagarlonare827 4 года назад

Hello Pawan Sir. Thanks a lot for sharing the valuable knowledge. I tried to get data from web using power query. I go data the required data successfully. But when I refresh it I am getting below error every time. Feedback Type: Frown (Error) Error Message: Container exited unexpectedly with code 0xFFFFFFFF. PID: 13488. Used features: (none).

@PavanLalwani 4 года назад

May be due to wrong URL it might be throwing error

@sagarlonare827 4 года назад

@@PavanLalwani no sir even if I try to get data from folder, I am getting same error. I have MS office professional plus 2019.

@PavanLalwani 4 года назад

Oh. So this is a problem. Let me check and get back. Is it newly installed on your machine ?

@sagarlonare827 4 года назад

@@PavanLalwani No sir, its been more than 8 months, I am using this version.

@PavanLalwani 4 года назад

Ok give me time I will reply on this