Google Sheets

Posts || Courses & Projects || Links & References || Add-Ons || Tools

Posts

this google workspace dialog or sidebar isn't working help

Add the Current Date to a Sheet When Data Is Added So That The Date Does Not Change(Static) – Google Sheets (Updated July 2023)

Code,Google Apps Script,Google Sheets,Sheets,TriggersGoogle apps script,Google Sheets,javascript forEach,onEdit,Time

Four Digits to Time in Google Sheets with Google Apps Script

Google Apps Script – How to Automatically Generate a Time From a Four Digit 24 hour Time in Google Sheets.

Code,Google Sheets,Sheets,Triggersdata validation,Google apps script,Google Sheets,onEdit

Create a Dynamic Password Generator in Google Sheets

Google Sheets,Google Sheets Advanced,UncategorizedGoogle Sheets,Google Sheets Advanced,Google Sheets JOIN,Google Sheets LAMBDA,Google Sheets LEN,Google Sheets MAP,Google Sheets MID,Google Sheets RANDBETWEEN,Google Sheets SEQUENCE

Alphanumeric list in columns rows and cells in Google Sheets v3

5 ways to create an ordered alphanumeric list in Google Sheets

Google Sheets,Google Sheets Intermediate,UncategorizedGoogle Sheets ADDRESS,Google Sheets ARRAYFORMULA,Google Sheets BASE,Google Sheets CHAR,Google Sheets JOIN,Google Sheets LAMBDA,Google Sheets MAKEARRAY,Google Sheets MAP,Google Sheets REGEXEXTRACT,Google Sheets SEQUENCE,Google Sheets SPLIT,Google Sheets TRANSPOSE

Create links to the first item of each group in Google Sheets

Google Sheets,Google Sheets Intermediate,UncategorizedGoogle Sheets ARRAYFORMULA,Google Sheets HYPERLINK,Google Sheets IFNA,Google Sheets Intermediate,Google Sheets MATCH,Google Sheets Sort,Google Sheets UNIQUE

Adding Links to Images and Buttons in Google Sheets

Google Sheets,Google Sheets BasicsGoogle Sheets,Google Sheets HYPERLINK,Google Sheets IMAGE,Google Sheets Images

How to Easily Calculate Sales Tax (GST 🦘) in Google Sheets

Google Sheets,Google Sheets BasicsGoogle Sheets,Google Sheets basics,Google Sheets finance

Display values by odd or even rows or col vals in Google Sheets

Displaying Odd and Even Row Data in Google Sheets

Google Sheets,Google Sheets IntermediateGoogle Sheets,Google Sheets ARRAYFORMULA,Google Sheets FILTER,Google Sheets ISEVEN,Google Sheets ISODD,Google Sheets RIGHT,Google Sheets ROW,Google Sheets Sort

Filtering IMPORTRANGE data in Google Sheets

Google Sheets,Google Sheets IntermediateGoogle Sheets,Google Sheets COLUMN,Google Sheets FILTER,Google Sheets IMPORTRANGE,Google Sheets Intermediate,Google Sheets QUERY,Google Sheets Sort,Google Sheets UNIQUE

Using VLOOKUP with IMPORTRANGE in Google Sheets

Google Sheets IMPORTRANGE: Looking up data with the VLOOKUP function

Google Sheets,Google Sheets Intermediate,UncategorizedGoogle Sheets ARRAYFORMULA,Google Sheets Arrays,Google Sheets IF,Google Sheets IFNA,Google Sheets IMPORTRANGE,Google Sheets VLOOKUP

importrange prevent editors from accessing other ranges of your imported Google Sheet

Google Sheets IMPORTRANGE: Prevent clever editors from accessing other ranges of your imported sheet

Google Sheets,Google Sheets Intermediate,UncategorizedGoogle Sheets,Google Sheets IMPORTRANGE,Google Sheets Intermediate,Spreadsheets

Importing live range data from one Google Sheet to another

