Google Sheets Beginners: Filter (38) & Filter View (39)

In these video tutorials, we will cover the Filter tool in Google sheets.

Filter

You can set up a specialised view of your Google Sheet data that will let you sort, or filter out unwanted data in any column with the Filter tool.

This tool can pack a punch. You can sort different columns alphabetically, numberically, suing custom rules or even background colours. You can then use the filter part of the tool to remove unwanted parts of your data.

Don’t worry though, the filter will not affect your original. All you have to do is remove the filter and your data is back to normal.

In this video tutorial, we will go into the details on how to use the Filter tool. We will also cover some common gotchas, that beginners stumble on when trying to use Filter for the first time.

Check it out:

Watch this video on YouTube.

00:00 Intro
00:26 Accessing the Filter tool
01:14 About column headers and Filter
01:26 Fixing up hidden headers
01:39 A basic sort
01:46 Sorting A-Z & Z-A
02:00 Sorting with numbers
02:28 Sort by a background colour
03:09 Sort by order then colour
03:34 Sort by multiple columns (gotchas!)
04:23 Sort by grades
05:25 Filtering
05:34 Filter by values
07:46 Filter by colour
08:27 Filter by condition

Filter Views

You can create a variety of different filtered views without code or changing your data with Google Sheets Filtered Views. These views can be really handy for quickly presenting your data to your team or clients.

Take a look at the video:

Watch this video on YouTube.

00:00 Intro
00:17 How to create a Filter View
00:44 Filter view layout
01:03 Create your first Filter View
01:32 Updating the range
02:48 Accessing & hiding Filter Views
03:07 Create another Filter View
04:13 Duplicating a Filter View
05:57 View a list of Filter Views
06:21 Remove a Filter View
06:41 Educating your team

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

Google Sheets Shorts: Beginners

Want a quick reference to the top shortcuts? Check out these handy mousepads.

 

Want a solid step-by-step course to become a pro at Google Sheets? Udemy has some professional courses that will turn you into an admin ninja!

I’m a huge fan of Justin Mares, Mastering Google Sheets course. Sign up today*

 

*The above affiliate links have been carefully researched to get you to what you specifically need. If you decide to click on one of these links it will cost you just the same as going to the site. If you decide to sign up, I just get a little pocket money to help pay for the costs of running this website. 

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

Just when you thought that copy and paste was a no-brainer you start working in Google Sheets spreadsheets and find that there is a little more here than meets the eye.

The good news is that Google  Sheets has some great pasting types to help you copy or cut your data and put it in the cells or ranges exactly how you want it.

This tutorial takes you through a simple beginners tutorial on copying and pasting in Google Sheets to rapidly get you underway and then we dive into a Complete Guide to cut, copy, all the various paste types and possible gotchas you might face.

Cut, Copy & Paste Basics

Watch this video on YouTube.

The most important takeaway from this tutorial are the shortcuts that are going to be vital for you to boost your efficiency:

  • Cut : PC –  ctrl + X, Mac –  ⌘ + X
  • Copy : PC –  ctrl + C, Mac –  ⌘ + C
  • Paste : PC –  ctrl + V, Mac –  ⌘ + V
  • Paste just the values  : PC –  ctrl + shift + V, Mac –  ⌘  + shift + V

Cut, Copy & Paste Complete Guide

Here we dig into the weeds of all the capabilities that Google Sheets has with Cut, Copy and Paste.

Watch this video on YouTube.

In this tutorial, I’ll cover,

  1. 00:00 Intro
  2. 00:30 The basic copy and paste function and it’s shortcuts.
  3. 01:59 Copy and pasting basic formatting.
  4. 02:38 Differences with formulas with copy and paste.
  5. 04:01 Copy and pasting – across select ranges in the same Sheet.
  6. 04:43 Copy and pasting – from one Google Sheet to another.
  7. 05:38 Copy and pasting – from a different Google Sheet to another.
  8. 06:19 Copy and pasting – from other document types like Text, Excel, or a Webpage.
  9. 10:15 Copy and pasting – same values or a range of values multiple times.
  10. 11:57 Copy and pasting – formatting only.
  11. 13:12 How copying the formatting also copies conditional formatting.
  12. 13:55 Copy and pasting – excluding borders.
  13. 14:36 Copy and pasting – column widths only.
  14. 15:40 Copy and pasting – formulas only.
  15. 16:44 Copy and pasting – data validation
  16. 17:27 Copy and pasting – conditional formatting only.
  17. 18:40 Copy and pasting – transposed ( changing rows to columns and columns to rows)

