This course is an introduction to the features of Google Sheets. It covers an overview of the Sheets interface, performing calculations, modifying a worksheet to present relevant data, print setup, and manipulating a workbook to better view the data.
Upon successful completion of this course, you will be able to create and develop Google Sheets spreadsheets to work with and analyze data.
This course is intended for students who wish to gain the foundational understanding of Google Sheets that is necessary to create and work with electronic spreadsheets.
To ensure success, students will need to be familiar with using computers and should have experience using a keyboard and mouse. Students should also have an active G Suite (Google) account.
Lesson 1: Getting Started with Google Sheets
Topic A: Navigate the Google Sheet User Interface
Topic B: Use Google Sheet Commands
Topic C: Create, Save, and Download a Basic Spread-sheet
Topic D: Spreadsheet Settings
Topic E: Enter Cell Data
Topic F: Use Google Sheets’ Help
Lesson 2: Performing Calculations
Topic A: Create Worksheet Formulas
Topic B: Insert Functions
Topic C: Reuse Formulas and Functions
Lesson 3: Modifying a Spreadsheet
Topic A: Insert, Delete, and Adjust Cells, Columns and Rows
Topic B: Search for and Replace Data
Topic C: Use Proofing Tools