Importing Range Data From One Google Sheet to Another

Google Sheets,Google Sheets BasicsGoogle Sheets,Google Sheets basics,Google Sheets IMPORTRANGE,spreadsheet basics

How to create a time sequence in Google Sheets

Google Sheets,Google Sheets Advanced,UncategorizedGoogle Sheets,Google Sheets ARRAYFORMULA,Google Sheets FLOOR,Google Sheets HOUR,Google Sheets MINUTE,Google Sheets SEQUENCE,Google Sheets VALUE

Google Sheets - calculate duration between two times

Calculate the Total Duration of Time between two periods in Google Sheets

Google Sheets,Google Sheets Basics,UncategorizedGoogle Sheets,Google Sheets Beginners,Google Sheets Data Validation,Google Sheets Formatting

Get the most frequently occurring word in a column with Google Sheets v2

How to get the most frequently appearing words in a column in Google Sheets

Google Sheets,Google Sheets Intermediate,UncategorizedGoogle Sheets ARRAYFORMULA,Google Sheets COUNTIF,Google Sheets FILTER,Google Sheets MAX,Google Sheets QUERY,Google Sheets UNIQUE

Update a Dropdown List Dynamically Across a Range in Google Sheets

Update a range of dropdown lists in a Google Sheet dynamically based on a corresponding dropdown choice (Updated 28 Mar 2022)

Google Sheets,Google Sheets IntermediateGoogle Sheets ARRAYFORMULA,Google Sheets Data Validation,Google Sheets FILTER,Google Sheets IF,Google Sheets ISNA,Google Sheets MATCH,Google Sheets TRANSPOSE

New course 🎉🎉🎉 Google Sheets: Learn the Essentials with Three Detailed Projects & 60% off 😃

Google Sheets,Google Sheets Advanced,Google Sheets Basics,Google Sheets IntermediateGoogle Sheets,Google Sheets basics,Google Sheets course

Why can't I edit this Google document that was shared with me

Why can’t I edit this Google Sheet that was shared with me? 🤔

Google Sheets,Google Slides,Google Suite,UncategorizedGoogle Docs,Google Sheets,Google Slides,Google Workspace

Google Sheets Beginners: Getting Help (44)

Google Sheets,Google Sheets IntermediateGoogle Sheets,Google Sheets basics,spreadsheet basics,Spreadsheet Education

Google Sheets Beginners: Understanding The Explore Tool (43)

Google Sheets,Google Sheets BasicsGoogle Sheets,Google Sheets basics,spreadsheet basics,Spreadsheet Education

Google Sheets Beginners: Add-ons (42)

Google Sheets,Google Sheets BasicsGoogle Sheets,Google Sheets basics,spreadsheet basics,Spreadsheet Education

Google Sheets Beginners: Using Themes (41)

Google Sheets BasicsGoogle Sheets,Google Sheets basics,spreadsheet basics,Spreadsheet Education

Google Sheets Beginners: Charts (40)

Google Sheets,Google Sheets BasicsGoogle Sheets,Google Sheets basics,spreadsheet basics,Spreadsheet Education

Get the occurrence of a Value as a percentage in Google Sheets

Get the Occurrence of a Value in a Range as a Percentage in Google Sheets (Updated Feb 2022)

Google Sheets,Google Sheets IntermediateGoogle Sheets,Google Sheets COUNTA,Google Sheets COUNTIF,Google Sheets Pivot Tables,Google Sheets Sort,Google Sheets UNIQUE,spreadsheet basics

Google Sheets Beginners: Filter (38) & Filter View (39) (Updated 21 June 2022)

Google Sheets,Google Sheets BasicsGoogle Sheets,Google Sheets basics,spreadsheet basics,Spreadsheet Education

Google Sheets Beginners: Grouping Rows and Columns (36)

Google Sheets,Google Sheets BasicsGoogle Sheets,GoogleEDU,GoogleWorkspace,GSuite,Sheets,Spreadsheets

