Power Pivot Explained | Installation | Importing Data to Power Pivot
HTML-код
- Опубликовано: 19 окт 2024
- Power Pivot Explained | Installation | Importing Data to Power Pivot | Version Compatibility
Power Pivot is an Excel add-in you can use to perform powerful data analysis and create sophisticated data models. With Power Pivot, you can mash up large volumes of data from various sources, perform information analysis rapidly
Excel Power Pivot Playlist Link- • Excel Power Pivot
Download the Assignment Master Practice Folder here (All Playlist Example at one place)
drive.google.c...
===========VIDEO COURSE============================
✅ Mastering Excel Video Course
www.innozant.c...
✅ Mastering Power BI Video Course
www.innozant.c...
✅ Mastering VBA Video Course
www.innozant.c...
✅ Mastering SQL Video Course
www.innozant.c...
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/innozanti...
#powerpivot #excelpowerpivot #powerpivottutorial #importdatapowerpivot #innozant #learnpowerpivotexcel #powerpivotexplained
hello sir, i m your student and subscriber from Pakistan. I really love the way you teach us excel and now advance excel. i do not have words to admire your hard work and content. how clear you are, everyone can understand and practice you are really wonderful.
Thanks Dear..Keep Learning ❤️
Fan ho gaye h Guru... Bahut din k bad mila h koi Sachmuch Guru.. and we hope u will not leave us inbetween...
Thanks Santosh Ji..Good Morning have a nice day..never leave dear.
Happy learning. Thanks for being part of innozant
सर जी, बेहतरीन, लाजवाब, हमेशा की तरह, मानो हर बॉल पे छक्का.
पहले मुझे मेरा काम बेमतलब, बेकार सा, बोरिंग लगता था, सर जी, आपने उसी मेरे काम को मतलब और मकसद दिया है,
आप के हर वीडियो में बहोत मज़ा आता है, धन्यवाद् 🙏🙏🙏
Thanks Shukla ji ..Itne pyare appreciation Ke liye . Really means a lot to me ❤️🙏
Learn a lot from you. Thanks. Love from PAKISTAN
You're teaching amazing..no need to watch again nd again..
Dear sir your every video is super . One time watch is enough to learn
Thanks dear..Happy Learning ♥️
Sir kiya zabardast method sy ap smajhaty hain. Sir i am very impressed. Thanks sir is topic ka maine bohat wait kiya k jab ap ye smajhaye gy phir hi smajh aye ga aur ab smajh aana start ho gya. Thanks a lot sir
Thanks Umair Zahid Sahab..Dnt worry bilkul patience ke saath complete course krenge step by step jaise excel seekha re h .aayega samajh ❤🙏
Sir maine apko aik mail bi ki thi apki guidance chahye us main.
Kasam se sir jisne bhi aapka excel video playlist pura kia ho ga company interview mai usko fail kar hi nahi sakti.we are waiting next part of power pivot thanku sir and good night 🙏🙏🙏
Ye aaone isliye anamise kiya hai kyunki aap start se jude hain aur seek rahe hai..Thanks for your love and support Satish.Good Night..God bless you
aap bahat achha padhate hain.... your teachings are selfless.... Thank you Thank you Thank you sooooo much for creating this kind of learning content for all of us.....
Thanks dear..Keep Learning
I am not getting the Power Pivot in add ins. I followed your steps. I am getting only Power Map. Please guide@@Innozant
Thank you brother your hard work for us is always appreciable.
Thank you SIR, I am really enjoying your videos. Looking forward to understanding power pivot.
Thanks Rajeev
❤❤❤Sir You are Jem for students ❤❤❤
Thank you Dil Se❤
Thanks dear
Thank you so so so much sir apne itni details me videos banai hai aj maine apki videos se achievement kari hai. Please keep on creating video in a detail manner you do. Thanks a lot.
Also the practice sheets were very helpfull.
Thanks dear..Keep learning
BEAST TEACHER FOR EXCEL LEARNER.
Thanks Haphij sahab ❤️
Getting Excited To Learn Power Pivot With Patience
❤❤
Very Nice information and examples of power pivot thank you sir I await sir
Thanks Pramod Ji
Best teacher ❤
nice definition about power pivot
Thanks Arti..❤️❤️❤️❤️❤️
Sir, continue power pivot series I am eagerly waiting
Duper Hit Guruji🙏🏾
Thanks Shiv ji
Super super. This channel is learning hub❤️❤️♥️🇵🇰
Thanks Raja..Happy Learning dear..God bless you
Guru ji supeb....❣️
Thanks dear
Only saying thanks don't think is enough towards your hard work of making these tutorial...
You deserve more...
But this is even true there is no substitute of this word too.....
So thank you so much sir for this excellent series of videos
Thanks Sheikh Sahab..Allah bless you..Happy learning ❤️
Great interpretation
Amazing. Thankyou Sir.
Sir aapki wjah se MNC m mera interview cleared ho gya h MIS role k liye
Wow..Great Arun.
Proud of you..Have a wonderful career ahead 👍👍
@@Innozant thanks sir
Great sir ji... Jab aap itna expert hai excel me to .. Apke guru ji kitna expert honge 🤔🤔🤔🤔 😊apna time ayega ..hum bhi dhire dhire expert ban rahe hai apse sikh ke 😊😊
haha..main to bina Guruji ka Self learner insaan hu pragati..😀haan kyu nhi bnenge expert yadi ek hi topic ka practice kai baar krenge to❤🙏
@@Innozant hame pata hai sir ji ki abhi koi guru ji nahi sikhate aap khud experiment karte rahte hai formulas ke sath lekin suruwat me koi to sikhaya hoga n kisi ne to rasta dikhaya hoga bhale hi us raste per aap chalne me expert ho gaye hai aaj... Jo suru me rasta dikhata hai wahi to guru ji hota hai n mai unki baat kar rahi hu... I'm sorry itna deep me bolne ke liye 🙏😊😊
Acha to Ye pucha aaapne..Aur Sorry Kisliye...❤🙏kaunsa topic aaj padha apne..?Step by step saare topic dubara revise krna hai apko
@@Innozant hyperlink, sumifs aur kai sheet ka value formula ke davara dusre sheet per nikalna.... Yes sir mai excel pahle se hi sikhi hu bas Beach me competition ki tayari ke chakkar me revision hi nahi kar pai so cheeje bhulne legi thi.... Lekin apke video dubara suru se besic se dekh rahi hu taki jo nahi aata wo aa jayega aur jo aata hai wo revision ho jayega... Thanks 🙏
Very good Pragati..harek video step by stwp dekhte aur practice krte jaiye..aap kuch time baad kahoge khudme kya changes hua hai aapke.i hope ❤
beautifull style
Thanks...Have a grea learning journey ahead👍❤️🙏
Thanks bro for your support
Very useful sir 👍🏻👍🏻👍🏻👍🏻
Very nice video helpful thanks sir
Thanks Madhuri,M uploading Power Query Series now after that you may able to see complete tutorial of Power Povot dear
Sir aise padate rahiye sir thanks
Thanks Panku
Very excited to learn Power series🤗🤗
Thanks Balveer
What a explanations man salute👏 i am at your 2nd video hope for better learning
Keep Exploring 👍❤️
you are real life hero
Very nice sir, interested topic 🙏🌷
Thanks Nilesh ji
Great Interpretation.
Thanks Rajdeep Ji..Happy learning
very Interesting Topic🙏
Thanks Pavan ..Aise hi interest banake rakhenge aapka..Happy learning dear
Dear Sir
Superb beginning of power pivot tutorial with wonderful explanation. Really you are an Excel Guruji. I am sure lot of interesting tutorials are coming in near future.
Thanks
Jayanta Bhattacharyya
Thanks Jayanta...God bless you..happy learning
Thnx sir ji 🔥🤗❤️
Great Learning
Good work keep it up. All the best Dilip bro
Thanks Shahroor Sahab❤❤🙏🙏
Beautiful sir
Hi sir, hope u r doing well. Sir can use power pivot in excel 2007?.
Awaiting for next video sir please upload
After Power query series will upload powwr pivot
Hello sir, I recently started following you...I like the way you are explaining everything, you are a good tutor and a motivator. I have watched all the video's for Power pivot. Please let me know when you are gonna upload further videos on power pivot, SQL and VBA.
Thanks Ruchi for valuable appreciation.
yes we are going to upload soon power bi series after completion of power pivot & power query
Hi sir..very well explained...I love to see these videos by your teaching methodology...when you are planning for ..VBA and power bi tutorial series
Thanks dear..Soon after power series
Waiting for your continuation in Power Pivot table series, as your teaching skills are very good and simple to learn for anyone.
Thanks Pawan..Power query and power pivot both dear...uploading soon.
@@Innozant Also, pls clear the difference between Power Pivot, Power Query & DAX. Regards
already made video on this..kindly watch Career guide Playlist for the same
@@Innozant I am not able to find next video and how to download same file
Wonderful sir
Request for further videos on Power Pivot
Sure after power query
Really enjoyed sir where I willl get the complete video of pivot table
Kindly watch seprate playlist of pivot table is there.❤️❤️🙏
great sir 👌☺️☺️☺️☺️
thanks sandeep
Thanks
Sir plz upload complete power pivot video.
After Power Query m going to start uploading power Pivot videos
Is power Pivot available in Excel 2016 Standard? I am not getting any clue.
Thanks🙏
Dear,
I am using 2013 but not available power pivot in add ins, how i will get it. My laptop is 32 bits. It is office laptop
sir plz complete power pivot series
sure.pehle power query finish kar lete hain phir power pivot par move krte h
sir power query,power pivot and power Bi me kya difference hai? aj ke time ke according konsa jyada use hota hai. kya seekhna acha rhega.
Career Guide playlist me maine explain kiy hai already aap wp video dekhen
ruclips.net/video/tkFv2UTDzaI/видео.html
@@Innozant ok sir ji,thank you😊🙏
Tq very much sir
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.
Dear Sir
we are waiting next part.
sure👍
thanx sir ,,,,, sir power pivot aur power query power bi mai bhi hai ....to excel mai seekhle to dono mai kam chal jayga ?
offcourse power pivot ,query ho kahin bhi excel ka ho to plugin h
@@Innozant ok sir thanx
Nice video
Great interpretation and I L U sir
Thanks Kishire Ji..Love you dear for your love and support..❤
Very good information 🙂
Sir mere 2016 ke com add in me power pivot ka option nahi dekh raha hai
excdl 2016 profesdional h ya kaunsa..ek baar jo ppt diya h maine usme se dekhoye kaunsa version me supprtive nhi h wo list diya h
Good Morning Sir,
Have A Great Week Ahead.
Sir Normal Data Ko Bhi Power Pivot Mai Import Kar Sakte Hain Kya?
haan kyu nahi..but large data jab ho tab jrurat hogi uski..
@@Innozant Sir Aaj Maine 80 Thousands Tak Range Li Par Phir Bhi Excel Mai Hi Sum aur Sumif Dono Value Aa Gayi Without Power Pivot ka use karke,
Minimum Range Kitni Honi Chahiye Power Pivot Ka Use Karne Ke Liye?
Any Idea
jab 10 lac se jyada row to power pivot ki jyada jarurat
@@Innozant Kya Real Mai 10 Lac Row Par Work Hota Hai? Can't Believe.
Anyway I Am Looking Forward To Learn Power Pivot With Excel King(You).
not 10 lac dear more than 10 lac kitna bhi
Sir ji please provide chapter wise video list of Power Pivot
Playlist is there and videos are in sequence dear..more videos are coming soon for this
good video
Sir good evening
Sir mere Excel ka version 2016ka hai aur isme add ins me ja kar mere me sirf Microsoft power view for Excel hi so ho rha hai
Plz
power pivot praice see required hai
sir i am using ms 2021 but even after activation from in add still i am not getting power pivot plz help
Thank sir
Thanks Gaurav ji
Sir,
VBA series kab start karne ka plan h bcz VBA demand day by bay in Market
Data Visualization tool is more important in comparisuon to VBA thats why startwd series of POWER
Sir, Power Bi sekh le to power pivot sekhne ki jarurt padegi??
Power query aur power pivot power bi me hi cover ho jayega dear
@@Innozant thank you very much sir you're so humble person that i have ever seen....
Fabulous
Thanks Sudha
Guru ji kisi bhi topic ki series build kiya kijiye jise ki hume or bhi zyada flexibility easy to watch rahe apki Playlist me topic break ho rahe hai kuch idhar kuch udhar 🙏🏻
Anil ji sabhi topic ke seprate playlist hain..aap jb bhi video dekhte h to playlist me Jake dekhen sab sequence me milegaa..
Uploaded video me to har ek alag alag topic ka video upload hota h..wahan se nhi dekhna h
@@Innozant sir jo apki Playlist me beingner excel usme index match nhi hai countif nhi show nhi ho raha h please help how to find out
Sir plz upload power pivot videos
After power query series dear
@@Innozant sir plz upload videos quickly on power Query. I really appreciate the way you teach.
Osm sir
But screen proper share krogo to kafi acche se dikhega nd apni picture toda chota rakhoge to
🙏🙏
Ok Sure Manoj ji..aaj walw video me conceptusl hissa jyada tha mujhe explain krna tha isliye nhi to mere video bhi chote rhte h aur zoom bhi.thnks gn
sir please help me ... 2016 me nhi show ho rha hai. only microsoft power map show ho rha hai bs.
there is any English version tutorial
No dear ..Its for Hindi audience
Dear. Sir practice file is not going to be downloaded. Plz. Check its access for any one. For all power querry power pivot and pivot tables practice files not download
It's open public link for all .. kindly try again.
Downloadable file are there..you may download it
Still waiting ....pls continue
sure dear
SIR🙏
I Didn't Know About Power Pivot
You came to know by time
Sir मेरे ऑफिस में 2013 एक्स है उसमें मैं अलग से एडिंग इंस्टॉल करके पावर क्वेरी use करता था लेकिन अब मुझे नया सिस्टम मिला है उसमें विंडो 11 है और एक्सल एक्सेल 2013 है उसमें भी मैंने एडिंग अलग से इंस्टॉल कर लिया है नया तब भी आ गया है पावर क्वेरी का लेकिन वह वर्क नहीं कर रहा है क्लिक करने पर कुछ हो नहीं रहा है यह ठीक कैसे होगा
Institute kab open hora sir
1st week of Feb se reopen hone ja raha hai offline classes
@@Innozant thank you waiting for it
Sir next video kab ayega..
Bht jald❤️🙏
Next video sir
❤❤❤❤
Hi Sir,
I want to know, how can we install power pivot in excel 2013 professional.
already process bataya hai video me dear
Sir i required download link.
I also facing Same problem ... Pls share add in link to download the same 64 bit 🙏
Sir how can i install power pivot in excel 2016? It's not showing in add ins.
Inbuilt in office 2016
@@Innozant sir my excel version is Microsoft Office Standard 2016...but in "add ins" it's not showing... Can i install it from Microsoft site??
Excel 2013 add in link please ... 64 bit
Not available on Microsoft support website
Office 13 64 is available for download ij number of channels
@@Innozant sir, nahi samjha kya bolna chateho ??
hello sir.
sir mere pas excel 2016 hai but add ins mai power pivot nhi hai kese unable kru plese help kr deejiye.
Com addinns me dekhiye hoga
Sir mene saara chk kr lia hai nhi hai. Mere pas pirated version hai 2016 standard hai.. sir please help me out... Kya mai google se download nhi kr skta. Agar kr skta hu to kese please guide kr deejiye..🙏🙏🙏🙏
Add ins mai only power map hai. Mene disable ad ins mai bhi ja k dekh lia but waha kuch nhi hai ki enable kia jaye..and controle panal ma ja k ms offc app mai ja k bhi chk kia waha bhi power pivot show nhi ho rhi hai
Hello sir, please help me out
Wi any other video in the series will come
Chirag Ji after power query m going to upload more videos of power pivot 🙏❤️
Oh, thank you for replying
Mere system me ms excel 2013 hai but ume power pivot inbuilt nhi hai so plz help how can enable pivot table.
File-options-addins -com addins me check kiya aapne.?wahan se enable kar lijiye
@@Innozant yes sir i already checked but wanha blank hai...
offcie 2013 professional h sayad usne nhi h
Hi sir where is your next video of power pivot
under power pivot Playlist
@@Innozant only two videos there
Yes ..first m going to cover power query series
My question
Kisi ka name hai jaise
Indian isme I ketne bar hai wo kaise count hoga
👍👍👍👍
Thanks Mohit
Main kam kya hota hai power pivot ka ek line me javab do sir
It is use for data modeling(to create relation between multiple tables)
Lazwaab aapke liye jitna kuch kahu kam pdega
Thanks
Kitna bolte ho yaar