Support The Channel

This channel is not associated with Google or Microsoft.

Second Channel

Sign up to get updates, practice files and code snippets

New to Google Sheets?

Start Here

Google Sheets for Beginners

Follow along using the following spreadsheets (Click File->Make a Copy):

Link 1

Link 2

Link 3

Link 4

LOOKUP Functions in Google Sheets

VLOOKUP, INDEX & MATCH

VLOOKUP A to Z

How to do INDEX & MATCH?

Follow along using the spreadsheet below

Spreadsheet Link

Apps Script Tutorials

Learn how to automate Google Sheets using JavaScript

Apps Scripts Series 1

Start with Apps Scripts here. 21 video tutorials about Google Apps Scripts, Google Sheets & Google Drive.

Apps Scripts Series 2 – Intermediate

Array & JavaScript Array Methods

Discover the power of using JavaScript arrays and learn all important & useful array methods.