Google Sheets Beginners: Cutting, Copying and Pasting ( + bonus complete guide) (35)

Google Sheets,Google Sheets Basics,UncategorizedGoogle Sheets,Google Sheets basics,spreadsheet basics,Spreadsheet Education

monster guide to data validation in Google Sheets v2

The Monster Guide to Data Validation in Google Sheets: Free Course (Updated May 2022)

Google Sheets,Google Sheets Advanced,Google Sheets Basics,Google Sheets Intermediate,Uncategorizeddata validation,dropdown menus,Google Sheets,Google Sheets Data Validation,Google Sheets Date Picker

Google Sheets Beginners: Data Validation (34)

Google Sheets,Google Sheets Basics,Google SuiteGoogle Sheets,Google Sheets basics,spreadsheet basics,Spreadsheet Education

Google Sheets Beginners: Split text to columns (33)

Google Sheets,Google Sheets Basics,Google SuiteGoogle Sheets,Google Sheets basics,spreadsheet basics,Spreadsheet Education

Accessing the keyboard shortcuts in Google Sheets

Google Sheets Beginners: Accessing the Keyboard Shortcuts (32)

Google Sheets,Google Sheets Basics,Google SuiteGoogle Sheets,Google Sheets basics,spreadsheet basics,Spreadsheet Education

31 Editing Excel and ODS format files in Google Sheets

Google Sheets Beginners: Editing Excel and ODS format files in Google Sheets (31)

Google Sheets,Google Sheets BasicsGoogle Sheets,Google Sheets basics,spreadsheet basics,Spreadsheet Education

Creating Custom Page Breaks for Printing and Exporting 30

Google Sheets Beginners: You Can Create Custom Page Breaks for Printing and Exporting (30)

Google Sheets,Google Sheets BasicsGoogle Sheets,Google Sheets basics,spreadsheet basics,Spreadsheet Education

Google Sheets Beginners: Printing your Google Sheet (29)

Google Sheets,Google Sheets BasicsGoogle Sheets,Google Sheets basics,spreadsheet basics,Spreadsheet Education

28 Downloading or Exporting your Google Sheet

Google Sheets Beginners: Exporting your Google Sheet as different file types (28)

Google Sheets,Google Sheets BasicsGoogle Sheets,Google Sheets basics,spreadsheet basics,Spreadsheet Education

Google Sheets Beginners: Trim Whitespace (27)

Google Sheets,Google Sheets BasicsGoogle Sheets,Google Sheets basics,spreadsheet basics,Spreadsheet Education

Google Sheets Beginners: Workbook Edit Version History (26)

Google Sheets,Google Sheets BasicsGoogle Sheets,Google Sheets basics,spreadsheet basics,Spreadsheet Education

25 Google Sheets Shorts - Get Cell User History

Google Sheets Beginners: Cell History (25)

Google Sheets,Google Sheets BasicsGoogle Sheets,Google Sheets basics,spreadsheet basics,Spreadsheet Education

Google Sheets Recipe Template cover image

Use Google Sheets to store your Recipes to automatically change Batch Sizes and Recipe Amount by Weight

Apps,Google SheetsGoogle Sheets,Google Sheets template,Recipe

24 Google Sheets Shorts - Get Notifications for Edits and Form Submissions

Google Sheets Beginners: Getting Email notifications on changes and form submits (24)

Google Sheets,Google Sheets Basics,Google SuiteGoogle Sheets,Google Sheets basics,spreadsheet basics,Spreadsheet Education

23 Google Sheets Shorts - Protect Cells Ranges Sheet Tabs

Google Sheets Beginners: Protecting cells, ranges and sheet tabs (23) [updated Feb 2022]

Google Sheets,Google Sheets BasicsGoogle Sheets,Google Sheets basics,spreadsheet basics,Spreadsheet Education

22 Google Sheets Shorts - Remove Duplicates From a Range

Google Sheets Beginners: Remove Duplicates from a Range (22)

