All classes are taught LIVE by seasoned instructors. * 9.6 of 10 (over 22 k student survey results - 2023)

Find A Class in Your City:


Google Sheets Intermediate

Email this page | Print this page

Google Sheets Intermediate (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 Intermediate

 

·         Customize and enhancing environment with Dashboard in Google Sheets

·         Calculating Data with Advanced Formulas

o   Use Specialized Functions

o   Analyze Data

·         Analyzing Data Using PivotTables with Google Sheets

·         Organizing Sheet and Table Data

·         Use Functions to Calculate Data

·         Presenting Data Using Charts and Objects

·         Google Forms – Tips/tricks (more advanced)

·         Q/A for Advanced Formulas, Macros, What/If

·         Q/A for customizing Dashboard

·         Q/A for Mobile Sheets

·         Google Sheets and Add-Ons

o   Data Gathering

o   Sharing/Publishing

o   Build your own Add-ons

o   Working offline with Google Sheets

·         Apps Scripts – An introduction

o   Building your first script

o   Editing current app scripts

o   Other uses of Google’s app scripts