Spreadsheet fundamentals
Core Google Sheets skills: formulas, formatting, charts, and everyday workflows
How to Embed a Single Tab in a Website
Learn how to embed a single tab from a Google Sheet into your website, allowing you to share specific data without exposing the entire spreadsheet. This tutorial guides you through the process step-by-step, ensuring privacy and control over your shared information.
How to Embed a Spreadsheet in a Website
Learn how to embed a Google Sheet into your website instead of sharing it as a link, allowing for a seamless integration of your data. This video guides you through the steps of publishing your Google Sheet to the web and embedding it using an iframe.
Jump to Specific Cell Automatically
Learn how to automatically jump to a specific cell in your Google Sheets every time you open the document using a simple Apps Script function.
How to Convert Text to Lowercase Snake Case in Google Sheets
Learn how to convert text to lowercase snake case in Google Sheets using a simple formula that combines the LOWER and SUBSTITUTE functions.
How to Convert Text to Uppercase Snake Case in Google Sheets
Learn how to convert any text in Google Sheets to uppercase snake case by replacing spaces with underscores using the upper and substitute functions.
Don't Delete My Formulas
In this video, learn how to protect your formulas in Google Sheets from accidental deletion by using various techniques, including array formulas and Apps Script automation. Discover tips to ensure your formulas remain intact even when others attempt to modify them.
How to Add a CSV as a New Tab in Google Sheets
Learn how to easily add a CSV file as a new tab in Google Sheets, allowing for better organization of your data without creating a new spreadsheet.
How to Append a CSV in Google Sheets
Learn how to easily append a CSV file to an existing Google Sheets document, ensuring your data is seamlessly integrated without losing any existing information.
How to Import a CSV in Google Sheets
Learn how to easily import a CSV file into Google Sheets, whether it's from your Google Drive or your local storage. This video covers various import options to help you manage your data effectively.
How to Copy a URL to Share a Google Sheet
Learn how to easily copy a URL to share your Google Sheet with others, whether you've already shared it or are doing so for the first time.
How to Insert Dates #googlesheets
Learn how to easily insert dates in Google Sheets using the date picker feature and data validation rules. This video guides you through setting up a date picker for your spreadsheet.
How to Edit Spreadsheet Name in Google Sheets Android
Learn how to easily rename a Google Sheet on your Android device with this quick tutorial. Follow the simple steps to update your spreadsheet name and see the changes reflected in your Google Drive.
How to Rename a Tab in Google Sheets
Learn how to easily rename a tab in Google Sheets with multiple methods, including double-clicking the tab name and using the File menu. Be aware of the 100-character limit for tab names to avoid errors.
Create Custom Functions in Google Sheets
In this video, learn how to create custom functions in Google Sheets using Google Apps Script, specifically focusing on building a CPM calculator. This tutorial demonstrates how to streamline calculations and enhance the functionality of your spreadsheets.
Resctrict Access to a Cell
Learn how to restrict access to a cell in Google Sheets based on the value of another cell, ensuring users fill in required information before proceeding.