Google Sheets,Google Sheets BasicsGoogle Sheets,Google Sheets basics,spreadsheet basics,Spreadsheet Education

Google Sheets Beginners: Linking (21)

Google Sheets,Google Sheets BasicsGoogle Sheets,Google Sheets basics,spreadsheet basics,Spreadsheet Education

20 Google Sheets Shorts - Sharing & Permissions

Google Sheets Beginners: Sharing your Sheet (20)

Google Sheets,Google Sheets BasicsGoogle Sheets,Google Sheets basics,spreadsheet basics,Spreadsheet Education

19 Google Sheets Shorts - Comments and Communication

Google Sheets Beginners: Communicating with Comments (19)

Google Sheets,Google Sheets BasicsGoogle Sheets,Google Sheets basics,spreadsheet basics,Spreadsheet Education

Google Sheets Beginners – Alternating Colours (17)

Google Sheets,Google Sheets BasicsGoogle Sheets,Google Sheets basics,spreadsheet basics,Spreadsheet Education

18 Google Sheets Shorts - Inserting Images

Google Sheets Beginners – Inserting Images (18)

Google Sheets,Google Sheets BasicsGoogle Sheets,Google Sheets basics,spreadsheet basics,Spreadsheet Education

16 Google Sheets Shorts - Timezone date n time

Google Sheets Beginners – Change Your Current Workbook’s Timezone Date & Currency (16)

Google Sheets,Google Sheets BasicsGoogle Sheets,Google Sheets basics,Spreadsheet Education,Spreadsheets

15 Google Sheets Shorts - Spell check in Google Sheets

Google Sheets Beginners – Spell Check(15)

Google Sheets,Google Sheets BasicsGoogle Sheets,Google Sheets basics,spreadsheet basics,Spreadsheet Education

14 Google Sheets Shorts - Add and remove Google Sheet Tabs

Google Sheets Beginners – Creating Sheet Tabs (14)

Google Sheets,Google Sheets BasicsGoogle Sheets,Google Sheets basics,spreadsheet basics,Spreadsheet Education

13 Google Sheets Shorts - Hide columns and rows in Google Sheet Tabs

Google Sheets Beginners – Hide and unhide columns and rows(13)

Google Sheets,Google Sheets BasicsGoogle Sheets,spreadsheet basics,Spreadsheet Education

12 Google Sheets Shorts - Insert Columns and Rows

Google Sheets Beginners: Insert Columns and Rows (12)

Google Sheets,Google Sheets BasicsGoogle Sheets,spreadsheet basics,Spreadsheet Education,Spreadsheets

Compare current week with previous Google Sheets automation 1

How to compare current week’s data with previous week’s data in Google Sheets

Google Sheets,Google Sheets Intermediate,Google SuiteGoogle Sheets,Google Sheets Conditional Formatting,Google Sheets Data Validation,Google Sheets FILTER,Google Sheets TODAY,Google Sheets VLOOKUP,Google Sheets WEEKDAY,Google Sheets WEEKNUM

11 Google Sheets Shorts - Freeze Columns and Rows

Google Sheets Beginners: Freeze Rows and Columns(11)

Google Sheets,Google Sheets BasicsGoogle Sheets,spreadsheet basics,Spreadsheet Education,Spreadsheets

Google Sheets Beginners: Paint Format (10)

Google Sheets,Google Sheets Basics,Google SuiteGoogle Sheets,Spreadsheet Education,Spreadsheets

09 Google Sheets Shorts - Conditional Formatting

Google Sheets Beginners: Conditional Formatting (09)

Google Sheets,Google Sheets BasicsGoogle Sheets,Google Sheets basics,spreadsheet basics,Spreadsheet Education

Google Sheets Beginners: Borders (07 & 08)

Google Sheets,Google Sheets BasicsGoogle Sheets,spreadsheet basics,Spreadsheet Education,Spreadsheets

Google Sheets Beginners: Backgrounds (06)

