Power Pivot RELATED Function | Vlookup Replacement | Relationship and Import Folder Data

Рет қаралды 34,214

3 жыл бұрын

Power Pivot RELATED Function | Vlookup Replacement | Relationship and Import Folder Data using power query
Excel Power Pivot Playlist Link- • Excel Power Pivot
Download the Assignment Master Practice Folder here (All Playlist Example at one place)
drive.google.com/drive/folder...
Music: www.bensound.com
===========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
#powerpivot #tablerelationship#innozant #exceltutorial

Пікірлер: 115

@Uniqueshreee Жыл бұрын

There is no such word as of now for you, I think you are the Unique Excel Guru.

@Innozant Жыл бұрын

Really means a lot to be

@neerajkhurrana283 5 ай бұрын

Sir, I bow to you with respect. You are the best thing that has happened in my life ❤😊

@Innozant 5 ай бұрын

Thanks dear

@deepraazshaw7369 3 жыл бұрын

Sir Mai apke vidoe ko mere Sare frnd ko share Kiya hu. App bahut hi a6a sikhate hai teacher jaisa.

@Innozant 3 жыл бұрын

Haan unsabse boliye jaise maine playlist wise upload kar ra hu video..in sequence seekhna hai unhe..

@saddammalik5566 3 жыл бұрын

You've been very helpful and alongside you are also best friend for us.👍

@Innozant 3 жыл бұрын

Thanks Saddam..Happy Learning dear..God bless you👍❤️

@jaitiwari241 3 жыл бұрын

True

@faisalmd283 3 жыл бұрын

Thanks for resuming the most awaited power pivot series. All thanks from bottom of my heart😊.

@Innozant 3 жыл бұрын

Thanks Faisaal sahab.Happy Learning.. Thanks for your love and support

@akshatgoyal2473 3 жыл бұрын

Thank you so much for starting again series on Power pivot Eagerly waiting for the next chapter

@Innozant 3 жыл бұрын

Thanks Akshat Ji..Happy Learning dear..God bless you 👍❤️

@deepraazshaw7369 3 жыл бұрын

Sir apke jaisa KZfaq me Hindi me koi nji sikhata. Thanks you sir aap hamre life me value add kr rahe hai.

@Innozant 3 жыл бұрын

Thanks Deepraz aapke valuable feedback jke liye..eham hain ye words mere liye yadi apki life me main value add kar paya whi merA fees hoga

@jaitiwari241 3 жыл бұрын

Best part sir you also share dataset to practice and dive deep into each topic

@AvinashKumar-vm1if 3 жыл бұрын

Superbb...Sir ,Aapke video se Life me Value add hota h .... Thank you

@Innozant 3 жыл бұрын

Thanks Avinash..Love you dear🙏❤️God bless you all.

@AvinashKumar-vm1if 3 жыл бұрын

Aapka video mere life me bhot value Add kr rha h sir..... Logo ko Successful people ya Bollywood celebrities se milne ka Sapna hoga....lekin mujhe aapse milne ka h....Ek din Jarur milunga sir...Naam yaad rakh lijiye.....You are my inspirational man...Once again Thank you...Pranam

@Innozant 3 жыл бұрын

Thanks Avinash Ji..Itne valuable comment ke liye..Ye videos aapke lif eme value add kar paa rahe hain ye mere liye bht badi baat hai .Step by step seekhiye aur life me khud ko ek step aage dekhna hai humesha

@vishalbhati912 2 жыл бұрын

Bahot badiya sir. Ye hi sikhna tha mujhe. Plzzz video banate rahna ispe. Thank so much. Aapke channel ko subscribe karke mujhe kai chize janne ko mili he. 🙏🙏🙏🙏

@Innozant 2 жыл бұрын

Thanks ❤️❤️Good Night

@deepraazshaw7369 3 жыл бұрын

Sir very very thankyou for this video. Mujhe Kafi Dino se intajar tha. Thanks you sir.

@Innozant 3 жыл бұрын

Thanks Deepraaz

@artiverma2357 3 жыл бұрын

we all time respect you guru g , because of you i learn excel breifly

@Innozant 3 жыл бұрын

Thanks Arti Verma Ji...God bless you dear❤️🙏

@gulshanmehta6997 3 жыл бұрын

Thanks Sir, for sharing very informative tutorial 🙏🙏🙏

@Innozant 3 жыл бұрын

Thanks Mehta Ji👍❤️

@TheSuvankarKundu 3 жыл бұрын

Boss.. you are exceeding our expectations 🙏

@Innozant 3 жыл бұрын

Thanks Suvankar .Love you dear ..👍🙏God bless you

@shrikantbadge3978 Жыл бұрын

