Excel Sorting and Filtering Data

Sdílet
Vložit
  • čas přidán 6. 06. 2018
  • This excel video tutorial provides a basic introduction into sorting and filtering data. It explains how to sort numbers in increasing order as well as sorting letters and words in alphabetical order. It discusses how to filter data by words, numbers, and dates.
    Excel Tutorial For Beginners:
    • Excel Tutorial For Beg...
    Top 30 Excel Tips & Shortcuts:
    • Top 30 Excel 2016 Tips...
    _______________________________________
    Excel - Auto Fill:
    • How To Use Autofill In...
    Excel Flash Fill:
    • Excel Flash Fill Tutorial
    How To Insert Rows and Columns:
    • How To Insert Rows and...
    Resize Multiple Rows and Columns:
    • How To Resize Multiple...
    How To Move Columns:
    • How To Move Columns In...
    _______________________________________
    How To Move Multiple Rows & Columns:
    • How To Move Multiple R...
    How To Split Text Into Multiple Columns:
    • How To Split Text Into...
    How To Use Hyperlinks In Excel:
    • How To Use HyperLinks ...
    How To Sort and Filter Data:
    • Excel Sorting and Filt...
    Excel - Find and Replace Tutorial:
    • Excel 2016 - Find and ...
    Excel Conditional Formatting:
    • Excel Conditional Form...
    ______________________________________
    CZcams Channel Growth Accelerator:
    / youtubechannelgrowthac...
    Algebra For Beginners:
    www.video-tutor.net/algebra-f...
    Final Exams and Video Playlists:
    www.video-tutor.net/
    Full-Length Math & Science Videos:
    / collections

