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

- Defining Range Names: Using Name Box; Create from Selection
- The Name Manager
- Using Range Names in formulas: F3 key; Applying to existing formulas
- 3-D Names

Prerequisite: Some experience with Excel.

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

- Appointment Slots vs Appointment Schedules

- Need a work or school Google account can create
- Anyone one can schedule an appointment with you (Slots requires a Google account)
- Create dedicated calendar (optional)
- Create time block to split into Slots
- Customize duration, repeats, (optional) calendar, (optional) sign-in to your organization
- Customize description: information, links
- Duplicate/edit to create other blocks
- Let others help manage (optional) dedicated calendar
- Get link to email or embed on a website
- 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 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.

- Creating Pivot Tables
- Modifying Pivot Tables
- Creating Pivot Charts
- Insert Slicers
- Insert Timelines

Prerequisite: Some experience with Excel.

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

- Google Slides Screen elements
- Create new presentation
- Introduce Slide layouts
- Edit slides
- Add slides
- Delete slides
- Move slides
- Speaker notes
- Designs, custom backgrounds
- Print options
- View options, view presentation
- Add transitions and text animations
- Presenter view (if time allows)

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 two hours of interactive instruction, tailored to your needs.

- Open ONLY to employees of districts subscribed to our Office Professional Applications Learning (OPAL) CoSer
- One-on-one, two hour sessions
- Scheduled at the mutual convenience of the registrant and our trainer, sometime during the month
- Help with any software product in our current catalog or that we have offered in the recent past
- Work on a special project, problem, or general training
- When you register, we will contact you to ask for specifics of your need

