Тёмный

Excel GetPivotData function | Use GetPivotData Function to Pull Values from Pivot Table 

Innozant
Подписаться 155 тыс.
Просмотров 50 тыс.
50% 1

Excel GetPivotData function | Use GetPivotData Function to Pull Values from Pivot Table
1. Getpivotdata vs Vlookup
2. Get Data from your Pivot Table with the GETPIVOTDATA Function
Excel Pivot Tables Playlist Link - • Excel Pivot Tables
Download the Assignment Master Practice Folder here (All Playlist Examples 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...
#innozant #pivottable #getpivotdata #excelpivottable

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

 

14 окт 2024

Поделиться:

Ссылка:

Скачать:

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

Добавить в:

Мой плейлист
Посмотреть позже
Комментарии : 136   
@ravichauhan3933
@ravichauhan3933 9 месяцев назад
You are the first to come to mind when I'm stuck in Excel because you always have solutions to my problems.
@Innozant
@Innozant 9 месяцев назад
Thanks dear.
@HaseebMirza-f8y
@HaseebMirza-f8y Месяц назад
I was stuck on this function. Your video helped me out.
@monysain6762
@monysain6762 11 месяцев назад
Sir, words would never do justice to how grateful I am to find your RU-vid channel thank you for making such content
@Innozant
@Innozant 11 месяцев назад
Thanks Mony..Keep Learning
@sonamchauhan4969
@sonamchauhan4969 2 года назад
Superb explanation, bhut acche se explain kia, kisi ko bhi samajh aa jye 👍🏻
@Innozant
@Innozant 2 года назад
Thanks Sonam,Step by step in sequence learn kariye aur practice kariye ,koi query aati hai to telegram id @innozamtofficial par puch sakte hain.Have a wonderful career ahead
@aabdullahhaasnain7033
@aabdullahhaasnain7033 Год назад
You tought me what I searched for. Great man...
@Innozant
@Innozant Год назад
Thanks dear..Happy Learning ❤️
@sunilmasta
@sunilmasta Год назад
The confident way of teaching makes you different from the crowd
@Innozant
@Innozant Год назад
Thanks dear
@virendrahardiya2797
@virendrahardiya2797 Год назад
आज फिर कुछ नया सीखा है sir thank you so much sir ❤️💓🥳
@nikhilagarwal9024
@nikhilagarwal9024 4 месяца назад
way looking for this from a long time, found many videos explained in shortcuts. This is in detail and extremely helpful
@Innozant
@Innozant 4 месяца назад
Thanks.Keeo learning
@ravichauhan3933
@ravichauhan3933 9 месяцев назад
Jha Sir, you are always great "Guru Ji in the world of Excel.
@Innozant
@Innozant 9 месяцев назад
Thanks
@pravinkumbhare1750
@pravinkumbhare1750 Год назад
Bahot hi badhiya explain Kiya Sir... Thank You..
@hiteshkekre8514
@hiteshkekre8514 7 месяцев назад
too good, this is truly awesome and the way you simplified the formula is commendable
@Innozant
@Innozant 7 месяцев назад
Thanks.Keep Learning
@keshariprasad1992
@keshariprasad1992 Год назад
Very nice Brother. U r teaching very nicely.
@Innozant
@Innozant Год назад
Thanks dear
@arunkumarsinghark3024
@arunkumarsinghark3024 2 года назад
Amazing sir ji thanks continue to 🌹राधे राधे 🌹ARK 🔥🏹हमेसा हंसते मुस्कुराते रहिये l
@mahantheshgh151
@mahantheshgh151 Год назад
Your enlighten and enriched the knowledge of Excel on top,you made us easy working in Excel, Thank you soooo much Teacher forever for your excellent Teaching
@Innozant
@Innozant Год назад
Thanks dear.Keep learning
@vishalshelar697
@vishalshelar697 3 года назад
Best Teaching techniques, The way you are teaching is fabulous, superb..
@Innozant
@Innozant 3 года назад
Thanks Vishal ji..Happy Holi
@E_K18
@E_K18 Год назад
Thanks for your knowledge in Videos sir. For your students like me who take break from excel for years, these are your blessings❤
@Innozant
@Innozant Год назад
😊👍❤️Late nhi hue hai ..Keep exploring ❤️
@amritathakur2036
@amritathakur2036 Год назад
Super se bhi upar sir thanks 🙏 from heart 💓 many many thanks 🙏 sir ji
@Innozant
@Innozant Год назад
Thanks Amrita itne pyarse feedback ke liye..Ydi mere ye videos aapke life me value add kar paa rahe hain to wo mere liye har fees se badhke hai.
@RohitKumar-cc7zi
@RohitKumar-cc7zi 3 года назад
Dear sir, this one is Superb , again big heart thanks a lot. And most of the thing you have a great way of Presentation. I want meet you one to one uf possible in life. Great thanks again
@Innozant
@Innozant 3 года назад
Thanks Rohit Ji..Offcourse dear ,Will meet ❤🙏🙏Have a wonderful career ahead
@Jishayaful
@Jishayaful 3 года назад
Best teaching sir. Thank you for sharing your knowledge with the world.
@Innozant
@Innozant 3 года назад
Thanks Jishaya for such a wonderful feedback.Hope these videos add some value in your life.🙂❤️👍
@arunkumarsinghark3024
@arunkumarsinghark3024 2 года назад
अति सुंदर सर जी धन्यवाद्, getpivotdata formula पर और अधिक videos बनाए सर please please please, 🌹राधे राधे 🌹ARK 🔥🏹हमेसा हंसते मुस्कुराते रहिये l
@hemantgusain1260
@hemantgusain1260 3 года назад
Thanks you sir, your knowledge of excel is unbeatable.
@Innozant
@Innozant 3 года назад
Thy Hemant Ji..Hope you are Learning and enhance skills on regular basis.❤️👍
@user-hq5gr9hk1j
@user-hq5gr9hk1j 2 года назад
Very well explained
@Saurabh-Yaduvanshi.
@Saurabh-Yaduvanshi. 7 месяцев назад
Mahan Ho Sir Aap
@sandeepaswal8944
@sandeepaswal8944 3 года назад
No Word No Word Sir ji❤😘 New concept new skills today I learned. You are marvelous. You are best mentor. I love it your all videos.
@Innozant
@Innozant 3 года назад
Thanks Sandeep..Hope you like Getpivotdata funcation and find it beneficial 👍🙏❤️
@user-te9yg8nl5h
@user-te9yg8nl5h Месяц назад
Sir when I am using getpivot on the bigger data you showed us regarding agent and acctype I am getting a REF! error?
@monalisa_ghosh1
@monalisa_ghosh1 Год назад
Thnq sir for sharing ur knowledge with us❤️
@Innozant
@Innozant Год назад
Keep learning and Exploring..Do practice on regular basis
@dominatorgaming2980
@dominatorgaming2980 2 года назад
Very informative video
@powerbiselfstudyguide
@powerbiselfstudyguide 3 месяца назад
Excellent, Keep it up!
@abhisheksinghal7525
@abhisheksinghal7525 Год назад
What if we take 2 value fields in pivot and shift the values to rows and want to get data for both value fields
@kavita8390
@kavita8390 2 года назад
Excellent video… I have one silly question, while applying formula which key are you pressing to deactivate/ hold for a while and navigate to data fields.
@Innozant
@Innozant 2 года назад
Hahahaha..Kavita before = just give space to deactivate it for a while then again remove space from there to activate our formula .♥️♥️♥️😀happy Learning
@Pro-Tips-Tricks
@Pro-Tips-Tricks 2 года назад
Multiple columns text par hai, usko number format main lana in single time process. Possible?
@ishantsonker5787
@ishantsonker5787 3 года назад
I appreciate ur efforts... Sir.
@Innozant
@Innozant 3 года назад
Thanks Ishant Sonakar Sahab 👍❤️🙏
@ishantsonker5787
@ishantsonker5787 3 года назад
"Sonakar" nhi sonker... ☺ sir....🙏
@merichitrakari
@merichitrakari 4 месяца назад
Thank u sir ❤❤❤❤❤
@vipulbeerupadhyay9459
@vipulbeerupadhyay9459 3 года назад
Sir mera mis ka course complete hai aur mai apka video mis interview cracker bhi dekh rha hu
@vishalshelar697
@vishalshelar697 3 года назад
Thanks alot sirji
@puransingh-sx2tk
@puransingh-sx2tk 3 года назад
Guru g more vedios on pivot table with dashboard plz😂😊 ye dil maange more 👍✌️
@Innozant
@Innozant 3 года назад
Koshish jaari hai.👍🙏❤️
@surajsinghrajput9321
@surajsinghrajput9321 3 года назад
Superb sir.👍🔥
@Innozant
@Innozant 3 года назад
Thanks Suraj 👍🙏❤️
@balance1772
@balance1772 Год назад
Wow! Guru ji
@MithunSapui
@MithunSapui 2 года назад
Thank you Sir
@tonightdiary86
@tonightdiary86 Год назад
wow dynamicallty of pivot table
@rubayyanitu4300
@rubayyanitu4300 Год назад
How can i use this formula by external excel documents
@mamtamishra7882
@mamtamishra7882 3 года назад
Thank uh sir
@Innozant
@Innozant 3 года назад
Thanks Mishra ji
@hemgandhi8087
@hemgandhi8087 2 года назад
Thankx
@dhavalgorasia3068
@dhavalgorasia3068 2 года назад
hi, I have pivot in another sheet and I'm using getpivot formula to get the values, but I'm getting reference error even though I have added the right reference.
@vimaldewangan9309
@vimaldewangan9309 2 года назад
Very interesting
@rahulrakshe1988
@rahulrakshe1988 2 года назад
Very nice
@amitsw21
@amitsw21 2 года назад
Thank you,
@Innozant
@Innozant 2 года назад
Thanks dear
@pareshparikh7944
@pareshparikh7944 3 года назад
Very good sir
@Innozant
@Innozant 3 года назад
Thanks Paresh ❤️🙏
@saurabh17sharma68
@saurabh17sharma68 3 года назад
Great sirji
@Innozant
@Innozant 3 года назад
Thanks Saurabh.🙏👍❤️
@kinghundred
@kinghundred 3 года назад
very useful sir
@jaiarora4473
@jaiarora4473 3 года назад
U r great sir
@Innozant
@Innozant 3 года назад
Thanks Jai.Happy learning
@deepakchauhan4974
@deepakchauhan4974 3 года назад
Sir, ye formuale jab mai excute kiya to ho gaya, lekin kya sir is se bas koi do chiz hi hum nikal sakte hai kya, multiple date get kar sakte hai ya nahi, agar kar sakte hia to kaise
@successmaharjan2906
@successmaharjan2906 2 года назад
Thank u
@nitinrautela5561
@nitinrautela5561 3 года назад
Sir koi power query aur Powerpivot ki series bana do bhut demand hai ajkl uski
@Innozant
@Innozant 3 года назад
Aayega dear..❤️👍
@ajaykumar-hu3py
@ajaykumar-hu3py 3 года назад
kindly make video about power pivot
@Innozant
@Innozant 3 года назад
Aayega dear..have patience..abhi to excel khatam kr lein pehle 👍❤️🙏
@shahidalikhan9503
@shahidalikhan9503 Год назад
Sir not apply automatic get pivot data in my sheet.
@Rejuanhaque
@Rejuanhaque 3 года назад
Mind blowing Sir
@Innozant
@Innozant 3 года назад
Thanks Zoie Raem❤️👍
@ANILTV82
@ANILTV82 2 года назад
is it possible to Pull values based on both agents & branch?
@Innozant
@Innozant 2 года назад
Yes ..why not
@MohdTaufiqKassim
@MohdTaufiqKassim Год назад
Hello Mr. Dinnozant : You have make Statement of V-Look and GetPivotdata yrself u have have not teach us how u make this both statement I have not understand yr solution ?? pls expedite ?? Regards M.Taufiq Karachi Pakistan
@excelsolutions.7167
@excelsolutions.7167 3 года назад
Sir agar koi lead I'd August month me reject ho or wo lead I'd is month me approved ho jaye to aisa kon sa formula lagaya ki us lead I'd ka count us month se hat ke is month me add ho jaye
@Innozant
@Innozant 3 года назад
Customized formula apne requirements ke base par likhiye.maise kuch specific option nhi h available
@amandeepbadgujjar7096
@amandeepbadgujjar7096 10 месяцев назад
Hello sir 🙏, sir mujhe formula likha or ase hi jese apne bataya, lekin mujhe #REF error Mila kyu? plz reply 😇.
@MithunSapui
@MithunSapui 2 года назад
Sir, PIVOT data me agar 2 category rahega, toh getpivot kaise kam karega?
@MithunSapui
@MithunSapui 2 года назад
I mean to say Colum me month v hai year v hai. tab kaise kam karega?
@Innozant
@Innozant 2 года назад
Do criteria based field aur item ki value pick krenge
@GauravSharma-iu5mr
@GauravSharma-iu5mr Месяц назад
Best yr
@gauravbhatia7987
@gauravbhatia7987 3 года назад
Thnq sir
@AnshulMarele-gbaa
@AnshulMarele-gbaa Год назад
How to return row data, not value column(s) data
@shaikh9394
@shaikh9394 3 года назад
sir jo last mai aap ne getpivotdata laga kr just datfield select ki to sb information agai thi but meny jb kiya koi information nahi arhi hai please btai kia problem ho skti hai
@Innozant
@Innozant 3 года назад
Ek baar phirse video dekhke apply kriye kuch galati kr re honge
@tejpalsain1507
@tejpalsain1507 3 года назад
Thanks sir.
@Innozant
@Innozant 3 года назад
Thanks Tejpal Ji👍🙏❤️
@lkumar2727
@lkumar2727 3 года назад
Power pivot par video banaiye.
@Innozant
@Innozant 3 года назад
Pehle Pivot to khatam Ho Jaye 🙏👍❤️
@omkumarsharma2242
@omkumarsharma2242 Год назад
Kaise kar leteho..good
@sagardeshwal7612
@sagardeshwal7612 3 года назад
Sir please make a video on invoice matching concept For example if an invoice no is ABC/2019-20/015 and another invoice is 15. In substance they both are same but how we can match each other by using formula
@Innozant
@Innozant 3 года назад
Acha Kisi video example me add kr denge 👍❤️🙏
@chayankumar8061
@chayankumar8061 3 года назад
sir i am pleased
@Innozant
@Innozant 3 года назад
❤️🙏
@arunkumarsinghark3024
@arunkumarsinghark3024 2 года назад
Sir, मेरी कुछ Excel Queries है ऑफिस से, कृपया मार्गदर्शन करे l, Queries solve करने मे please help me sir, आपसे बहुत उम्मीद लगा है, दिल मत todiyega l🌹राधे राधे 🌹ARK 🔥🏹हमेसा हंसते मुस्कुराते रहिये l
@s.surenderrao3854
@s.surenderrao3854 3 года назад
Dear Sir, please give a solution on calculation of "growth rate" on consecutive years/ months
@Innozant
@Innozant 3 года назад
Ok.Rao Sahab will make a seprate video for the same.
@knowledge-withfriend2686
@knowledge-withfriend2686 3 года назад
Nice
@Innozant
@Innozant 3 года назад
Thanks Dear 🙏👍❤️
@arunkumarsinghark3024
@arunkumarsinghark3024 2 года назад
हम आपसे कैसे संपर्क करे l कृपया आप मदद करे और जानकारी दे l
@vipulbeerupadhyay9459
@vipulbeerupadhyay9459 3 года назад
Mis job ke liye kaise aply kre
@FranceTurkiye
@FranceTurkiye Год назад
I wish wish the video was in English as its title.
@Innozant
@Innozant Год назад
😊❤️
@vishalpal4396
@vishalpal4396 3 года назад
Sir mujhe ek interview ki sheet bhejni h apko kaise bhuje?
@Innozant
@Innozant 3 года назад
@innozantofficial telegram id
@vishalpal4396
@vishalpal4396 3 года назад
@@Innozant sent
@SanjayKumar-uw9kn
@SanjayKumar-uw9kn 3 года назад
🙏
@Innozant
@Innozant 3 года назад
Thanks Sanjay Ji👍❤️🙏
@sagararora8040
@sagararora8040 3 года назад
present sir
@Innozant
@Innozant 3 года назад
Good 👍❤️🙏
@kunarmodi
@kunarmodi 2 года назад
09:44🤣🤣🤣
@MohdTaufiqKassim
@MohdTaufiqKassim Год назад
Mr. Dinozant I am yr permanet Student ?? Karachi Pakistan M.Taufiq
@Innozant
@Innozant Год назад
👍🙏
@ashu1303tilwar1991
@ashu1303tilwar1991 2 года назад
I am getting excel learning from HARDY SANDHU
@Innozant
@Innozant 2 года назад
❤️👍
@arnavaj3392
@arnavaj3392 2 года назад
kuch b nhi bhut kuch h isme
@bishtlokesh1297
@bishtlokesh1297 3 года назад
You begun to hard work too much for excel users
@Innozant
@Innozant 3 года назад
Thanks Lokesh for your support and valuable comment.👍🙏❤️
@bishtlokesh1297
@bishtlokesh1297 3 года назад
It's my duty
Далее
Flipping Robot vs Heavier And Heavier Objects
00:34
Просмотров 39 млн
Pivot table ko bhul jawo! Par kyun🤔?
20:14
Просмотров 142 тыс.
Advanced Pivot Table Options in Excel |
18:34
Просмотров 170 тыс.
Excel useful formula Series in Hindi - Part - 6
21:57
Flipping Robot vs Heavier And Heavier Objects
00:34
Просмотров 39 млн