104 Google Sheet Tutorials

💡

An exclusive library of Google Sheet Tutorials

🚀
Efficient: Automation techniques to supercharge your workflow and automate repetitive tasks.
🎯
Precise: Ensure your data is always accurate and your analysis is clear.
🌈
Creative: Discover new ways to use Google Sheets.
Can't Find a Video?: Members can reach out and ask me anything!

How to Make an AI Integrated Freebie Spreadsheet

How to Make an AI Integrated Freebie Spreadsheet

Better Numbers and Bullet Points in Your Spreadsheets

Better Numbers and Bullet Points in Your Spreadsheets

Improve Google Sheets Readability
Improve the readability of your spreadsheets and supercharge your productivity with our top tips for better numbering and bullet points in Google Sheets.

Create Visually Appealing Sheets
Discover how to create clear, concise, and visually appealing spreadsheets that engage your audience and get results! Make your lists spicy hot with numbering and bullet points. Learn how to execute this to make your sheets look better.

Understanding the Importance of Readability in Spreadsheets Readability is crucial when it comes to spreadsheets. It refers to how easy it is for your audience to read and understand the data you are presenting. If your spreadsheet is cluttered, confusing, and hard to read, your audience will quickly lose interest and may not be able to make informed decisions based on the data you are presenting.

The Benefits of Using Bullet Points and Numbering in Spreadsheets
Using bullet points and numbering in spreadsheets can help to improve readability by breaking down complex information into more manageable pieces. Here are some of the benefits of using these features:
  • Bullet points and numbering help to organize information in a logical and easy-to-follow way
  • They make it easier to scan and find important information quickly
  • They can help to emphasize key points and make them stand out from the rest of the data 
  • They make your spreadsheet look more visually appealing and professional
Spreadsheet Automation 101 Lesson 1: Spreadsheet Taxonomy

Spreadsheet Automation 101 Lesson 1: Spreadsheet Taxonomy

Learn about the strategy and concept of the SpreadsheetApp. Understand rows, columns, and cells better.
Sheet Improvement: Electric Vehicle Stock Tracker by evuniverse.io

Sheet Improvement: Electric Vehicle Stock Tracker by evuniverse.io

An epic sheet improved in under one hour. Watch this video to see me revamp a Google Sheet and Take it to the Next Level!  Discover the Secrets to Improving this EV Universe Sheet, Including Customized Colors, Easy Navigation and Valuable Updates. 
Sheet Improvement: Better Business Idea Selection Framework

Sheet Improvement: Better Business Idea Selection Framework

Got this template directly from AppSumo and improved upon it.
Sheet Improvement: Better Band Bureau Better Schedule

Sheet Improvement: Better Band Bureau Better Schedule

A few tips: Delete extra columns and rows to improve readability, change the colors and fonts to incorporate branding, and adjust the sheet to promote the Better Band Bureau podcast more.
4 Ways to Make a New Spreadsheet

4 Ways to Make a New Spreadsheet

Here's four ways to make a new sheet. There's lots of reasons why you wanna know all of them. Makes you a more flexible, faster spreadsheeter.
Spreadsheet Automation 101: Introduction to Pre-course Videos

Spreadsheet Automation 101: Introduction to Pre-course Videos

Learn how to automate spreadsheets with Apps Script. The pre-course videos equip you with the fundamentals of coding before you start.
Spreadsheet Automation 101 Lesson 1: onOpen() Trigger - Custom Menu

Spreadsheet Automation 101 Lesson 1: onOpen() Trigger - Custom Menu

This lesson will get you started on your first trigger. It’s the first real spreadsheet automation you can do. Fun stuff!
Spreadsheet Automation 101 Lesson 2: onEdit() Trigger

Spreadsheet Automation 101 Lesson 2: onEdit() Trigger

One of the things to learn: We can only have one onEdit() in our entire spreadsheet file. I’ll also walk you through on how you can use Event and Logger to get cool information.
Job Application Tracker Template | From TheLandOfRandom - Sheet Improvement!

Job Application Tracker Template | From TheLandOfRandom - Sheet Improvement!

Turning a drab sheet into a fab sheet. Transform your job search with this amazing job application tracker template! Get it now from the Land of Random newsletter and streamline your job hunt.
How To Improve: 1,000 Business ideas: Business Idea Generator

How To Improve: 1,000 Business ideas: Business Idea Generator

Revolutionize Your Business Ideas with This Simple Template - Get Inspired in Minutes! 
Pabbly Connect Countdown - "Sheet Improvement!"

Pabbly Connect Countdown - "Sheet Improvement!"

Create a countdown timer inside of a google sheet. Unlock the secret to a lifetime deal... TIMEI! Discover their amazing live Google sheet and join the countdown to their exclusive offer. Watch as we recreate and enhance their sheet with stunning colors. Don't miss out on this epic journey. Click now!
Create a new Spreadsheet from just a Name in a Sheet.

Create a new Spreadsheet from just a Name in a Sheet.

Create the Apps Script to create a new sheet from some data inside your sheet. Script included in the sheet below.
Adding a Foodcourt to Doc's Virtual Mall | Sheet Improvement!

Adding a Foodcourt to Doc's Virtual Mall | Sheet Improvement!

A fun way to make a sheet look like a mall.
Escape Spreadsheet Hell A Mini Game

Escape Spreadsheet Hell A Mini Game

Spreadsheet Automation 101: Functions

Spreadsheet Automation 101: Functions

Get introduced to Apps Script functions and functions syntax. Learn how to write new functions, how to name functions and call functions from your sheet.
Spreadsheet Automation 101: Variables

Spreadsheet Automation 101: Variables

Dive deeper into the world of variables. Learn what variables do. Learn how to assign information to variables.
Spreadsheet Automation 101: Dot Notation

Spreadsheet Automation 101: Dot Notation

Learn how Dot Notation allows you to go deeper into the functions.
Spreadsheet Automation 101: Camel Case

Spreadsheet Automation 101: Camel Case

Learn the importance of camel case. Camel Case is a simple technique that involves capitalizing the first letter of each word in a text string, except for the first word. This creates a consistent and easily readable format for text that may be used in formulas, labels, or other applications.

Displaying items 1-20 of 104 in total