Google Sheets 3 - Advanced

Take this course if you've taken the level one and two courses already, and you're ready for the next steps, OR take this course if you are already a regular spreadsheet user, and want to add to your Google Sheets tool kit.

Resources for today's PD:

• Parking Lot - put questions you have here

• Example Spreadsheet (this is a link to a set of data we can use hands-on in our course)

• Finances Example Spreadsheet

• Useful formulas in Google Sheets:

  • https://www.lovesdata.com/blog/google-sheets-tips#google-sheets-tip-6

• Conditional Formatting Across an Entire Row

• Referring to data in another sheet

• Protecting Cells/Rows/Columns

• Introduction to Pivot Tables (video)