One really amazing thing about Google Sheets is how easy it grab live data from one Google Sheet and import it into another. I’m not talking about a simple copy and paste job here. I am talking about real live data. Data that, when updated in the master sheet, will be reflected in the Google Sheet that you have imported the data to.
Everything starts with the IMPORTRANGE Google Sheets function.
But before we get started on the “How to’s,” you might be wondering why you might need to import live Google Sheet data from one sheet to another.
Or check out the table of contents to dive straight into what you need right now!
Whether you are looking to skill up, make your work-life easier or impress your boss then this course will take you from Google Sheets beginner to producing corporate-level Google Sheets with three detailed projects.
And because this is the opening week, I am offering a whopping 60% off the course for the next 7 days only.
Just use the Coupon Code…
NEWCOURSEDISCOUNT
…on the checkout page and you can start the course today.
If you are already a Google Sheets legend, you know how important it is to learn how to master spreadsheets. If you know someone transitioning industries, just starting out or simply needing to boost their skillset please share this post.
This is a whopper of a discount and not one to miss.
This has been a project I wanted to build for a long time. The best way to learn something is by getting hands-on and building a project. That’s how I know I learn best.
I wanted to build a Google Sheets beginners to pro course that I wanted when I first started in the world of Google Sheets. Something with real-life examples and a set of projects that I can build and maybe even modify and reuse in the future. Something that not only gives me the how-toos but the why I should be building and designing my spreadsheets in a certain way.
Go on, check out the link to find out more about the course and try out the first 5 chapters on me. I know you are going to get a lot out of it.
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 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.
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 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.
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 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.