Google Sheets Beginners: Getting Help (44)

One of the biggest revelations that I came across that really changed my whole view of learning was that learning how to ask the right questions or know where to get help completely transforms how you learn.

Knowing how to get help quickly and efficiently in Google Sheets is really going to cut away a lot of the frustration of finding the right information and get you there in a much more efficient way.

In the video below I will go over how to use all of Google Sheets help tools effectively and then discuss how you can research to find out how to build more complicated functions and processes in Google Sheets.

Check out the video below!

00:00 Intro
00:27 The help menu
01:13 Keyboard shortcuts
01:30 The help search bar
02:08 The Sheets Help tool
02:44 Understanding the help tool for functions
04:03 Preparing complex formulas with the Function List
05:14 How to ask the right questions

This is the last video in the Google Sheets beginners Youtube course. This is the first online course I have created. It was a long and rewarding journey. I’ve learned a lot along the way and I hope you got a lot out of the course.

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: 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