Google Sheets can be used in so many different ways and for so many different purposes. Here are 10 Google Sheets tricks plus a bonus collection of 30 ideas for using Sheets in the classroom.
Google Sheets might look a little scary and a bit threatening at first glance but once you take the time to unlock its secrets you’ll discover that it can do so much more than just crunch numbers.
So how can we get started using Google Sheets ourselves? And what are some great Google Sheets activities that we can use with our students?
During our weekly #DitchBook Twitter chat (Thursdays at 7 p.m. PST / 8 p.m. MST / 9 p.m. CST / 10 p.m. EST), hosted by Craig Klement, we discussed these questions and more. We even had some Google Sheets gurus stop by the chat to drop their knowledge and share some ideas for unlocking the power of Sheets!
Educators shared tons of great tips and tricks to help you get started using Sheets along with ideas for using them with your students. In addition to the 10 tricks you will find below we also curated the resources shared for using Google Sheets in the classroom. Be sure to check out this copyable Wakelet to see 30 ideas for using this versatile G Suite app with your class!
Click on the numbered subtitles for links to tutorials, videos, or blog posts.
A2: Google Sheets has a RANDBETWEEN function which can be used to make random writing prompts https://t.co/xatHqk8IWJ and random emoji prompts https://t.co/vN0fF6h7hF #ditchbook #GoogleEDU pic.twitter.com/xihvmCevW5
— Eric Curts (@ericcurts) May 10, 2019
A2 Flippity is like its own Swiss Army Knife of sheets tricks. https://t.co/FYXiY18JlV In similar vein, though not 1 I’ve explored, Glide looks like intriguing Sheets partner: https://t.co/JLGWngga8Z And of course, Sheets functions themselves: https://t.co/a2dUUt19sX #ditchbook
— Brian Rozinsky (@brianrozinsky) May 10, 2019
A2 There are so many hacks and tricks that I ❤ to use with #GoogleSheets! One that really blew #GIFaDay participants minds is the simple double-click to fill down trick! Here’s the #EduGIF! #DitchBook https://t.co/MLVfv24ywU pic.twitter.com/vO9RGj2iXh
— Jake Miller (@JakeMillerTech) May 10, 2019
A2: One of my fav tricks in Google Sheets is using Control Y. If I want to repeat adding a row. #ditchbook
— Vicki (@33heupel) May 10, 2019
A1; my other favorite thing to do is lock sheets or cells so students can’t change what I’ve written, but they can add to it! #DitchBook
— Krista Harmsworth (@zonie71) May 10, 2019
A2: My favorite Google Sheets tricks are setting up check boxes and using data validation to create drop down menus within cells. These are great to know tricks for setting up a sheet as a rubric. #DitchBook
— Nicholas Taylor (@n_taylor05) May 10, 2019
A2: Freeze bars, check boxes, conditional formatting are super easy but super helpful. But my top choice would have to be Pivot tables! #DitchBook pic.twitter.com/1c17lJiZhR
— Craig Klement (@craigklement) May 10, 2019
A2: My absolute new & fav trick in Google Sheets is using macros to run the same set of steps on all my sheets as I ran on the 1st sheet all in 1 little Click. You have go to try Record & Run a Macros! 💥 #ditchbook pic.twitter.com/FjIZNF79j9
— Vicki (@33heupel) May 10, 2019
Also learned to use the $ sign in front of the column or row to lock the formula so it doesn’t change.
— Dr. Lance McClard (@drmcclard) May 10, 2019
*Lance learned this tip from Jake Miller’s GIF-a-Day Google Sheets Ninja Level 1 course. Fill out this form to get on the list for the next session coming up soon!
A2: Conditional Formatting is a great way to make self-checking assessments and reviews for students. See here: https://t.co/hrB35Kqpo8 #ditchbook #GoogleEDU pic.twitter.com/z51Tr30BRa
— Eric Curts (@ericcurts) May 10, 2019
Want to get in on the next #DitchBook Twitter chat?
Having trouble? Still unclear on how a Twitter chat works? Feel free to tweet to these #DitchBook ambassadors and they’ll help — Karly Moura @karlymoura, Sean Fahey @seanjfahey, Sandy Otto @sandyrotto, Rachel Marker @rachelmarker, Evan Mosier @emosier3, Mandi Tolen @TTmomTT, Craig Klement @craigklement, Tara Martin @taramartinedu, Krista Harmsworth @zonie71, Anne Kamper @annekamper, Rayna Freedman @rlfreedm, Lance McClard @drmcclard, Stephanie DeMichele @sdemichele or David Platt @herrplatt!
For notifications of new Ditch That Textbook content and helpful links:
Interested in having Matt present at your event or school? Contact him by e-mail!
Matt is scheduled to present at the following upcoming events:
[getnoticed-event-table scope=”upcoming” max=”15″ expanding=”false”]
Session expired
Please log in again. The login page will open in a new tab. After logging in you can close it and return to this page.
[…] Here are 10 Google Sheets tricks you (probably) don't know about […]