Google Sheets: Basics

3 sessions of 2.5 hours each

This course is appropriate for Mac, PC, Chromebook, and Tablets users.

Google provides a complete suite of FREE Apps for spreadsheets, word processing, email, calendars and more. This three-lesson class will show you how to use the Google Sheets app to create and format spreadsheets. Learn how to track your expenses, keep stats on your favorite team, cost out a planned trip, produce an invoice; it’s all possible using Google Sheets.  The class is designed for those who are entirely new to spreadsheets, those who have started to use Sheets but want to master more of its capabilities, and those who want to migrate from another spreadsheet program. 

Lesson 1 – Getting Started and Navigating

● Purpose of spreadsheets and what they can do for you. ● Launching the program and understanding the menu structure, basic tools and commands.  ● The Sheets “neighborhood” – rows, columns, cells, worksheets and workbooks.  ● Entering text, numbers and simple formulas.  ● Saving your work.

Lesson 2 – Moving Ahead

● Inserting, deleting, and resizing rows and columns.  ● More on formulas – relative and absolute cell addresses. ● Freezing panes to work in larger worksheets.  ● Working with ranges of cells. ● Making your worksheet more readable and attractive with type fonts and cell formatting.● Saving time with copying, pasting and formatting tools and features.

Lesson 3 – Using Key Features and Printing

● Using shapes and pictures in your worksheet. ● Working with dates and date arithmetic to keep track of a schedule.● Using conditional formatting to make selected items stand out.  ● Automatic tables and power tools for sorting and selecting data.  ● Locking cells to protect against errors. ● Page layout, previewing and printing your worksheets and workbooks. ● Google Drive and managing files ● Document sharing and collaboration

The SeniorNet Advantage

● Hands-on instruction	● Individual attention	● One student per computer
● Manuals included	● Friendly atmosphere	● Seniors teaching seniors