Excel GetPivotData Function | Udemy Instructor, Leila Gharani [bestseller]

[@bsa18599]

Leila is a genius, Lelia's videos are always so well explained and easy to follow, if ever I'm having problems she is always the first I go to. Thank you so much Leila!

[@notreallyhere1136]

I’ve recently starting using it. Finding it useful as an alternative to xlookuping large data sets. Improves performance by referencing a summarised version of it in a pivot tablle.

[@vita9197]

Awesome! I want my teachers and lecturers are just like her. Easy to understand :D

[@houstonvanhoy7767]

Life's good with LG.

[@vinod-fu5wn]

Hello Leila, Very simple explanation, i like the video. Nice explanation. Thank you soooo much

[@yashsomaiya8141]

I learned a formula which I had never used in an effective. Thank you liela for uploading such video.

[@houstonvanhoy2198]

Life's better with LG!

[@winifredgiddings7154]

Thanks for this instructional video on Excel GetPivota Function. I've never used this functionality and going to work with it!

[@svetlanapokorna7580]

Hi Leila. Thank you for all your videos. Really great! I am wondering if there is an option you can add comments section to a pivot table other way then actually have special 'comments' column in the original data tab. I need to update my pivot with comments, but I couldn't find the option to do so. Please let me know if there is such option. Thank you

[@apwnew]

Leila! As always - great job! Thank you! 👏🌼🥇

[@katerina6495]

Thank you so much Leila, that was lovely video, I have not used getpivot function before, but will from now on, Viele liebe Grüsse

[@udemy]

We're so glad you enjoyed the video!

[@edrojano8902]

Very nice! well explained. Clear and concise. TYSM

[@faddtayo]

thank you so much for such a very good instructional video

[@roberth.9558]

Well done, Leila. Thank you.

[@theflutemaya4737]

Thanks for the informative video.. Your videos are in general very professional and to the point just like how anyone would expect them to be.. 😊

[@samuelraj4134]

Yes, we do use Getpivot a lot

[@sivakumarbelamana1984]

Very nice function. Thank you Madam.

[@Muuip]

I've been looking for this for awhile now. Thank you! Much appreciated! 👍

[@asifshauket]

Thank you so much I will use this functionality now

[@udemy]

We're so glad you enjoyed the video!

[@fe9523]

very very useful, thank you very much!!!

[@sedarathnadcd]

Thank you for comprihensive vedeo

[@Success_Mantra82]

*Thanks.! I Purchased that in Udemy.*

[@shuska9247]

Hi Leila, Great video, as always! I have a question regarding the categories. You pointed out that they need to be visible in the Pivot Table. My question is if this also includes filters? I would prefer to have one category in the filter field, so I can better read the data in the Pivot Table itself. Tschüss!

[@seunghyunshin1286]

Thank you for big help. from Korea :)

[@ann-pl2st]

Thank you Leila.

[@jasoncommins7197]

Hi Leila, I download a bank statement daily and add information to it. With the information I have created an Analysis field so as to be able to identify types of expenditure and receipts during the year for each month. I created a pivot table that has the receipt and expenditure type in each row in one column, and Years in one row and Months in another in each column from left to right to the end of the data. With total for each were the intercept. I have been trying to add an opening and closing balance rows just below the Grand Totals in my Pivot Table. I ideally wanted it all auto update when I hit the refresh on the Pivot Table. I cannot get it to work unless I do it manually by pulling a column of data from left to right to reference the new data in the Pivot Table. I cannot seem to get the GETPIVOTDATA to work with the Receipt/Expenditure type with the Years and Months. Do you have any suggestions. If you would like to see my file and advise I am more that happy for you to take a look. I can change the data. Many thanks! Kind regards, Jason.

[@patrickchileshe5984]

She just the best!

[@danielmathivathan7391]

Brilliant is there away of having the title on the chart dynamically linked to the slicer?

[@rosalynneal8761]

I have never used this before. Have no knowledge of it. Is it needed for the course.

[@zmalsabbagh]

Thank you so much 👍

[@Rajiblayek]

Hey Leila, Which course of yours has this video. I want to purchase the same.

[@prathmesh__w]

very informative video