Conclusion

So did anyone get the Tribble easter egg? Anyone…? 👓🐐

Spend some time masting the shortcuts for cut, copy and paste. Most of them will apply for all sorts of software (not just Google Products). So it is well worth knowing.

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

Want to be a shortcut master? Check out these handy mousepads.

 

Want a solid step-by-step course to become a pro at Google Sheets? Udemy has some professional courses that will turn you into an admin ninja!

I’m a huge fan of Justin Mares, Mastering Google Sheets course. Sign up today*

 

*The above affiliate links have been carefully researched to get you to what you specifically need. If you decide to click on one of these links it will cost you just the same as going to the site. If you decide to sign up, I just get a little pocket money to help pay for the costs of running this website. 

Google Sheets Beginners: Data Validation (34)

Data validation helps you to control what your users enter into your cells. It also allows you to create dropdown menus for your users.

In this tutorial, we will cover some basics on using Data Validation.

Data validation can really help prevent your user from making errors and guide them towards good practice as well as speed up their data input.

Watch this video on YouTube.

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

 

Want a solid step-by-step course to become a pro at Google Sheets? Udemy has some professional courses that will turn you into an admin ninja!

I’m a huge fan of Justin Mares, Mastering Google Sheets course. Sign up today*

 

*The above affiliate links have been carefully researched to get you to what you specifically need. If you decide to click on one of these links it will cost you just the same as going to the site. If you decide to sign up, I just get a little pocket money to help pay for the costs of running this website.

 

Google Sheets Beginners: Split text to columns (33)

Have a list of names and need to separate the first and last name? Need to put a list of names in separate cells? Need to find a specific Sheet code in a website? Google Sheets has your back with Split text to columns.

In this tutorial, we quickly and easily cover how to do all these things to save you time and sanity.

Watch this video on YouTube.

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

Want a solid step-by-step course to become a pro at Google Sheets? Udemy has some professional courses that will turn you into an admin ninja!

If your work life is Google Sheets, then you really need to master
the shortcuts to improve your efficiency. One way to do this is by
having a handy cheat sheet at hand for you to quickly reference. The
problem is that cheatsheets go missing and get in the way, but not
mousepads. They are right there beside you. So I thought, what about
a mousepad with a cheat sheet on it. The design is what you see
below. Take a look! It’s well worth a buy and helps support me to
build more content for you.

 

Google Sheets Beginners: Accessing the Keyboard Shortcuts (32)

Learning keyboard shortcuts are a must to improve performance when using Google Sheets.

Urban myth or not, I remember hearing a story about a manager in the financial industry who took away his new charge’s mouse and made sure the rest of the team didn’t give them one. This shocking bit of tough-love was to force their charge into using keyboard shortcuts because they knew that it dramatically improved their ability to quickly negotiate a spreadsheet.

I have been tempted to do this with my own staff over the years only, I suppose, tempered by the zeitgeist of this era.

In this short tutorial, we will cover how to access and negotiate the shortcuts menu so you can start to memorise the shortcuts you need to be successful as a Google Sheets ninja.

Watch this video on YouTube.

If you want a rundown on the top shortcuts to get you on the road to be the next Hussain Bolt of Google  Sheets, check out the tutorial below:

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

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

If your work life is Google Sheets, then you really need to master
the shortcuts to improve your efficiency. One way to do this is by
having a handy cheat sheet at hand for you to quickly reference. The
problem is that cheatsheets go missing and get in the way, but not
mousepads. They are right there beside you. So I thought, what about
a mousepad with a cheat sheet on it. The design is what you see
below. Take a look! It’s well worth a buy and helps support me to
build more content for you.

 

Want a solid step-by-step course to become a pro at Google Sheets? Udemy has some professional courses that will turn you into an admin ninja!

I’m a huge fan of Justin Mares, Mastering Google Sheets course. Sign up today*

 

*The above affiliate links have been carefully researched to get you to what you specifically need. If you decide to click on one of these links it will cost you just the same as going to the site. If you decide to sign up, I just get a little pocket money to help pay for the costs of running this website.