Komentáře • 149

  • @TheOrganicChemistryTutor
    @TheOrganicChemistryTutor  Před 5 měsíci

    Final Exams and Video Playlists: www.video-tutor.net/
    Full-Length Videos & Worksheets: www.patreon.com/MathScienceTutor/collections

  • @clownassociation9753
    @clownassociation9753 Před 2 lety +100

    MY guy good at everything lol

  • @PunmasterSTP
    @PunmasterSTP Před 15 dny +1

    This tutorial was most Excel-ent! 👍🙏

  • @derrickwheeler5329
    @derrickwheeler5329 Před 3 lety +27

    Simple and clear instruction. Great video!

  • @ainzulaikha4392
    @ainzulaikha4392 Před 2 lety +18

    It's you. It's always you helped me a lot with my assignments. Thank you so much! ♥️

  • @recer7506
    @recer7506 Před rokem +4

    You did not show me what i wanted, but you showed me what i needed. Thank you :)

  • @belloaliyu3310
    @belloaliyu3310 Před rokem +8

    This is just amazing. You made it so simple to understand. Good job

  • @kathywalker1970
    @kathywalker1970 Před rokem +9

    This was just what I was looking for! Thank you for clear and concise instructions. I’m going to continue watching your Excel videos to advance my 50 year old brain knowledge even more! A+

  • @fat1t1
    @fat1t1 Před rokem

    THANK YOU SOO MUCHHHHH!!!!! Tomorrow's my ICT practical exam and I just remembered at the last second, I quickly turned on CZcams and couldn't find a proper video explaining the stuff the exam's based on, until I found this one!!! I'm really good at Excel now, all thanks to your vid!!! :D

  • @zonafutshane6663
    @zonafutshane6663 Před rokem +1

    Clear and straight forward. Thank you so much.

  • @soybeans8139
    @soybeans8139 Před 2 lety +2

    Thank you. Your instructions will really clear and helpful.

  • @salmanben6918
    @salmanben6918 Před 3 lety +10

    Thank you for making these vids easy to understand

  • @TheUnstopableJoe
    @TheUnstopableJoe Před 2 lety +10

    You have helped me through 2 different majors and so many different classes. Calculus, Statistics, Engineering and now ITM??? You’re a God.

    • @PunmasterSTP
      @PunmasterSTP Před 15 dny

      Out of curiosity, what were your two majors?

    • @TheUnstopableJoe
      @TheUnstopableJoe Před 10 dny +1

      @@PunmasterSTP I did Electronics Engineering my first 2 years and then switched to Finance and graduated with my bachelors.

    • @PunmasterSTP
      @PunmasterSTP Před 10 dny

      @@TheUnstopableJoe Sounds good! I hope finance is going well.

    • @TheUnstopableJoe
      @TheUnstopableJoe Před 8 dny +1

      @@PunmasterSTP Yes sir. I’m in a great paying sales role with a fortune 200 company. Can’t go wrong with the business route man. Good luck to you.

    • @PunmasterSTP
      @PunmasterSTP Před 8 dny

      @@TheUnstopableJoe That’s awesome; I was stoked to hear it 👍

  • @mgb2172
    @mgb2172 Před rokem +1

    real helpful my guy, don't stop helpin' us ever - i'm in uni and i still ain't outgrown the tried and tested Mr CZcams teachin' method

  • @meshackotieno9097
    @meshackotieno9097 Před rokem +1

    very clear and simple. That was nice.

  • @ItsMuaaz
    @ItsMuaaz Před 3 lety +1

    Appreciated for the info, great video! 👍🏻

  • @aswathipillai1444
    @aswathipillai1444 Před 2 lety +1

    THANK YOU SO MUCH FOR THIS INFORMATIVE VIDEO!

  • @Judaswoof
    @Judaswoof Před rokem +1

    Thank you, very useful!

  • @annalattaruloconti2511
    @annalattaruloconti2511 Před 11 měsíci

    Thank you so much! This is exactly what I was looking for!!

  • @JMrai7437
    @JMrai7437 Před 2 lety +3

    Sir your superb tutorial made my life easy. God bless you.

  • @kariakichernocherno2274
    @kariakichernocherno2274 Před 2 lety +1

    This guy is so so good he just teaches every thing

  • @moniey54
    @moniey54 Před rokem +1

    Just literally helped me on the job. Thank you

  • @jevanceochieng7721
    @jevanceochieng7721 Před 2 lety

    Perfect! I more than love this, upload more Tutor

  • @yuratea1700
    @yuratea1700 Před 4 lety +6

    You are a wonderful teacher. Thank you.

  • @ssarthak
    @ssarthak Před 3 lety +6

    You are a good man thank you

  • @jelalejanaabubakar7860
    @jelalejanaabubakar7860 Před 2 lety +4

    I needed this for my statistical mini research, thanks a bunch!!

  • @geraldgiovanni6627
    @geraldgiovanni6627 Před 2 lety

    Thank you very much for sharing this!

  • @gaaraofthefunk7163
    @gaaraofthefunk7163 Před 2 lety

    Thank you! THANK YOU SO MUCH FOR UPLOADING. It’s been years since I used this program, I can only remember so much 😭

  • @taniamondal7402
    @taniamondal7402 Před rokem +2

    You are a great teacher 🙂👍🏻👍🏻

  • @carstenschluter3446
    @carstenschluter3446 Před 2 lety

    So that's what the JG in your logo means!! Thank you for all your tutorials

  • @koakalamau9212
    @koakalamau9212 Před rokem +1

    Super simple and helpful bro! Thanks a TON!

  • @zorojuro1785
    @zorojuro1785 Před 2 lety +1

    I didn't know you also teach microsoft. You sure helped me with my chemistry

  • @saralmudunuri6453
    @saralmudunuri6453 Před rokem

    So simple Julio!!! Keep it up..

  • @TheSlickest08
    @TheSlickest08 Před 2 lety +2

    Great video. Clear and concise.

  • @sweetmelon6213
    @sweetmelon6213 Před rokem

    Thanks my guy you helped a lot!

  • @mohamedhussienegeh3239

    Thanks Man You Really Helped Me

  • @seallv4507
    @seallv4507 Před rokem

    Thankyou bro!! Was having trouble with this

  • @melfromtoronto8746
    @melfromtoronto8746 Před 4 lety +3

    Wow! Thanks for this video, I learned something new today!👍

  • @ryand667
    @ryand667 Před rokem

    1000 thanks; you really helped me out! : D

  • @kgetsepemkhabela3963
    @kgetsepemkhabela3963 Před 3 lety +1

    Thank you so much
    You are skilled in every field, enjoyed your science classes.

  • @javiermoreno4373
    @javiermoreno4373 Před rokem +1

    Helped me complete my chart with a clear, short, and simple tutorial

  • @fatimagudekar506
    @fatimagudekar506 Před 3 lety +1

    Thanks for such a nice explanation sir

  • @josephjohnpaul6688
    @josephjohnpaul6688 Před 2 lety

    Thanks u made me understand how easy it is to make a tournament table and statistics

  • @onyebuchiikechukwu2118
    @onyebuchiikechukwu2118 Před 11 měsíci

    Thank you for this❤❤

  • @antoinettemilano359
    @antoinettemilano359 Před 4 lety +3

    I rather enjoyed this. Going to class now to learn this but you make it seem rather simple. TY!!!

  • @najmuibnmoideen649
    @najmuibnmoideen649 Před rokem +1

    Thanks sir, really i feel like to telling a special thanks by shake hands😊 Very informative

  • @d.m.958
    @d.m.958 Před rokem

    Very good tutorial.

  • @rickychen6656
    @rickychen6656 Před rokem

    I was just watching an orgo video and here I am watching an Excel tutorial. What can't this man do.

  • @Saddysaadchannel
    @Saddysaadchannel Před rokem

    great video . thank you😍

  • @avelinileva
    @avelinileva Před rokem

    TOP!!! Thank you! 🔥🔥🔥🔥🔥

  • @malihatayyab5180
    @malihatayyab5180 Před 3 lety +1

    Thank you that saved me for my test😛

  • @ahmadhassan2131
    @ahmadhassan2131 Před rokem

    Video was very helpful

  • @chantemonique5968
    @chantemonique5968 Před 2 lety +5

    Thank You ☺️ you were very clear and it was super helpful!!

  • @shakurburton9358
    @shakurburton9358 Před 6 lety +3

    You've been a big help in helping me to use Excel properly.
    Thank you.

  • @shreyasuresh1252
    @shreyasuresh1252 Před 3 lety

    Thank you I could not understand my teacher because she teaches complicatedly tysm

  • @Bestmansaye
    @Bestmansaye Před rokem

    Thanks a lot
    I learn

  • @kgorilla2
    @kgorilla2 Před 2 lety

    best video ever?!

  • @sarojmanandhar2457
    @sarojmanandhar2457 Před rokem

    Thanks a lot.

  • @aaronmaseko7763
    @aaronmaseko7763 Před rokem

    Clearly demonstrated

  • @soniamalik9900
    @soniamalik9900 Před 3 lety

    Zuberdust sharing dear.... Keep it ho

  • @donwilliam3575
    @donwilliam3575 Před rokem +3

    Excellent explanation! Your video was really helpful.
    Was wondering if I could filter out a column. I mean not necessarily hide columns but exclude certain person's from seeing a particular column?

  • @charliecool4461
    @charliecool4461 Před 2 lety

    What?!!! This guy does everything

  • @athena263
    @athena263 Před 2 lety

    Great video

  • @josephineybanez-ny6vm

    like your explanation

  • @jeewgunarathna8516
    @jeewgunarathna8516 Před rokem

    Thank you so much... 😍😍

  • @ziyancheng8122
    @ziyancheng8122 Před 2 lety

    WOW!!! IT'S YOU AGAIN!! YOU MUST BE EVERYONE'S GOD DUDE!!

  • @INDIANARMY-142
    @INDIANARMY-142 Před 2 měsíci

    it helped me very thank yuo

  • @muthusanjay3368
    @muthusanjay3368 Před 3 lety +1

    Thank you sir

  • @user-cz7is3td2g
    @user-cz7is3td2g Před 10 měsíci

    Very very good

  • @husseinalaa2681
    @husseinalaa2681 Před 4 lety +1

    Really great explain, thank u so much

  • @jeewgunarathna8516
    @jeewgunarathna8516 Před rokem

    Good job 😍👍👍👍

  • @HMarije
    @HMarije Před rokem +1

    Great video! Does anybody know how to merge for example all the apples together under just 1 category of apples?

  • @NanaKwarteng
    @NanaKwarteng Před 8 měsíci

    You are a star⭐

  • @Maisha-Halisi
    @Maisha-Halisi Před 4 lety +1

    Thank you a lot. Good job

  • @maryannladi1332
    @maryannladi1332 Před 10 měsíci

    Big help

  • @sheikhrazibhossain2085

    Good video

  • @mdroman9480
    @mdroman9480 Před 2 lety

    so nice

  • @pvczity3042
    @pvczity3042 Před 3 lety

    thanks bro

  • @anikchowdhury9708
    @anikchowdhury9708 Před 2 lety

    Superb

  • @tharindupathirana30
    @tharindupathirana30 Před 4 lety +1

    Thank you!

  • @post1113
    @post1113 Před 2 lety

    Is there a way to change the title with in (many) cells so that "The" comes at the end? For example;
    The Beatles to Beatles, The
    The Rolling Stones to Rolling Stones, The
    The Da Vinci Code to Da Vinci Code, The
    etc.?

  • @ihsanulkamil1999
    @ihsanulkamil1999 Před 5 měsíci

    awesome

  • @Eminentbryan
    @Eminentbryan Před 9 měsíci

    Good 👍

  • @brhanfentahun763
    @brhanfentahun763 Před 2 lety

    Thanks

  • @diegowooh96
    @diegowooh96 Před 2 lety

    You know is a good tutorial when you hear the voice saying: “in this video we’re going to…” #TeamTheOrganicChemistrytutor

  • @DrawingwithNoel
    @DrawingwithNoel Před 3 lety

    thanks

  • @lissyperez4299
    @lissyperez4299 Před 8 měsíci

    Hi, I know I've seen this before but how can you add to the filters how many of each choice there are in a list? I'm not saying of the spreadsheet itself but I've seen in the filter when you have a list of items how how many times the item is listed in that column?

  • @CDznGfx
    @CDznGfx Před 2 lety

    Can you use this to filtwr leads callcenter

  • @sanoyeee9220
    @sanoyeee9220 Před 2 lety

    Ur so hot organic chemical tutor , u literally know everything 😭

  • @pilarbatapabeaka6686
    @pilarbatapabeaka6686 Před 2 lety

    How do you add data into a filtered table?

  • @tameemmohammed6906
    @tameemmohammed6906 Před 3 lety

    Great video, move on, thanks a lot.

  • @Itdontmakesense.
    @Itdontmakesense. Před rokem

    Got a fright when I heard your voice... didn’t think you’d help in computing classes too 😂

  • @munawarsultan5810
    @munawarsultan5810 Před 6 měsíci

    nice

  • @user-xq6ds9hv8g
    @user-xq6ds9hv8g Před 2 lety

    Thank you for useful information can I offer about you If it acceptable to make a new video about pivot table 😀😉

  • @MyWatchP1
    @MyWatchP1 Před 2 lety

    Pls, how do I filter when my data is in 5 different sheet but the same file?

  • @javaidiqbal8467
    @javaidiqbal8467 Před měsícem

    Best

  • @elianmoralespina5851
    @elianmoralespina5851 Před 2 lety

    I want to sort by a cell that has numbers and a letter, I wanted to sort this cells in ascending by its number (both the number and letter are in the same cell).

  • @zareh805
    @zareh805 Před 3 lety

    How do sort number lowest to highest but those numbers correspond to names?

  • @gersonorellana8932
    @gersonorellana8932 Před rokem

    how can make a table that sums up only apples from a table? or only bananas from one table?

  • @stefangrozdanov1299
    @stefangrozdanov1299 Před rokem

    after command of sort a-z i get message "You can't change part of an array" any suggestion how to solve this please?