Google Sheets,Google Sheets Basics,Google SuiteGoogle Sheets,Spreadsheet,spreadsheet basics,Spreadsheet Education

Google Sheets Beginners: Merging Text (5)

Google Sheets,Google Sheets BasicsGoogle Sheets,Spreadsheet Education,Spreadsheets

4 Google Sheets Shorts - text formatting in cells

Google Sheets Beginners: Formatting Text Inside Cell (4)

Google Sheets,Google Sheets BasicsGoogle Sheets,Spreadsheet Education,Spreadsheets

3 Google Sheets Shorts - text formatting

Google Sheets Shorts: Text Formatting (3)

Google Sheets,Google Sheets BasicsGoogle Sheets,Google Sheets Text formatting,spreadsheet basics

2 Google Sheets Shorts - align n wrap text

Google Sheets Shorts: Align and Wrap Text (2)

Google Sheets,Google Sheets Basics,Google SuiteGoogle Sheets,Spreadsheet Education,Spreadsheets

Google Sheets Shorts: Sorting Data (1)

Google Sheets,Google Sheets BasicsGoogle Sheets,Google Sheets Sort,Spreadsheet

0 Google Sheets Shorts - resizing columns and rows

Google Sheets Shorts: Change the Column and Row Size (0)

Google Sheets,Google Sheets BasicsGoogle Sheets,Google Sheets basics,spreadsheet basics,Spreadsheet Education

Count the number of days of the week in a range Google Sheets

Count the Number of Selected Days of the Week in Google Sheets

Google Sheets,Google Sheets BasicsGoogle Sheets DAYS,Google Sheets NETWORKDAYS,Google Sheets NETWORKDAYS.INTL,Google Sheets VALUE

Number of Words and Sentences in a Paragraph Google Sheets

Google Sheets: Get the Number of Words or Sentences in a Cell (Paragraph)

Google Sheets,Google Sheets BasicsGoogle Sheets,Google Sheets COUNTA,Google Sheets ROUND,Google Sheets SPLIT

Google Sheets: How to use OR inside a FILTER

Google Sheets,Google Sheets Intermediate,Google SuiteGoogle Sheets,Google Sheets AND,Google Sheets FILTER,Google Sheets ISBLANK,Google Sheets NOT,Google Sheets OR

Google Form Seat Booking and Registeree list

Create a seat booking form with Google Forms, Google Sheets and Google Apps Script

FormApp,Google Apps Script,Google Forms,Google Sheets,Google Sheets Basics,SheetsCOUNTA,filter,GAS,Google apps script,Google Forms,Google Sheets,IFERROR,REGEXMATCH,UNIQUE

Google Sheets Filter & Count cells that contain values

Google Sheets: Counting and Filtering Rows where Cells Contain Particular Values.

Google Sheets,Google Sheets AdvancedGoogle Sheets,Google Sheets ARRAYFORMULA,Google Sheets COUNTIF,Google Sheets FILTER,Google Sheets REGEXMATCH,regular expressions

Google Sheets -Dail USD-XRP Exchange Rate by Gateway final Tutorial Chart

Google Sheets Intermediate Project: Comparing the Best Daily Currency Exchange Rates Between Two Agencies – XRP/USD Chart Example Part 3

Google Sheets,Google Sheets Intermediate,Google SuiteChart editor,Google Chart editor,Google Charts,Google Sheets,trendline

Google Sheets - intermediate project tutorial part 2 XRP

Google Sheets Intermediate Project: Comparing the Best Daily Currency Exchange Rates Between Two Agencies – XRP/USD Example Part 2

Google Sheets,Google Sheets Intermediate,Google SuiteARRAYFORMULA,conditional formatting,Google Sheets,IF,SPARKLINE

Google Sheets Intermediate Project: Comparing the Best Daily Currency Exchange Rates Between Two Agencies – XRP/USD Example Part 1

