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”)