I want to ask one thing, when doing the sorting function i noticed that (,)isnt working for me, (;) this is the one working for me. Why is it like that?
Sometimes, use slicers instead of conditional formatting: It is easier and displays particular information. To use this tool, change data into table. For example, if you want to find out a house with 4 bedrooms, 3 bathrooms, and has the least price among all, check out with slicers. To fo find the least price, sort the "Listing price" as ascending order.
I didn't know about Flash Fill. I usually use functions like LEFT, RIGHT, MID combined with FIND and LEN. Flash Fill is wow. I don't have words for this, it's so amazing feature. Thanks a million for bring this up.
Thanks Joe super done ,..but ONE more thing if you could give the name of the soundtrack that starts at the beginning of the video , much appreciated, Regards
Hello Sir thanks for the tutorial. At 11 :00 how can we automatically fill Last, First if the person have only one name? I do not master the "if" condition.
Exercise Files: learnitanytime.com/p/exercise-files-excel-intermediate-tutorial-2024
Guu
great tut
I want to ask one thing, when doing the sorting function i noticed that (,)isnt working for me, (;) this is the one working for me. Why is it like that?
The intermediate tutorial was a perfect sequel to the beginner tutorial...
Thank you Joe Patti and Learnit for providing such valuable content...
You are very welcome!
thanks Joe buddy for providing this diamond quality content free of cost
No problem 👍
Joe is even better than I expected
Thanks!
Thank you very much!!!😘
You are very welcome!
This was a good pace and really clear and logical to follow. Thanks Joe.
Glad it was helpful!
Thanks a lot from India.
Joe Sir and Learnit Training
Learned a Lot, Appreciate your generosity❤❤
You are very welcome! Thank you for watching!
Thank you for this comprehensive tutorial. It too useful for intermediate level.
Glad it was helpful!
Joe is even better than I expected!
Thanks!
Sometimes, use slicers instead of conditional formatting: It is easier and displays particular information. To use this tool, change data into table.
For example, if you want to find out a house with 4 bedrooms, 3 bathrooms, and has the least price among all, check out with slicers.
To fo find the least price, sort the "Listing price" as ascending order.
Awesome tip! Thank you for sharing
I didn't know about Flash Fill. I usually use functions like LEFT, RIGHT, MID combined with FIND and LEN. Flash Fill is wow. I don't have words for this, it's so amazing feature. Thanks a million for bring this up.
I’m gonna learn a lot from you thanks a lot just subscribed ❤
Welcome Aboard!
Thank you very much for the valuable informations..Appreciate that
Glad it was helpful!
learning Excel has never been easier, thank you!
Thanks Joe super done ,..but ONE more thing if you could give the name of the soundtrack that starts at the beginning of the video , much appreciated, Regards
Oh man we have had that music licensed for so long that we just know it as intro. haha
Thank you ever so much! I have learned a lot.
I did not find the SORT function on my Excel 365. Do you know the reason
press =sort
I Learned a lot with this tutorial.....amazing!
Thanks!
Thank you so much for the cource. Learned a lot. 🙏🙏🙏
Glad it was helpful!
Fantastic content. Thank you for sharing.
You are very welcome!
These videos are SO helpful...THANK YOU!
You are so welcome!
Excellent video. Anything that can fill in gaps in my knowledge is welcome. Looking forward to Friday's launch of Advanced.* Thanks for your work.
Great to hear!
Nice tutorial. Keep up your Good work !!
Thank you so much. Please where can i get projects to do so i can build my portfolio
Upwork and Fivver are great places to put yourself out there and get experience
Thank you so much for your informative and excellent presentation.
You are welcome!
Can you help with a list of how to watch all these videos from beginner to advanced so I won't lost my pace. Thanks
this is very digestable good job
Thanks!
That was really helpful! Thank you :)
Glad it was helpful!
Hello Sir thanks for the tutorial. At 11 :00 how can we automatically fill Last, First if the person have only one name? I do not master the "if" condition.
Don't understand how did you locked the header - 5:40?
i can't find the data we are working with. do i have to pay for this section please
learnitanytime.com/p/exercise-files-excel-intermediate-tutorial-2024
Thanks, Joe for your explication
Glad it was helpful!
Thank you very much.
You are welcome!
Joe thanks much....u are a savior❤❤❤
❤❤❤
What if I dont get Quick Analysis icon after marking the table range?
what if I dont have the quick analyse tool in excel ( free 365 microsoft tools) ? can somebody help, I don't have the pivot tables aswell in excel
you are the best bro. thanks a lot of
You are welcome
is the sort function only for Excel 365?
Amazing tutorial!
Glad it was helpful!
Thanks G
YW
Thanks a lot!!
You're welcome!
Thanks, I am enjoying learning Excel, is there any opportunity to get a free certificate?
Certificates can be earned at www.learnitanytime.com
Thanks a lot🤝
Welcome 👍
great am learning a lot. Thanks
You are welcome!
Awesome 👌
Thanks!
There is no phone number option available in format cells... Could u pls help!!
15:00 right here will be 10/10/2024 10:00 PM
👍👍👍
Thank You Very Much
You are very welcome!
Just wonderful :)
Thanks!
Thanks for teaching me excel, but the data on exl worksheet is unable to see
Why won't the error msg work for my phone number if more than 10 digits?
thanks , you are awsome
You are very welcome!
Has anyone experienced that the SORT function isn't not working!?
Nor the UNIQUE one
I dont have sort function option in my excel why 🙄
Sort is only available on the Microsoft 365 versions of Excel
Where can I find the exercise files?
learnitanytime.com/p/exercise-files-excel-intermediate-tutorial-2024
You are the bestttt
Thanks!
Superb
Thanks 🤗
The fill opened in wps office and i didn't know that excel is free in WPS office?
i don't have unique option in my excel why
The Unique function is only available on Excel 365 and Excel 2021.
Sir can you provide Excel certificate please.
how can i strart it ?
You got this!
@0:14 0:17 0:17 @😊
👍👍👍👍
The exercise files do not work with me
We just tested the link and files. They are currently working
got it.
Great!
Muchas Muchas Gracias ❤❤
De nada
I need my $92K back from webster because now I am seeing why I failed accounting 1.
We are glad you found so much value in our videos!
Joe is even better than I expected
Thanks!