Google Sheets,Google Sheets Intermediate,Google SuiteARRAYFORMULA,conditional formatting,filter,Google Sheets,Google Sheets LEFT,Google Sheets WEEKDAY,LEFT,max,min

My live Google Form response in Google Sheets won’t update in another Sheet Tab that references them. What do I do?

Google Sheets,Google Sheets Intermediate,Google SuiteGoogle Form Data,Google Forms,Google Sheets,Google Sheets Arrays,Spreadsheets

Google Apps Script – URL Fetch JSON data from an API and add it to a Google Sheet – Ripple API example

Google Apps Script,Google Sheets,Google Suite,Sheets,Triggers,UrlFetchAppGAS,Google apps script,Ripple API,SpreadsheetApp,Time Triggers,UrlFetchApp,XRP

Google Sheets: How to create a task completion check sheet. (Updated Feb 2022)

Google Sheets,Google Sheets Basics,Google Suitealternating colors,conditional formatting,Google Sheets,Google Workspace,IF,IMPORTRANGE,protecting sheets and ranges,share sheet,spreadsheet basics,Spreadsheets,TODAY

Hide formula on empty rows in Google sheets

Google Sheets: How to hide formula error warnings where there is no data or the data divides by zero

Google Sheets,Google Sheets Basics,Google SuiteGoogle Sheets,IF,IFERROR,ISBLANK,spreadsheets education

Send Emails and Edit permission from Google Sheet Uniques list with Google Apps Script

Google Apps Script: Send Bulk Emails and Share a Google Sheet with One Button Click

Code,Gmail App,Google Apps Script,Google Sheets,Google Suite,Sheets,UI ClassGAS,gmail,gmailApp,Google apps script,Google Sheets,SpreadsheetApp

Google Sheets: Conditional Formatting with Custom Formula

Google Sheets,Google Sheets Advanced,Google SuiteAND,conditional formatting,Google Sheets,OR,Spreadsheets,sum

Google Apps Script – When I add a value to a cell in a selected column, I want it to move to another Google Sheet [update Feb 2022]

Google Apps Script,Google Sheets,Sheets,TriggersCopying Data,copyTo,GAS,Google apps script,Google Sheets,onEdit

How to display a date for one day in a week that automatically changes weekly on Google Sheets

Google Sheets,Google Sheets Advanced,Google SuiteGoogle Sheets,Google Sheets TEXT,Google Sheets TODAY,Google Sheets WEEKDAY,Spreadsheets

Creating a Google Sheet Geo Map From Form Data and Posting it to WordPress – Part 3 of Google Forms in WordPress with Live Chart Project (Updated Feb, 2022)

Code,Google Forms,Google Sheets,Google Suite,JavascriptGoogle Forms,Google Sheets,Google Suite,IMPORTXML,Wordpress

Embedding a Live Google Sheet Graph that Updates Every 30 Seconds into a WordPress Post – Part 2 of Google Forms in WordPress with Live Chart Project

Code,Google Forms,Google Sheets,Google Suite,JavascriptGoogle Forms,Google Sheets,Javascript,Wordpress

Multiple Cell Data and Formula Reference With Find and Replace – Google Sheets

Google Sheets,Google Sheets Basics,StatisticsGoogle Sheets,spreadsheet basics,spreadsheets education

5 Easy Shortcuts That Will Save you Heaps of Time – Google Sheets

Google Sheets,StatisticsGoogle Sheets,spreadsheet basics,Spreadsheets,spreadsheets education

split the first name from a cell - Google Sheets

Google Sheets – How to Separate the First Name from a Full Name Cell

Google Sheets,StatisticsFIND,Google Sheets,LEFT,len,RIGHT,Spreadsheets,spreadsheets education

Get Sheet Names and Spreadsheet Names: Google Apps Script

Google Apps Script – How to Get the Sheet Name and Spreadsheet Name and add to a Cell on Google Sheets with a Custom Function (Updated Feb 2022)

Code,Custom Functions,Google Apps Script,Google Sheets,SheetsCustom Functions,GAS,Google apps script,Google Sheets

