Introduction to Power Pivot for Excel
Вставка
- Опубліковано 3 жов 2024
- Learn how to connect, analyze & visualize massive amounts of data from familiar interface of Excel | Advanced DAX formulas, measure patterns, custom calendars, performance optimization and tricks
Go for Power Pivot if you are,
1. Very good with Excel
2. Work as a data analyst or manager
3. Responsible for reporting, analysis or visualization
4. Have lots of data
5. Create dashboards or MIS reports
6. Keen to master Power Pivot
Excel Power Pivot Playlist Link- • Excel Power Pivot
Download the Assignment Master Practice Folder here (All Playlist Example at one place)
drive.google.c...
Music: www.bensound.com
===========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 #powerpivotinexcel#Innozant #msexcel#powerpivotutorial
Your content and explanation is simple and easy to understand.
Thank you for your contribution sir.😊
Tq u sir bht din SE wait Kar rha tha power pivot Ka...thank u very much sir.👍
Thanks Aftab ji🙏❤
@@Innozant Sir Please aek Video bane "Lookup" ke hawale se please sir please.
आप हमारे जिंदगी मे आये उजाले की तरह to give us right direction सर.
Thanks Shrikant Ji for such a lovely appreciation..God Bless you dear.❤🙏
Sir Main apka fan ho Gaya hu. Aap meri life change kr de rahe hai. Thank you sir itani a6i Tarah se video banane ke kiye. Apko Mera bahut bahut dhanyabad
Thanks Deepraaz..Happy Learning. God bless you dear
I wish I watched your videos WHEN YOU UPLOADED IT I WAS IN THE GOOD COMPANY RIGHT NOW
You are not late dear..start your learning journey now.
Very informative... Thank you sir
I would like to thank to innozant chenal and too innozant family, cause I m graceful of you sir.
Love you sir, 🙏
Thanks Pawan for your respect,love and support dear..really mean a lot to me
Apse seekhne m bhot maaja aata hai , you give lessons also and explain things very lighly
Thanks dear
Great explanation sir,
Thanks Hemant ji
Great yaar itna detail me bohot hi kam log shikhate hai..Appreciated Sir👌👌👏👏
Thanks Raza...Aisw hi complete course tutotual learn krenge humlog dear
@@Innozant zaroor👌👌😊
आपके बोलने का अंदाज बोहोत जबरदस्त हैं सर. that's why I am your fan.
Thanks Shrikant Ji .Happy Learning
Thanku sir for power pivot explanation.sir humko machine nahi banna hai knowledgeable banna Hai jo aapki video se ho jaye ga.good night 👌👌👌
Thanks Satish Ji.Happy learning dear.
Thanks for this whole playlist ❤
Sir, awesome pls continue it daily power series
Weekly.daily me aur kai saare playlist ek saath chal re h dear
I hope nothing else
Hats off bare Vai, Love from Bangladesh
Thanks dear
Zabardast video once again Sir. Thank you
Hello sir mai apka regular viewer hoo aur mera kaam Google Sheets pe hota hai jo ki bahut hang hota hai to kripya is topic per bhi vidio banaye sir
Sir sach bole toh.hungry to grab to learn.come soon sir.❤️
Sure Situ..Soon dear ..gn..tc.
Great Gurujii 🙏🙏🙏
Sir aapki wjh se humara ghar chal rha hai 👏🏻
Nahi dear ..Wo aapne mehnat kiya hai..
Koshish kariye khud ki skills itne ache se improve krenge ki aapki wajahse aur logon ka Ghar chal sake👍❤️
Thanks Thanks Thanks Thanks Thanks Thanks Thanks Thanks Thanks Thanks
Must awaited Series😀😃🤗🤩🥰😘😍🙏🙏🙏
Love you Pavan Ji for this much respect and love dear🙏❤
Again first like nd comment
Thanks Sahil🙏❤
Sir way u present the things connect masses.Keep it up.
Bahut accha explaination
Thank You Sir
Awesome Class As Always
Thanks dear
Hello sir, Just saw your introduction to power pivot video and its really great. Can i find all the videos related to power pivot and power query in your channel.
Yes dear . please find seprate Playlist for both
Thank you for power pivot.
Thanks Tejpal
nice video
Great Sir, I am very excited to know about it.. excellent explanation.. Sir
Thanks Anup ji❤🙏
Awaiting for your next video sir on PP
sure soon
Interesting and likely to learn sirji 👍
Thanks Yogesh
Hi sir.you teach excel at advance level.thanks for that.i have just one query is it any need to join your courses.because you already teaching deeply on UA-cam and gives us training.please suggest.
speaking honestly you dont need to invest your money in our course if you are thoroughly able to understand every thing taught in the virtual training .but, if you want one on one attention then u are surely welcome to our institute its always open for you .
so you dont need to worry about anything and all the best for the future
Thank you so much sir.you are inspiration for all of those who want to succeed in their life.🙏👍
thanks rushali for the wishes may god bless you and the whole innozant family's best wishes are with you .
best of luck for the rest of your career
It's helpful
Thanks Chandan❤️🙏
Dear Sir
It makes me very happy that much awaited power pivot series is about to start. In power pivot intro tutorial your way of teaching really impressed me. I wish every success of your channel.
Thanks
Jayanta Bhattacharyya
Thanks Jayanta for your love and support..Good night..tc.
all 10 videos cover power pivot and advanced power pivot?
Very nice sir
Very nice sir!!
Thanks Badal..Gn.tc
Thank you so much.
Thanks Arif ji
Great learning 👌👍
Thanks
Good video
Thanks Sunil Ji
Thanks sir
Thanks dear
sir advanced power pivot aur dax ka content youtube pe nahi hai aisa kyo
Sir ageing report bhi bata dijiye please formule se bahut hard or time taking lag rahi hai
Sir 2007 me power query avelble nhi h kya ?
Please complete power pivot table series
Pehle power query finish kar dete hain phir jal krate hain power pivot
@@Innozant Please Sir, kindly do
I am eagerly waiting for the power pivot series
Please share when will be series coming, if possible
Nice Sir😊
Great 👌
Guru jii🙏
Thanks Raman Ji..Happy Learning dear
Aaj he CV main update karne ja raha hoon advance power Pivot 😂😂😂😂 dil se
👍🙏❤😀
Thanks sir, I have learnt alot from you.. but I hv 1 problem. How can I calculate cumulative achievement % in a pivot table. How to do field calculation for that.
Sharw data sheet for the same
Mai Toh Sikhne Ke Liye Interested Rahta Hu Humesha, Kyoki Mujhe Khud Se Behtar Hona Hai.
good
Nice
Thanks Asif sahab💖🙏
sir. ur all videos are very helpful. but please remove background music. this wasnt there in vlookup Playlist. this background music is irritating
Thanks Isha for your valuable suggestions...Wo edit krte time sound jyada reh gya tha background ka..ok let me try to reduce voice of possible
Thanks sir...
Thanks Aman ji..Happy learning..gn
Hi is there any that we can query power pivot data like sql query and place the data in excel. If possible, could you please make a video for that
Using pivot table find Total any no ODR ID Count AND Total Unique no is repeated and some are unique ODR ID COUNT no are duplicate 2 or 3 time and some are unique Mobile No wise in the Same Pivot Table i have use dis . count but not possible
❤️❤️❤️
sir mere paas 2016 standard hai usem nhi aa rha hai
Hello…I have PDF file which have some coloured text can I get the data in word or excel with the colour?? Please help.
Power query and power pivot m kya difference hai ??
aane wale videos me saare doubt clear hote jayenge..Have patience dear
please help solve the problem
Thnq sir 🙏🙏
❤🙏
sir i eagerly waiting for this series.
thank you so much.
but i have some problems with my excel software.whenever i transfer data or use something in power query,it always shows unexpected error code 0xFFFFFFFF.And this happends not only with huge data but also for small data with only 10 rows.And i know power query is important for power pivot.if you don't mind,can you please send me thr download link of your excel latest version (i mean 2019)?because i think there is something error with my version.mene google and youtube pe search kiya ye problem but koi solution nhi mila.baki functions to perfectly work kr rhe h bs power query and power pivot me kuch error ara h.data transform hi nhi hora.file select krte hi loading hoti h and unexpected error.please help me sir if you can🙏
thats means last example of pivot table where i use power query not done ? First try to implement that with power query still the same prob you may found then it may be your excel us currupted or some other reason.Aur saare function yadi work kar rhe hain phir ye bhi chalna chaiye..connction check ktke dekhna db ka wo create kr pata hai ya nhi
@@Innozant sir i think power query currupted h meri.data tab me new query me jake file select krni hoti h ya fir table select krke query create krni hoti h kisi se bhi work nhi krra.sb kuch try kr liya.data query me load hi nhi hora.aur agr glti se transform.ho bhi jata h to air koi feature apply kro to firse vhi same error ata h.
ap apne wale excel ka download link de skte ho kya?apne bhi shyad google se hi download kiya ho?
haan..but yaad nhi hai link Ishu..kisi youtube ke video me link tha description me whin sw kiya tha download..but dahi chal ra hai mera to..wk baar kisi aur link se krke dekhiye ya main kal dekhta hu ek baar aur btata hu link
@@Innozant ok sir g.then i am waiting.mil jaye to theek na mile to koi bat nhi jyada tension mt lena ap.
me to bs isliye puch rhi thi kyoki mobile data se download krna hota h mujhe.aur agr fir se mujhe koi currupted link mil gya to bar bar download krna possible nhi.agr fir bhi nhi chla to kya hi kr skte h.adjust kr lungi me.thank you so much sir🙏
@Shalu Jain vo sirf old version me hota h.latest versions me inbuilt power query hi chlta h.jo ap bol rhe ho vo excel 2010,2013 versions me chlta h.2016 ke bad se inbuilt power query aa gya excel me.alg se install nhi ho skta
Sir you haven't uploaded macros series yet.
Yes Shahida..Will upload soon
Sir aap vba kab suru karege???
Kuch time baad..kai saare playlist chal re hain ek saath itna manage nhi ho payega..thts why
@@Innozant ok sir
Sir, today I contact innozant but, there was some another guy named Dilip Jha. Confuse. Pls let me know. Thanks
Hahahaha..There is only one guy...why you confused ?😊❤️
gangadhar hi shaktimaan hai😂😂😂
Sir Google in scripting per video banana
Acha Kuch time baad dear.
Not Understand [@SalesRep]
Plz Explain
Query?
When will next part release
soon
@3:48 you mistakenly said 1048516 which instead of 1048576
Ohh ..kindly rectify it.. Thanks for notifying us❤️❤️👍
@@Innozant its request can you make one video bunch of hidden command in excel which we can add and use in customize tab hope this is good topic and helpful for your subscriber If you had already made please share link
Sir I hv mail one query request you to pls revert with solution
OK..Will let you know dear..Time nhu rhta h bikul bhi.
@@Innozant okay sir thanks for ur rply
Find highest and lowest value.
TEBAL
Highest Lowest
20 44
40 45
60 51
Drop-down list
Highest/ Lowest =
Hi sir
high music
Noted...will work in next video
😊😊😊😊😊😊
What is your problem man? It is so annoying to focus when you keep moving right to left and left to right ...
It was old videos dear that time unable to do good editing,Sorry for your inconvenience
👍👍👍👍👍
Bhai aap itta zyada bolre aur batare bhoot kam, 13 min me hi bata sakte thae magar sirf intro me hi lagadiye aap pura video. Islye skip krna padhra apki video ko.zara kaam krte krte boldiyeto bhi samj jate log.
Ye tips and tricks video channel nhi hai..complete course jab karte hain to bus topic ko touch krke nhi nikal jana hota hai in depth explain karna hota hai..yadi time ki kami hai aapke paas aur jaldi se crash course karna chahte hain uske liye ye phir galat channel hai....aur bht resource hain padhne ke liye wahan kam.time me Seekhiye
@@Innozant Are Sir g aap naraz hojare kaiku, mai bus explanation bada hogaya bol ke bola, aap galat mat smjhiye, mai apku demotivate ya phir nicha dikhane k liye nai bola, agar apku bura laga to usk liye sorry, mai apk videos dekhta hu thode tricks sikha apk hi videos se...actually i was excited to see the trick but there was no content about the power pivot.islye mai kuc zyada boldiya jaisa apku laga shaad.Many Thanks👍
If you can stop blabbering, It could have made sense
Bhai Kam ki bat kr yr sirf boring kr rha hai😤😤
Aakash ji ye Jadoo wale tricks video nhi hain ..Is channel par in depth course learning hota hai..Aapse gujarish hai kripya dubara video na dekhen na bore ho.Entertainment nhi educational channel hai ye .
Respect your parent and teacher.😊
you talk much sir
Why can't you just get to the point you are trying to explain and how about not moving yourself from right to left so the viewer can actually concentrate on the actual topic. Total waste of time.
Thank You Sir
Find highest and lowest value.
TEBAL
Highest Lowest
20 44
40 45
60 51
Drop-down list
Highest/ Lowest =
Find highest and lowest value.
TEBAL
Highest Lowest
20 44
40 45
60 51
Drop-down list
Highest/ Lowest =
whats Problem while creating this list..you wang combined list i hope .
sir combined nhi Hoga Kya ye