Lynda.com is a PMI Registered Education Provider. This course qualifies for professional development units (PDUs). To view the activity and PDU details for this course, click here.
The PMI Registered Education Provider logo is a registered mark of the Project Management Institute, Inc.
- 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.
Skill Level Intermediate
- [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.