Google Sheets Beginners: Understanding The Explore Tool (43)

The Google Sheets team seem to come out with more and more great tools to help us do more, help us think creatively about how we display our data and improve our efficiency.

On the wave of machine learning, it seems that the Google Sheets devs are making our lives just that little bit easier with the Explore Tool.

You can find the explore tool down the bottom right of your Google Sheets. The tool strives to do a number of things:

  • Bridge the gap, and considerable learning curve, by providing some natural language support for asking questions about your data in Google Sheets.
  • Create a constantly improving list of styling, chart and pivot table suggestions that you can simply click an add to your own project.
  • Provide inspiration for you to think about how to best present your data in a clear and informative way.

Check out the video!

00:00 Intro
00:16 Features of the Explore tool
00:30 The first Example
00:42 Understanding the Explore Menu
02:00 Asking Explore questions
04:06 The second Example
07:46 My opinion of the current state of the Explore Tool

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

Did you enjoy the tutorial? Want 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: Add-ons (42)

Sometimes you get to a point in your Google Sheets career where the vast array of tools that Google Sheets is not quite enough. Maybe you want to shortcut a process but don’t have time to learn or write Google Apps Script to do it.

Well, the good news is that there is a huge community of developers who have provided a huge amount of added extras to your Google Sheets all with the help of add-ons.

To learn about the Google Sheets Add-on marketplace and how to add, manage and remove your add-on check out the video below.

00:00 Intro
00:16 What are add-ons
00:53 Accessing the add-on marketplace
01:07 Searching for add-ons
01:38 Learn about he add-on
02:20 Installing the add-on
02:38 About authorisation
03:33 Accessing the example Add-on for the first time
04:16 Getting Help for the add-on
04:39 Run the example add-on
05:48 Managing add-ons
06:27 Uninstalling the add-on

If you enjoy the videos 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 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: Using Themes (41)

You don’t have to do all the hard work of creating all the formatting for your Google Sheet data, pivot tables and charts. Google Sheets actually comes with editable set themes that can quickly make your data look coordinated and stylish with a click of a few buttons.

Contents

00:00 Intro
00:17 Accessing Themes
00:29 How Themes style the Google Sheet
01:32 Customize the theme

 

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

Did you enjoy the tutorial? Want 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: Charts (40)

A top data presentation is all about displaying your data in an easy to understand and memorable way. This is why being able to quickly create charts with your Google Sheets data is an essential tool.

In this video tutorial, I’ll cover the basics of how to build a number of common chart types in Google Sheets. I’ll then show you how to quickly format them and cover a few gotchas new chart users face.

Here is a link to the data, if you want to play along!

Charts Data

Check out the video!

Contents:

00:00 Intro
00:27 How to access charts
01:07 Google Sheets suggested charts
01:23 Pie charts
01:31 The Chart Editor
01:36 The Setup Tab
02:43 The Customize Tab
02:47 Chart Style
03:18 Pie Chart menu
03:42 Slice labels menu
04:09 Pie slices menu
04:39 Chart Axis & Title
05:03 Legend menu
05:16 Interacting with a chart
05:39 Bar Charts
06:39 Modifying the data in a chart
07:23 Formatting your chart
10:37 Copying a chart as a template
11:11 Aligning charts in your Google Sheet
11:39 Column Charts
12:10 Displaying the total or average of a range
13:20 Area Chart
14:20 Updating the range
14:50 Setup for auto-update

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

Did you enjoy the tutorial? Want 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: 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, numerically, 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:

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:

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

Did you enjoy the tutorial? Want 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