Тёмный

Sorting in Excel - Basics and Beyond 

Technology for Teachers and Students
Подписаться 1,5 млн
Просмотров 345 тыс.
50% 1

Learn everything you need to know about sorting in Microsoft Excel. This video is perfect for Excel beginners, but it also will extend your knowledge of sorting beyond the basics. ***Support Technology for Teachers and Students on Patreon***: / technologyforteachersa... Here's my entire playlist of Excel tutorials: bit.ly/tech4excel Consider saying "Thanks" by clicking the Thanks button below the video. Here's the practice file for this video: bit.ly/sortexcel #excel #exceltutorials #microsoft365

Хобби

Опубликовано:

 

3 авг 2024

Поделиться:

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист
Посмотреть позже
Комментарии : 76   
@DemetriPanici
@DemetriPanici 2 года назад
Sometimes I find that something as basic as this can really set you apart from other people in the work place! Great video
@bobbiehennessy4636
@bobbiehennessy4636 9 месяцев назад
Excellent video and it was exactly what it says it is; all about sorting! Clear, concise and right on point! Thanks so much!
@penelopebarby5987
@penelopebarby5987 2 месяца назад
Just that simple step of inserting blank row or column to protect other data CHANGE EVERYTHING - THANKS 🙂
@Life_is_very_Beautiful
@Life_is_very_Beautiful 2 года назад
As splendid as in your other briefs. Thank You. 🙏
@simoiyahector-morales3781
@simoiyahector-morales3781 2 года назад
Always appreciate your tutorials
@bencrossley4085
@bencrossley4085 Год назад
Very clear and helpful. Thank you.
@oleksandrmoskalov3222
@oleksandrmoskalov3222 3 месяца назад
Man, that's the perfect tutorial I've been needed. Great thanks from me to you!
@e4ezzat
@e4ezzat Год назад
Amazing info direct to the point👍
@dutjamesgarang6824
@dutjamesgarang6824 2 года назад
Great video. Basics raise curiosity.
@peaceandquiet
@peaceandquiet Год назад
Thanks a lot, this helped me very much, so many years I never used excel until now, my mistake and now I am learning.
@taharizwan3538
@taharizwan3538 9 месяцев назад
dude you are lifesaver.
@tizmehere492
@tizmehere492 2 года назад
This is so simply awesome! Thank you!!!!
@markeggenberger4984
@markeggenberger4984 Год назад
This is very informative. We'll done. Thank you!
@Dream-ft5ct
@Dream-ft5ct 2 года назад
Awesome! easy to understand. Thanks, alto.
@allisonshimonski9399
@allisonshimonski9399 2 года назад
Hi I’m new to your channel and am finding it extremely helpful as I’m working to brush up on my excel skills. I was wondering if you might be willing to do a video on extracting data from reports or other docs/applications. I also believe that data could be then turned into charts/pie charts? Thank you for sharing your knowledge!
@srijitm8760
@srijitm8760 Год назад
Really, a great video, I understood the things very easily after seeing your video.
@Alexandra-hy8bp
@Alexandra-hy8bp 11 месяцев назад
Thank you heaps, super clean and helpful video.
@JustinW007
@JustinW007 8 месяцев назад
Sorting was exactly the key I needed to transform my ability to use Excel.
@bskak1940
@bskak1940 Год назад
Very nice presentatio. I have learnt a new thing.Thanks
@johnnyandigisi3258
@johnnyandigisi3258 5 месяцев назад
You are a Legend.
@justbbee
@justbbee 5 месяцев назад
Extremely helpful! Thanks
@SARTHAKTHEMAN
@SARTHAKTHEMAN 2 года назад
Your tutorials are sick..😁😁😁
@vincentaldagcuta9283
@vincentaldagcuta9283 Год назад
The CTRL + A = solved my issues. Damn those small issues/mistakes sometimes complicate things. TY Bro!
@yvonneasomanidansowaa2370
@yvonneasomanidansowaa2370 Год назад
TOO GOOD, Thank you
@rumanijain9305
@rumanijain9305 Год назад
you are amazinggggg...thank you ....support from India
@ndelpurg
@ndelpurg 2 года назад
always great Many thanks
@HTCGT1963
@HTCGT1963 9 месяцев назад
EXCELLENT VIDEO THANK YOU 👍
@almoezsaadabi5599
@almoezsaadabi5599 2 года назад
Really I can't thank you enough. Do you have any videos of how to make charts please
@islamshawqi3823
@islamshawqi3823 3 месяца назад
Excellent job 😊
@markpodesta4605
@markpodesta4605 2 года назад
Thank you.
@kylegeddis2666
@kylegeddis2666 4 месяца назад
thank you, this worked
@shuaibopeyemi7137
@shuaibopeyemi7137 Месяц назад
Thank youuuuuu😊
@danabee3775
@danabee3775 2 месяца назад
Very helpful, thank you! :-)
@elita.23
@elita.23 Год назад
Love this!!
@laurenbrown667
@laurenbrown667 Год назад
Thank you!!
@themixchannel1816
@themixchannel1816 Год назад
Thanks very much !!!!
@foxybrown2k11
@foxybrown2k11 2 месяца назад
Thank you :)
@SinemSimonaTurkish
@SinemSimonaTurkish 4 месяца назад
thank you. it helped.
@neerajallamseti4582
@neerajallamseti4582 2 года назад
Sir Ji, I need ur guidance in solving this.. In a sheet, A1, B1, C1 are the three cells. C column will be given by me as input (positive no). B1 = A1 - C1 and so on for B Column A2 = B1 and so on for A column Now, A1 is to be automatically derived, such that "0" comes in A column. Thanks in Advance 😊🙏
@JoAnnGooding-ct8bt
@JoAnnGooding-ct8bt Год назад
Thanks! Thank you so much this was more than helpful!
@techteachersandstudents
@techteachersandstudents Год назад
Glad it helped! Thanks so much for your kind gift.
@XDShami
@XDShami Год назад
I want to abuse you bro. You are the best solution provider one of the best creators on RU-vid
@MazyHadz
@MazyHadz Год назад
Thank you so much
@BeksiVlog
@BeksiVlog 7 месяцев назад
❤❤❤ Thanks for sharing thanks thanks thanks
@vistron888
@vistron888 3 месяца назад
If you only select one cell in the column and select sort a to z. it simply sorts that column and all the other columns stay in the same place. So data gets mixed up.
@eng.ashrafemara2294
@eng.ashrafemara2294 2 года назад
Thanks
@michaelcourter5432
@michaelcourter5432 Год назад
Fantastic
@markschmid6463
@markschmid6463 2 года назад
Always enjoy your videos.
@Jhallidaybell
@Jhallidaybell Год назад
V helpful
@ihsanulkamil1999
@ihsanulkamil1999 7 месяцев назад
awesome
@moshemaor1731
@moshemaor1731 Месяц назад
Hello, An old simple problem I have in Excel. I have the following Column in Excel: R101, R10, R11, R1, R20, R2 And after sorting, I expect to Get: R1, R10, R101, R11, R2, R20 But I do not. Instead, I get: R1, R10, R101, R11, R2, R20 How can I do it? Thanks. Moshe.
@BenderArts
@BenderArts 2 года назад
Thanks!
@techteachersandstudents
@techteachersandstudents 2 года назад
Welcome! Thank YOU for your support! Sorry for my delay in saying thanks.
@BenderArts
@BenderArts 2 года назад
@@techteachersandstudents Wish I had more to support your work! Maybe someday:) TY
@spec24
@spec24 Год назад
Well, I guess we see what it takes for this guy to reply to his followers.
@gabecajamarca
@gabecajamarca Год назад
When I try it it says I can’t change part of an array. What does that mean?
@joshswenson8390
@joshswenson8390 5 месяцев назад
You mentioned to add a blank row or column to separate the data into another section that doesn't get sorted along with the rest. Well, I have done that accidentally, and now my data won't sort along with the rest -- but I can't find the blank row. How do I group the data together again?
@igors1234
@igors1234 7 месяцев назад
If I have a 20x10 chart with 200 unrelated to each other numbers and want to sort them from smallest to largest, how do I do that? It would be easy if they were written in one row or one column, but there are 10 rows and 20 columns.
@gokulakannanh2158
@gokulakannanh2158 2 года назад
Sir, I worked on file and sorted the data and Saved, Now, How to undo the sorted filter, or how to go back to original position ,
@jarjar621
@jarjar621 Год назад
do we need a specific setup to make sure we dont accidentally sort the column names as well? i kept screwing that up.
@rajwvilla
@rajwvilla 11 месяцев назад
Hi How to i keep my sort order ? eg i have a table of names and points and copy to another area to sort. I highlight, and choose sort function, and sort per points. Now, the following week i will update this table, and copy to the area mentioned, i go to sort and my sort order has gone. I want to keep that sort order, Any ideas?
@tracybuford9243
@tracybuford9243 7 месяцев назад
I know this has been a minute but I'm just not seeing it. What am I doing wrong if when I click on the name column and A to Z and it puts one of the names above the labels. Like the column labels I have set up.
@patrycjaw8323
@patrycjaw8323 12 дней назад
Did i notice the names of the players not be in alphabetical order when the team was in the harder part of the sort?
@stevenzahorec6009
@stevenzahorec6009 3 месяца назад
MINE SORTS SEPARATELY EVERYTIME
@RuneHansen4300
@RuneHansen4300 2 месяца назад
What if my sorting is about letters and not numbers? I am using excel 365 and it allows me to sort but only by colors, numbers and that I cant get it to sort alphabethically
@bobwoolcock
@bobwoolcock 3 месяца назад
Hmm. Mine doesn't work. I have a dozen rows - but it only sorts 2-12 and leaves the top row as is. ??
@ZakirK
@ZakirK Год назад
how to sort alphanumeric data ?
@andrewlwin9407
@andrewlwin9407 11 месяцев назад
Hello, How to automatically count sorted items?
@rirox9196
@rirox9196 2 года назад
👍
@user-xc3vc5fo8u
@user-xc3vc5fo8u Месяц назад
sir plz attach the file for practise in description it's helps a lot
@techteachersandstudents
@techteachersandstudents Месяц назад
bit.ly/sortexcel
@brianinja
@brianinja Год назад
I try to sort and it says "You can't change part of an array."
@yrot1123
@yrot1123 Год назад
this is NOT everything about Excel sorting... you have not talking about row sorting.. or option sorting..
@chillaxsounds5508
@chillaxsounds5508 Год назад
Unclear video
@stevenzahorec6009
@stevenzahorec6009 3 месяца назад
nothing changes this, and this videos blantant lie that its one click is frustrating
@spec24
@spec24 Год назад
And when Excel is STUPID, and DOES sort your title row with the rest, what then? I'm not sure saying that Excel is smart quite covers it.
Далее
How to Filter in Excel
16:22
Просмотров 428 тыс.
MS Excel - Data Sorting
9:05
Просмотров 891 тыс.
БАТЯ И СОСЕД😂#shorts
00:59
Просмотров 1,6 млн
Help Barry And Barry Woman Scan Prisoners
00:23
Просмотров 2,6 млн
Excel Sorting and Filtering Data
13:29
Просмотров 907 тыс.
Filtering in Excel: Basics and Beyond
8:05
Просмотров 33 тыс.
How to SORT Data in Excel | 7 Tips
16:51
Просмотров 83 тыс.
Master Data Analysis on Excel in Just 10 Minutes
11:32
Say Goodbye to IF Statements in Excel with SWITCH
7:45
EASILY Make an Automated Data Entry Form in Excel
14:52