Power Query Explained : Life Changing Tool | Excel Power Query Tutorial Step by Step

Power Query Explained : Life Changing Tool | Excel Power Query Tutorial Step by Step
Excel Power Query Play Link - • Excel Power Query
Download the Assignment Master Practice Folder here (All Playlist Example at one place)
drive.google.com/drive/folder...
===========VIDEO COURSE============================
✅ Mastering Excel Video Course
www.innozant.com/courses/adv-...
✅ Mastering Power BI Video Course
www.innozant.com/courses/powe...
✅ Mastering VBA Video Course
www.innozant.com/courses/vba-...
✅ Mastering SQL Video Course
www.innozant.com/courses/orac...
Visit - innozant.com
=====================================================
===========HYBRID CLASSES============================
✅ आरंभ EXCEL | सक्षम Analytics | निपुण Analytics
✅ Database Training(SQL , PL\SQL , Oracle Developer)
✅ Mastering Data Science
Visit - innozant.com
====================================================
Videos in a Sequence -Basic to Advanced EXCEL
Basic Excel- • Basic Excel-The Learni...
Advanced Excel Sorting and Filter- • Advanced Excel Sorting...
Subtotal TTC and Data Validation- • Excel Subtotal TTC and...
Excel What if Analysis- • Excel What if Analysis
Excel Array and Sumproduct- • Excel Array & Sumprodu...
Excel Lookup Functions- • Excel Lookup Functions...
Excel Pivot Tables- • Excel Pivot Tables
Excel Power Pivot- • Excel Power Pivot
Excel Power Query- • Excel Power Query
Excel Chart and Infographics- • Excel Chart and Infogr...
Excel Dashboard & Reports- • Excel Dashboard & Reports
Value add-ons Playlist
ProQuest-Check Point- • Excel ProQuest-Check P...
Career Guide:सिफर से सिखर तक - • Career Guide-सिफर से श...
StudsTalk -The Journey begins- • StudsTalk-The Journey ...
QUIZ Sunday- • EXCEL MIS QUIZ SUNDAY
Excel Tips and Tricks- • Excel Tips & Tricks
MIS Interview Cracker- • MIS Interview Cracker
MIS Job Live Interview :Based on Real Incident- • MIS JOB Live Interview...
Excel Maharaj- • EXCEL MAHARAJ - For Ex...
Microsoft Powerpoint- • Microsoft Powerpoint
Microsoft Word- • Microsoft Word
Office 365- • Office 365
Google Sheets- • Google Sheets
Microsoft Outlook- • Microsoft Outlook
Power BI- • Power BI
Excel VBA- • Excel VBA Macro
TezXL Jata Shorts- • #shorts | जो TRIM के ब...
Announcements- • Announcements
Website - "www.innozant.com"
Let's Connect:
Instagram ► / innozantinfotech
Facebook ► / innozantinfotech
Telegram►t.me/innozantinfotech
#powerquery #powerquerytutorial#innozant #powerquerystepby step#excelpowerquery #powerquerytutorial

[@sudiptakar9157]

I have never seen explaining technical tool videos in such a simpler way! Thank you so much! Best tutorial ever !!

[@Innozant]

Thanks Sudipta for your valuable appreciation.Happy learning

[@user-wi8on1tx6p]

Thanks sir for explaining in a simple way.

[@balveerkumar9686]

Yes it's very important for every Excel lover. Thank you so much for this series ❤️❤️❤️

[@Innozant]

Thanks Balveer ji..Happy learning

[@chayanbhattacharya1736]

wonderful introduction

[@PradeepKumarSingh]

Thanks Sir for such a knowledgeable video. 🙏

[@user-nd7yf2jx1d]

this part is crucial for every data analyst aspirant so thankyou for the explanation sir.

[@pawanjounkani]

I appreciate your effort. Really, your way of teaching, style and your sweet smile. Students can learn easily without getting bored and without skipping your videos. 👍🙏

[@Innozant]

Thanks Pawan..Really means a lot to me dear Pawan ji..Happy learning..Gn

[@momukeem1973]

Sir I'm your fan power pivot playlist has been done now power query started❤❤🎉🎉

