Mike Halliburton

+ 14

97Google Sheet Tutorials

Discover the Power of Productivity

An Exclusive Library of Google Sheet Tutorials!

Why Choose Our Google Sheet Tutorials?

🚀 Efficient:

Learn the best Google Sheets formulas and spreadsheet automation techniques to supercharge your workflow. Discover how to automate repetitive tasks effortlessly, saving you valuable time and effort.

🎯 Precise:

Master Google Sheets formulas to ensure your data is always accurate and up-to-date.

🔧 Automate Your Sheets

Delve into the world of Google Apps Script. Automate reporting. Automate your data. Automate your business

Form Automations: Close Multiple Forms When Over Limit

Adding to the Form Automations:
Allow User to Reopen form without Apps Script access
Set Limit in a Sheet, not in Apps Script
Set Limits for different Forms

Automate Form Response to Confirmation Email

Create an email automatically when someone fills out a google form. include a url that has a clickable confirmation link and a unique id.

Automate Help Desk Ticket Closing

Create a simple automated help desk ticketing system.

Create tickets
Closed dropdown
Calculate time to close
Create dashboard

How To Change Date Format Automatically

Create automations to change date format based on the format you want, inside your sheet.

Embed Email Form and Name Form into Website to Google Sheets

Add names to the Email2Sheet apps script and code.

What Sucks About Selling Spreadsheets And How to Solve These Problems

I go through a few of the darkest parts of selling spreadsheets and how you can fix them. I offer how to do updates that generate revenue and what marketplaces to sell on to avoid marketing into the void.

Add Tasks to Google Tasks From Google Sheets

Create tasks in Google Tasks from Google Sheets using Apps Script

Built a Cookie Clicker Clone in Google Sheets

I built a clone of Cookie Clicker, live on YouTube. Watch the full 1 hour live stream here.

In this video I update it a bit, and show off that it works!!

Learn how to build trigger builders and use user properties to store data you don't want a user to change (easily)

Pick a Raffle Winner with Number of Tickets

Pick a raffle winner if you only have the names and number of tickets. And do it in one cell.

Introducing Bigger Brain

10x your expertise driven content. Create new sections and fun additions to your own content. Make your writing more engaging and more educational.

Beginner Intermediate Advanced

Create New Worksheet When Google Form Submitted

Automate copying a template for new form submissions with user data inserted into the new sheet.

Better Email Form on Google Sites

Submit email from a Google Sites to Google Sheets with this easy to embed html form instead of using Google Forms.

Intermediate Advanced

How To Update Your Add-on

How to update your add-on when you update your code for fixes or add functionality.

Scoping Functions in Apps Script

Create multiple functions that run with the result of other functions.

Advanced Coding in Google Sheets for Programmers

Add a Custom Menu
Create Native-like Functions
Get URL and Sheet ID's via Apps Script
A Few things to know about Developing Google Sheet Add-ons

Intermediate Advanced

Google Sheets Easter Eggs Beyond PRIDE

Going beyond PRIDE, to show you some undocumented google sheets hacks that you might call "Easter Eggs"

Beginner Intermediate Advanced

How to Insert Multiple Rows in Google Sheets (Easy to Hard)

Learn how to add multiple rows to your google sheets by hand, and automatically.

Beginner Intermediate Advanced

Sync Tabs in Different Sections

How to sync different sections on different tabs. In this case we're taking data from multiple tabs putting into one, and syncing between those.

Sync Many Tabs without ImportRange()

Sync more than two tabs with Apps Script

Embed Quote and Author to Daily Quote Website

Step by step tutorial to update random quote site to show both Quote and Author separately. Example site: https://todayquote.carrd.co/

Quick tutorial to show you how to build a random quote site →Here

Displaying items 1-20 of 97 in total

Better Sheets

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

Get Started Now

Google Sheets Help

Google Sheets Courses

Google Sheet Templates and Tools

Google Sheet Add Ons