Advanced‎ > ‎

Advanced Spreadsheets


Google Spreadsheets
Use the training resources on this page to expand upon your basic Google Spreadsheet skills.  The more training you have using any tool, the more impact it will have on your students.
 
















Create a mail merge using Google apps scripts and forms


Watch the Google Gooru video below about how to create a mail merge using a Google apps script and Google forms.

How to create a mail merge using Google Apps Script



Add a second Y-axis to a chart in Google Spreadsheets


Watch the Google Gooru video below about how to add a second Y-Axis to a chart in Google Spreadsheets.

How to Add a Second YAxis to a Chart in Google Spreadsheets



Control values entered into a Google Spreadsheet

Watch the Google Gooru video below to learn how to control values entered into a Google Spreadsheet.

How to Control the Values entered into a Google Spreadsheet



Transposing data in Google Spreadsheets


Watch the Google Gooru video below to transpose data in Google Spreadsheets.

How to Transpose Data in Google Spreadsheets



Text-to-columns in Google Spreadsheets


Watch the Google Gooru video below about how to do text-to-columns Google Spreadsheets.

How to do text-to-columns in Google Spreadsheets



Pivot tables in Google Spreadsheets


Watch the Google Gooru video below to learn about pivot tables in Google Spreadsheets.

How to use Pivot Tables in Google Spreadsheets



How is DPS doing?



The DPS Google Support Site with further integration ideas and resources can be found here.




Comments