1. Introduction

• Switching to Sheets from Microsoft Excel

• Access Sheets

2. Working with Excel Files

• Import Excel Data into Sheets

• Convert Excel Files to Sheets

• Edit Excel Files in Drive without Converting

• Convert Sheets Files to Excel or Other Formats

3. Basic Data Management 

• • Moving Rows and Columns

  • Adding or Removing Rows and Columns

  • Copying and Pasting Data

  • Find and Replace

  • Printing Spreadsheets

4. Organizing Worksheets 

• Group Rows or Columns

• Freeze Header Rows and Columns

5. Data Formatting 

• Format Data Types

• Add Descriptions to Columns

• Add Checkboxes to Cells

6. Data Preparation

• Filtering and Sorting Data

• Split Data into Columns

• Space Rows & Columns Evenly

• Swap Rows and Columns (Transpose)

• Remove Duplicate Data & Spaces

• Convert Data to Tables

• Data Validation 

7. Basic Functions 

• SUM

• AVERAGE

• COUNT / COUNTA

• MAX

• MIN

• ROUND

• IF

• TODAY

• NOW

• PROPER

• UPPER

• LOWER

• TRIM

• CONCAT / CONCATENATE

8. Sharing Files 

• Share Spreadsheets

• Restrict Data Sharing

9. Exporting Files 

• Download Files in Different Formats

• Make a Copy

• Email a Copy