Learn about the features and updates added in the newest version of Google Sheets.
- [Instructor] Let's review some of the newest features and changes in this version of Google Sheets. Now it's more intuitive to create a new spreadsheet right from the Home screen. You'll see these thumbnails right along the top to start a new spreadsheet. You can either create a new blank spreadsheet right from here or use one of these handy templates from the Template Gallery. This makes it faster than ever to get started with this great tool. In the updated version of Google Sheets, you can now publish individual spreadsheets to the web. I'll show you with my Formula spreadsheet.
Just click the Share button in the upper right, click the Advanced in the lower right of the dialog that pops up and change the access level to On, Public on the Web. Click Save and Done. Formulas have gotten a lot easier to create in Google Sheets. Now when you type an equal sign into a cell, you'll see suggestions for formulas based on contextual clues from your spreadsheet data. I'll show you that in my Formula spreadsheet.
If I type an equals sign into the button row of my price column, I'll see these suggestions for possible formulas including average price and price sum. I also like the average and press enter. $47.07 is the average price in this column. Waterfall charts have been added to the type of charts you can insert into your spreadsheet. Let me show you how to find it. Click Insert, Chart, and the Chart Editor pops up.
Under Chart Type, you'll see a bunch of different types, scroll down, and you can pick Waterfall Chart. Some of the most exciting updates come out of the launch of the new Explore button in Google Sheets. You'll find that Explore button in the bottom right corner of any spreadsheet and when you hover over it, you'll see the word Explore. You can click to open the Explore menu, it'll open in the right side of your spreadsheet. Here in the Explore menu, you can type in a question about your data and Google will attempt to answer it.
For example, if I want to find the average price of a charger, Google will find that answer for me and it will even create a Formula that I can click See Formula to view. I can click to copy or drag to insert that formula right into my spreadsheet. I also see suggestions for analysis here based on my data and those suggestions are based on the selected area in my spreadsheet.
I also like the percent of stock items sold. Here I see suggested questions to ask about my data. I can click on them to find the answer. I also see suggested formatting for my spreadsheet. I can click on a suggested format, see what it looks like and I can also see suggested pivot tables and charts to add into my spreadsheet. The new Google Sheets provides a lot of features that were requested by users.
If you have an additional feature you'd like to request or if you need help with Google Sheets, click Help from the menu bar, select Sheets Help, and from here you can search the help by typing in a question, or you can click Send Feedback to suggest your ideas.
- Navigating Google Sheets
- Creating, naming, and saving spreadsheets
- Importing files
- Converting other file formats such as Microsoft Excel to Google Sheets
- Editing cells
- Inserting, deleting, and moving rows and columns
- Adding hyperlinks and images
- Formatting data
- Using formulas and functions
- Sharing spreadsheets
- Using the Google Sheets mobile app
Skill Level Appropriate for all
Q: This course was updated on 04/17/2018. What changed?
A: We revised five videos to reflect the latest features and enhancements in Google Sheets.