This class is available ONLY to employees of districts that belong to the Office Professional Applications Learning (OPAL) CoSer. Check our website for current members (https://www.mhric.org/offerings/opal-districts).

Note: The instructor will email a link to each person whose topic and time have been arranged, regardless of Approval status.

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

Open ONLY to employees of districts subscribed to our Office Professional Applications Learning (OPAL) CoSer.

This class will be a fifteen-minute demonstration.

This class is available ONLY to employees of districts that belong to the Office Professional Applications Learning (OPAL) CoSer. Check our website for current members (https://www.mhric.org/offerings/opal-districts).

Note: The instructor will email a link to each registrant, 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 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.

- Choose the Density (spacing) of Calendar
- Choose a Color Set for your calendar
- Change the default color for each calendar you view
- Use different calendar views: day, week, month, year, schedule
- Manage general event settings
- Set default guest permissions
- Manage your view options
- Set a custom view
- Set your working hours
- Customize individual calendars: Access permissions, Event notifications, Other notifications, Daily email of that day's agenda
- Customize individual events: Color, Notifications, Guest permissions

Prerequisite: Some experience with Google Calendar.

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 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 standalone Drawing in Drive
- Add/arrange/size shapes
- Use lines and connectors
- Draw free-hand
- Add text: inside shapes; text boxes; Word Art
- Insert and annotate images
- Adjust object locations
- Customize objects: color, size, border
- Copy objects
- Group objects to move together
- Insert and customize Diagram templates
- Create new Drawing in Doc, Sheet or Slide
- Insert existing Drawing into Doc
- Copy/paste existing Drawing into Slide
- Download: standalone Drawing from Drive; Drawing from a Slide

Prerequisite: Some experience with Google Drive.

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

- Choose the Density (spacing) of items in your inbox
- Use a Theme
- Change your Inbox Type
- Include a Reading Pane
- Use Conversation View
- Create and manage Signatures
- Turn Hover Actions off or on
- Move or hide Hangouts/Chat and Meet

Prerequisite: Some experience with Gmail.

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

- Understand relational databases
- Explore a database
- Create a database
- Create a table
- Create primary keys
- Relate two tables
- Enter data
- Edit data

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.

A Heartland Account Specialist will be presenting an array of topics, including news about upcoming and newly released software updates.

This meeting is recommended for anyone who regularly uses Mosaic as well as anyone who would like to learn more about the system.

This meeting is for Mosaic Food Service Member Districts only.

The deadline for registration is Tuesday, August 30th. The Zoom link will be emailed to all registrants a week before the event, and periodically to those who register in the last week.

Please email foodservice@mhric.org if you need any additional information.

A Heartland Account Specialist will be presenting an array of topics, including news about upcoming and newly released software updates.

This meeting is recommended for anyone who regularly uses WebSMARTT as well as anyone who would like to learn more about the system.

This meeting is for WebSMARTT Food Service Member Districts only.

The deadline for registration is Tuesday, August 30th. The Zoom link will be emailed to all registrants a week before the event, and periodically to those who register in the last week.

Please email foodservice@mhric.org if you need any additional information.

This class will be two hours of interactive instruction, tailored to your needs.

- Open ONLY to employees of districts subscribed to our Office Professional Applications Learning (OPAL) CoSer
- One-on-one, two hour sessions
- Scheduled at the mutual convenience of the registrant and our trainer, sometime during the month
- Help with any software product in our current catalog or that we have offered in the recent past
- Work on a special project, problem, or general training
- When you register, we will contact you to ask for specifics of your need

This class is available ONLY to employees of districts that belong to the Office Professional Applications Learning (OPAL) CoSer. Check our website for current members (https://www.mhric.org/offerings/opal-districts).

Note: The instructor will email a link to each person whose topic and time have been arranged, regardless of Approval status.

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.

- Insert text from Microsoft Word
- Insert and style a picture
- Insert a text box
- Insert a chart
- Enter and edit chart data
- Insert slides from other presentations
- Insert a table
- Insert and format WordArt

Prerequisite: Some experience with PowerPoint.

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.

Open ONLY to employees of districts subscribed to our Office Professional Applications Learning (OPAL) CoSer.

This class will be a fifteen-minute demonstration.

This class is available ONLY to employees of districts that belong to the Office Professional Applications Learning (OPAL) CoSer. Check our website for current members (https://www.mhric.org/offerings/opal-districts).

Note: The instructor will email a link to each registrant, 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.

- 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

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.

- Perform calculations on groups of records using totals
- Create crosstab queries to summarize grouped data
- Create action queries
-- to add records to an existing table
-- to delete specific records from a table
-- to update to modify data in tables
- Use a make table query

Prerequisite: Some experience with Access Queries.

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.

- Working with forms
- Working with events
- Control statements
- Program flow

Prerequisite: Some experience with Access.

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.

- Grouping
- Filters
- Show only a specified data set
- Summary options
- Remove duplicates
- Multi level sorting
- Table management tools
--- Insert/Table
--- Table Ribbon
--- Automatic Filtering (Total row shows totals for the filtered data, not the whole table)
--- Add rows and columns
--- Table Style options, banded rows, Total row, etc
--- Working with basic functions & formulas (automatic fill, subtotal function)
--- Convert to Range (make sure to remove formatting first)

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

- What is Google Drive?
- Compare with MS Windows & Office
- Screen elements:
--- Drive, New, Star, Recent, Preview, Trash, Views (Grid, List), Share with me, Shared Drives
- Create a document
--- Differences from MS Word: name file, auto save, star, move to folder, comments, suggest mode, make a copy
- Create a folder
- Organize files
- Download options
- Upload
- Share
- Version history

Prerequisite: Some experience with internet browsers is helpful.

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

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

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

Open ONLY to employees of districts subscribed to our Office Professional Applications Learning (OPAL) CoSer.

This class will be fifteen minutes, with the following format:

- The instructor will present a quick tip;
- For the remaining time, participants can ask any question related to the general topic of the day (noted in the class name);
- If the instructor does not have an immediate answer to a question, they will research it and send a follow up email to all attendees.

This class is available ONLY to employees of districts that belong to the Office Professional Applications Learning (OPAL) CoSer. Check our website for current members (https://www.mhric.org/offerings/opal-districts).

Note: The instructor will email a link to each registrant, 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.

Open ONLY to employees of districts subscribed to our Office Professional Applications Learning (OPAL) CoSer.

This class will be a fifteen-minute demonstration.

This class is available ONLY to employees of districts that belong to the Office Professional Applications Learning (OPAL) CoSer. Check our website for current members (https://www.mhric.org/offerings/opal-districts).

Note: The instructor will email a link to each registrant, 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 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.

- Understand spreadsheet software
- Explore the Excel window
- Understand formulas
- Enter labels and values
- Use Autosum
- Edit cell entries
- Enter and Edit a simple formula
- Switch worksheet views
- Choose print options

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

- Create a complex formula
- Insert a function
- Type a function
- Copy and move cell entries
- Understand relative and absolute cell reference
- Copy formulas with relative cell references
- Copy formulas with absolute cell references
- Round a value with a function

Prerequisite: Some experience with Excel.

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

- Understanding labels vs folders
- Create labels
- Search your email using labels
- Remove and apply labels
- Manage labels
- Archiving using the inbox label
- Use filters to automatically organize messages
- Create a filter
- Manage filters

Prerequisite: Some experience with Gmail.

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

Open ONLY to employees of districts subscribed to our Office Professional Applications Learning (OPAL) CoSer.

This class will be a fifteen-minute demonstration.

This class is available ONLY to employees of districts that belong to the Office Professional Applications Learning (OPAL) CoSer. Check our website for current members (https://www.mhric.org/offerings/opal-districts).

Note: The instructor will email a link to each registrant, 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 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.

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

- Short review on Forms
- Show which question types allow the "Go to section based on answer” option
- Insert sections
- Navigate each potential answer to the related section
- From each section: Insert return to main list option; Insert submit option
- Preview the form
- Test the form
- Look at responses

Prerequisite: Some experience with Google Forms.

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.

Open ONLY to employees of districts subscribed to our Office Professional Applications Learning (OPAL) CoSer.

This class will be fifteen minutes, with the following format:

- The instructor will present a quick tip;
- For the remaining time, participants can ask any question related to the general topic of the day (noted in the class name);
- If the instructor does not have an immediate answer to a question, they will research it and send a follow up email to all attendees.

This class is available ONLY to employees of districts that belong to the Office Professional Applications Learning (OPAL) CoSer. Check our website for current members (https://www.mhric.org/offerings/opal-districts).

Note: The instructor will email a link to each registrant, 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.

Open ONLY to employees of districts subscribed to our Office Professional Applications Learning (OPAL) CoSer.

This class will be a fifteen-minute demonstration.

This class is available ONLY to employees of districts that belong to the Office Professional Applications Learning (OPAL) CoSer. Check our website for current members (https://www.mhric.org/offerings/opal-districts).

Note: The instructor will email a link to each registrant, 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.

- Google.com or the browser address field (Chrome and Firefox)
- Optional: Set your default search engine to Google
- Start with the basics
- Choose words carefully
- Don't worry about the little things (spelling and capitalization)
- Find quick answers
- Punctuation & symbols
- Search operators
- Filter your search results
- Advanced Search
- Find free-to-use images
- Turn SafeSearch on or off
- Delete searches & browsing activity
- Google Easter Eggs

Prerequisite: Some experience with internet browsers.

This class is free to employees of districts that belong to the Office Professional Applications Learning (OPAL) CoSer. See our website to check if your district is an OPAL member:
https://www.mhric.org/training/opal-districts

We encourage you to speak to your district regarding membership in this service. If your district is not a current member of the service or you are a community resident, you may still participate in these classes. Please contact us for more information at least one week before the class.

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

If you have any 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.

- Undo Send
- Schedule Send
- Send and Archive
- Email templates
- Smart Compose
- Smart Reply
- Snooze
- Nudges
- Vacation responder
- Contact Groups
- Confidential Mode

Prerequisite: Some experience with Gmail.

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

- Screen elements
- Create and send email
- Reply to email
- Edit recipients or subjects when replying
- Save and print attachments
- Understanding labels vs folders
- Star important email
- Use Importance markers
- Archive or delete email
- Search your inbox
- Open your Google Calendar and events
- Open notes in Google Keep
- Open your to-do lists in Google Tasks

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.

Open ONLY to employees of districts subscribed to our Office Professional Applications Learning (OPAL) CoSer.

This class will be a fifteen-minute demonstration.

This class is available ONLY to employees of districts that belong to the Office Professional Applications Learning (OPAL) CoSer. Check our website for current members (https://www.mhric.org/offerings/opal-districts).

Note: The instructor will email a link to each registrant, 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 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.

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