[@OpPhilo03]

Thanks sir.❤❤❤

[@pramodbhavsar4488]

Thank you sir for starting powerquery and powerpivot tools I await your videos for new knowledge of excel thank you very much sir

[@Innozant]

Thanks Pramor Ji..Happy learning Power Series.

[@nickbabu369]

You are really great Sir! I like your teaching techniques!

[@Innozant]

Thanks Amit ji,Happy learning

[@AnupKumar-oe2jb]

I am really very thankful to you sir that I am watching your video. What a teaching great sir

[@Innozant]

Thanks Anup.. Happy learning dear🙏❤️

[@rashidalirafi9368]

Spectacular 👏👏👏

[@palakgoel34]

The only channel where I like to comment. Thanku so much Sir for introducing one more valuable playlist..

[@Innozant]

Thanks Palak ,Good Morning..Have a nice day..Really means a lot to me me.❤❤🙏🙏

[@johnpatrick4396]

You are amazing instructor I have ever found on KZbin. Great content and method of teaching is remarkable. Love you sir, Dil se...

[@Innozant]

Thanks dear..Happy learning..Have a wonderful career ahead

[@johnpatrick4396]

@@Innozant Sir, I request you to make a series like this on VBA as well. We really appreciate your effort ❤️

[@devendramalviya5789]

THANKS

[@shivkeshkanoujiya2183]

Nicely Explained Thank you Sir 🙏

[@Innozant]

Thanks Shivkesh

[@yogeshrao5924]

Good Explain gurujii😊❤

[@itssingh.Prashant]

Thankyou so much Sir, Was waiting for the same ETL Tool.

[@Innozant]

Thanks Singh Sahab

[@pawanmaske5665]

Thank you sir i got it very easily the difference between power pivot and power query

[@Innozant]

👍😊

[@artiverma2357]

realy u change my life

[@Innozant]

Thanks Arti..❤️❤️❤️

[@Masishamo]

great....

[@sohailalam9993]

I am recently join your channel.your videos very helpful for me.I love you sir and Thank You so much

[@Innozant]

