Find out how to check your workbooks changes history in Google Sheets. In this tutorial, I'll cover, 1. Why you might need to check the version history. 00:05 2. How to see the version history 00:18 3. What you can see opening version history 00:32 4. How to expand to see specific individual history 00:52 5. How to see edits individually by colour. 01:01 6. Toggle the view on and off. 01:38 7. How to Restore a version 01:57 8. How to Name a version. 02:30 9. How to Make a Copy. 03:10 10. How to exit version history 03:47 #GoogleSheets #Spreadsheets #SpreadsheetBasics #GoogleEDU #GoogleWorkspace Even knowing the basics can really give you the edge and save you a heap of time in the workplace. If you like the video, check out my website: https://yagisanatode.com/ Here is the link to just Google Sheets tutorials: https://yagisanatode.com/google-sheets/ Sign up for my course: Google Sheets: Learn the Essentials with Three Detailed Projects https://yagisanatode.teachable.com/p/google-sheets Grab a Google Sheets Shortcuts Mousepad to help you memorise the Shortcuts. https://www.zazzle.com.au/collections/shortcuts_mousepads-119754792503977450 ... https://www.youtube.com/watch?v=DqNO1XVtrnQ

New to Google Sheets and spreadsheets in general? Find out how to Insert image into your Google Sheets In this tutorial, I'll cover, 1. Discuss the two options for inserting images in sheets. 2. Inserting images from a file 3. Inserting images from your Google Drive 4. Inserting images from a link 5. Copying and pasting screenshots into your Google Sheet Oh, and a very awkward comment about a goat. ? #GoogleSheets #Spreadsheets #SpreadsheetBasics #GoogleEDU #GoogleWorkspace Even knowing the basics can really give you the edge and save you a heap of time in the workplace. Find out a sneaky way to add a link to an image in Google Sheets here: https://youtu.be/laNiG4nlVIs If you like the video, check out my website: https://yagisanatode.com/ Here is the link to just Google Sheets tutorials: https://yagisanatode.com/google-sheets/ Sign up for my course: Google Sheets: Learn the Essentials with Three Detailed Projects https://yagisanatode.teachable.com/p/google-sheets Grab a Google Sheets Shortcuts Mousepad to help you memorise the Shortcuts. https://www.zazzle.com.au/collections/shortcuts_mousepads-119754792503977450 ... https://www.youtube.com/watch?v=Pn0SWa91F-g

In this tutorial, we create a password generator (random string generator) in Google Sheets using the LAMBDA function and two helper functions MAP and MAKEARRAY. To the written tutorial and starter sheet!: https://yagisanatode.com/create-a-dynamic-password-generator-in-google-sheets/ 00:00 What we will build. 01:14 The character string. 01:41 Find the length of the string. 01:59 Get a random character from the string. 03:43 Create a sequence matrix. 04:36 Maps random characters to the sequence. 06:47 Join the random array into a string. 07:59 Create an array of passwords. 10:11 Add the string to the formula. 11:06 Change values from other cells. 13:47 Convert dynamic formula to static text. If you like the video, check out my website: https://yagisanatode.com/ Here is the link to just Google Sheets tutorials: https://yagisanatode.com/google-sheets/ Sign up for my course: Google Sheets: Learn the Essentials with Three Detailed Projects https://yagisanatode.teachable.com/p/google-sheets Grab a Google Sheets Shortcuts Mousepad to help you memorise the Shortcuts. https://www.zazzle.com.au/collections/shortcuts_mousepads-119754792503977450 #GoogleSheets #spreadsheets #lambda #password ... https://www.youtube.com/watch?v=SRuOVBr7JCw

Sections to Sheets is a free Google Sheets Add-on that separates rows by column sections and puts them in individual pages or sheets in a spreadsheet in preparation for export and printing. To the homepage: https://yagisanatode.com/sections-to-sheets-free-google-add-on-that-separates-column-sections-into-individual-sheets-for-page-by-page-export-or-printing/ To the Google Workspace Marketplace Page: https://workspace.google.com/marketplace/app/sections_to_sheets/730200342547 00:00 What is Sections to Sheets 00:47 Installation 01:41 Setup Your Data 02:37 e.g.2 Just Data 04:41 e.g.1 Data with Repeating Header 06:02 e.g.3 Data with Repeating Header & Footer 07:16 e.g.4 Combine Columns to Make a Section 09:30 Scopes and Authorisation 12:12 Limitations ** My Site ** https://yagisanatode.com/ ** More on Google Apps Script ** https://yagisanatode.com/google-apps-script/ ** Products ** Create and Publish Google Workspace Add-ons with Google Apps Script: Master Class https://yagisanatode.com/products/create-and-publish-google-workspace-add-ons-with-google-apps-script-master-class/ * Courses * https://yagisanatode.com/products-category/courses/ * Google Workspace Tools * https://yagisanatode.com/products-category/google-workspace-tool/ * Google Workspace Add-ons * https://yagisanatode.com/products-category/gwao/ #googleworkspace #googleappsscript #GoogleSheets #onEdit #admin #googleWorkspaceAddons #businessadministration #addons @googleworkspacedevs #googleworkspaceEditorAddon #GoogleSheetsAddons ... https://www.youtube.com/watch?v=DAWGbG51bbk