4 of Excel's Best Kept Secrets
27:16
5 жыл бұрын
DistinctCount in Excel
16:56
6 жыл бұрын
Excel Date tricks you NEED to know.
27:53
Пікірлер
@myprettypsych
@myprettypsych 11 күн бұрын
"Text to Columns" did it!!! Spent days trying to fix this issue.
@unleashyourpaws3163
@unleashyourpaws3163 Ай бұрын
When I right click, I do not have a "group" option😥
@dianamamawal4664
@dianamamawal4664 3 ай бұрын
Does anybody know how to cite the map generated from this 3d feature in an APA format?
@EmilyOsborne-y3h
@EmilyOsborne-y3h 4 ай бұрын
Lol "Mordor" and "Gorbag the Orc"; very good.
@ElMakk_Med
@ElMakk_Med 4 ай бұрын
i was really mad & angry trying to solve this problem , that trick Text to columns saved me, thank you from morocco 😛
@Surfingandy111
@Surfingandy111 5 ай бұрын
Incredible. How the command "Text to Columns" fixes the date issue is beyond me, but it worked. I was about to go insane fixing it.
@maxsablosky
@maxsablosky 6 ай бұрын
Bro that text to columns move is insane!! Fixed my whole model thanks!!!!
@my_commenting_account
@my_commenting_account 6 ай бұрын
does this work the same when your source table is crosstabbed by date (dates are the column headers, not a column value)? i cant seem to group my column headers as they are showing as "sum of" fields even though nothing is being grouped
@taiwoayeni6122
@taiwoayeni6122 7 ай бұрын
THANKS FOR THIS VIDEO.
@zehanfarzana2762
@zehanfarzana2762 8 ай бұрын
Thanks for the excellent guidelines.
@COCOCOCO-bp7vn
@COCOCOCO-bp7vn 8 ай бұрын
Great job.Thank you
@jozefchromy8044
@jozefchromy8044 10 ай бұрын
thumb up for the tutorial, but to join you, you would have to learn how to zoom your tutorial - think about you viewers man, after all not everyone has a 20/20 vision and then it becomes a struggle to watch. Some tutorials pay great attention to show, up close the viewer, what they want to convey to them that is kudo for them but this......... Greetings
@NishanAman-h2m
@NishanAman-h2m 11 ай бұрын
is todays date update automatically day by day?
@fakdolan
@fakdolan 11 ай бұрын
So easy to follow, you're a great teacher, ty!
@hakiinmohamud9852
@hakiinmohamud9852 11 ай бұрын
Thank you so much. Great Video!
@vipuljain3179
@vipuljain3179 Жыл бұрын
Just Brilliant
@Odawg421
@Odawg421 Жыл бұрын
Great video. This is getting me closer to what I’m looking for. In this example that you’ve created, is there a ways to calculate the remaining days excluding weekends and/or holidays?
@SenthilKumar-xu9fb
@SenthilKumar-xu9fb Жыл бұрын
This Video is very useful. I have try for using this formula for maintaining chemical expiry monitoring. is is fine and working good. Thanks
@credencehomehealthservices
@credencehomehealthservices Жыл бұрын
THANK YOU
@KareemAdel-c5k
@KareemAdel-c5k Жыл бұрын
Hii, Thank you for this video, can you help me how i can receive and email in gmail once the value got About to expire ?
@danbello4728
@danbello4728 Жыл бұрын
nice really helped me
@jonatancohen
@jonatancohen Жыл бұрын
Amazing video bro. Thanks. Very clear
@michaelangelocapistrano26
@michaelangelocapistrano26 Жыл бұрын
Right is correct, left is wrong. Nothing political here😂
@LeahHunter-y2l
@LeahHunter-y2l Жыл бұрын
Could you maybe leave out the pretentious attitude and focus on the learning?
@etherlords88
@etherlords88 Жыл бұрын
didn't work for me, I'm getting multiple 1s , no 2, multiple 3s, 4s and so on.
@abigailquilarto
@abigailquilarto Жыл бұрын
hi! is it possible to have a date filter after grouping the dates by years? thanks. i can't move on with this error.
@786NOUSHAD
@786NOUSHAD Жыл бұрын
Thank you so much for you training your so kind and its very easy to understand
@Hucklebrau
@Hucklebrau Жыл бұрын
I can do this easily in the local app. But the online version does not show a [Group] option in the right-click menu. What now?
@thesalesforcecoach
@thesalesforcecoach Жыл бұрын
Best explanation on the entire internet!
@vinaynagaonkar8592
@vinaynagaonkar8592 Жыл бұрын
Its a wonderful tool, Thank you very much, God Bless You
@garimajain5907
@garimajain5907 Жыл бұрын
life Saver video, thanks a lot!
@audjau8150
@audjau8150 Жыл бұрын
Thank you very much😇, you help me to solve my problem with my data. it was a nightmare since 2 days to find a solution with my 10000 rows 🧐🤓
@kenji4955
@kenji4955 Жыл бұрын
Thank you my friend! Good stuff! IVery much like your sense of humor. Please allow me to share one more simple way of doing "Only Month" without vlookup, by using formula "=datevalue(A2&1)"🙂
@joelmorales534
@joelmorales534 Жыл бұрын
Thanks for the video. I finally solved my errors in grouping a date :)
@Info365d
@Info365d Жыл бұрын
Great Sir, What a beautiful and detailed explanation, love it. Thanks
@AmarFemco
@AmarFemco Жыл бұрын
Useful video
@Tat-cx1lr
@Tat-cx1lr Жыл бұрын
Très intéressant merci
@WenboCanadaImmigration
@WenboCanadaImmigration Жыл бұрын
thanks a lot
@darshanawajira3826
@darshanawajira3826 Жыл бұрын
Thanks
@Wealth_Focus
@Wealth_Focus Жыл бұрын
You're cocky 😝 but very very good 👍. Thanks for saving me. I've spent an entire day trying to fix this. You're the best. I've done myself a favor by subscribing to your channel. Thanks 🙏 once again. Mmmmuuuuuaaaaaaa 😘💋
@pavelbursa9247
@pavelbursa9247 Жыл бұрын
Great video! I do not like approximate match, as I do not know the algorithm and the result may be unexpected. Also, i need something, to give me weekly timeline with missing datapoints filled with zeros. Group by 7 days creates insanely long data labels for horizontal axis for chart. Last resort is to merge datapoint dates with generated simple calendar with all dates in power query.
@stephenedmondson8173
@stephenedmondson8173 Жыл бұрын
Holy crap the audio difference between your voice over and brand intro is insane - I nearly had a heart attack. Good video though.
@JacobBogovefa-bb4os
@JacobBogovefa-bb4os Жыл бұрын
i like it, really helpful however its not clear enough to see.
@observer8291
@observer8291 Жыл бұрын
Thank you very much
@CryptoAirDrop.0
@CryptoAirDrop.0 Жыл бұрын
Can it give me notification reminder
@trentorhu7587
@trentorhu7587 Жыл бұрын
Hi. Will this work on Google Sheets?
@AbdulrahmanAlahdal-lc3wz
@AbdulrahmanAlahdal-lc3wz Жыл бұрын
Thank you so much the video was really helpful and explained it in a very clear and easy way.
@johnwatson3521
@johnwatson3521 Жыл бұрын
Companies that work on a fiscal calendar year instead of a normal calendar year is my special period issue. Unless there is another way? This will work! Thank you!
@aniketgangakhedkar7101
@aniketgangakhedkar7101 2 жыл бұрын
Awesome video man
@imransiyal801
@imransiyal801 2 жыл бұрын
Well Done Sir.