At the end of this video, you'll be able to list 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 dialogue 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 on my formula spreadsheet.
If I type an equal sign into the bottom row of my price column, I'll see these suggestions for possible formulas, including average price and price sum. I'll select 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 wanna find the average price (typing) of a charger, Google will find that answer for me, and 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'll select 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'll 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. Google Sheets has added the much requested feature to add a checkbox column to the spreadsheet. You may want to use check boxes on your spreadsheet for many purposes, like to track a project, take inventory, or check off your to-do list.
I'll add a checkbox column to track whether the item was sold at a discounted price on my sales chart. I'll name the column discount applied. Then I'll select all the cells where I want to add check boxes. From the top menu I'll select insert, and checkbox. I'd like those check boxes to be centered in each cell. So from the formatting menu, I'll select center. Now I can check the box in the rows where the item was sold at a discount.
(mouse clicking) One of the coolest new features in Google Sheets is the ability to group rows and columns. Grouping just means outlining the rows or columns with a plus or minus symbol to expand or hide the rows grouped. On this sales chart, I want to group the rows by date. I'll select the rows I want to group. First I want to group all the rows with the date of March 1st. So I'll select rows two through eight. Now I'll right click and select group rows two through eight from the menu that appears.
Now I can hide or expand the rows in this group with the plus or minus sign that appears on the left of the first row in the group. I can group columns the same way. I'd like to group the items SKU column with the item type column. So I'll select those two columns, right click, and select group columns E and F. Now I can close those columns up to minimize them when I'm working with my spreadsheet, and open them when I need to view them.
To ungroup, I just right click on a plus or minus sign and select remove group.
- 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 Intermediate
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.
Q: This course was updated on 10/17/2018. What changed?
A: New videos were added that cover customizing your printed spreadsheet and automating tasks with recorded macros.