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.
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!
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 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.
When your Google Sheet spreadsheet starts to grow in complexity it is often a good idea to group similar parts of your data so you can easily collapse and expand them as you need them. Fortunately, Google Sheets has your back with the Grouping tool.
In this tutorial, we will look at how to group rows and columns in Google Sheets. We’ll also look at a few advanced capabilities and show you how to avoid some common traps.
Check it out!
This tutorial covers:
00:00 Intro
00:28 Example of grouped data
01:44 How column and row groupings work.
02:52 How to create groupings in Google Sheets
02:59 Grouping columns
04:03 Grouping adjacent columns and rows
05:13 undo grouping
05:38 Grouping rows
06:27 Sub or secondary groupings.
If you enjoy the video 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.
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
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.
In this tutorial, I’ll cover,
00:00 Intro
00:30 The basic copy and paste function and it’s shortcuts.
01:59 Copy and pasting basic formatting.
02:38 Differences with formulas with copy and paste.
04:01 Copy and pasting – across select ranges in the same Sheet.
04:43 Copy and pasting – from one Google Sheet to another.
05:38 Copy and pasting – from a different Google Sheet to another.
06:19 Copy and pasting – from other document types like Text, Excel, or a Webpage.
10:15 Copy and pasting – same values or a range of values multiple times.
11:57 Copy and pasting – formatting only.
13:12 How copying the formatting also copies conditional formatting.
13:55 Copy and pasting – excluding borders.
14:36 Copy and pasting – column widths only.
15:40 Copy and pasting – formulas only.
16:44 Copy and pasting – data validation
17:27 Copy and pasting – conditional formatting only.
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 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.
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.
If you enjoy the video 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.
