To View Class Dates: Please use the pull down options on the upper left of this page to select your course and city. (All Adobe public classes are limited to 5 students - small, focused training.) You can then navigate to other classes in that same city, view class descriptions and register for the class or you call us and register now, 877-760-0078.

• Training at your company site (group or 1on1) -- click here.

• We have taught thousands of business professionals throughout the years. Read what our students say

• Free repeats! You are allowed to repeat your class for free within 6 months for any reason whatsoever! Classes are 9am to 4pm and come with courseware and CD to practice afterward.

• Are you signing up for more classes? See our package discounts page

 

Course Description

Google Sheets Introduction / Fundamentals

Overview –

Google Sheets is a web-based spreadsheet application that allows you to create and edit spreadsheets online while collaborating with other users. Sheets have many features, including built-in formulas, charts and graphs, conditional formatting options, and pivot tables. Sheets is compatible with Microsoft Office Excel files.

Lesson 1: Creating a Basic Sheets Worksheet

·         Identify the Elements of the User Interface (Google Sheets Editor)

            --Toolbar options, navigating to other Google apps like Docs or Slides

            --Open File Picker to access other Google drive for other Sheets

·         Work with Cells, Enter Data

Lesson 2: Performing Calculations in Sheets

·         Create Basic Formulas

·         Calculate the Cell Values by Using Functions

·         Copy Formulas and Functions

Lesson 3: Modifying and Formatting a Sheets Worksheet

·         Manipulate / Sort Data

·         Modify the Worksheet Elements

·         Search for Data in a Worksheet

·         Modify Rows and Columns

·         Modifying Fonts, Borders, Colors, etc

Lesson 4: Collaboration in Sheets

·         Comments

·         Chat Window

Lesson 5: Printing Sheets Workbooks

·         Set the Page Layout Options

·         Set Page Breaks

·         Print a Workbook

Lesson 6: Table Data & Charts

·         Organizing Sheet and Table Data

·         Use Functions to Calculate Data

·         Presenting Data Using Charts and Objects

Lesson 7: Google Sheets Mobile App Basics

·         Sheets homepage, menu, editor