Thanks Sohail...Recommend you start your learning journey from Playlist Basic Excel onwards (videos in sequence Playlist available in videos description ..kindly follow that we welcome you to experience the taste of Success with Innozant-Seed of success

[@usamajaved5386]

Great sir

[@sandeepkhawas3367]

I believe it's similar to the Power BI and very helpful to the Ones who are learning Power Bi, Thanks for your assistance .

[@Innozant]

Very True ..Power query and power pivot is part of BI..SOON m going to start Power Bi series too

[@sandeepkhawas3367]

@@Innozant seriously I m very excited !!

[@syed599]

You are amazing instructor

[@Innozant]

Thanks Syed

[@ajaysaroha2539]

Thank you so much pls continue it

[@Innozant]

Thanks Ajay ji..👍👍

[@GauravChaudhary-hs7pf]

Ur teaching method is awesome 👌

[@Innozant]

Thanks Gaurav ji..Gn..tc

[@surenderrawat4282]

Thanks for this series.....looking forward for more videos Sir.....Best of Luck

[@Innozant]

Thanks Rawat sahab🙏❤️

[@shrikantbadge3978]

Thank you Dilip Sir.

[@Innozant]

Thanks dear

[@biswajitsingh1686]

Very nice explanation ... Thank you 😊😊😊

[@Innozant]

Thanks Singh Sahab.Gn

[@ArmaanKing17]

Thanks for such informative videos. You are best teacher!

[@Innozant]

Thanks ..Keep learning

[@pintusharma8484]

Awesome, nicely explained the intro...

[@Innozant]

Thanks Sharmaji..Happy Learning dear ❤️🙏

[@user-ic3jf5yl4c]

love from bangladesh sir I am your student.....Thank you

[@oldtowntoastott360]

This is is Gem💥

[@rakeshmlearningentertainme6099]

NICE VIDEO SIR

[@gauravbhatia7987]

Thnq sir power query ka hi wait tha thnq sir

[@Innozant]

Thanks Gaurav ji

[@rakeshthakur9403]

Really nice video thank you so much

[@Innozant]

Thanks Thakur Ji🙏❤️

[@satishojha6240]

Sir I really desperate to learn power query, power pivot,power bi with help of your playlists I very exciting today video thanku for new concept sir. good night 🙏🙏🙏

[@Innozant]

Thanks Satish Ji..Hope you like the Power query video

[@ultron7461]

awesome tutorials sir. thanks a lot 😇

[@Innozant]

Thanks dear

[@bhoopendraraghav9781]

U are great sir..

[@Innozant]

🙏🙏🙏

[@jksunique2463]

Best wishes for starting power query tutorial.

[@Innozant]

Thanks Jeetu

[@situsahoo2482]

Sir hume aacha laga.this video I am eagerly waiting when u start .👍👍

[@Innozant]

Thanks Situ Sahoo ji..started now

[@addnew2448]

Tq sar

[@abhishekshirsekar2065]

Aap jo bhi sikhate wo badhiya hi hoota hai .sir aapake samjana tarika sabse achha hai👍🙏🙏 thank sir

[@Innozant]

Thanks Abhishek Ji...Really means a lot to me

[@RahulChauhan-ll9pu]

Zebredast guru ji 👍🙏

[@Innozant]

thanks Rahul

[@suniljoshionly4u]

U r genious sir

[@Innozant]

Thanks Joshi Ji

[@jayantabhattacharyya628]

Dear Sir Thanks for starting power query tutorial. I'm eagerly waiting for various power query magic. You rightly say that power query is nothing but a life changing tool. I also say that it's a time saving tool also. Thanks & Regards Jayanta Bhattacharyya

[@Innozant]

Thanks Jayanta for your appreciation ..Happy learning Power query.

[@tejpalsain1507]

Thanks sir.

[@Innozant]

Thanks Tejpal ji...Good Morning

[@MrManish261000]

Dilip ji, you rock.

[@Innozant]

Thanks Manish Ji🙏❤️

[@MrManish261000]

@@Innozant Dilip ji, Can I fetch data from three similar tables with equal number of rows and columns using table name ranges only but not column or row name ranges

[@puransingh-sx2tk]

I'm excited 👌🏻❤️

[@Innozant]

👍👍👍

[@R_K_ENTERTAINMENT]

Good start

[@Innozant]

Thanks dear

[@oldtowntoastott360]

This channel is GEM💥🙏

[@Innozant]

👍❤️

[@sakhawatbaloach8006]

best wishes for you

[@Innozant]

👍❤️

[@ahsanullah7682]

After searching power query tutorial ,i couldn't find any video intersting,then i found your tutorial ,though I'm bangladeshi(cant't understand hindi properly) but enjoyed your videos.Thanks

[@Innozant]

Love you Ahsan Sahab..Happy learning.God Bless You dear🙏❤️

[@sawaimalhi8439]

jai ho sirr

[@avinayakchoudhary4172]

Thanks sir ,i am waiting power query

[@Innozant]

Thanks Avinayak Ji .👍👍

[@Ksjain_5390]

🙏🙏Pranaam Guruji, Aaj aapne mujhe - apna keemti samay diya aur Power Query ka ye behtareen idea bhi diya, aaj shuru krne ja raha hu apke aashirwaad se. Baki agey jaise bhi rahega job ke regarding and career, apki guidance mei sab baht acha hi hoga.. Thanks a lot for these good videos and great knowledge you have and excellent work you are doing🙏🙏👍

[@Innozant]

Keep Learning..Never feel low or demotivated..Soon you will get good job.Have a wonderful career ahead

[@Ksjain_5390]

@@Innozant Thanks !!

[@sandeepaswal8944]

सर आप अच्छे प्रशिक्षक हैं। Power Query हमारे कार्य-जीवन को बेहतर बनाता है। मुझे पूरी उम्मीद है कि परमेश्वर आपको वह उपहार देता रहेगा जो आपके लाभ के लिए शिक्षण के लिए है।

[@Innozant]

Thanks Sandeep Aswal Sahab...aPake ye comments mere liye bahut mayne rakhte hain dear

[@prajwalshetty2047]

Nice Video 👍

[@Innozant]

Thanks dear

[@RA-rh5lb]

Thank you sirji , what is unpivot columns,. I do pivot the data..

[@Altaf_Alam]

🔥

[@ramanmangat3320]

Kya baat ae guru jii❣️😁

[@Innozant]

Thanks Raman ji..proque assignment complete kr lena aur upload bhi

[@ishutiwari5567]

nice sir🙏😊

[@Innozant]

Thanks Ishu...Good Morning

[@Jitenderkumar-yp1rn]

Hello sir.... I hope that you are very fine..... After a long time finally install office 2019 version for use power query & pivot....❤❤❤

[@Innozant]

Good Jitender Ji..Happy learning dear

[@syedumai8315]

Sir ap cube ka formula bi explain karay

[@accountsdepartment7444]

Hi....Sir I have a serious problem while transform and edit pdf file from our Accounting Program "Pioneer"......PDF Accounting Ledger statement while converting to excel showing : Debit & Credit side showing in different columns . I mean in 1st page "Debit" shown in column 'A" but second page "Debit" Shown in "B" column so on.......same way "Credit; coloumn also shown in difference coloumn in each page. I means not in one line thought-out the sheet. Pls help me to sort out this issue ....

[@jupitermkk]

बहुत बढ़िया सर ,आपकी चेहरे की मुस्कुराहट ऐसे ही बनी रहे है, चेहरे की मुस्कुराहट बहुत बढ़िया लगता है जैसे लगता है आप हंस के बोल रहे है

[@Innozant]

Thanks Manish ji aapke itne pyare Valueble comment ke liye dear. Happy learning..God bless you

[@anjaligulatiamb_123]

बिलकुल सही

[@Smiles_deep]

Sir your explanation is great. Can u pls explain how to get these options in data tab on Microsoft 365 . Data tab shows only basic options in excel 365 not the actual power query. Thanks

[@Smiles_deep]

​@@InnozantSir pls suggest a way to install power query for excel 365

[@sachinchavan3019]

👌🏻👌🏻👌🏻👌🏻

[@mjaved701]

Dear Sir I really appreciate your efforts, I'm anxiously waiting for power Query complete lectures, sir can you provide me link where I can see all your lectures on Power query? thanks sir

[@Innozant]

I started power query Playlist now.. You may find soon complete tutorial there

[@parmarrahul2680]

👍

[@VLAXIN]

😍

[@GaganDeep-rx5zx]

😍😍😍

[@Innozant]

❤❤🙏🙏

[@deepraazshaw7369]

Sir, I am very excited for power query. If I will learn it, my salary will increase.

[@Innozant]

👍👍👍

[@careergyanshala2734]

Pore yt pr best training padhane ka tarika wah bhut achha sikhaya

[@Innozant]

Thanks dear ❤️

[@manjunathhugar1704]

Sir Ji, I am working under mis team. I have 9 monthly sale data files in separate excel files and i wants to combine into one pivot table but unable to do that every time i am compiling manually ,Please help me.. i have tried but getting error.

[@surajagasti2309]

please bring new videos for power query and power pivot

[@Innozant]

Sure..soon

[@neerajtomar9018]

Sir aap VBA ki bhi vedio banao sir

[@Innozant]

Haan .Jan se aayega VBA series

[@neerajtomar9018]

Ok sir iska intjar rahega ..

[@sharingiscaring1378]

sir m from Pakistan i want to buy your lectures basic to adv excel kindly guide how can i purchase

[@Innozant]

visit our website www.innozant.com and and purchase course from there,Kindly note that we are not video seller,We provide Live Classroom session via zoom

[@sureshrao4051]

Please i request to you can one comple video about what is power bi -pquery, pview, ppivot, pmap

[@Innozant]

Kindly watch career guide playlist ..already there

[@manjulapapanna5633]

Hi ,I am working in Global asset management, struggling to consolidate different vendor reports io master file. Each vendor reports has different headers. Hw to align and get into consolidated. It's daily activity by refreshing this needs add data. pls advise n reply

[@Innozant]

Check out Power query playlist ..it will surely help you out..still issue you may connect us @innozantofficial telegram id for query support

[@ramanjeet1111]

only disadvantage is that it does not select all the files at one, u have to select on by one

[@mohiuddinchoudhury1145]

Hello Sir, Excel file share kese korte Hain tracking apply korne see pehle iska upar ak video banayega. It will be more helpful for me.

[@Innozant]

ok..security ke uapat bna dunga ek video..yaad dilate rhna aap

[@kunalsharma2661]

Sir plz make a video of someproduct wildcard and xloockup. Sir i know you are full concentrating on power query but May be xloockup is a part of lockup and we did not cover it. If you dont have time right now than plz mention me, from when will you start xloockup series.

[@Innozant]

Sharma Ji..Array and Sumproduct Playlist are already there.Latest functions we are going to cover soon in office 365 playlist

[@kunalsharma2661]

@@Innozant haa sir vo playlist to maine dekhi h But m sumproduct wildcard k baare m baat kr raha tha M sumproduct wildcard ki video k bahut time se wait kr raha hu Like : countif wildcard through sumproduct, sumif wildcard through sumproduct

[@Innozant]

haan..wo video aaana pending hai

[@Marathiboost]

Excel me 4.5 lakh ke data ko kaise handle kare .. vlookup lagaye copy pest kare kuch bhi kare ek single text bhi copy pest kare to excel sheet 5 min ka timw leti he kabhi kabhi 10 min.. not responding krke .. uske liye kya karna padega sir... kuch solution he

[@RinkuDevi-uq7yq]

Start my new series Power Query

[@avtarmishra7549]

Sir...kiya Power query window 7 Mai 2016 version mai chal sakta hai..mere mai problem ho rhi h run nhi ho rha ...plllllllzzzzzzzzzz

[@RAKESHKUMAR-qw9cn]

Power BI ka topic hai power query Topic wise study krna

[@Innozant]

👍👍👍

[@RAKESHKUMAR-qw9cn]

@@Innozant power bi ki class kab se

[@syedumai8315]

Sir cube ka formula ap nay banaya plz reply

[@Innozant]

Not now

[@shaalam2096]

Sir power bi and power query same hai different hai please reply waiting

[@Innozant]

Alam sahab Power query Data cleaning tool hai aur Power Bi Data visualization tool hai dear..Bi ke inside hi power query hai ab default

[@SatishKumar-jd5it]

Sir POWER QUERY POWER BI KA HI PART H KYA ?? USME BHI DAX USE HOTA H ?? PLEASE BATAIYE

[@Innozant]

Dono ka purpose alaga h

[@guddusarika5622]

32 bit vale system me excel 2010 me power query tab show nh ho rha

[@yogeshsoni7969]

Sir pls numbring power quary video like 01...... 02..... 03..... 04.... Etc Smajh me nhi aa rha konsi video phle dekhe

[@ramanjeet1111]

is vba getting obsolete or has microft stopped supporting

[@Innozant]

Not at all..VBA ka apna alag market hai wo kbhi absolute nhi ho skta hai .jahan automation chaiye wahan VBA chaiye hi

[@ramanjeet1111]

@@Innozant wat abt power query

[@chandrashekharmishra9521]

Sir excell 2007 me nhi ho payega kya?

[@Innozant]

No dear

[@AkashMishra-yr5pg]

Sir please mere questions ka answer dijiye Excel ke sheet 1 me 200 data hai aur us 200 data ko 200 pdf me convert karna hai o kaise hoga plz reply

[@Innozant]

Excel tips and tricks me video banaya hai maine ..kindly check

[@Marathiboost]

Drag down kare tabbi time le raha he

[@shivakumar-jw7zz]

At least give subtitle to you videos in english. Thanks

[@Innozant]

Noted ❤️👍

[@qaisermehboob993]

dear sequence smj ni a rhi first 2nd 3rd kon c video

[@Innozant]

Power query ke playlist me Jake sequence me video dekhen

[@qaisermehboob993]

@@Innozant thank u

[@bhushanara]

video me kuch sikhane ko nahi mila

[@Innozant]

Kindly watch complete series