Google Sheets – Remove The Lowest Grade for Each Student on a Course

Google Sheets,StatisticsGoogle Sheets,Google Sheets COUNTIF,Google Sheets FILTER,Google Sheets INDEX,Google Sheets MATCH,Google Sheets MIN,Google Sheets SUM,spreadsheets education,sum

Top 2 grades for each group - Google Sheets

Google Sheets – Get the Top 2 Grades for Each Group in a Spreadsheet using RANK and FILTER (Updated Feb 2022)

Google Sheets,StatisticsGoogle Sheets,Google Sheets FILTER,Google Sheets RANK,Spreadsheets,spreadsheets education

Google Apps Script – How to make a Custom Function to Use in Google Sheets

Custom Functions,Google Apps Script,Google SheetsCustom Functions,GAS,Google apps script,Spreadsheets

Google Sheets – Random Alphabetic, Random Alphanumeric and Random Alphanumeric + Character Custom Functions (Updated January 2022)

Code,Custom Functions,Google Apps Script,Google Sheets,SheetsCustom Functions,GAS,Google apps script,Spreadsheets

How to Hide a Row based on a Cell Value in Google Sheets with Filter or Google Apps Script.

Code,Google Apps Script,Google Sheets,Sheets,Triggerscode,GAS,Google Sheets,onEdit,Spreadsheets

Sections to Sheets – Free Google Add-on That Separates Column Sections Into Individual Sheets for Page-by-Page Export or Printing

Apps,Google Apps Script,Google Sheets,GWAOw!Editor Add-ons,Google Sheets,GWAOw,GWAOw Sheets,Spreadsheets

How to Get Something from Google Sheets and Display it in the Sidebar in Google Apps Script (Updated January 2022)

Code,Google Apps Script,Google Sheets,HtmlService,Sheets,code,Google apps script,Google Sheets,HtmlService,Spreadsheets

Add the Current Date When Data is Added to a Cell(Dynamic) – Google Sheets

Google Sheets,StatisticsGoogle Sheets,NOW,Spreadsheets,Time,TODAY

Skewed Random Range in Google Sheets (RANDBETWEEN)

Google Sheets,Google Sheets Basics,StatisticsGoogle Sheets,Google Sheets RANDBETWEEN,Randomisation,Spreadsheets

How do I Randomly Assign People to a Group Without Doubling Up on the Same Group in Google Sheets

Google Sheets,Google Sheets Basics,StatisticsGoogle Sheets,Randomisation,Spreadsheets,TRANSPOSE

VLOOKUP Left in Google Sheets with INDEX and MATCH

Google Sheets,StatisticsGoogle Sheets,index,match,Spreadsheets,vlookup

Spacer – Free Google Add-On That Spaces Rows by Column Category (Updated January 2022)

Apps,Google Apps Script,Google SheetsGoogle Sheets

How do I lock certain cells in a formula in Google Sheets?

Google Sheets,Statisticscountif,Google Sheets,Spreadsheets

No post found

Back to Top

Courses & Projects

Google Sheets Beginner to Pro | Complete Bundle

Master Google Sheets with this complete video course.

Google Sheets Beginner to Pro | Project 3: Gradebook

Analyze Datasets with dashboards, advanced formulas, live data integration and more. Master advanced Google Sheets techniques and workflows.

Google Sheets Beginner to Pro | Project 2: Project Management Spreadsheet

Learn the Benefits of Templating Data, collaboration, and live tracking of your team's progress with this completed video course.

Google Sheets Beginner to Pro | Project 1: Create a Budget Spreadsheet

Master the very basics of working in Google Sheets by building a budget project.

Beginners

Absolute beginners video guide to working inside Google Sheets-FREE

This bite-sized Youtube course covers 44 special tools that will have you mastering Google Sheets in no time. One of the keys to success and efficiency in any business is having a grasp of handling spreadsheets.

