Modern School Bus

Modern School Bus

Welcome to Modern School Bus. This channel is dedicated to offering free technology education videos to help keep you up to date in the modern world. Learn how to use various spreadsheet programs, software, web apps, and other technology to help you succeed in work, school, or for personal use.

We hope you find our content helpful. Be sure to reach out with any questions or content requests that you have!

www.modernschoolbus.com/

How to Wrap Text in Excel

How to Wrap Text in Excel

How to Filter in Excel

How to Filter in Excel

How to Merge Cells in Excel

How to Merge Cells in Excel

How to Sort in Excel

How to Sort in Excel

Пікірлер

  • @reet1489
    @reet1489Күн бұрын

    A Big Thanks to your video...very helpful.

  • @skalawag0523
    @skalawag0523Күн бұрын

    hello, how to sort highest to lowest value two column data but exclude cell with zero or blank value? thank you

  • @Shortsfunnyvibes
    @Shortsfunnyvibes2 күн бұрын

    thanks bro <3

  • @DavidOldenburg1
    @DavidOldenburg12 күн бұрын

    Great video this is exactly what I wanted to do!

  • @rhapsodygrab
    @rhapsodygrab3 күн бұрын

    Hello thank you for the video. It was very helpful indeed. I will appreciate if you could do a video to show us how to copy a very large table from the Google sheet into the Google slide. I actually tried doing that but right on the Google slide it was more than the frame. Like it was overlapping kind of, it didn't fit. So, what's the best way to do that? Thanks

  • @vickymclaughlin2344
    @vickymclaughlin23443 күн бұрын

    How do you rearrange columns?

  • @stevelee858
    @stevelee8585 күн бұрын

    How do you color change to a cell to a different sheet within the same workbook?

  • @hostsingercharlyn4066
    @hostsingercharlyn40665 күн бұрын

    thank youn!

  • @KDY0NE
    @KDY0NE6 күн бұрын

    Thank you so much!!

  • @ModernSchoolBus
    @ModernSchoolBus6 күн бұрын

    Thanks for watching

  • @lordia79
    @lordia796 күн бұрын

    Thanks great advice

  • @ginnymonroe4918
    @ginnymonroe49189 күн бұрын

    Thanks for your help... Very well explained... Great VID.

  • @guccyma67
    @guccyma6710 күн бұрын

    your display font block the formula,

  • @mariagratielaifrim3859
    @mariagratielaifrim385911 күн бұрын

    Great learning. Thank you

  • @Aspru
    @Aspru11 күн бұрын

    hard🔥🔥🔥💯

  • @TheolOnroadThings
    @TheolOnroadThings11 күн бұрын

    Thanks

  • @kalyankumar8629
    @kalyankumar862912 күн бұрын

    very useful sir, thanks

  • @mamtaswajeetrai6339
    @mamtaswajeetrai633912 күн бұрын

    Very well explained 👍

  • @ModernSchoolBus
    @ModernSchoolBus12 күн бұрын

    Thank you!

  • @dragonwings36
    @dragonwings3612 күн бұрын

    Thank you so much! Very much appreciate it!

  • @WriterLady
    @WriterLady15 күн бұрын

    OML, thank you soooo very much for sharing this! I used to build incredible formulaic maneuvers to prevent keep these miserable things from popping up. The solution was so simple!

  • @ModernSchoolBus
    @ModernSchoolBus14 күн бұрын

    Glad to hear it worked out for you!

  • @lucyrobin9428
    @lucyrobin942815 күн бұрын

    Having an issue, F4 does nothing as its a brightness key, and im UK so I assume I enter in £ (Locale set to UK), however that immediately invalidates the value?

  • @chair6152
    @chair615216 күн бұрын

    Thanks!

  • @AndroidFanatic
    @AndroidFanatic17 күн бұрын

    Thanks! Exactly what I was looking for! :)

  • @ravindrap7962
    @ravindrap796218 күн бұрын

    Thank you very much

  • @FrankCubillan-cx8uw
    @FrankCubillan-cx8uw18 күн бұрын

    THANKS !

  • @mework3069
    @mework306919 күн бұрын

    Thank you for this video!

  • @heliosak
    @heliosak19 күн бұрын

    How to sort ony some selected data, not all?

  • @ModernSchoolBus
    @ModernSchoolBus19 күн бұрын

    You can just highlight the data you want sorted and it will only sort what you highlighted.

  • @inferno8070
    @inferno807020 күн бұрын

    You are a lifesaver!!!

  • @fuhbox
    @fuhbox21 күн бұрын

    Gotta love it when you search up a question, and KZread FINALLY gives you what you want to hear 😁

  • @ModernSchoolBus
    @ModernSchoolBus21 күн бұрын

    Check out the full course here: kzread.info/dash/bejne/f3qelrxrdMqvpJM.html

  • @qmacker
    @qmacker21 күн бұрын

    EXCELLENT! THANK YOU!!!

  • @VictorGomezMaga
    @VictorGomezMaga23 күн бұрын

    Unfortunaltely this doesn work anymore in 2024

  • @ModernSchoolBus
    @ModernSchoolBus23 күн бұрын

    Which method?

  • @hannahamelia401
    @hannahamelia40123 күн бұрын

    this might seem like a stupid question, but what is meant by value?

  • @frankagreat3073
    @frankagreat307325 күн бұрын

    Thank you very much, this came at the right time

  • @user-dc1mx7ry7e
    @user-dc1mx7ry7e27 күн бұрын

    Nice training. Thank you.

  • @lileagle37
    @lileagle37Ай бұрын

    It would of been nice if you actually print and show us the hard copy

  • @firdausismail3020
    @firdausismail3020Ай бұрын

    so you cant do this from a pivot table?

  • @SavannahKee
    @SavannahKeeАй бұрын

    I was trying to calculate the median of a range of numbers only corresponding to values less than or equal to 600. All of the tutorials and blogs I found were using MEDIAN IF in order to work with text, but it wasn't working for me. In the hopes this helps some other random internet stranger, here is the formula I wrote to figure it out. =MEDIAN(QUERY(data_range, "SELECT data WHERE condition", headers)) ex: =MEDIAN(QUERY(C3:E200, "SELECT E WHERE C <= 600", 3)) If you're unfamiliar with queries in google sheets: data_range should encompass the entire table or columns that you are wanting to query, not just the columns you want to find the median of and set conditions for. For example: The column with data I want to use as a condition is C, but the column I want to find the median of is H. You would do C__:H__ with __ being wherever your data starts and ends. data is the column, row, or range that you want to find the median of the dataset. condition is a logical expression. headers is the number of header rows at the top of your data, if you wish to include them. If not, you can leave it blank and just end after the condition

  • @piyushjha780
    @piyushjha780Ай бұрын

    Solid hai just abhi use kiya Thank you very much 😊

  • @vishwahiremath7160
    @vishwahiremath7160Ай бұрын

    Love u dude... U saved my time

  • @deaconx
    @deaconxАй бұрын

    Bro thank you so much.

  • @RanjMN
    @RanjMNАй бұрын

    Thank you!

  • @seaningham99
    @seaningham99Ай бұрын

    My issue is the date appears as August 3rd, 2024. How do I convert it to 08/3/2024?

  • @AD-hu6ou
    @AD-hu6ouАй бұрын

    Thank you for this, it helped so much

  • @chrisreisinger5002
    @chrisreisinger5002Ай бұрын

    Thank you. Simple and to the point.

  • @Thetravellinaussie
    @ThetravellinaussieАй бұрын

    Great video, Loved it!

  • @ginanet
    @ginanetАй бұрын

    Thanks!

  • @GoingGreenMom
    @GoingGreenMomАй бұрын

    Thanks!

  • @faruonline5079
    @faruonline5079Ай бұрын

    I watch in 2024

  • @faruonline5079
    @faruonline5079Ай бұрын

    I watch 2024🎉

  • @Robert_St-Preux
    @Robert_St-PreuxАй бұрын

    Not just Sheets and Excel. Ctrl+Z for undo is a pretty common keyboard command across computing.