Andrew Kamphey

Google Sheets wizard at BetterSheets.co

Mastering the Art of Template Creation

Mastering the Art of Template Creation

An Exclusive Interview with Becky, Owner of The Template Nook 📺Watch the entire 1 hour interview on YouTube In our latest edition of "Sheet Talking," we dove deep into the world of templates and organization with Becky, the owner of The Template Nook. Becky's unique approach

Philippines Phone Number Validation: Use of REGEXMATCH in Google Sheets

Every school year thousands of students and teachers’ data were being added to the school database. As someone who was always given the task to narrow down lots of information after the school enrollment, validating students’ data manually is very exhausting. Take this as an example, when you ask students

How to reference a different Google Spreadsheet in Apps Script?

How to reference a different Google Spreadsheet in Apps Script?

Transferring Data Between Cells in Different Spreadsheets

One Simple Google Sheets Hack for Better Header Fonts

One Simple Google Sheets Hack for Better Header Fonts

If you don’t want your spreadsheet to look dull and unprofessional, there’s one trick to make it stand out.

The Double-Edged Sword of Google Sheets Formulas: A Journey Through Frustration and Triumph

The Double-Edged Sword of Google Sheets Formulas: A Journey Through Frustration and Triumph

A misplaced comma, an incorrect range, or a simple syntax error can render a formula ineffective, leading to hours of troubleshooting. Formula Parse Error, anyone?

Generate Variations of Headlines EASILY in Spreadsheets (with Spintax)

Generate Variations of Headlines EASILY in Spreadsheets (with Spintax)

You can now create headline variations and permutations super easily with Spintax. And do it in spreadsheets. More info on Spintax: https://spintax.bettersheets.co/ I just updated the Spintax tool to be able to generate spintax as well as parse it: What is Spintax? Spintax, or spin syntax, is

A Decade of Spreadsheet Wisdom

A Decade of Spreadsheet Wisdom

10 years ago Timber was the #1 song... and I was coding in spreadsheets then, just as I am now. Learn from my decade of experience.

Better Sheets

Something for everyone to Learn Google Sheets. Includes Google Sheets for Beginners and Advanced Google Sheets Tutorials alike.

Google Sheets Help

Google Sheets Courses

Google Sheet Templates and Tools

Google Sheet Add Ons