Amazing sir. Thank you.

@sudhashy0 2 жыл бұрын

Extraordinary way of explaining.

@Innozant 2 жыл бұрын

Thanks Sudha...Good Night ❤️

@sudhashy0 2 жыл бұрын

@@Innozant Good Night Sir. Ram Ram 🙏

@jayantabhattacharyya628 3 жыл бұрын

Dear Sir Thanks for resuming the magic of power pivot again. Your way of teaching makes the topic easier for me. Many more exciting functions such as DAX, Measure are yet to come. I am eagerly waiting for that. Sir, does excel 365 have power query add-ins facility? Thanks & Regards Jayanta Bhattacharyya

@Innozant 3 жыл бұрын

Yes Jayanta.. Thanks dear❤️🙏

@VimalKumar-ih6ik 7 ай бұрын

Great Learning

@dhakafady774 Жыл бұрын

thanks a lot, sir for the wonderful content

@Innozant Жыл бұрын

Thanks dear

@sudiptamanna4195 3 жыл бұрын

Your taliking style like Hrithik Roshan... keep it up great video sir

@Innozant 3 жыл бұрын

😊 Thanks Sudipta ...Happy Learning dear👍❤️🙏

@Ashish-ie5di Жыл бұрын

Informative video

@mdsahabajansari6002 3 жыл бұрын

please be consistent ......what do you think people wait for six months to learn new concept.....eventually they try to learn from other resources......maintain a schedule .........you explain concepts very easily .waiting for next video

@Innozant 3 жыл бұрын

Dear Sahabaj kindly note that i am runny number of Playlist parallel and uploading videos on regular basis.Yes Power pivot videos was not uploaded as fucused on Power Query Series.Thanks for your suggestions 🙏❤️

@rajdeepsaha9059 Жыл бұрын

Great Interpretation

@Innozant Жыл бұрын

Thanks Rajdeep

@prabalroybarman5466 3 жыл бұрын

Have seen basic playlist what playlist should I watch next ..and also could you upload count and counta, count if advanced stuffs and also how to combine one function within another and what is the concept

@iveymbabest5303 3 ай бұрын

Awesome video

@Rajvlogs4401 10 ай бұрын

Views nahi aa rhe par video most satisfying hai ❤

@Innozant 10 ай бұрын

Thanks dear

@hemantsingh9966 Жыл бұрын

Great Sir

@ArunKumar-jh4qe 2 жыл бұрын

Sir plz start Power Bi vedios also. Your presentation skills are superb. Thanks sir

@Innozant 2 жыл бұрын

Thanks Arun,Sure dear will start Power BI series soon.

@bholasinghverma2412 2 жыл бұрын

Good evening sir, I am Bhola Singh Verma Mai apka pura video dekhta hu aap basic se lekar advance Tak clear jankari dete ho Mai apna computer me excel file formula put Kiya hu lekin us excel file ko kisi dusare computer me use karne se formula Kam na kare taki excel file ka formula safe rahe. Sir aapse request hai ki aap upay bataye

@Innozant 2 жыл бұрын

Formula hide kar diya karen...security topic me cover kiya gya hai video me

@mohammedshamim9568 Жыл бұрын

Love to hug 🤗 you brother ❤

@ankitjindaljulana 3 жыл бұрын

Thank you sir

@Innozant 3 жыл бұрын

Thanks Ankit ji

@SaurabhSharma-ry8iz 3 жыл бұрын

AWESOME SIR

@Innozant 3 жыл бұрын

Thanks Saurabh 🙏❤️

@createyour6681 3 жыл бұрын

Very great sir

@Innozant 3 жыл бұрын

❤️🙏

@tejpalsain1507 3 жыл бұрын

Thanks

@Innozant 3 жыл бұрын

Thanks Tejpal❤️🙏

@satishojha6240 3 жыл бұрын

Sql mai dekha hai aise but aap ka explanation bahut hatkey hai 🙏🙏🙏🙏. good night sir.

@Innozant 3 жыл бұрын

Thanks Satish Ji .Ab Power Query ,Power Pivot aur bht jald Power BI ke video bhi aane wale hain..seekhiye aur badhiye life me aage

@satishojha6240 3 жыл бұрын

@@Innozant I really excited sir 🙏🙏🙏

@manojkumarsingh3385 3 жыл бұрын

Nice sir ji

@Innozant 3 жыл бұрын

Thanks

@rakeshmlearningentertainme6099 2 жыл бұрын

aswesome video

@prajwalshetty2047 2 жыл бұрын

Sir I used separate Power query to append Gross sales of various Branches to find total Gross sales and Sales return of various Branches to find total sales return in two different sheet, in one sheet total Gross sales and in other sheet total sales return. To find Total Net sales, I manually reduce sales return from gross sales. Sir is there any way to do this all calculation in power query itself.

