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: Formatting a Worksheet
Topic A: Apply Text Formats
Topic B: Apply Number Formats
Topic C: Align Cell Contents
Topic D: Apply Styles
Topic E: Adding Borders and Colors
Topic F: Apply Basic Conditional Formatting
Topic G: Create and Use Templates
Lesson 2: Printing Spreadsheets
Topic A: Preview and Print a Spreadsheet
Topic B: Set Up the Page Layout
Lesson 3: Managing Workbooks
Topic A: Manage Sheets
Topic B: Manage Workbook and Sheet Views
Topic C: Manage Workbook Properties