[@toomtoom1212]

Do you suggest using that instead of vlookups?

[@mikeleblanc9103]

Is there a way to extract data from one table and insert in another? I have a table with internal invoice numbers that repeat multiple times to show sub contractor invoices. I like to extract each internal invoice and have them in a separate table where each will be unique. I hope this makes sense. As you can probably tell, I’m a novice.

[@pembalama677]

Great Video...What should we do to hide the original chart ("created with gaps").

[@brianhogan9563]

Pemba, move the chart you want to show as part of a dashboard to a new sheet with the slicer.

[@xBrugal]

Awesome video

[@youarebest2]

Excellent

[@angelsapphire6088]

I am having trouble understanding the GETPIVOTDATA function. I just want the calculated sales total from my pivot table to display at the bottom so I can do My own formulas with it, however - my sheet is set like horizontally. I am probably missing a simple step- but I am not sure.

[@jbseph1131]

Thanks for the New Idea.

[@udemy]

We're so glad you found the video helpful!

[@sreejx]

Hi Leila,when using GETPIVOTDATA inside SUM to get sum of all row items it gives #REF! error if any of the row item is Null.is there a workaround for this(for eg:=SUM(GETPIVOTDATA("Qty",A3,"Product",{"Apple","Orange","Pineapple"},"Month","Jan")) here if for month Jan there is no value for Orange and Pineapple it gives #REF.

[@karpin7747]

Good video.THX. QUESTION: I was hoping to find a way to simplify the copy/paste of a formula using the GetPivotData. Is there a way to include a formula in the GetPivot data function arguments? I was hoping to reference the first one (the header "title" with a cell reference ($A5 instead of "Sum of Revenue") Is this possible somehow??? I do know the other arguments (that refference files) can be changed by formula or cell refferences. But i struggle to remove the text of the "header" from the refference and make it automatic. THANK YOU!

[@ShivaSingh-vs4yv]

Hey, I have the data for which I wanted to create a inforgraphics.. In the data I have three columns:- area, No of days, total customer met. For example: New Delhi, 12, 50 It means in new Delhi in 12 days I met 50 people.. And my data goes on like this.. So how can I create a Inforgraph for this.. So that it is better understanding through chart. Pls help

[@melikadaneshjoo4462]

very useful , thanks

[@pralhaddhole5208]

Thank you

[@petr6617]

Yes, but why? I rejected GETPIVOTDATA function as unnecessary (compared to the SUMIFS function).

[@ravisuriya2970]

Hi Leila , How do we add dynamic referencing for date and years in getpivotdata formula .

[@jassem5855]

Thanks😘

[@Ahmed-mt1px]

Hi i can not extract the dynamic part from pivot formula would you support me

[@ProgramadorExcelVBA]

show, parabens. Att, Gledson Programador Excel VBA

[@garrysoriano2591]

Thank you😊😊😊

[@carmenleung335]

thx so much

[@ZaurPoladashvili-r3e]

Can you add subtitles in Russian in Turkish or Georgian? I bought the course but I don't understand the lessons :(

[@Saddam-Abdulameer]

شكرا

[@Mishkafofer]

You know what's sad? You can get 1080p videos from Udemy on KZbin but rarely on Udemy. You can choose 720p and lower on Udemy. If you want 1080p you need to choose AUTO and pray that Udemy website will be kind to you.

[@ajmraghu2683]

no. not yet

[@pittedmetal]

Thank you :)

[@belovedspear53]

Can you focus ONLY on the GET DATA function? A simple how-to is all that's needed.

[@brianpower6311]

You don't need to convert your data set to a Table using CTRL+T, you can just set the data source of the pivot table to be $A$D (all data in columns A through D)

[@alexkim7270]

I think you'll end up having blank values, which in some cases would need to be removed by deselecting "blank" in your pivot table filters.

[@chiomaizejimba8549]

Thanks

[@angekouakou7753]

Wow !

[@fathyelsmadissy6831]

what the realation between exce l and bmp in picture or pixel in images

[@madhav771]

how to filter descending order in getpivotdata function

[@Chanderv31]

2:00

[@connornusser-mclemore631]

lol

[@vrjk2001]

Good information