In this lesson, we discuss some super useful shortcuts that will help you be much more efficient when working with data in Google Sheets. For a complete list of shortcuts available in Google Sheets, click Ctrl + / (on a PC) or ⌘ + / (on a Mac).

The raw dataset for this data cleaning exercise can be accessed here (will make a copy on your Drive):

Lesson 6 Data Cleaning Sheet