Join Sally Norred for an in-depth discussion in this video What's new in Google Sheets, part of Google Sheets Essential Training.
The new Google Sheets is a major update that released in early 2014. Let's review some of the new features and changes in this version of Google Sheets. Any new spreadsheets that are created in Google Sheets are automatically created in the new Google Sheets. At the time of this recording, spreadsheets created in a previous version of Google Sheets will remain in the older version. If you need to create a new spreadsheet in the older version of Google Sheets, visit this link, g.co/oldsheets.
In a nutshell, the new Google Sheets allows you to edit spreadsheets offline, it has faster scrolling and loading capabilities, it includes the new Google Sheets Home Screen, and it adds several other helpful features. You can enable offline editing of Google Sheets spreadsheets in Google Drive when you're using Chrome or on your Google Sheets mobile app, to create, view and edit spreadsheets without an Internet connection. You can start at the Google Sheets Home Screen to access all the Google Sheets that you've created, or that have been shared with you.
The new Google Sheets has added saveable filter views so that you can save the way you filtered your spreadsheets, without altering the way collaborators see your spreadsheets. Many of the limits in formula complexity and spreadsheet size have been eliminated in the new Google Sheets. The new product will support up to two million cells of data, although extremely large or complex spreadsheets may have slower performance. In the area of formulas and functions, the new Google Sheets has improved the function editing tools, and has added several new spreadsheet functions, including some if, count if, and average if.
Other feature updates include more advanced conditional formatting options, colored sheet tabs, paste transposed to paste a column in a row and vice versa, an improved find and replace tool, easier hyper-linking, third-party add-on app installation, and lots more number formatting options. There's also a few features that were retired in this new version of Google Sheets. These include spell check, web clipboard, solver, special auto-fill using Google Sets, and a few functions including continue, Google Clock, expand, no expand, and Google Tournament.
Also note that the new version of Google Sheets does not yet support publishing of individual sheets. 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 the new Google Sheets, click the new Google Sheets check mark on the bottom right corner of any worksheet created in the new Google Sheets.
- 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
1. Getting Started with Google Sheets
2. Creating Spreadsheets
3. Editing Spreadsheets
4. Viewing and Printing Spreadsheets
5. Formatting Spreadsheets
6. Working with Spreadsheet Data
7. Collaborating with Google Sheets
Commenting on a spreadsheet3m 26s
8. Using the Google Sheets Mobile App
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.Cancel
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.