- 751
- 709 046
Better Sheets
United States
Приєднався 3 кві 2020
Tools, Templates, and Tutorials for Google Sheets Users!
Helping you excel in Google Sheets, for all time.
👩💻 TUTORIALS
Unlock the full potential of Google Sheets with our expert guidance and step-by-step tutorials. Whether you're a beginner or an advanced user, we have something for everyone. If you use spreadsheets, we've got you covered.
🖼️ TEMPLATES
Explore our collection of free templates at free.bettersheets.co
Designed to streamline your workflow and save you valuable time.
⚙️ TOOLS
Enhance your Google Sheets experience with our free add-ons. Powerful tools extend the functionality of Google Sheets, allowing you to automate tasks, generate better designs, and perform complex calculations effortlessly ( like Spintax). Sell sheets with OnlySheets and market them better with Coupon Code Maker.
Ready to take your spreadsheet skills to the next level? Visit us at Bettersheets.co to learn more and access our wealth of resources. Empowering you to succeed!
Helping you excel in Google Sheets, for all time.
👩💻 TUTORIALS
Unlock the full potential of Google Sheets with our expert guidance and step-by-step tutorials. Whether you're a beginner or an advanced user, we have something for everyone. If you use spreadsheets, we've got you covered.
🖼️ TEMPLATES
Explore our collection of free templates at free.bettersheets.co
Designed to streamline your workflow and save you valuable time.
⚙️ TOOLS
Enhance your Google Sheets experience with our free add-ons. Powerful tools extend the functionality of Google Sheets, allowing you to automate tasks, generate better designs, and perform complex calculations effortlessly ( like Spintax). Sell sheets with OnlySheets and market them better with Coupon Code Maker.
Ready to take your spreadsheet skills to the next level? Visit us at Bettersheets.co to learn more and access our wealth of resources. Empowering you to succeed!
How Many Days Has it Been Since My Last Birthday?
Calculate Days Since Any Birthday with Google Sheets
Learn how to use the date diff function in Google Sheets to calculate the number of days since any birthday. This tutorial explains how to set start and end dates, use different units like 'd' and 'yd', and automatically update the calculation daily. Find out how to determine days since the last birthday and get more tips to enhance your Google Sheets skills. Subscribe to BetterSheets on UA-cam for more tips and tricks.
00:00 Introduction to Date Calculations
00:09 Using Date Diff Formula
00:24 Understanding Units in Date Diff
00:44 Practical Application of Date Diff
00:51 Subscribe for More Tips
Learn how to use the date diff function in Google Sheets to calculate the number of days since any birthday. This tutorial explains how to set start and end dates, use different units like 'd' and 'yd', and automatically update the calculation daily. Find out how to determine days since the last birthday and get more tips to enhance your Google Sheets skills. Subscribe to BetterSheets on UA-cam for more tips and tricks.
00:00 Introduction to Date Calculations
00:09 Using Date Diff Formula
00:24 Understanding Units in Date Diff
00:44 Practical Application of Date Diff
00:51 Subscribe for More Tips
Переглядів: 1
Відео
How Many Days Old Are You?
5 годин тому
In this episode, learn how to calculate your age in days using the DATEDIF function in Google Sheets. Follow along as we select a birthday as the start date and use today's date as the end date, focusing on days instead of years to get a precise age calculation. 00:00 Introduction: Age is Just a Number 00:03 Calculating Days Old 00:05 Using Date Diff Function 00:06 Setting Dates for Calculation...
Your Age in Months | Get in Google Sheets
Переглядів 15 годин тому
Calculate Your Age in Months Using Google Sheets Forget calculating age in years! Learn how to find out your age in months using Google Sheets. This tutorial shows you how to use the date diff function with your birthday and today's date to calculate your age in months. 00:00 Introduction to Age Calculation 00:02 Calculating Age in Months 00:05 Using Date Diff Function 00:17 Understanding the O...
Find Out Anyone's Age
Переглядів 25 годин тому
Learn how to calculate anyone's age in Google Sheets by using the DateDif function. This step-by-step guide demonstrates how to enter the start date (birthday) and the end date (today) to get the age in years. 00:00 Introduction to Finding Age 00:01 Using DateDif Function 00:03 Calculating Age with DateDif
How to Get Name of Last Month in Google Sheets
Переглядів 819 годин тому
How to Display Last Month's Name in Google Sheets Learn how to display the name of last month in a cell using Google Sheets. This tutorial will guide you step by step through using the EOMONTH function and text formatting to achieve this. Follow along for more Google Sheets tips and tricks on Better Sheets. 00:00 Introduction to Getting Last Month's Name 00:08 Understanding the TODAY Formula 00...
How to Get This Month's Name in Google Sheets
Переглядів 4622 години тому
How to Auto-update Month Names in Google Sheets Using EOMONTH Formula In this tutorial, you will learn how to automatically update the name of the month in a cell based on today's date using Google Sheets. The video explains common mistakes and how to fix them by replacing the MONTH formula with the EOMONTH formula. Subscribe for more tips and tricks on Google Sheets at ua-cam.com/users/BetterS...
How to Sort Google Sheets
Переглядів 332 години тому
Mastering Google Sheets: Advanced Sorting Techniques In this video, you'll learn various sorting techniques in Google Sheets. The tutorial emphasizes the importance of freezing the first row to keep the header intact during sorting. It covers sorting entire sheets and specific ranges alphabetically or numerically, and demonstrates advanced options using the 'Sort Range' feature. The video also ...
Filter Doesn't Work with Allow Multiple Selections How to Fix it!
Переглядів 242 години тому
Fixing the 'Allow Multiple Selections' Feature in Google Sheets In this video, we tackle the new 'Allow Multiple Selections' feature in Google Sheets, explaining its benefits and a particular issue with the filter function in the menu. The video demonstrates a workaround using the filter and search functions, providing a solution to view all instances where a committee member, like Bart, is lis...
How to Automate Raffle Draws with Google Sheets
Переглядів 492 години тому
How to Automate Raffle Draws with Google Sheets In this episode, we explore an innovative way to conduct a raffle using Google Sheets. Instead of the traditional method, we demonstrate how to set up a system where each participant can have multiple entries based on their tickets. We'll break down a unique formula that updates dynamically every time there's an edit, ensuring real-time changes ar...
How To Get Last Name with Middle Names in Google Sheets
Переглядів 534 години тому
Automatically Extract Last Names in Google Sheets In this tutorial, learn how to resolve the error when extracting the last name from a full name containing a middle name using an index split formula in Google Sheets. The video demonstrates a semi-manual approach and introduces a programmatic solution using a count-a formula to adjust the position based on the number of name components. Enhance...
How To Alphabetize by Last Name in Google Sheets
Переглядів 264 години тому
Sort by Last Name in Google Sheets: Step-by-Step Tutorial This video demonstrates how to alphabetize a list of full names in Google Sheets by the last name. It involves adding a column, using the SPLIT function to separate first and last names, and then applying the INDEX function to isolate last names. The tutorial concludes with sorting the sheet alphabetically by last names using Google Shee...
How To Alphabetize Google Sheets
Переглядів 194 години тому
How to Alphabetize Names in Google Sheets This video tutorial guides viewers through the steps of sorting names in Google Sheets in alphabetical order. The process involves selecting the relevant column, using the sort feature, and addressing common errors like sorting headers. It demonstrates how to freeze the header row to exclude it from sorting and covers sorting options such as A to Z and ...
Combine Filters In One Column in Google Sheets
Переглядів 1039 годин тому
Google Sheets Advanced Filtering: Creating Dynamic Sales Summaries In this tutorial, we demonstrate how to create a dynamic sales summary in Google Sheets using advanced filtering techniques. Learn how to combine two filters to display sales data by salesman and month, adapt filters using cell references, and concatenate results for clearer reporting. This step-by-step guide will help you gener...
How to Quickly Add Approval Dropdown Chip
Переглядів 4312 годин тому
How to Quickly Add Approval Dropdown Chip
How to Quickly Add Status Dropdown Chip
Переглядів 4412 годин тому
How to Quickly Add Status Dropdown Chip
How to FILTER the Multi Select Dropdown Feature in Google Sheets
Переглядів 10912 годин тому
How to FILTER the Multi Select Dropdown Feature in Google Sheets
How to Quickly Add Yes/No Dropdown Chip
Переглядів 6312 годин тому
How to Quickly Add Yes/No Dropdown Chip
How to add Pennies Places to Currency in Google Sheets
Переглядів 2214 годин тому
How to add Pennies Places to Currency in Google Sheets
How to Group by Drop Down Menu in Google Sheets
Переглядів 7014 годин тому
How to Group by Drop Down Menu in Google Sheets
How to Remove Pennies from Currency Values in Google Sheets
Переглядів 3016 годин тому
How to Remove Pennies from Currency Values in Google Sheets
How to Customize Currency Formats in Google Sheets
Переглядів 2916 годин тому
How to Customize Currency Formats in Google Sheets
How to Change Format Currency Settings
Переглядів 1516 годин тому
How to Change Format Currency Settings
How to Change Dropdown Chips to Plain Text get rid of rounded corners
Переглядів 8719 годин тому
How to Change Dropdown Chips to Plain Text get rid of rounded corners
Build a Startup Pitch Generator in Google Sheets
Переглядів 7719 годин тому
Build a Startup Pitch Generator in Google Sheets
Auto-Reformat Pasted Cells in Google Sheets with this App Script Trick
Переглядів 119День тому
Auto-Reformat Pasted Cells in Google Sheets with this App Script Trick
Create a Spooky Halloween Movie Marathon Poster with Google Sheets and OMDB API
Переглядів 69День тому
Create a Spooky Halloween Movie Marathon Poster with Google Sheets and OMDB API
How to Get Alerts When Someone Has Edited My Google Sheet
Переглядів 21114 днів тому
How to Get Alerts When Someone Has Edited My Google Sheet