Пікірлер
@MyMummasMagic143 12 күн бұрын
It really helped me 😊😊😊😊
@dsuchinsky 13 күн бұрын
This solved my problem, Thank you!
@ayusharya3449 27 күн бұрын
how to do the same thing in mac? because this option is not showing on my mac
@voievod9260 27 күн бұрын
Very good examples!
@SumiVinoth-j3r Ай бұрын
Awesome..Thanks
@naeemmalik5982 Ай бұрын
can you share the link for the chart video mentioned at the end of video?
@naeemmalik5982 Ай бұрын
Well explained
@kelloh8 Ай бұрын
Tq
@allysamaelopena289 Ай бұрын
Thank you so much!!
@SlametPundya Ай бұрын
The best explanation about expand function ever. Thank you
@Nitinpaste-k5l Ай бұрын
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 Ай бұрын
This is first ever instance where I learnt something new, Thank you.
@aeromsp99422 2 ай бұрын
Really I liked your videos... Thanks for your time to post this..❤
@shreyasood2457 3 ай бұрын
Can we do this in PowerPoint?
@vanhong1900 3 ай бұрын
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 3 ай бұрын
Nice. Please give the files
@rabimahananda4809 3 ай бұрын
Thanks a lot sir 🙏
@ankursharma6157 3 ай бұрын
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 4 ай бұрын
So far best video on these three pivot table topics!
@steventezcan689 4 ай бұрын
Very good info! Thanks for sharing!
@earlmitchell5642 4 ай бұрын
very helpful thanks!
@user-eo6bs6ir7p 4 ай бұрын
no file for down load
@adiliophi 4 ай бұрын
Thanks a Lot!
@annjohn4215 4 ай бұрын
INCREDIBLY Helpful!
@aryanroostaie3803 4 ай бұрын
thank you man
@MK-fq3fk 5 ай бұрын
Great very helpful
@Nori-mr9mw 5 ай бұрын
clear instruction, thank you, so basically excel doesn't have bi-directional, mirror chart or wtf it is
@ajnanmenon1356 5 ай бұрын
Nice one.. Thanks a lot
@ginikagupta388 5 ай бұрын
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 5 ай бұрын
Hi! what if i wish to combine multiple workbooks with the exactly sale headers? Please advise
@staronline7988 6 ай бұрын
❤😂
@abdullahquhtani4247 6 ай бұрын
Great 👍🏼. Is there a way to apply the same concept and eliminate FRIDAYS from days between tow dated ?!
@user-ic1ln4te8y 6 ай бұрын
Superb!! waiting more the practical video like this
@geoffroyc 6 ай бұрын
Great straightforward video, thanks!
@indujcharu584 6 ай бұрын
Thanks Teacher
@cassandrashelton7361 6 ай бұрын
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 6 ай бұрын
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 7 ай бұрын
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 7 ай бұрын
Worked perfect! Thanks man
@joesmith4254 8 ай бұрын
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 8 ай бұрын
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 8 ай бұрын
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 8 ай бұрын
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 8 ай бұрын
Thanks for your appreciation
@akhiljain7382 9 ай бұрын
I feel there is a problem with the horizontal axis labeling. center should be 0 and then scaling should run both ways.
@premiertraininghub 8 ай бұрын
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 3 ай бұрын
@@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!
@viince1249 9 ай бұрын
😁 Thanks for that solution concerning Pivot Tables that I'm looking for since long time...
@sagarverma2708 9 ай бұрын
Hello Sir, your videos are very helpful, do you provide personal trainings or can you provide practise files of all the videos?
@user-dn5gd1rn9f 9 ай бұрын
Excellent practical examples- thank you! I have found myself using unique a lot & would not have thought of your solutions.
@premiertraininghub 9 ай бұрын
You're very welcome!
@romany4all 10 ай бұрын
Great
@TopBam 10 ай бұрын
Great video! Here is an easier to use formula to accomplish the job: =TOCOL(Table1[Product]&EXPAND("",,ROWS(Table2[month]),""))
@premiertraininghub 10 ай бұрын
Thanks for liking the video. Thats also a nice way of accompalishing the task but whether it is easier or not is a perception :). There is one thing that you missed to mention in your solution, so let me add the same for the benefit of readers. In the method advised by you, for creating the 2nd column (Month column) in the output database, we would need to modify the TOCOL formula by adding a 3rd argument as "1", else the formula would create an incorrect database (this is in addition to reversing the Tables as shown in the video). The formula for the month column in the formulas advised by you would become :- =TOCOL(Table3[Month]&EXPAND("",,ROWS(Table1[Product]),""),,1) But i am not sure whether appending a blank array with a table would be intuitive for many people.
@guranslifes 10 ай бұрын
awesome. i was looking for it this morning and found out at afternoon without looking for it.
@gingermariska198912 11 ай бұрын
thank you, does this apply to text fields as well?