Whether you are coming from MS Excel or you are working with spreadsheets for the first time. This guide is a must.

Check out the Youtube series here:

Youtube Beginners Guide

Back to Top

The Monster Guide to Data Validation in Google sheet-FREE

This course caters for both the beginner neophyte and intermediate level medicum in Google Sheets. Mastering data validation will help you control and guide what users enter into your Google Sheets resulting in cleaner more usable data.

This FREE course takes you through each aspect of data validation while also covering many of the common challenges you might face and provide some solutions to those challenges. Finally, this course will provide you with a number of custom validation tools to help you in your day-to-day Google Sheets work.

Check it out now!

https://yagisanatode.com/2021/01/26/the-monster-guide-to-data-validation-in-google-sheets-free-course/

Back to Top

Intermediate

Google Sheets Intermediate Project: Comparing the Best Daily Currency Exchange Rates Between Two Agencies – XRP/USD Example: FREE

This FREE 3-part course is designed for you to explore some intermediate Google Sheets functions, design, conditional formatting and workflow as you make your way through a project.

You’ll learn how to create a client-focussed chart to compare two daily currency exchange agency rates that are being fed live to your Google Sheet. You’ll then learn how to build a chart to display the comparisons and plot the daily exchange rate.

By the end of this course, you should have picked up a number of intermediate skills that you can apply to your own projects.

You can start at part 1 – HERE!

Back to Top

Links & References

Websites || Communities || Social

Just a short list of recommended links.

Websites

Google Support Page – Functions: Using the search bar and the function list for Google’s Support Page will help you solve most of your issues. Make sure you bookmark this one if you work with Google Sheets regularly.
Ben Collins: A site similar to this one with a tonne of tutorials on Google Sheets. Ben also provides some exceptional courses FREE and paid. He’s a great guy. Go and show him some love!
Baz Roberts: Another prolific Google Suite and Google Apps Script blogger. Baz has a great collection of project-based tutorials that are well worth getting your teeth into.
Ayran Irani: Has a growing mix of Youtube videos with a selection of Google Apps Script, Google Sheets and other Google Workspace videos.

Back to Top of Links

Community

Google Sheets Help: The Google Docs Help Community is a pretty good resource for you to troubleshoot problems or, when you are really stuck, get some advice.

Back to Top of Links

🐐You can support me for free by using this Amazon affiliate link in your next tech purchase :Computers & Stuff! 🐐

Social

You can follow me on: Twitter or Facebook

Twitter
- GSuite: Google’s GSuite page has some great tips and updates on all things GSuite including some regular Google Sheet tips and gif videos showing new functionality or boosting productivity.
Youtube
- Learn Google Spreadsheets: two years and over 50 videos on Google Sheets from this fella. His videos are top quality and his pacing is top-notch.
- Prolific Oaktree: A number of good Google Sheets tips here.

Back to Top

Add-ons

A list of my current Add-ons for Google Sheets

Spacer – FREE: Spacer is a Free Google Add-On that creates row spaces by column categories.
Sections to Sheets – FREE: Free Google Add-On that separates column sections into individual sheets for page-by-page export or printing.

Back to Top

Tools and Templates

Product: List all Files and Folders in a Google Drive Directory in Google Sheets

Far too busy to go through the tutorial? No worries. Grab List all Files and Folders in a Google Drive Directory in Google Sheets as a product here.

Named Function Pack

An expanding list of named functions to you can easily import into your own Google Sheets or use the pack's custom template for your own project.

Instantly share ONLY Teach:able Students to selected Google Drive Files and Folders

You don't want to give the whole world access to your Teachable course materials. Find out how to instantly share ONLY Teachable students to selected files and folders in Google Drive when they enroll.

Project Tasks Manager: Google Sheets

Track the hours you work on a project and quickly enter in your hours worked in this customisable easy to use Google Sheet template.

Attractive Recipe Template to store recipes for sharing and printing. You can quickly change the batch size or total ingredient weight. There is also a table of contents.