I'm always trying to find ways to convince people to use spreadsheets. I think that a spreadsheet tool like Google Sheets is one of the best ways to set up and organize your project, life, or finances.
When you want to learn a new app, spending time with a few tutorials can really ease the pain of the learning curve. You can work through these tutorials to build your Sheets knowledge and get excited about using the app.
I think that this round-up of tutorials is the very best way to get started with using Google Sheets. Below, I'm going to show you 18 of the best Google Sheets tutorials that we've published here on Envato Tuts+. Whether you're already using Sheets or are considering it for your work, read and follow through these to learn more.
1. How to Use Google Sheets to Make Your First Spreadsheet
Never even heard of Google Sheets? No problem. Make this the first Google Sheets tutorial that you check out.
Even if you don't have a Google Sheets account, this tutorial has what you need to start learning. You'll learn how to open Google Drive, create your first spreadsheet, and write a basic formula to start using Sheets in no time.
2. What is Google Sheets? (Free Online Spreadsheets Tool)
If you still aren't convinced that you can use Google Sheets for your work, this tutorial can help you see the potential for the app. I'll show you five of my favorite features that make Sheets a part of my workflow no matter what I'm working on. Learn what sets Sheets apart from other spreadsheet apps you may have tried before as well.
3. How to Add Formulas & Functions in Google Spreadsheets
Formulas and functions are two of the most important features of any spreadsheet apps. Whether those are basic math operators like addition and multiplication or text transformation options, it's all about working with data and modifying it. Formulas and functions transform and modify data so that you can take input data and evolve it.
This Google Sheets tutorial can help you master a few basic formulas and functions and help you start learning more. Give it a read to see some of the functions that you'll find yourself using every day.
4. How to Quickly Convert Excel Spreadsheets to Google Sheets
Maybe you're avoiding using an app like Sheets because you're already locked in as a Microsoft Excel user. This Google spreadsheet tutorial is going to help bridge that gap and help you make the shift.
Try out this tutorial if you want to take your Excel spreadsheet files (.XLSX files) and start using them in Google Sheets.
5. Google Sheets to Excel: How to Move Back & Forth Between Spreadsheets
After you've been using Sheets for some time, you might need to download one of your spreadsheets and send it to a Microsoft Excel user. Luckily, Sheets and this tutorial make it easy to do just that.
This Google Sheets tutorial is a great reminder that you don't have to be locked into a single app. Jump back and forth between the apps using these two tutorials.
6. How to Quickly Collaborate on Edits in Google Sheets (Online)
If you aren't excited about using Google Sheets yet, this may be the tutorial that tips the scales. You can invite other Sheets users to collaborate with you inside of the same spreadsheet.
First, you'll learn to add other users using email addresses. You can also post the spreadsheet at a public URL so that anyone can view or edit the file. You'll even learn to customize permissions so that no unwanted changes occur to your spreadsheets.
Make sure to check out the link below to start mastering collaboration in Google Sheets.
7. How to Link Spreadsheets & Share Data in Google Sheets
For spreadsheet power users, it won't take long before you've created many workbooks with many tabs (Sheets) in them. You might want to start connecting those so that you can share data between files.
This Google Sheets tutorial can help you link your spreadsheets up. You'll learn a helpful function and tricks to pull data back and forth between multiple Sheets files.
8. How to Edit & Format Cells in Google Sheets Spreadsheets
Formatting can bring a sense of style and readability to your spreadsheet. It's all about applying cell styles that make it easier for someone to read the spreadsheet. Using techniques like borders, shading, and font styles are easy steps you can take to make a spreadsheet readable.
Try out this tutorial to find out more about the best way to format spreadsheets to get the most from them:
9. How to Protect Sheets & Lock Cells in Google Sheets
As you begin to invite collaborators to your spreadsheet, you'll want to think about how you've set up your spreadsheet with cell protections. There are some cells that you just don't want others to change, so make sure to use cell locks and sheet protections.
This tutorial covers all of those techniques. You'll learn to protect your spreadsheet so that it's never changed accidentally.
10. How to Sort & Filter Spreadsheet Data in Google Sheets
The larger your data set is, the more tools that you'll need to navigate it. That's why sorting and filtering are so important.
With these two skills, you can take a huge data set and find exactly what you're looking for. Filtering can help you refine the data to specific selections. Make sure to take time and learn this technique in the tutorial below so that you can work with your data and understand it.
11. How to Use (Timesaving) Google Sheets Keyboard Shortcuts
Once you've got some serious spreadsheet skills, it's time to start looking for ways to work more efficiently and quickly inside of them. Look no further than learning a few crucial keyboard shortcuts so that you can spend less time in Sheets.
Check out this tutorial to see some of the most important keyboard shortcuts that practically any user can benefit from. Learning a few shortcuts in this Google spreadsheet tutorial can help you save many hours while working.
12. How to Use Pivot Tables in Google Sheets (Ultimate Guide)
Earlier, you saw the Google Sheets tutorial on sorting and filtering data to help you navigate a large dataset. While that can certainly help you find specific rows, you truly need to learn more about Pivot Tables to summarize and understand a dataset. Basically, you can drag and drop to build reports using pivots in Sheets.
Pivot tables are just one of those features that you've got to see in action to understand the potential. Try out the tutorial below for an illustrated walkthrough on this feature.
13. How to Create Web Input Forms With Google Sheets
I constantly find myself wanting to get input or feedback from others on projects that I'm working on. Instead of writing out an email and asking for it, I now just point them to a form that grabs data and puts their feedback directly into a spreadsheet.
Check out this Google spreadsheet tutorial to learn more about creating that same setup so that you don't have to parse and re-type data that you receive from a variety of sources:
14. How to Make Professional Charts in Google Sheets
When you're looking into learning Google Sheets, you might be wondering if you can build great-looking charts. Graphics and visual charts are two of the most popular features of spreadsheet apps because they help drive understanding of data with a viewer. A well-created chart goes a long way to communicating your findings.
Look no further than this Google spreadsheet tutorial to help you master charting in Google Sheets. You'll take the data that's in your Sheets and create the right graphic for them to help an audience understand the data.
15. How to Use IFTTT With Google Sheets
Google Sheets connects to several services on its own, but using an app like IFTTT can help it connect to practically any app. Complete tasks like bringing tweets or Dropbox file names right into a spreadsheet in this Google spreadsheet tutorial.
This is one of my favorite Google Sheets tutorials to help you see the potential for using spreadsheets. Even if you don't think of yourself as a spreadsheet user, you'll quickly see the value of connecting multiple apps to Sheets for easy data sharing.
16. How to Track Stock Data in Google Sheets - With GOOGLEFINANCE Function
Looking to become an expert stock picker? Trying to track your own personal retirement portfolio? You'll need an easy way to get data into your spreadsheets without constantly looking up and retyping data.
I'll show you how to use the GOOGLEFINANCE function in Sheets in this tutorial. You'll use that function to automatically pull in up-to-date or historical data about financial instruments into your spreadsheet.
- Google SheetsHow to Track Stock Data in Google Sheets - With GOOGLEFINANCE FunctionAndrew Childress
17. How to Print Areas, Ranges or Full Google Spreadsheets
Spreadsheets are for more than just viewing onscreen. You can also print that important report or analysis and hand it off for review.
Because spreadsheets can be large or oddly shaped, you'll want to be careful when you go to print the file. This Google spreadsheet tutorial will help you print your files just as you want, with as little ink and paper waste as possible.
Try out this tutorial to set the print area perfectly and ensure you print your spreadsheet perfectly the first time.
18. 20 Free Google Sheets Business Templates to Use in 2018
To round out this collection of Google Sheets tutorials, here's a collection of my favorite templates that you can use. A template is really just a pre-built design that you can easily add your own data to.
I like to use templates to help me think about what I should include in my files. That could include anything from a budget to a project plan. Make sure to check out the roundup below for 20 different choices of Sheets templates.
In this round-up, I shared some of the best learning resources we've built here at Envato Tuts+ to help you master Google Sheets. Try out each of these tutorials to learn a different skill, and soon you'll be a spreadsheet savant.
What else do you want to learn when it comes to Google Sheets? Leave a comment below and we just might cover that skill next.
Envato Tuts+ tutorials are translated into other languages by our community members—you can be involved too!Translate this post