Пікірлер
@dhritijariwala9513
@dhritijariwala9513 9 күн бұрын
thanks man. you helped me to do my project
@pratapcabm123
@pratapcabm123 Ай бұрын
Great .Thanks for clear explanation PTH
@arieprimari5503
@arieprimari5503 Ай бұрын
Structured presentation. Good work!
@patriciohdzbravo5215
@patriciohdzbravo5215 Ай бұрын
I LOVE YOU
@SINGEH-f2p
@SINGEH-f2p 2 ай бұрын
you have a gift in teaching Excel. Thanks for the knowledge from all your videos.
@Ni3Bhosale
@Ni3Bhosale 2 ай бұрын
Brilliant👍
@ajithvs126
@ajithvs126 2 ай бұрын
Not working in google sheet
@minadev1
@minadev1 3 ай бұрын
amazing , thanks!!!
@MyMummasMagic143
@MyMummasMagic143 3 ай бұрын
It really helped me 😊😊😊😊
@dsuchinsky
@dsuchinsky 3 ай бұрын
This solved my problem, Thank you!
@ayusharya3449
@ayusharya3449 4 ай бұрын
how to do the same thing in mac? because this option is not showing on my mac
@voievod9260
@voievod9260 4 ай бұрын
Very good examples!
@SumiVinoth-j3r
@SumiVinoth-j3r 4 ай бұрын
Awesome..Thanks
@naeemmalik5982
@naeemmalik5982 4 ай бұрын
can you share the link for the chart video mentioned at the end of video?
@naeemmalik5982
@naeemmalik5982 4 ай бұрын
Well explained
@kelloh8
@kelloh8 4 ай бұрын
Tq
@allysamaelopena289
@allysamaelopena289 4 ай бұрын
Thank you so much!!
@SlametPundya
@SlametPundya 5 ай бұрын
The best explanation about expand function ever. Thank you
@Nitinpaste-k5l
@Nitinpaste-k5l 5 ай бұрын
This absolutely worth watching n learning new things in excel. I watched your couple of videos and learnt new things. Great JOB. I am you fan now.
@Nitinpaste-k5l
@Nitinpaste-k5l 5 ай бұрын
This is first ever instance where I learnt something new, Thank you.
@aeromsp99422
@aeromsp99422 6 ай бұрын
Really I liked your videos... Thanks for your time to post this..❤
@shreyasood2457
@shreyasood2457 6 ай бұрын
Can we do this in PowerPoint?
@RyanStraube
@RyanStraube 3 ай бұрын
I think I figured it out, at least for pie charts. You can format the data series and rotate the "angle of first slice" I'm on a Mac though and I'm not sure those are the same directions for Windows. You can't rotate in the negative direction but as a pie chart is circular, you can achieve the effect of -90 degrees by rotating to 270 degrees. I hope this helps!
@vanhong1900
@vanhong1900 6 ай бұрын
Hi. I have a query: When I Convert file excel (From other sources), Table import wizard noticed that "0 Rows transferred". How can I fix it?. Although I checked my file again, and it actives nomarlly (it have 422 rows)
@ubaidillahmuhammad20
@ubaidillahmuhammad20 6 ай бұрын
Nice. Please give the files
@rabimahananda4809
@rabimahananda4809 7 ай бұрын
Thanks a lot sir 🙏
@ankursharma6157
@ankursharma6157 7 ай бұрын
Hi Sir, Thank You for sharing a very interesting video on EXPAND 🙏🏾 Sir, what if the Products are: Belt Goggles Camera The final Product list should have the items in the same order (Belt, Goggles, Camera). The solution in the video will sort the item in A-Z order. Please suggest a solution. Thank You!
@Curic-Ivan
@Curic-Ivan 7 ай бұрын
So far best video on these three pivot table topics!
@steventezcan689
@steventezcan689 7 ай бұрын
Very good info! Thanks for sharing!
@earlmitchell5642
@earlmitchell5642 7 ай бұрын
very helpful thanks!
@JonneyKwords
@JonneyKwords 7 ай бұрын
no file for down load
@adiliophi
@adiliophi 8 ай бұрын
Thanks a Lot!
@annjohn4215
@annjohn4215 8 ай бұрын
INCREDIBLY Helpful!
@aryanroostaie3803
@aryanroostaie3803 8 ай бұрын
thank you man
@MK-fq3fk
@MK-fq3fk 8 ай бұрын
Great very helpful
@ajnanmenon1356
@ajnanmenon1356 9 ай бұрын
Nice one.. Thanks a lot
@ginikagupta388
@ginikagupta388 9 ай бұрын
But what if I want this letter on my company letterhead and also download this as a pdf for all these employees and use mail merge to send this?
@amit0210
@amit0210 9 ай бұрын
Hi! what if i wish to combine multiple workbooks with the exactly sale headers? Please advise
@staronline7988
@staronline7988 9 ай бұрын
❤😂
@abdullahquhtani4247
@abdullahquhtani4247 9 ай бұрын
Great 👍🏼. Is there a way to apply the same concept and eliminate FRIDAYS from days between tow dated ?!
@MadindaRiva
@MadindaRiva 9 ай бұрын
Superb!! waiting more the practical video like this
@geoffroyc
@geoffroyc 9 ай бұрын
Great straightforward video, thanks!
@indujcharu584
@indujcharu584 10 ай бұрын
Thanks Teacher
@cassandrashelton7361
@cassandrashelton7361 10 ай бұрын
When I select 1st series, instead of highlighting a column, it highlights the entire row including a, b, c, d, e and f
@VINAY_DEVADIGA
@VINAY_DEVADIGA 10 ай бұрын
You can achieve the same result by using a very short Syntax as below and then if needed, convert that into a lambda function with 4 input parameters as defined below the formula =INDEX(FILTER($B$3:$B$16,$A$3:$A$16=D3),E3) $B$3:$B$16 is the item names; in your case--> fruit names $A$3:$A$16 is the dates D3 is the individual item you want to evaluate E3 is the Nth value you wish to obtain In order to avoid errors on selection of the Nth value you can use the formula =SEQUENCE(COUNTIF($A$3:$A$16,D3)) and reference the above to a Drop Down list Once done, user can only select the numbers from the drop down
@SKidharsan_SManodheedan
@SKidharsan_SManodheedan 10 ай бұрын
Can we get sequence of quarter date between two input dates? i.e., If I put 15 Jan. 2024 and 15 Dec. 2024 then it suppose to display 15 Jan. 2024, 15 Mar. 2024, 15 June, 2024, 15 Sep. 2024 and 15 Dec. 2024. Thanks in advance
@sarkisfitness1112
@sarkisfitness1112 11 ай бұрын
Worked perfect! Thanks man
@joesmith4254
@joesmith4254 11 ай бұрын
Thanks a lot for the video. I have made similar output with much more work the last many years. Now I have just to figure out how to expand with 3 or 4 tables. If anybody have an Expand formula ready using 3 or 4 tables, I will very much appreciate to see it.
@joesmith4254
@joesmith4254 11 ай бұрын
Thanks a lot PTH - it's really an elegant solution to expand items in a list to a dataset. Just had to practice a bit to expand formulas to use 3 tables. This is going to save me a lot of time.
@arsattarian
@arsattarian Жыл бұрын
Your Excel tutorials are fantastic, and I encourage you to keep up the excellent work! Your expertise and engaging teaching style make complex topics understandable. The practical insights you provide are invaluable. I look forward to more of your content, as it continues to be a tremendous asset for learners. Thank you for your dedication! 👏🚀
@arsattarian
@arsattarian Жыл бұрын
Your professional-level Excel tutorials are exceptional! Your expertise in breaking down complex features, paired with real-world applications, has significantly enhanced my skills. The commitment to high production standards amplifies the learning experience. Thank you for being a valuable resource for advanced Excel knowledge - your contributions are truly appreciated. 👏🚀
@premiertraininghub
@premiertraininghub 11 ай бұрын
Thanks for your appreciation
@akhiljain7382
@akhiljain7382 Жыл бұрын
I feel there is a problem with the horizontal axis labeling. center should be 0 and then scaling should run both ways.
@premiertraininghub
@premiertraininghub Жыл бұрын
Thats not a problem for the output we are looking for. You do not need to show the horizontal axis labeling as the values are depicted by data labels. So just hide the axis as there is no need to put axis on your chart or presentation.
@sallyho146
@sallyho146 6 ай бұрын
@@premiertraininghubif I want to stack sales and margin in one bar chart(clustered column?) and stack sales% and margin % in another clustered column. Basically side by side stacking Sales and Margin/ Sales% and margin%, how do I do that? When I selected stacked column for Sales and Margin under ‘Chart Type’, all changed to stacked column. Please help. Thank you!