learn google sheets spreadsheet training

  • 100% Hands-On, In Person Training
  • Led by a Google Sheets Power User/Google Apps Script Developer
  • The curriculum can be catered to your needs.
  • At your office, conference room.. you name it. Training at your location, at your convenience.
  • 100% Satisfaction Guaranteed
  • 100% Hands-On, In Person Training

On-Site Google Sheets Classes

Instant Online Estimate
Please Select The Difficulty

Introduction

Total trainig time: 3 Hours.
Learn how to build basics spreadsheets, write basic formulas, use SUM, AVERAGE functions. This class is best suited for those who have very little or no experience with Google Sheets.

Basic User

Total trainig time: 4 Hours.
Create better formulas with more complex cell referencing. Learn to lock cells, use mixed cell references, sort and filter data, text to columns, basic charts. Functions: SUMIF, SUMIFS, SUBTOTAL, COUNT, COUNTA.

Intermediate

Total trainig time: 4 Hours.
Pivot Tables, VLOOKUP, larger datasets, cleaning data, merge data, linking spreadsheets. Functions: VLOOKUP, IFERROR, IMPORTRANGE.

Advanced

Total trainig time: 5 Hours.
INDEX, MATCH, Logical Test, Text Manipulation, Date Calculations. Functions: INDEX, MATCH, IF, IFS, AND, OR, NETWORKDAYS, DATE, LEFT, REGEXEXTRACT and many other functions.

Advanced Level 2

Total trainig time: 5 Hours.
Array Calculations, ARRAYFORMULA, SUMPRODUCT, SPLIT, INDEX. Functions: SUMPRODUCT, TEXT, SEARCH, SUBSTITUTE.

Apps Script

Total trainig time: 10 Hours.
Learn how to change Google Sheets programmatically. Course covers: base JavaScript syntax. writing to Cells and Ranges, IF Then Else statement, simple For Loops, automatic row and column size adjustments.