Google Sheets Beginners: Trim Whitespace (27)

Last Updated on 2021-10-31 by Jarret Hooper

Trim Whitespace removes all spaces in a text string, leaving just a single space between words.

Search not working? This may be why.

This is a quick and easy tool that you can apply to all of your cells.

If you enjoy the video and want to learn more about how to use Google Sheets, check out the Youtube Playlist:

Google Sheets Shorts: Beginners

Did you enjoy the tutorial? Want to upskill and get a solid step-by-step course to become a pro at Google Sheets? Check out my course, Google Sheets: Learn the Essentials with Three Detailed Projects. Sign up today.

 
Google Sheets Shortcuts Mousepad
Google Sheets Shortcuts Mousepad
Want a fast track to boost your Spreadsheet efficiency? Grab one of these handy Google Sheets Shortcuts mousepads that I created from my store.
Google Sheets Shortcuts Mousepad Gel
Google Sheets Shortcuts Mousepad Ge

~Yagi

Google Sheets Beginners: Workbook Edit Version History (26)

Last Updated on 2021-10-31 by Jarret Hooper

Google Sheets keeps a detailed version history of your workbook. You can use this version history to track changes and identify when, where and who made a change. You can make a copy of an old version or revert your current sheet back to an old version.

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

If you enjoy the video and want to learn more about how to use Google Sheets, check out the Youtube Playlist:

Google Sheets Shorts: Beginners

Did you enjoy the tutorial? Want to upskill and get a solid step-by-step course to become a pro at Google Sheets? Check out my course, Google Sheets: Learn the Essentials with Three Detailed Projects. Sign up today.

 
Google Sheets Shortcuts Mousepad
Google Sheets Shortcuts Mousepad
Want a fast track to boost your Spreadsheet efficiency? Grab one of these handy Google Sheets Shortcuts mousepads that I created from my store.
Google Sheets Shortcuts Mousepad Gel
Google Sheets Shortcuts Mousepad Ge

~Yagi

Google Sheets Beginners: Cell History (25)

Last Updated on 2021-10-31 by Jarret Hooper

Google Sheets

Did you know you can peek in on the history or each one of your Google Sheets cells?

via GIPHY

Find out how in this short video tutorial:

If you enjoy the video and want to learn more about how to use Google Sheets, check out the Youtube Playlist:

Google Sheets Shorts: Beginners

Did you enjoy the tutorial? Want to upskill and get a solid step-by-step course to become a pro at Google Sheets? Check out my course, Google Sheets: Learn the Essentials with Three Detailed Projects. Sign up today.

 
Google Sheets Shortcuts Mousepad
Google Sheets Shortcuts Mousepad
Want a fast track to boost your Spreadsheet efficiency? Grab one of these handy Google Sheets Shortcuts mousepads that I created from my store.
Google Sheets Shortcuts Mousepad Gel
Google Sheets Shortcuts Mousepad Ge

~Yagi

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

Last Updated on 2021-10-31 by Jarret Hooper

Google Sheets

Sometimes it is helpful to hide and unhide columns in Google Sheets. You may have some completed tasks that you want to indicate as completed to your users or you may want to hide columns that you have used for working. Whatever, the case hiding rows in columns is a helpful trick to have in your Google Sheets toolbox.

In this video tutorial we  will cover:

  1. Why you might want to hide columns and rows in Google Sheets.
  2. Hiding and unhiding individual columns and rows.
  3. Hiding and unhiding ranges of columns and rows.
  4. Hiding and unhiding selected columns or rows.

Check it out now!

If you want to grab more Google Sheets basics, you click in the link below to the playlist:

Google Sheets Beginners playlist

Did you enjoy the tutorial? Want to upskill and get a solid step-by-step course to become a pro at Google Sheets? Check out my course, Google Sheets: Learn the Essentials with Three Detailed Projects. Sign up today.

 
Google Sheets Shortcuts Mousepad
Google Sheets Shortcuts Mousepad
Want a fast track to boost your Spreadsheet efficiency? Grab one of these handy Google Sheets Shortcuts mousepads that I created from my store.
Google Sheets Shortcuts Mousepad Gel
Google Sheets Shortcuts Mousepad Ge

~Yagi

Google Sheets Beginners: Backgrounds (06)

Last Updated on 2021-10-31 by Jarret Hooper

New to Google Sheets and spreadsheets in general? Find out everything you need to know about inserting a background cell colour efficiently.

Changing cell colours in Google Sheets can really make your spreadsheets pop!

In this tutorial, I’ll cover,
1. How to insert a background into a single cell.
2. Inserting a background into a range of cells.
3. A brief style guide on best practices when using colour in Google Sheets.
4. An example of background colour formatting.

Even knowing the basics can really give you the edge and save you a heap of time in the workplace.

 

Did you enjoy the tutorial? Want to upskill and get a solid step-by-step course to become a pro at Google Sheets? Check out my course, Google Sheets: Learn the Essentials with Three Detailed Projects. Sign up today.

 
Google Sheets Shortcuts Mousepad
Google Sheets Shortcuts Mousepad
Want a fast track to boost your Spreadsheet efficiency? Grab one of these handy Google Sheets Shortcuts mousepads that I created from my store.
Google Sheets Shortcuts Mousepad Gel
Google Sheets Shortcuts Mousepad Ge

~Yagi

%d bloggers like this: