Can't make any of the regularly scheduled classes? Need more assistance on a particular software product or application? Have a specific project you need to complete that you want support with? Have a targeted topic (previously coffee break class) that you need covered? Then individualized training is for you!

These sessions will be up to two hours of interactive one-on-one online instruction, tailored to your needs. In-person sessions are possible.

PLEASE USE THIS LINK TO SIGN UP FOR AN INDIVIDUALIZED TRAINING SESSION: Google Form

Drop-in on Zoom with our instructor to ask any questions that you may have regarding Google Workspace applications.

Use this time to start a conversation with our instructors about Google Workspace. If they don't know the answer, they will research and follow up with you.

Use this Zoom link to join at any time during this one-hour block. The meeting ID is 953 2778 2639 and the password is 631420.

For questions, please contact our Office Professional Applications Learning (OPAL) team at OPAL@mhric.org.

This class will be ninety minutes of interactive instruction. There will be exercises and feedback given through screen sharing. The instructor will be available for 15 minutes afterward for an optional Q&A.

- Change line and paragraph spacing
- Align paragraphs
- Indent text: tab key, indent icon
- Use the ruler to set custom indents
- Use tabs
- Add tab stops
- Add bullets and numbering
- Add borders and shading

Prerequisite: Some experience with Google Docs.

