Spreadsheet fundamentals

Build a Job Status Checker API in 15 Minutes

In this video, learn how to build a Job Status Checker API using Google Sheets and Apps Script in just 15 minutes. This tutorial demonstrates how to create a web app that allows users to check job statuses securely without exposing the entire spreadsheet.

How do I prevent people from sharing my spreadsheets by making a copy?

In this video, Andrew shares effective strategies to prevent unauthorized sharing of your Google Sheets by making copies, including mindset shifts and the use of a specialized tool called Only Sheets.

Turn Headlines up to 11! [Update to Spintax Tool]

Discover how to enhance your headlines using the updated Spintax tool in Google Sheets, allowing you to generate multiple variations effortlessly. This video showcases the powerful features of Spintax, including the new spin generate function that utilizes OpenAI's API.

Formula Parse Error Explained

Learn how to troubleshoot and fix formula parse errors in Google Sheets, including common mistakes like missing commas and quotation marks.

Create a Branded Lead Magnet from Qualitative Data

In this video, learn how to enhance a Google Sheet lead magnet created from qualitative data by adding branding elements, analyzing call-to-action lengths, and improving usability for sharing. Discover tips on making your sheets more appealing and functional.

Do you start in A1?

Discover a handy Google Sheets add-on that helps you eliminate unnecessary rows and columns, allowing for a cleaner and more organized data presentation. Perfect for those who prefer starting their sheets in A1 without any padding.

This One Thing Makes It Easy to Work in Spreadsheets

In this video, Andrew from Better Sheets shares how lowering contrast in spreadsheets can significantly enhance usability and reduce eye strain, showcasing his free tool, Sheet Styles, which simplifies this process.

NEWS- Google Sheets' New Feature!! #googlesheets

Discover the new rating feature in Google Sheets that allows you to easily add star ratings directly in your cells. This video demonstrates how to utilize this feature for better data visualization and summation.

What is this Ampersand Doing in Google Sheets

In this video, we explore the unique role of the ampersand in Google Sheets, particularly in relation to date calculations and concatenation. Discover how this seemingly simple character can lead to interesting insights when working with months and dates in your spreadsheets.

Bet You Didn't Know This Google Sheets Trick: Numbering Tasks

Discover a handy Google Sheets trick for numbering tasks efficiently, including how to quickly fill in sequences without dragging. This video reveals shortcuts that can save you time and effort in your spreadsheet tasks.

Increase Productivity with Happiness

Discover how to enhance your productivity in Google Sheets with a simple add-on that improves visual comfort and data readability. Learn about the Sheet Styles add-on and its features for a better spreadsheet experience.

Task Counter

Learn how to effectively track your tasks in Google Sheets using formulas to count completed tasks versus total tasks. This video breaks down the process step-by-step for better task management.

Coffee Cash #googlesheets

In this video, discover how years of coding Google Sheets can turn your coffee passion into profit. Learn tips on selling your Google Sheets creations for cash.

PRINT your Free Yearly Planner in Google Sheets

Learn how to print your free yearly planner in Google Sheets, including tips on downloading in various formats for the best results. Make 2024 your best year yet with this customizable planner.

BIG YEAR - Free Google Sheets Yearly Planner Template

Discover the 'Big Year' free Google Sheets template designed to help you plan your entire year with ease. This comprehensive tool includes daily checkboxes and multiple layouts to suit your planning style.

Santa Screwed Up

In this festive video, Santa faces a challenge with his naughty and nice list, but with the help of a spreadsheet and an app script, he manages to write 'Nice' for thousands of kids in no time.

One Weird Trick with Curly Brackets

Discover a unique method to streamline your Google Sheets by using curly brackets in the header for array formulas, enhancing data management without altering output.

Validate 1,000 Emails a Month for Free

Learn how to validate up to 1,000 emails a month for free using a Google Sheets API and custom Apps Scripts. This video guides you through the process of setting up email validation with practical examples.

Brighten Up Your Checklist Automatically

Learn how to automatically brighten up your checklist in Google Sheets using Apps Script. This video guides you through the process of modifying background colors based on RGB values triggered by edits in your sheet.

Counting Stars QUICKLY

Learn how to quickly count star ratings in Google Sheets using VLOOKUP and dropdown menus. This tutorial simplifies the process of converting star ratings into numerical values for better data analysis.

Make a Self Checking Checklist

Learn how to create a self-checking checklist in Google Sheets using App Script, allowing your checkboxes to be automatically checked at set intervals.

ChatGPT Clone in Google Sheets Part 2

In this second part of the ChatGPT Clone in Google Sheets tutorial, learn how to enhance your chat interface by labeling human and AI responses, creating multiple chat sessions, and managing chat history effectively.

Gamify Studying

Learn how to gamify your study sessions by effectively tracking and summing your study times in a spreadsheet, avoiding common pitfalls like negative time values.

IMDB of Google Sheet Formulas

Discover the ultimate IMDb for Google Sheet formulas at Better Sheets, where you can find detailed descriptions, misconceptions, and instructional videos for every formula, including FILTER, SUMIF, and VLOOKUP.