Sorting in Excel - Basics and Beyond

Рет қаралды 346,814

Technology for Teachers and Students

2 жыл бұрын

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

Пікірлер: 77

@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 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 2 ай бұрын

Just that simple step of inserting blank row or column to protect other data CHANGE EVERYTHING - THANKS 🙂

@simoiyahector-morales3781 2 жыл бұрын

Always appreciate your tutorials

@bencrossley4085 Жыл бұрын

Very clear and helpful. Thank you.

@Life_is_very_Beautiful 2 жыл бұрын

As splendid as in your other briefs. Thank You. 🙏

@redbullreddy7777 17 сағат бұрын

Appreciate the directness

@markeggenberger4984 Жыл бұрын

This is very informative. We'll done. Thank you!

@tizmehere492 2 жыл бұрын

This is so simply awesome! Thank you!!!!

@dutjamesgarang6824 2 жыл бұрын

Great video. Basics raise curiosity.

@Dream-ft5ct 2 жыл бұрын

Awesome! easy to understand. Thanks, alto.

@oleksandrmoskalov3222 3 ай бұрын

Man, that's the perfect tutorial I've been needed. Great thanks from me to you!

@e4ezzat Жыл бұрын

Amazing info direct to the point👍

@Alexandra-hy8bp 11 ай бұрын

Thank you heaps, super clean and helpful video.

@srijitm8760 Жыл бұрын

Really, a great video, I understood the things very easily after seeing your video.

@justbbee 5 ай бұрын

Extremely helpful! Thanks

@taharizwan3538 9 ай бұрын

dude you are lifesaver.

@JustinW007 8 ай бұрын

Sorting was exactly the key I needed to transform my ability to use Excel.

@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.

@yvonneasomanidansowaa2370 Жыл бұрын

TOO GOOD, Thank you

@HTCGT1963 9 ай бұрын

EXCELLENT VIDEO THANK YOU 👍

@bskak1940 Жыл бұрын

Very nice presentatio. I have learnt a new thing.Thanks

@shuaibopeyemi7137 Ай бұрын

Thank youuuuuu😊

@ndelpurg 2 жыл бұрын

always great Many thanks

@elita.23 Жыл бұрын

Love this!!

@islamshawqi3823 3 ай бұрын

Excellent job 😊

@rumanijain9305 Жыл бұрын

you are amazinggggg...thank you ....support from India

@themixchannel1816 Жыл бұрын

Thanks very much !!!!

@johnnyandigisi3258 5 ай бұрын

You are a Legend.

@SARTHAKTHEMAN 2 жыл бұрын

Your tutorials are sick..😁😁😁

@kylegeddis2666 4 ай бұрын

thank you, this worked

@laurenbrown667 Жыл бұрын

Thank you!!

@markpodesta4605 2 жыл бұрын

Thank you.

@SinemSimonaTurkish 4 ай бұрын

thank you. it helped.

@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!

@MazyHadz Жыл бұрын

Thank you so much

@almoezsaadabi5599 2 жыл бұрын

Really I can't thank you enough. Do you have any videos of how to make charts please

@danabee3775 3 ай бұрын

Very helpful, thank you! :-)

@foxybrown2k11 2 ай бұрын

Thank you :)

@vincentaldagcuta9283 Жыл бұрын

The CTRL + A = solved my issues. Damn those small issues/mistakes sometimes complicate things. TY Bro!

@JoAnnGooding-ct8bt Жыл бұрын

Thanks! Thank you so much this was more than helpful!

@techteachersandstudents Жыл бұрын

Glad it helped! Thanks so much for your kind gift.

@BeksiVlog 7 ай бұрын

❤❤❤ Thanks for sharing thanks thanks thanks

@markschmid6463 2 жыл бұрын

Always enjoy your videos.

@michaelcourter5432 Жыл бұрын

Fantastic

@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 😊🙏

@eng.ashrafemara2294 2 жыл бұрын

Thanks

@ihsanulkamil1999 7 ай бұрын

awesome

@Jhallidaybell Жыл бұрын

V helpful

@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 ,

@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.

@BenderArts 2 жыл бұрын

Thanks!

@techteachersandstudents 2 жыл бұрын

Welcome! Thank YOU for your support! Sorry for my delay in saying thanks.

@BenderArts 2 жыл бұрын

@@techteachersandstudents Wish I had more to support your work! Maybe someday:) TY

@spec24 Жыл бұрын

Well, I guess we see what it takes for this guy to reply to his followers.

@jarjar621 Жыл бұрын

do we need a specific setup to make sure we dont accidentally sort the column names as well? i kept screwing that up.

@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.

@XDShami Жыл бұрын

I want to abuse you bro. You are the best solution provider one of the best creators on KZfaq

@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?

@joshswenson8390 6 ай бұрын

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?

@gabecajamarca Жыл бұрын

When I try it it says I can’t change part of an array. What does that mean?

@andrewlwin9407 11 ай бұрын

Hello, How to automatically count sorted items?

@ZakirK Жыл бұрын

how to sort alphanumeric data ?

@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.

@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.

@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