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/
Пікірлер
A Big Thanks to your video...very helpful.
hello, how to sort highest to lowest value two column data but exclude cell with zero or blank value? thank you
thanks bro <3
Great video this is exactly what I wanted to do!
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
How do you rearrange columns?
How do you color change to a cell to a different sheet within the same workbook?
thank youn!
Thank you so much!!
Thanks for watching
Thanks great advice
Thanks for your help... Very well explained... Great VID.
your display font block the formula,
Great learning. Thank you
hard🔥🔥🔥💯
Thanks
very useful sir, thanks
Very well explained 👍
Thank you!
Thank you so much! Very much appreciate it!
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!
Glad to hear it worked out for you!
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?
Thanks!
Thanks! Exactly what I was looking for! :)
Thank you very much
THANKS !
Thank you for this video!
How to sort ony some selected data, not all?
You can just highlight the data you want sorted and it will only sort what you highlighted.
You are a lifesaver!!!
Gotta love it when you search up a question, and KZread FINALLY gives you what you want to hear 😁
Check out the full course here: kzread.info/dash/bejne/f3qelrxrdMqvpJM.html
EXCELLENT! THANK YOU!!!
Unfortunaltely this doesn work anymore in 2024
Which method?
this might seem like a stupid question, but what is meant by value?
Thank you very much, this came at the right time
Nice training. Thank you.
It would of been nice if you actually print and show us the hard copy
so you cant do this from a pivot table?
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
Solid hai just abhi use kiya Thank you very much 😊
Love u dude... U saved my time
Bro thank you so much.
Thank you!
My issue is the date appears as August 3rd, 2024. How do I convert it to 08/3/2024?
Thank you for this, it helped so much
Thank you. Simple and to the point.
Great video, Loved it!
Thanks!
Thanks!
I watch in 2024
I watch 2024🎉
Not just Sheets and Excel. Ctrl+Z for undo is a pretty common keyboard command across computing.