Google Training for School Secretaries and Administrative Assistants
Below you will find sessions for Google Sheets. Most sessions are an hour and half. Small large group training sessions are available in-person and virtually. To register or inquire about specific training sessions make sure to email us at evolving@evolvingeducators.com.
Google Sheets Descriptions
Beginner
Session Description: Google Sheets is a powerful tool for organizing information. We will show you the basics of sheets. We will explore how to work with Microsoft Office files, and use shortcuts to create new files. Learn how to create document templates and see changes to Drive files and folders. Finally, we will show you how to switch to a different version of your file, share “Make a copy” links to your files, restrict sharing options on Drive files, set an expiration date for file access, and transfer ownership of a file.
Session Description: Google Sheets is a powerful tool for organizing information. We will show you the basics of sheets. We will explore how to work with Microsoft Office files, and use shortcuts to create new files. Learn how to create document templates and see changes to Drive files and folders. Finally, we will show you how to switch to a different version of your file, share “Make a copy” links to your files, restrict sharing options on Drive files, set an expiration date for file access, and transfer ownership of a file.
Intermediate
Session Description: Join us as we take a deeper dive into Google Sheets. During our session, we will learn how to summarize data with charts, insert and edit charts. Learn how to share content with multiple people and send emails to collaborators. We will also explore how to filter data in a spreadsheet and protect the content of the spreadsheet. Finally, we will learn how to see data changes with conditional formatting and get notified about spreadsheet changes.
Session Description: Join us as we take a deeper dive into Google Sheets. During our session, we will learn how to summarize data with charts, insert and edit charts. Learn how to share content with multiple people and send emails to collaborators. We will also explore how to filter data in a spreadsheet and protect the content of the spreadsheet. Finally, we will learn how to see data changes with conditional formatting and get notified about spreadsheet changes.
Advanced
Session Description: In this advanced Google Sheets workshop, participants will learn how to make data more manageable and valuable. We will cover how to import data from another spreadsheet and link to data in a spreadsheet. We will create and edit pivot tables. We will split data into columns and learn how to use a few formulas. Participants will also learn how to share a file publicly, publish files like web pages, and create digital sign-in sheets for events.
Session Description: In this advanced Google Sheets workshop, participants will learn how to make data more manageable and valuable. We will cover how to import data from another spreadsheet and link to data in a spreadsheet. We will create and edit pivot tables. We will split data into columns and learn how to use a few formulas. Participants will also learn how to share a file publicly, publish files like web pages, and create digital sign-in sheets for events.
Google Tips and Tricks: Mail Merge with Google Sheets!
Session Description: In this session, learn how to create a mail merge with Google Sheets and Docs. We will explore how to Create a mail merge using Gmail and Google Sheets. We will also explore how to create labels using Google Sheets and Google Docs. This session is designed for those with an intermediate understanding of Google Sheets, Docs, and Gmail. Please note that you need Mail Merger and Avery Label Maker Add-ons installed to participate in this workshop.
Session Description: In this session, learn how to create a mail merge with Google Sheets and Docs. We will explore how to Create a mail merge using Gmail and Google Sheets. We will also explore how to create labels using Google Sheets and Google Docs. This session is designed for those with an intermediate understanding of Google Sheets, Docs, and Gmail. Please note that you need Mail Merger and Avery Label Maker Add-ons installed to participate in this workshop.
