1. Freezing the Top Row
The top row of our spreadsheet tells us what is in column. We want to be able to always see this row even if we scroll down the page. To do this, we need to freeze the top row. Watch the video below to see how to do this.
2. Moving Columns
We need to move the first column, the timestamp information. Also, if you have a second column with email addresses, we don’t need that either. We want the first column on the sheet to be names of students. Watch the video below to see how to move columns around.
3. Wrap Text in the Top Row
Wrapping text allows you to see everything written in a cell. Use the video below to wrap the text in your top row.
4. Capitalize Words in a Cell
Now we want to make sure all names are capitalized. Watch the video below to see how to do this. The formula I write is: =proper()
5. Alphabetize the Data
Now we are going to use names to sort the data alphabetically.
6. Adding Heatmaps with Conditional Formatting
TYPE IN A WORD THAT IS IN THE COLUMN YOU USE, NOT “HAPPY” LIKE I DO.
7. Make a Copy of a Sheet
8. Rename a Sheet
9. How to Use Filters
10. Translate a Column of Text
Korean =googletranslate(c2, “en”, “ko”) or French =googletranslate(c2, “en”, “fr”)