Tags

Formulas

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

Pick a raffle winner if you only have the names and number of tickets. And do it in one cell.
Using the ampersand and ARRAYFORMULA to combine two filters into a single column.
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.
Made Ali Abdaal's study google sheet better.
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.
Now you can select multiple options in a dropdown. Hip Hip Hooray!
Some helpful tips on how to get someone to look at a particular cell in your sheet.
Find out how I use Apps Script built in features to code very quickly and efficiently. 
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.
How to prevent someone from deleting your formulas. Beyond protecting your range or sheet.
Change the title of a spreadsheet from within a cell in the spreadsheet.
Automate copying a template for new form submissions with user data inserted into the new sheet.
The reason is because a new form has a setting to only allow those in your domain to fill in the form. I show you in the settings page where to fix this.
Create an automation that goes directly to a cell you pick every time you open the spreadsheet file.
Submit email from a Google Sites to Google Sheets with this easy to embed html form instead of using Google Forms.
Copy text from one tab to another based on a checkbox being checked.
Create buttons on your Google Site to get an NPS, or Net Promoter Score directly to a Google Sheet.
Connect your published Google Site to Google Sheets with Apps Script and a Button.  Great to use for Voting, upvoting, NPS, or anything you want feedback on, at the click of a button from your Google site to a Google Sheet.

Displaying items 1-20 of 580 in total