This class is free to employees of district members of the Office Professional Training (OPT) CoSer. Check our website for current members (https://www.mhric.org/offerings/opt-districts). We encourage you to speak to your district regarding membership in this service.

If your district is not a current member or if you are a community resident, you may still participate. Register at least five business days before the class and choose the appropriate payment option. (District PO: a budget amendment form is emailed to your business office.) Checks or signed amendments must be received at least 24 hours prior to the start of the class.

Note: The instructor will email the link to join each class to all registrants who are employees of our OPT districts or paid registrants, regardless of Approval status, about 15 - 30 minutes before each class.

For questions, please contact our Office Professional Training (OPT) team at opt@mhric.org.

This class will be forty-five minutes of interactive instruction. The instructor will be available for 15 minutes afterward for an optional Q&A.

Prerequisite: Some experience with Google Drive.

This class is free to employees of district members of the Office Professional Training (OPT) CoSer. Check our website for current members (https://www.mhric.org/offerings/opt-districts). We encourage you to speak to your district regarding membership in this service.

If your district is not a current member or if you are a community resident, you may still participate. Register at least five business days before the class and choose the appropriate payment option. (District PO: a budget amendment form is emailed to your business office.) Checks or signed amendments must be received at least 24 hours prior to the start of the class.

Note: The instructor will email the link to join each class to all registrants who are employees of our OPT districts or paid registrants, regardless of Approval status, about 15 - 30 minutes before each class.

For questions, please contact our Office Professional Training (OPT) team at opt@mhric.org.

This class will be one hour of interactive instruction. There will be exercises and feedback given through screen sharing. The instructor will be available for 15 minutes afterward for an optional Q&A.

Hiding/Unhiding sheets in a Google Sheet
- Who can hide/unhide sheets
- Where to see that there are hidden sheets
Restrict editing (Protect) Sheets and Cells in a Google Sheet
- How to open the Protected Sheets & Ranges panel
- Protect an entire sheet, a sheet except for certain cells, or a set of cells or a range in a sheet
- Set separate permissions for protected cells for other editors
- Allow editing but set a warning message
- See which cells/ranges are restricted
Share only specific column(s) from one Google Sheet to another

Prerequisite: Some experience with Google Sheets.

This class is free to employees of district members of the Office Professional Training (OPT) CoSer. Check our website for current members (https://www.mhric.org/offerings/opt-districts). We encourage you to speak to your district regarding membership in this service.

If your district is not a current member or if you are a community resident, you may still participate. Register at least five business days before the class and choose the appropriate payment option. (District PO: a budget amendment form is emailed to your business office.) Checks or signed amendments must be received at least 24 hours prior to the start of the class.

Note: The instructor will email the link to join each class to all registrants who are employees of our OPT districts or paid registrants, regardless of Approval status, about 15 - 30 minutes before each class.

For questions, please contact our Office Professional Training (OPT) team at opt@mhric.org.

Drop-in on Zoom with our instructor to ask any questions that you may have regarding Adobe applications.

Use this time to start a conversation with our instructors about Microsoft products. If they don't know the answer, they will research and follow up with you.

Use this Zoom link to join at any time during this one-hour block. The meeting ID is 954 1416 1127 and the password is 977831.

For questions, please contact our Office Professional Training (OPT) team at OPT@mhric.org.

This class will be a one-hour demonstration.

This class is an introduction. We will cover:
Create a Design
Use a templates
Working with Elements
Save and download your design
Creating Mail Merge in Canva

This class is free to employees of district members of the Office Professional Training (OPT) CoSer. Check our website for current members (https://www.mhric.org/offerings/opt-districts). We encourage you to speak to your district regarding membership in this service.

If your district is not a current member or if you are a community resident, you may still participate. Register at least five business days before the class and choose the appropriate payment option. (District PO: a budget amendment form is emailed to your business office.) Checks or signed amendments must be received at least 24 hours prior to the start of the class.

Note: The instructor will email the link to join each class to all registrants who are employees of our OPT districts or paid registrants, regardless of Approval status, about 15 - 30 minutes before each class.

For questions, please contact our Office Professional Training (OPT) team at opt@mhric.org.

This class will be one hour of demo instruction on OneDrive, the Microsoft cloud service that connects you to all your files.

This class is free to employees of district members of the Office Professional Training (OPT) CoSer. Check our website for current members (https://www.mhric.org/offerings/opt-districts). We encourage you to speak to your district regarding membership in this service.

If your district is not a current member or if you are a community resident, you may still participate. Register at least five business days before the class and choose the appropriate payment option. (District PO: a budget amendment form is emailed to your business office.) Checks or signed amendments must be received at least 24 hours prior to the start of the class.

Note: The instructor will email the link to join each class to all registrants who are employees of our OPT districts or paid registrants, regardless of Approval status, about 15 - 30 minutes before each class.

For questions, please contact our Office Professional Training (OPT) team at opt@mhric.org.

This class will be a one-hour demonstration.

- Use layers to organize artwork
- Create, view, hide and select layers
- Rearrange layers to change stacking order
- Resize and rotate layers
- Apply a gradient
- Apply blending and filters to layers
- Add text and layer effects
- Add an adjustment layer
- Flatten layers with save as

This class is free to employees of district members of the Office Professional Applications Learning (OPAL) CoSer. Check our website for current members (https://www.mhric.org/offerings/opal-districts). We encourage you to speak to your district regarding membership in this service.

If your district is not a current member or if you are a community resident, you may still participate. Register at least five business days before the class and choose the appropriate payment option. (District PO: a budget amendment form is emailed to your business office.) Checks or signed amendments must be received at least 24 hours prior to the start of the class.

Note: The instructor will email the link to join each class to all registrants who are employees of our OPAL districts or paid registrants, regardless of Approval status, about 15 - 30 minutes before each class.

For questions, please contact our Office Professional Applications Learning (OPAL) team at OPAL@mhric.org.

This class will be a one-hour demonstration.

- Amazing Excel Facts
- Customizing Excel
- Keyboard Shortcuts
- Worksheets
- Charts
- Headers/Footers
- Formatting
- Formulas

Prerequisite: Some Excel experience.

This class is free to employees of district members of the Office Professional Training (OPT) CoSer. Check our website for current members (https://www.mhric.org/offerings/opt-districts). We encourage you to speak to your district regarding membership in this service.

If your district is not a current member or if you are a community resident, you may still participate. Register at least five business days before the class and choose the appropriate payment option. (District PO: a budget amendment form is emailed to your business office.) Checks or signed amendments must be received at least 24 hours prior to the start of the class.

Note: The instructor will email the link to join each class to all registrants who are employees of our OPT districts or paid registrants, regardless of Approval status, about 15 - 30 minutes before each class.

For questions, please contact our Office Professional Training (OPT) team at opt@mhric.org.

This class will be forty-five minutes of interactive instruction. The instructor will be available for 15 minutes afterward for an optional Q&A.

Prerequisite: Some experience with Google Sheets.

This class is free to employees of district members of the Office Professional Training (OPT) CoSer. Check our website for current members (https://www.mhric.org/offerings/opt-districts). We encourage you to speak to your district regarding membership in this service.

If your district is not a current member or if you are a community resident, you may still participate. Register at least five business days before the class and choose the appropriate payment option. (District PO: a budget amendment form is emailed to your business office.) Checks or signed amendments must be received at least 24 hours prior to the start of the class.

Note: The instructor will email the link to join each class to all registrants who are employees of our OPT districts or paid registrants, regardless of Approval status, about 15 - 30 minutes before each class.

For questions, please contact our Office Professional Training (OPT) team at opt@mhric.org.

This class will be a one-hour demonstration.

- Create a document with multiple artboards
- Use tools and commands to create a variety of shapes
- Work with Live shapes
- Round Corners
- Work with drawing modes
- Work with the Shaper tool
- Use image trace to create shapes

This class is free to employees of district members of the Office Professional Training (OPT) CoSer. Check our website for current members (https://www.mhric.org/offerings/opt-districts). We encourage you to speak to your district regarding membership in this service.

If your district is not a current member or if you are a community resident, you may still participate. Register at least five business days before the class and choose the appropriate payment option. (District PO: a budget amendment form is emailed to your business office.) Checks or signed amendments must be received at least 24 hours prior to the start of the class.

Note: The instructor will email the link to join each class to all registrants who are employees of our OPT districts or paid registrants, regardless of Approval status, about 15 - 30 minutes before each class.

For questions, please contact our Office Professional Training (OPT) team at opt@mhric.org.

This class will be a 30 minute demonstration.

- Introduce the concept of templates
- Show premade templates
- Start from an ordinary Google Doc that is a good candidate for a template: letterhead, memo, fax sheet, etc
- Show where to save templates
- Use a template
- Edit a template
- Delete a template

Prerequisite: Some experience with Docs and Sheets.

This class is free to employees of district members of the Office Professional Training (OPT) CoSer. Check our website for current members (https://www.mhric.org/offerings/opt-districts). We encourage you to speak to your district regarding membership in this service.

If your district is not a current member or if you are a community resident, you may still participate. Register at least five business days before the class and choose the appropriate payment option. (District PO: a budget amendment form is emailed to your business office.) Checks or signed amendments must be received at least 24 hours prior to the start of the class.

Note: The instructor will email the link to join each class to all registrants who are employees of our OPT districts or paid registrants, regardless of Approval status, about 15 - 30 minutes before each class.

For questions, please contact our Office Professional Training (OPT) team at opt@mhric.org.

This class will be forty-five minutes of interactive instruction. The instructor will be available for 15 minutes afterward for an optional Q&A.

Prerequisite: Some experience with Google Slides.

This class is free to employees of district members of the Office Professional Training (OPT) CoSer. Check our website for current members (https://www.mhric.org/offerings/opt-districts). We encourage you to speak to your district regarding membership in this service.

If your district is not a current member or if you are a community resident, you may still participate. Register at least five business days before the class and choose the appropriate payment option. (District PO: a budget amendment form is emailed to your business office.) Checks or signed amendments must be received at least 24 hours prior to the start of the class.

Note: The instructor will email the link to join each class to all registrants who are employees of our OPT districts or paid registrants, regardless of Approval status, about 15 - 30 minutes before each class.

For questions, please contact our Office Professional Training (OPT) team at opt@mhric.org.

Drop-in on Zoom with our instructor to ask any questions that you may have regarding Adobe applications.

Use this time to start a conversation with our instructors about Adobe products. If they don't know the answer, they will research and follow up with you.

Use this Zoom link to join at any time during this one-hour block. The meeting ID is 996 7788 8254 and the password is 471308.

For questions, please contact our Office Professional Training (OPT) team at OPT@mhric.org.

This class will be a one-hour demonstration.

- Using the VLOOKUP statements
- Using the HLOOKUP statements
- Use Data Validation
- IS Function
- MATCH function
- INDEX

Prerequisite: Some experience with Excel.

This class is free to employees of district members of the Office Professional Training (OPT) CoSer. Check our website for current members (https://www.mhric.org/offerings/opt-districts). We encourage you to speak to your district regarding membership in this service.

If your district is not a current member or if you are a community resident, you may still participate. Register at least five business days before the class and choose the appropriate payment option. (District PO: a budget amendment form is emailed to your business office.) Checks or signed amendments must be received at least 24 hours prior to the start of the class.

Note: The instructor will email the link to join each class to all registrants who are employees of our OPT districts or paid registrants, regardless of Approval status, about 15 - 30 minutes before each class.

For questions, please contact our Office Professional Training (OPT) team at opt@mhric.org.

This class will be a one-hour demonstration.

This class is free to employees of district members of the Office Professional Training (OPT) CoSer. Check our website for current members (https://www.mhric.org/offerings/opt-districts). We encourage you to speak to your district regarding membership in this service.

If your district is not a current member or if you are a community resident, you may still participate. Register at least five business days before the class and choose the appropriate payment option. (District PO: a budget amendment form is emailed to your business office.) Checks or signed amendments must be received at least 24 hours prior to the start of the class.

Note: The instructor will email the link to join each class to all registrants who are employees of our OPT districts or paid registrants, regardless of Approval status, about 15 - 30 minutes before each class.

For questions, please contact our Office Professional Training (OPT) team at opt@mhric.org.

This class will be one hour of interactive instruction. There will be opportunities for individualized instruction. The instructor will be available for 15 minutes afterward for an optional Q&A.

- Appointment Schedules let anyone schedule an appointment with you
- You need a work or school Google account to create
- Create time blocks split into available appointments
- Updates to/from your Google Calendar
- Customize duration, repeats, description text/links
- (Optional) Verify email for non-Google accounts
- Get link to email or embed on webpage
- Individuals follow link to reserve
- See reserved appointments
- Delete reservation
- Print reservation list

Prerequisite: Some experience with Google Calendar.

This class is free to employees of district members of the Office Professional Training (OPT) CoSer. Check our website for current members (https://www.mhric.org/offerings/opt-districts). We encourage you to speak to your district regarding membership in this service.

If your district is not a current member or if you are a community resident, you may still participate. Register at least five business days before the class and choose the appropriate payment option. (District PO: a budget amendment form is emailed to your business office.) Checks or signed amendments must be received at least 24 hours prior to the start of the class.

Note: The instructor will email the link to join each class to all registrants who are employees of our OPT districts or paid registrants, regardless of Approval status, about 15 - 30 minutes before each class.

For questions, please contact our Office Professional Training (OPT) team at opt@mhric.org.

This class will be a one-hour demonstration.

InDesign is the program to work with for document lay out and print production. Work with text, colors, and graphics to create flyers, brochures, magazines, and books. Since InDesign uses many of the same tools, panels, and onscreen elements as other programs in Adobe's Creative Suite. We will look at the basics for getting started with InDesign such as inserting text, pictures, columns and saving as a PDF. This class is free to employees of district members of the Office Professional Training (OPT) CoSer. Check our website for current members (https://www.mhric.org/offerings/opt-districts). We encourage you to speak to your district regarding membership in this service.

If your district is not a current member or if you are a community resident, you may still participate. Register at least five business days before the class and choose the appropriate payment option. (District PO: a budget amendment form is emailed to your business office.) Checks or signed amendments must be received at least 24 hours prior to the start of the class.

Note: The instructor will email the link to join each class to all registrants who are employees of our OPT districts or paid registrants, regardless of Approval status, about 15 - 30 minutes before each class.

For questions, please contact our Office Professional Training (OPT) team at opt@mhric.org.

Drop-in on Zoom with our instructor to ask any questions that you may have regarding Google Workspace applications.

Use this time to start a conversation with our instructors about Google Workspace. If they don't know the answer, they will research and follow up with you.

Use this Zoom link to join at any time during this one-hour block. The meeting ID is 977 7311 1586 and the password is 526851.

This class will be forty-five minutes of interactive instruction. The instructor will be available for 15 minutes afterward for an optional Q&A.

Prerequisite: Some experience with Google Forms.

This class is free to employees of district members of the Office Professional Training (OPT) CoSer. Check our website for current members (https://www.mhric.org/offerings/opt-districts). We encourage you to speak to your district regarding membership in this service.

If your district is not a current member or if you are a community resident, you may still participate. Register at least five business days before the class and choose the appropriate payment option. (District PO: a budget amendment form is emailed to your business office.) Checks or signed amendments must be received at least 24 hours prior to the start of the class.

Note: The instructor will email the link to join each class to all registrants who are employees of our OPT districts or paid registrants, regardless of Approval status, about 15 - 30 minutes before each class.

For questions, please contact our Office Professional Training (OPT) team at opt@mhric.org.

This class will be forty-five minutes of interactive instruction. The instructor will be available for 15 minutes afterward for an optional Q&A.

Prerequisite: Some experience with Gmail.

This class is free to employees of district members of the Office Professional Training (OPT) CoSer. Check our website for current members (https://www.mhric.org/offerings/opt-districts). We encourage you to speak to your district regarding membership in this service.

If your district is not a current member or if you are a community resident, you may still participate. Register at least five business days before the class and choose the appropriate payment option. (District PO: a budget amendment form is emailed to your business office.) Checks or signed amendments must be received at least 24 hours prior to the start of the class.

Note: The instructor will email the link to join each class to all registrants who are employees of our OPT districts or paid registrants, regardless of Approval status, about 15 - 30 minutes before each class.

For questions, please contact our Office Professional Training (OPT) team at opt@mhric.org.

This class will be ninety minutes of interactive instruction. There will be exercises and feedback given through screen sharing. The instructor will be available for 15 minutes afterward for an optional Q&A.

- Share your calendar
- Manage access permissions for your calendar
- View other people's calendars
- Create additional calendars
- Subscribe and unsubscribe to calendars of interest
- Create a shared calendar
- Import and export events and calendars
- Delete a calendar
- Copy events from one calendar to another
- Change calendar owner

Prerequisite: Some experience with Google Calendar.

This class is free to employees of district members of the Office Professional Training (OPT) CoSer. Check our website for current members (https://www.mhric.org/offerings/opt-districts). We encourage you to speak to your district regarding membership in this service.

If your district is not a current member or if you are a community resident, you may still participate. Register at least five business days before the class and choose the appropriate payment option. (District PO: a budget amendment form is emailed to your business office.) Checks or signed amendments must be received at least 24 hours prior to the start of the class.

Note: The instructor will email the link to join each class to all registrants who are employees of our OPT districts or paid registrants, regardless of Approval status, about 15 - 30 minutes before each class.

For questions, please contact our Office Professional Training (OPT) team at opt@mhric.org.

This class will be ninety minutes of interactive instruction. There will be exercises and feedback given through screen sharing. The instructor will be available for 15 minutes afterward for an optional Q&A.

- Format with fonts
- Use the Format Painter
- Set document margins
- Create sections and columns
- Insert page breaks
- Insert page numbers
- Add headers and footers
- Insert and format a table
- Insert and format images

Prerequisite: Some experience with Google Docs.

This class is free to employees of district members of the Office Professional Training (OPT) CoSer. Check our website for current members (https://www.mhric.org/offerings/opt-districts). We encourage you to speak to your district regarding membership in this service.

If your district is not a current member or if you are a community resident, you may still participate. Register at least five business days before the class and choose the appropriate payment option. (District PO: a budget amendment form is emailed to your business office.) Checks or signed amendments must be received at least 24 hours prior to the start of the class.

Note: The instructor will email the link to join each class to all registrants who are employees of our OPT districts or paid registrants, regardless of Approval status, about 15 - 30 minutes before each class.

For questions, please contact our Office Professional Training (OPT) team at opt@mhric.org.

This class will be ninety minutes of interactive instruction. There will be exercises and feedback given through screen sharing. The instructor will be available for 15 minutes afterward for an optional Q&A.

- Create a new Doc
- Type a title and paragraph
- Basics of formatting
- Insert an image, text wrap
- Organize into a folder
- Download to Word
- Upload a Word document to Google Docs
- Share

Prerequisite: Some experience with internet browsers is helpful.

This class is free to employees of district members of the Office Professional Training (OPT) CoSer. Check our website for current members (https://www.mhric.org/offerings/opt-districts). We encourage you to speak to your district regarding membership in this service.

If your district is not a current member or if you are a community resident, you may still participate. Register at least five business days before the class and choose the appropriate payment option. (District PO: a budget amendment form is emailed to your business office.) Checks or signed amendments must be received at least 24 hours prior to the start of the class.

Note: The instructor will email the link to join each class to all registrants who are employees of our OPT districts or paid registrants, regardless of Approval status, about 15 - 30 minutes before each class.

For questions, please contact our Office Professional Training (OPT) team at opt@mhric.org.

This class will be forty-five minutes of interactive instruction. There will be exercises and feedback given through screen sharing. The instructor will be available for 15 minutes afterward for an optional Q&A.

- Use different methods for sorting data
- Sort by color (this will touch on Conditional Formatting)
- Filter data using: data points, text filters, date filters, number filters, and formulas
- Use Filter Views: create, save, share, and delete Filter Views

This class is free to employees of district members of the Office Professional Training (OPT) CoSer. Check our website for current members (https://www.mhric.org/offerings/opt-districts). We encourage you to speak to your district regarding membership in this service.

If your district is not a current member or if you are a community resident, you may still participate. Register at least five business days before the class and choose the appropriate payment option. (District PO: a budget amendment form is emailed to your business office.) Checks or signed amendments must be received at least 24 hours prior to the start of the class.

Note: The instructor will email the link to join each class to all registrants who are employees of our OPT districts or paid registrants, regardless of Approval status, about 15 - 30 minutes before each class.

For questions, please contact our Office Professional Training (OPT) team at opt@mhric.org.

This class will be ninety minutes of interactive instruction. There will be exercises and feedback given through screen sharing. The instructor will be available for 15 minutes afterward for an optional Q&A.

- Create rules to change formatting of cells, rows, or columns based on values: Numbers, Text, Dates, Formulas
- Single colors or a color scale
- Highlight blank or non-blank cells
- Apply formatting to cells based on contents of other cells
- Highlight duplicate values
- Format an entire row based on the value of one of the cells in that row
- Absolute vs. relative cell references
- Use wildcard characters
- Delete a rule
- Multiple rules: Order of application, Re-ordering rules
- Use alternating row colors

Prerequisite: Some experience with Google Sheets.

This class is free to employees of district members of the Office Professional Training (OPT) CoSer. Check our website for current members (https://www.mhric.org/offerings/opt-districts). We encourage you to speak to your district regarding membership in this service.

If your district is not a current member or if you are a community resident, you may still participate. Register at least five business days before the class and choose the appropriate payment option. (District PO: a budget amendment form is emailed to your business office.) Checks or signed amendments must be received at least 24 hours prior to the start of the class.

Note: The instructor will email the link to join each class to all registrants who are employees of our OPT districts or paid registrants, regardless of Approval status, about 15 - 30 minutes before each class.

For questions, please contact our Office Professional Training (OPT) team at opt@mhric.org.

This class will be forty-five minutes of interactive instruction. The instructor will be available for 15 minutes afterward for an optional Q&A.

Prerequisite: Some experience with Google Calendar.

This class is free to employees of district members of the Office Professional Training (OPT) CoSer. Check our website for current members (https://www.mhric.org/offerings/opt-districts). We encourage you to speak to your district regarding membership in this service.

If your district is not a current member or if you are a community resident, you may still participate. Register at least five business days before the class and choose the appropriate payment option. (District PO: a budget amendment form is emailed to your business office.) Checks or signed amendments must be received at least 24 hours prior to the start of the class.

Note: The instructor will email the link to join each class to all registrants who are employees of our OPT districts or paid registrants, regardless of Approval status, about 15 - 30 minutes before each class.

For questions, please contact our Office Professional Training (OPT) team at opt@mhric.org.

Drop-in on Zoom with our instructor to ask any questions that you may have regarding Google Workspace applications.

Use this time to start a conversation with our instructors about Google Workspace. If they don't know the answer, they will research and follow up with you.

Use this Zoom link to join at any time during this one-hour block. The meeting ID is 942 6058 2480 and the password is 443591.

This class will be forty-five minutes of interactive instruction. The instructor will be available for 15 minutes afterward for an optional Q&A.

Prerequisite: Some experience with Google Drive.

This class is free to employees of district members of the Office Professional Training (OPT) CoSer. Check our website for current members (https://www.mhric.org/offerings/opt-districts). We encourage you to speak to your district regarding membership in this service.

If your district is not a current member or if you are a community resident, you may still participate. Register at least five business days before the class and choose the appropriate payment option. (District PO: a budget amendment form is emailed to your business office.) Checks or signed amendments must be received at least 24 hours prior to the start of the class.

Note: The instructor will email the link to join each class to all registrants who are employees of our OPT districts or paid registrants, regardless of Approval status, about 15 - 30 minutes before each class.

For questions, please contact our Office Professional Training (OPT) team at opt@mhric.org.

This class will be one hour of interactive instruction. There will be exercises and feedback given through screen sharing. The instructor will be available for 15 minutes afterward for an optional Q&A.

Hiding/Unhiding sheets in a Google Sheet
- Who can hide/unhide sheets
- Where to see that there are hidden sheets
Restrict editing (Protect) Sheets and Cells in a Google Sheet
- How to open the Protected Sheets & Ranges panel
- Protect an entire sheet, a sheet except for certain cells, or a set of cells or a range in a sheet
- Set separate permissions for protected cells for other editors
- Allow editing but set a warning message
- See which cells/ranges are restricted
Share only specific column(s) from one Google Sheet to another

Prerequisite: Some experience with Google Sheets.

This class is free to employees of district members of the Office Professional Training (OPT) CoSer. Check our website for current members (https://www.mhric.org/offerings/opt-districts). We encourage you to speak to your district regarding membership in this service.

If your district is not a current member or if you are a community resident, you may still participate. Register at least five business days before the class and choose the appropriate payment option. (District PO: a budget amendment form is emailed to your business office.) Checks or signed amendments must be received at least 24 hours prior to the start of the class.

Note: The instructor will email the link to join each class to all registrants who are employees of our OPT districts or paid registrants, regardless of Approval status, about 15 - 30 minutes before each class.

For questions, please contact our Office Professional Training (OPT) team at opt@mhric.org.

This class will be forty-five minutes of interactive instruction. The instructor will be available for 15 minutes afterward for an optional Q&A.

Prerequisite: Some experience with Google Sheets.

This class is free to employees of district members of the Office Professional Training (OPT) CoSer. Check our website for current members (https://www.mhric.org/offerings/opt-districts). We encourage you to speak to your district regarding membership in this service.

If your district is not a current member or if you are a community resident, you may still participate. Register at least five business days before the class and choose the appropriate payment option. (District PO: a budget amendment form is emailed to your business office.) Checks or signed amendments must be received at least 24 hours prior to the start of the class.

Note: The instructor will email the link to join each class to all registrants who are employees of our OPT districts or paid registrants, regardless of Approval status, about 15 - 30 minutes before each class.

For questions, please contact our Office Professional Training (OPT) team at opt@mhric.org.

This class will be a one-hour demonstration.

- Introduction to Chromebooks via a presentation
- Fast boot up, SSD hard drive
- Screen elements
- Online Google productivity suite of apps
- Keyboard differences and keyboard shortcuts
- Creating more than one account on a Chromebook
- Pros & cons

This class is free to employees of district members of the Office Professional Training (OPT) CoSer. Check our website for current members (https://www.mhric.org/offerings/opt-districts). We encourage you to speak to your district regarding membership in this service.

If your district is not a current member or if you are a community resident, you may still participate. Register at least five business days before the class and choose the appropriate payment option. (District PO: a budget amendment form is emailed to your business office.) Checks or signed amendments must be received at least 24 hours prior to the start of the class.

Note: The instructor will email the link to join each class to all registrants who are employees of our OPT districts or paid registrants, regardless of Approval status, about 15 - 30 minutes before each class.

For questions, please contact our Office Professional Training (OPT) team at opt@mhric.org.

Drop-in on Zoom with our instructor to ask any questions that you may have regarding Google Workspace applications.

Use this time to start a conversation with our instructors about Google Workspace. If they don't know the answer, they will research and follow up with you.

Use this Zoom link to join at any time during this one-hour block. The meeting ID is 983 0357 5665 and the password is 164754.

If clicking the link does not work, copy and paste the link into your browser.

This class will be ninety minutes of interactive instruction. There will be exercises and feedback given through screen sharing. The instructor will be available for 15 minutes afterward for an optional Q&A.

Sharing Files and Folders
- Share file or folder with a link
- Share file or folder with specific individuals
- Stop sharing
Shared with me
- Organize files in Shared with me (shortcuts to Drive)
Shared Drives
- Create a Shared Drive
- Add members and set access levels
- Change member access levels
- Remove members
- Create a new folder in a Shared Drive
- Move files into a Shared Drive
- Delete and restore files from Trash
- Delete a Shared Drive

Prerequisite: Some experience with internet browsers is helpful.

This class is free to employees of district members of the Office Professional Training (OPT) CoSer. Check our website for current members (https://www.mhric.org/offerings/opt-districts). We encourage you to speak to your district regarding membership in this service.

If your district is not a current member or if you are a community resident, you may still participate. Register at least five business days before the class and choose the appropriate payment option. (District PO: a budget amendment form is emailed to your business office.) Checks or signed amendments must be received at least 24 hours prior to the start of the class.

Note: The instructor will email the link to join each class to all registrants who are employees of our OPT districts or paid registrants, regardless of Approval status, about 15 - 30 minutes before each class.

For questions, please contact our Office Professional Training (OPT) team at opt@mhric.org.

This class will be a 30 minute demonstration.

- Introduce the concept of templates
- Show premade templates
- Start from an ordinary Google Doc that is a good candidate for a template: letterhead, memo, fax sheet, etc
- Show where to save templates
- Use a template
- Edit a template
- Delete a template

Prerequisite: Some experience with Docs and Sheets.

This class is free to employees of district members of the Office Professional Training (OPT) CoSer. Check our website for current members (https://www.mhric.org/offerings/opt-districts). We encourage you to speak to your district regarding membership in this service.

If your district is not a current member or if you are a community resident, you may still participate. Register at least five business days before the class and choose the appropriate payment option. (District PO: a budget amendment form is emailed to your business office.) Checks or signed amendments must be received at least 24 hours prior to the start of the class.

Note: The instructor will email the link to join each class to all registrants who are employees of our OPT districts or paid registrants, regardless of Approval status, about 15 - 30 minutes before each class.

For questions, please contact our Office Professional Training (OPT) team at opt@mhric.org.

This class will be forty-five minutes of interactive instruction. The instructor will be available for 15 minutes afterward for an optional Q&A.

Prerequisite: Some experience with Google Forms.

This class is free to employees of district members of the Office Professional Training (OPT) CoSer. Check our website for current members (https://www.mhric.org/offerings/opt-districts). We encourage you to speak to your district regarding membership in this service.

If your district is not a current member or if you are a community resident, you may still participate. Register at least five business days before the class and choose the appropriate payment option. (District PO: a budget amendment form is emailed to your business office.) Checks or signed amendments must be received at least 24 hours prior to the start of the class.

Note: The instructor will email the link to join each class to all registrants who are employees of our OPT districts or paid registrants, regardless of Approval status, about 15 - 30 minutes before each class.

For questions, please contact our Office Professional Training (OPT) team at opt@mhric.org.

This class will be one hour of interactive instruction. There will be opportunities for individualized instruction. The instructor will be available for 15 minutes afterward for an optional Q&A.

- Appointment Schedules let anyone schedule an appointment with you
- You need a work or school Google account to create
- Create time blocks split into available appointments
- Updates to/from your Google Calendar
- Customize duration, repeats, description text/links
- (Optional) Verify email for non-Google accounts
- Get link to email or embed on webpage
- Individuals follow link to reserve
- See reserved appointments
- Delete reservation
- Print reservation list

Prerequisite: Some experience with Google Calendar.

This class is free to employees of district members of the Office Professional Training (OPT) CoSer. Check our website for current members (https://www.mhric.org/offerings/opt-districts). We encourage you to speak to your district regarding membership in this service.

If your district is not a current member or if you are a community resident, you may still participate. Register at least five business days before the class and choose the appropriate payment option. (District PO: a budget amendment form is emailed to your business office.) Checks or signed amendments must be received at least 24 hours prior to the start of the class.

Note: The instructor will email the link to join each class to all registrants who are employees of our OPT districts or paid registrants, regardless of Approval status, about 15 - 30 minutes before each class.

For questions, please contact our Office Professional Training (OPT) team at opt@mhric.org.

This class will be forty-five minutes of interactive instruction. The instructor will be available for 15 minutes afterward for an optional Q&A.

Prerequisite: Some experience with Google Docs.

This class is free to employees of district members of the Office Professional Training (OPT) CoSer. Check our website for current members (https://www.mhric.org/offerings/opt-districts). We encourage you to speak to your district regarding membership in this service.

If your district is not a current member or if you are a community resident, you may still participate. Register at least five business days before the class and choose the appropriate payment option. (District PO: a budget amendment form is emailed to your business office.) Checks or signed amendments must be received at least 24 hours prior to the start of the class.

Note: The instructor will email the link to join each class to all registrants who are employees of our OPT districts or paid registrants, regardless of Approval status, about 15 - 30 minutes before each class.

For questions, please contact our Office Professional Training (OPT) team at opt@mhric.org.

This class will be forty-five minutes of interactive instruction. There will be exercises and feedback given through screen sharing. The instructor will be available for 15 minutes afterward for an optional Q&A.

- Use different methods for sorting data
- Sort by color (this will touch on Conditional Formatting)
- Filter data using: data points, text filters, date filters, number filters, and formulas
- Use Filter Views: create, save, share, and delete Filter Views

This class is free to employees of district members of the Office Professional Training (OPT) CoSer. Check our website for current members (https://www.mhric.org/offerings/opt-districts). We encourage you to speak to your district regarding membership in this service.

If your district is not a current member or if you are a community resident, you may still participate. Register at least five business days before the class and choose the appropriate payment option. (District PO: a budget amendment form is emailed to your business office.) Checks or signed amendments must be received at least 24 hours prior to the start of the class.

Note: The instructor will email the link to join each class to all registrants who are employees of our OPT districts or paid registrants, regardless of Approval status, about 15 - 30 minutes before each class.

For questions, please contact our Office Professional Training (OPT) team at opt@mhric.org.