Here are a series of 1-minute tutorials to learn a new skill or to help you suggest new ways to use Google Sheets to help you organize your data.
Learn how to make cells "come alive" by changing their background colors based on the data in the cells.
Like to be lazy? Learn how to use the Magic Corner to fill down a column or across row. I guarantee you will never have to learn how to spell "Wednesday" again!
Don't enjoy long division? When you call someone Mean do you think they are Average? Here is a quick introduction to the most common functions. Once you learn a few, you will think of more creative ways to give value to your student data.
Want even less work for math? Some common equations are built right into Google Sheets. It can can even help you make a chart, which makes you look cool!
Learn to combine your love of functions and Magic Corners to make Google Sheets work for you! You will also see $$ in your future, but not for the reasons you think. Watch and find out.
Do you get student lists from PowerSchool where you need to combine first and last names into one cell? You never think this will happen to you.... It is easy to "add words" once you know the secret. Watch the video to find out how.
Has this happened to you? You get first and last names together but you want to sort it by last name? Learn how to use the most awkward sounding menu item Split Text to Columns to good use. You will also learn how to Paste Values like a superhero.
You NEVER want to play with your Form data while it is still live. Let me show you how to get started with the =query function. Query allows you to duplicate your live data and still filter, sort, change the order and so much more! This is one of my favorite tools when working with a large spreadsheet
Do you need to sort by 2 fields, such as Homeroom and then by Last Name? This menu item moved locations recently. Find out where it went and use it to help organize your data. Filtering helps you hide the data you don't need to see.
Is sheets hiding some of your data? See how a simple double-click can clear up any confusion. In addition, learn how to turn on Word Wrap so you can read longer responses with ease!
Is imitation the greatest form of flattery? Learn 3 different ways to use the Format Painter tool (Paint Format) to copy/paste your favorite formats to cells that already contain data: 1st: Basic, 2nd: Non-sequential cells, 3rd: Copy multiple formats AT THE SAME TIME!
Who decided you need 26 columns and 1000 rows? Is it just too "busy" for you? If so, it is very easy to delete all the columns and rows. You just need a "Shift" in your thinking! You can also add columns and rows too, but it is not as much fun as deleting.
Historically, the option to print spreadsheets was an added feature. It can be quite frustrating. Here are a few hidden options that might lower your stress level when printing. Learn how to print just parts of your document and how to force page-breaks where YOU want them.
It is quite common to have to import data from a different program. Once you know how to set it up in Google. It is smooth (data) sailing.
Do you need a color-coded dropdown? This new feature now only takes 1 step instead of 2. Stay organized and be more efficient at the same time!
If you use Google Forms for student scores and assessments, then VLOOKUP might be the right tool for you. It can match by student name and copy the scores that match. Learn what it can do and then think of other ways this might save you time and stress. Sorry it is longer than a minute.