@rohanparakhe4976 3 жыл бұрын

Please make video on difference between data analysis and business analyst

@Innozant 3 жыл бұрын

Career guide playlis me jaake last video dekhiye.. complete explain kya hai..👍❤️

@durgeshrai8938 3 жыл бұрын

Nyc sir

@Innozant 3 жыл бұрын

Thanks

@AvinashKumar-vm1if 3 жыл бұрын

Aap ye sab kaise jaante h sir.... Kon Book se aap itna Knowledge gain kiye h

@Innozant 3 жыл бұрын

Life me gheeshte 😀hain jo log unhe book ko refer ki jarurat nhi hoti hai .. situation sab seekha deta hai jab apke paas koi dusra option nhi rheta hai aur focused hote hain life me to

@vgug707 Жыл бұрын

Hi, can you suggest few student good in excel, we can provide good job

@Innozant Жыл бұрын

Hi,You may Connect With Innozant Consultancy and share your JD with our Team.

@prabalroybarman5466 3 жыл бұрын

Hi have seen the basic excel playlist so where is the advanced Excel playlist or which playlist should I watch after basic excel playlist and also in one video you said about interview question counta and count func and you said later on you will be uploading advanced stuffs on this first learn the basic concept

@Innozant 3 жыл бұрын

Watch this video mis Learning process kzfaq.info/get/bejne/aJ9jaJhhmr6XqYk.html

@kishorpanara4191 3 жыл бұрын

Sir bahot achha jaga lekin pura samaj me nahi aya kyo ki mere liye thoda advance hai thank you sirji

@Innozant 3 жыл бұрын

Pehle excel finish kijiye jab aapka pivot table finish ho jaye uske baad power query aur power pivot seekhna hai dear Kishor

@kishorpanara4191 3 жыл бұрын

@@Innozant ji sirji ye video dekha aur like kiya

@abhisheksable4592 4 ай бұрын

Hello @innozant please show your screen in full size

@dancertrishika Жыл бұрын

Dear sir thanks, but can you make a video for this.

@Innozant Жыл бұрын

Noted

@artiverma2357 3 жыл бұрын

wow sir padtey kha se hai ap ,muje bhi pilao ye jaadu ki guuti

@Innozant 3 жыл бұрын

Hahahaha...Ye jaadu ki guuti apke paas bhi hai bus regular learning krte rhiye ek waqt aane par apko bhi ofc me kahenge mujhe bhi de do ye guutti jaadoo wali

@user-xu8ch5qd7u Жыл бұрын

many to many relationships do not currently support worksheet

@ViveganVibes 3 жыл бұрын

Hello Sir I'm a librarian I need your help to creat a library issue return of books please help me.

@Innozant 3 жыл бұрын

Hi Narmada..Kindly share your query @innozantofficial telegram id..Will guide you for the same.

@sudeshjadhav8838 3 жыл бұрын

Sir ji main payments slip bana raha hun our us main uppar ka column merge hai wapas char line chhodkar niche ka column bhi merge hai to autofit ho sakta hai kya

@Innozant 3 жыл бұрын

Sheet dikha payenge to sure help kar paunga..@innozantofficial telegram id

@sudeshjadhav8838 3 жыл бұрын

@@Innozant bilkul sir. thanks sir apke sub videos achhe hai. Aap bahut hi asanise aur aur bahutsi chhoti chhoti chij samjate hai thnks. Is me photo copy bhej sakte hai kya.

@sudeshjadhav8838 3 жыл бұрын

Dusra koyi option hai telegram nahi use karta hun

@TheVaibhavdang 2 жыл бұрын

what is the folder name in the drive for evening,general,morning txt data ?

@Innozant 2 жыл бұрын

It is Ava under pivot table playlist

@TheVaibhavdang 2 жыл бұрын

Ok I will check it

@user-xu8ch5qd7u Жыл бұрын

many relationships do not support

@abdullahalmasud302 16 күн бұрын

Sir, Could not find the data folder(morning , evening ,night data file)

@Innozant 15 күн бұрын

It is there inside folder .kindly check link in video description

@jyotikashyap7733 2 жыл бұрын

Sir, Power pivot add download kha se karna h pls share the link if possible.

@Innozant 2 жыл бұрын

Jyoti ..Which version of office you are using..? Download it from Microsoft site

@jyotikashyap7733 2 жыл бұрын

@@Innozant Sir, I using Excel 2013, i have downloaded power query as per u r suggestion but i can't download power pivot from add-ins and also not showing my add-in into Excel. 2013 which I m using 2013.