Over a Decade of Serious Learning
for Ambitious Minds.
* 9.3 of 10 (over 13 k student survey results - 2015)
1-877-760-0078
Request a quote

Find A
Class in Your City:

Google Sheets Introduction Fundamentals
Email this page | Print this page

Google Sheets Introduction / Fundamentals (G Suite)

 

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