Tags

Formulas

167Google 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

I built a subreddit search tool to keep track of subreddits with keywords and interesting conversations.
Add a button to go to another sheet inside your sheet.
Simple automations you can add you to your CRM to keep it clean and looking great.
Create automatic triggers that close a form after a certain number of responses.
Create a few simple automations like email notifications and low stock alerts.
Use the Open AI API and Dall-e-3 to create image in Sheets
Create your own "Add Columns" button just like the add rows to the bottom.
Learn how to automate creating a template and moving the tab to the far right, or the end of the google sheets tabs.
You should know the difference between Data Validation and Data Veracity (or truthfulness of data)
This video points out some incredibly simple concepts of Data Validation you may want to use in your Google Sheets to make your data analysis better.
Without having to create two functions and two triggers you can combine two email sends into one function.
Learn how to harness Google Sheets' new multi-select dropdown feature in this tutorial. We'll guide you through setting up dropdowns that allow multiple selections, using search and filter formulas to analyze and display data efficiently. By the end, you'll be able to create dynamic reports and dashboards, streamlining your workflow and enhancing data management. Perfect for those looking to get the most out of Google Sheets' latest functionality!
Learn how to calculate BMI and create a custom BMI formula in Google Sheets! In this video, you'll explore the basic formula for BMI using weight and height, then dive into Google Apps Script to create a native BMI function. Perfect for anyone looking to enhance their spreadsheet with custom functionality.
Walk through creating an awesome automatic word count tracker that's easy to use and motivates the writer to keep going. With AI generated quotes from famous writers, along with simple formulas to generate states along the way.
Get Kanye Quotes, Hogwarts Houses, Public Holidays, and more fun with API's in this 1 hour dive into Free APis available online and accessible in Google Sheets. 
API's here: freepublicapis.com
10x your expertise driven content. Create new sections and fun additions to your own content. Make your writing more engaging and more educational.
I've created simple automations to make an awesome automatic task list. Add a checkbox when adding a task. Add a timestamp when done. Also emailing every day the top task.
Change the title of a spreadsheet from within a cell in the spreadsheet.
Submit email from a Google Sites to Google Sheets with this easy to embed html form instead of using Google Forms.

Displaying items 1-20 of 167 in total