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

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

This class will be a one-hour demonstration.

- Explain the merge process
- Use the Mail Merge task pane and the MAILINGS tab on the ribbon
- Use a letter template as the main document for a mail merge
- Create and edit a data source
- Insert merge fields in a main document
- Use an IF field in a main document
- Merge form letters
- Select records to merge
- Sort data records
- Address and print mailing labels and envelopes
- Change page orientation
- Merge all data records to a directory

Prerequisite: Some experience with Word and 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.

- Open image files
- Select and use tools in the Tools panel
- Set options using the options bar
- Use various methods to Zoom in and out
- Select and use panels and context menus
- Layers panel
- Adjustments panel

Prerequisite: Some experience with Photoshop.

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.

Prerequisite: Some experience with PowerPoint.

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 stunning visuals with Canva

Work with Graphics

Edit Photos

Photo Collage

Create a Gif

Work with Slide Shows

Edit and enhance Videos

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.

- Plan a chart
- Create a chart
- Move and resize a chart
- Change the chart design
- Change the chart format
- Format a chart
- Annotate and draw on a chart
- Create a pie chart
- Sparklines

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.

- Explain the merge process
- Use the Mail Merge task pane and the MAILINGS tab on the ribbon
- Use a letter template as the main document for a mail merge
- Create and edit a data source
- Insert merge fields in a main document
- Use an IF field in a main document
- Merge form letters
- Select records to merge
- Sort data records
- Address and print mailing labels and envelopes
- Change page orientation
- Merge all data records to a directory

Prerequisite: Some experience with Word and 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.

Prerequisite: Some experience with Access.

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 959 6759 2160 and the password is 895901.

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

This will be a one-hour demonstration class:

Find solutions to problems encountered when using Excel formulas.

#DIVO!

#ERROR!

#NA!

#NAME!

#NUM!

#VALUE!

#REF!

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 99958903102 and the passcode is qka2FO02.

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 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 a one-hour demonstration.

This class is an introduction to Adobe Acrobat Pro DC. We will cover:
Introduction to Acrobat screens and tools
Convert a PDF image to a PDF with text recognition
Editing text and images
Add pages from other files
Using comments
Adding signatures


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.

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 973 1289 6035 and the password is 251779.

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
- IFERROR 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 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 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.

- Learn about each type of question available in a Form
- Create a new form
- Create questions using some different question types
- Learn formatting options for questions
- See non-question entries: Title cards, videos, images
- Understand the Settings options
- Use the Form preview option
- Publish, share with responders, share with collaborators
- Look at Responses Summary and Responses Spreadsheet

Prerequisite: Some experience with Google Sheets and 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. 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.

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 a 30 minute demonstration.

- Why use templates
- Where to find premade templates (Google and your organization)
- How to use templates
- Turn an ordinary Google Doc or Sheet into a template: letterhead, memo, fax sheet, timesheet, sign up sheet, etc.
- How to submit your new template
- How to edit or delete your template
- How to make a template that is private to you, and shared by a link

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 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 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
- 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.

Smart Chips
- Insert smart chips in your Google Doc to include information about: dates, people, files, Google Calendar events, places, and more
- Hover or click on a chip to get more information
- Insert placeholder chips (Docs only) for editors to add the information later

Building Blocks
- Email or Calendar drafts, table templates of different types with prebuilt placeholders and dropdown menus

Dropdowns
- Insert dropdowns to reduce time and errors
- Create your own or use preset choices
- If changing existing data in a Sheet to a table, Sheets will automatically create dropdowns (these can be edited)
- In Sheets, choose to reject entries that aren't on menu, or just give a warning
- Add, edit or rearrange the dropdown menus

Prerequisite: Some experience with Google 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.

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 97207813599 and the passcode is S2x5ird1.