Get advanced tips and tricks to boost your productivity in Google Sheets, from creating interactive charts and surveys to applying conditional formatting.
- [Jess] My name is Jess Stratton, and welcome to this course on everyday tips and tricks that you can use to master Google Sheets. I'll first take you working through the spreadsheets themselves, such as how to download the file as Microsoft Excel or PDF. Then I'll show you how to work with columns, rows, and cells and how to do all sorts of formulas and functions, such as using conditional formatting and adding data validation. I'll then take you through working with charts, including inserting a gauge chart, a geo chart, and even publishing a chart to a website. Finally, I'll show you how to use Google Sheets with other Google products, such as using Google Forms to create surveys, browsing the add-on library, and getting notified by e-mail when a change is made to your Google Sheet.
I'll show you all of this and more. We have a lot to cover, so let's get started.
- Explain why it is beneficial to use a template spreadsheet in Google Sheets rather than start from scratch.
- Name the action you would need to take to make data fit in a column on a Google sheet.
- List the steps to include multiple lines in a cell.
- Explain how to use the iframe code for a chart when publishing it to a website.
- Recall the main advantage of using IFTTT services with Google Sheets.
- Recognize situations where Google Sheets email notifications would be useful.