Excel Sorting and Filtering Data

Поділитися
Вставка
  • Опубліковано 26 сер 2024
  • 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...
    ______________________________________
    UA-cam Channel Growth Accelerator:
    / youtubechannelgrowthac...
    Algebra For Beginners:
    www.video-tuto...
    Final Exams and Video Playlists:
    www.video-tuto...
    Full-Length Math & Science Videos:
    / collections

КОМЕНТАРІ • 151

  • @TheOrganicChemistryTutor
    @TheOrganicChemistryTutor  8 місяців тому

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

  • @clownassociation9753
    @clownassociation9753 3 роки тому +113

    MY guy good at everything lol

    • @Riya-ct5ij
      @Riya-ct5ij Рік тому +1

      Same

    • @safaazaba
      @safaazaba Рік тому +2

      @@Riya-ct5ij ??wachi mean same?

    • @jameiliajones4942
      @jameiliajones4942 Рік тому +3

      😂😂😂😂when I heard his voice I was stunned loll

    • @potthethird
      @potthethird 6 місяців тому

      @@jameiliajones4942fr bruh

    • @PunmasterSTP
      @PunmasterSTP 3 місяці тому

      Don't you mean, he *excels* at everything?

  • @TheUnstopableJoe
    @TheUnstopableJoe 2 роки тому +11

    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 3 місяці тому

      Out of curiosity, what were your two majors?

    • @TheUnstopableJoe
      @TheUnstopableJoe 3 місяці тому +1

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

    • @PunmasterSTP
      @PunmasterSTP 3 місяці тому

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

    • @TheUnstopableJoe
      @TheUnstopableJoe 2 місяці тому +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 2 місяці тому

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

  • @lansanad.flahun4367
    @lansanad.flahun4367 19 днів тому

    My greatest wish is for you to stay healthy and longer. Your tutorials have helped me so much in my academic career. Love you from Sierra Leone, West Africa.

  • @PunmasterSTP
    @PunmasterSTP 3 місяці тому +3

    This tutorial was most Excel-ent! 👍🙏

  • @kathywalker1970
    @kathywalker1970 Рік тому +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+

  • @ainzulaikha4392
    @ainzulaikha4392 2 роки тому +18

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

  • @derrickwheeler5329
    @derrickwheeler5329 3 роки тому +28

    Simple and clear instruction. Great video!

  • @belloaliyu3310
    @belloaliyu3310 Рік тому +8

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

  • @recer7506
    @recer7506 Рік тому +4

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

  • @fat1t1
    @fat1t1 Рік тому

    THANK YOU SOO MUCHHHHH!!!!! Tomorrow's my ICT practical exam and I just remembered at the last second, I quickly turned on UA-cam 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

  • @mgb2172
    @mgb2172 Рік тому +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 UA-cam teachin' method

  • @salmanben6918
    @salmanben6918 3 роки тому +10

    Thank you for making these vids easy to understand

  • @kariakichernocherno2274
    @kariakichernocherno2274 2 роки тому +1

    This guy is so so good he just teaches every thing

  • @taniamondal7402
    @taniamondal7402 2 роки тому +2

    You are a great teacher 🙂👍🏻👍🏻

  • @moniey54
    @moniey54 Рік тому +1

    Just literally helped me on the job. Thank you

  • @zorojuro1785
    @zorojuro1785 2 роки тому +1

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

  • @ssarthak
    @ssarthak 4 роки тому +6

    You are a good man thank you

  • @meshackotieno9097
    @meshackotieno9097 Рік тому +1

    very clear and simple. That was nice.

  • @rickychen6656
    @rickychen6656 Рік тому

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

  • @Goeker
    @Goeker Рік тому +1

    Very useful. Thank you!

  • @carstenschluter3446
    @carstenschluter3446 2 роки тому

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

  • @zonafutshane6663
    @zonafutshane6663 Рік тому +1

    Clear and straight forward. Thank you so much.

  • @JMrai7437
    @JMrai7437 3 роки тому +3

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

  • @d.m.958
    @d.m.958 Рік тому

    Very good tutorial.

  • @gaaraofthefunk7163
    @gaaraofthefunk7163 2 роки тому

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

  • @ginab2970
    @ginab2970 2 роки тому +1

    Very helpful, thank you!

  • @soybeans8139
    @soybeans8139 2 роки тому +2

    Thank you. Your instructions will really clear and helpful.

  • @annalattaruloconti2511
    @annalattaruloconti2511 Рік тому

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

  • @ziyancheng8122
    @ziyancheng8122 2 роки тому

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

  • @aaronmaseko7763
    @aaronmaseko7763 Рік тому

    Clearly demonstrated

  • @antoinettemilano359
    @antoinettemilano359 5 років тому +3

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

  • @onyebuchiikechukwu2118
    @onyebuchiikechukwu2118 Рік тому

    Thank you for this❤❤

  • @saralmudunuri6453
    @saralmudunuri6453 Рік тому

    So simple Julio!!! Keep it up..

  • @Bestmansaye
    @Bestmansaye Рік тому

    Thanks a lot
    I learn

  • @seallv4507
    @seallv4507 2 роки тому

    Thankyou bro!! Was having trouble with this

  • @mrCetus
    @mrCetus 2 роки тому

    THANK YOU SO MUCH FOR THIS INFORMATIVE VIDEO!

  • @lissyperez4299
    @lissyperez4299 11 місяців тому +1

    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?

  • @malihatayyab5180
    @malihatayyab5180 3 роки тому +1

    Thank you that saved me for my test😛

  • @Itdontmakesense.
    @Itdontmakesense. Рік тому

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

  • @mohamedhussienegeh3239
    @mohamedhussienegeh3239 Рік тому

    Thanks Man You Really Helped Me

  • @Afrographics-kk2qj
    @Afrographics-kk2qj Рік тому +11

    Is there anything you don't do? 😂

  • @josephineybanez-ny6vm
    @josephineybanez-ny6vm Рік тому

    like your explanation

  • @sanoyeee9220
    @sanoyeee9220 2 роки тому

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

  • @sweetmelon6213
    @sweetmelon6213 Рік тому

    Thanks my guy you helped a lot!

  • @INDIANARMY-142
    @INDIANARMY-142 5 місяців тому

    it helped me very thank yuo

  • @NanaKwarteng
    @NanaKwarteng 11 місяців тому

    You are a star⭐

  • @charliecool4461
    @charliecool4461 2 роки тому

    What?!!! This guy does everything

  • @agrenvtv
    @agrenvtv 2 роки тому

    Perfect! I more than love this, upload more Tutor

  • @najmuibnmoideen649
    @najmuibnmoideen649 2 роки тому +1

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

  • @sarojmanandhar2457
    @sarojmanandhar2457 2 роки тому

    Thanks a lot.

  • @ryand667
    @ryand667 Рік тому

    1000 thanks; you really helped me out! : D

  • @yuratea1700
    @yuratea1700 4 роки тому +6

    You are a wonderful teacher. Thank you.

  • @shreyasuresh1252
    @shreyasuresh1252 3 роки тому

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

  • @shakurburton9358
    @shakurburton9358 6 років тому +3

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

  • @user-cz7is3td2g
    @user-cz7is3td2g Рік тому

    Very very good

  • @ahmadhassan2131
    @ahmadhassan2131 Рік тому

    Video was very helpful

  • @jelalejanaabubakar7860
    @jelalejanaabubakar7860 3 роки тому +4

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

  • @HMarije
    @HMarije 2 роки тому +1

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

  • @koakalamau9212
    @koakalamau9212 Рік тому +1

    Super simple and helpful bro! Thanks a TON!

  • @Saddysaadchannel
    @Saddysaadchannel Рік тому

    great video . thank you😍

  • @josephjohnpaul6688
    @josephjohnpaul6688 3 роки тому

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

  • @geraldgiovanni6627
    @geraldgiovanni6627 2 роки тому

    Thank you very much for sharing this!

  • @fatimagudekar506
    @fatimagudekar506 3 роки тому +1

    Thanks for such a nice explanation sir

  • @kgorilla2
    @kgorilla2 3 роки тому

    best video ever?!

  • @javiermoreno4373
    @javiermoreno4373 2 роки тому +1

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

  • @ItsMuaaz
    @ItsMuaaz 3 роки тому +1

    Appreciated for the info, great video! 👍🏻

  • @diegowooh96
    @diegowooh96 2 роки тому

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

  • @avelinileva
    @avelinileva Рік тому

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

  • @BotcahMitjinCH
    @BotcahMitjinCH Місяць тому

    bro surprisingly is teaching excel lollll

  • @sheikhrazibhossain2085
    @sheikhrazibhossain2085 Рік тому

    Good video

  • @jeewgunarathna8516
    @jeewgunarathna8516 2 роки тому

    Thank you so much... 😍😍

  • @melfromtoronto8746
    @melfromtoronto8746 4 роки тому +3

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

  • @maryannladi1332
    @maryannladi1332 Рік тому

    Big help

  • @TheSlickest08
    @TheSlickest08 2 роки тому +2

    Great video. Clear and concise.

  • @kgetsepemkhabela3963
    @kgetsepemkhabela3963 3 роки тому +1

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

  • @shaqifasyrafbinyusoffstude8968
    @shaqifasyrafbinyusoffstude8968 2 роки тому

    Thanks

  • @donwilliam3575
    @donwilliam3575 2 роки тому +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?

  • @chantemonique5968
    @chantemonique5968 2 роки тому +5

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

  • @soniamalik9900
    @soniamalik9900 3 роки тому

    Zuberdust sharing dear.... Keep it ho

  • @post1113
    @post1113 2 роки тому

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

  • @athena263
    @athena263 2 роки тому

    Great video

  • @ElianMrl
    @ElianMrl 2 роки тому

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

  • @suzanne3t
    @suzanne3t 3 роки тому +1

    I appreciate these free how-to's but it would be really nice if you'd set up your example data ahead of time. (Another idea would be if you work with text strings, copy them so you don't have to make up some new names all over again.) Watching you enter data feels like a waste of time that could be spent focusing on the processes themselves. But again, thank you for these videos!

  • @gersonorellana8932
    @gersonorellana8932 Рік тому

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

  • @jeewgunarathna8516
    @jeewgunarathna8516 2 роки тому

    Good job 😍👍👍👍

  • @Eminentbryan
    @Eminentbryan Рік тому

    Good 👍

  • @ihsanulkamil1999
    @ihsanulkamil1999 8 місяців тому

    awesome

  • @stefangrozdanov1299
    @stefangrozdanov1299 2 роки тому

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

  • @MyWatchP1
    @MyWatchP1 2 роки тому

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

  • @muthusanjay3368
    @muthusanjay3368 4 роки тому +1

    Thank you sir

  • @Pravinamadoori
    @Pravinamadoori 2 роки тому

    Hi, i have a column with. Both text and numbers. I want to see only text entries but not number.. how can it be achieved via filtering? Thanks
    For example values are 556896,4444789,Canada, Europe, 6666789, KSA.....
    After filtering I need entries with text only

  • @keeganpretorius847
    @keeganpretorius847 3 місяці тому

    You are in every corner of youtube 😂

  • @CDznGfx
    @CDznGfx 2 роки тому

    Can you use this to filtwr leads callcenter

  • @Maisha-Halisi
    @Maisha-Halisi 4 роки тому +1

    Thank you a lot. Good job

  • @abdorashed8511
    @abdorashed8511 Рік тому

    How I can make total every item in one cell

  • @husseinalaa2681
    @husseinalaa2681 4 роки тому +1

    Really great explain, thank u so much

  • @preetamgurav4139
    @preetamgurav4139 Рік тому

    How to get it back to default entry

  • @zareh805
    @zareh805 3 роки тому

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

  • @munawarsultan5810
    @munawarsultan5810 8 місяців тому

    nice