Catalog: MHRIC Central School District (Web Registration)

Search Options

Search Results (1 - 99 of 99)

1. Access - Building and Using Queries (D)

Program: Office Professional Applications Learning

Location: Online (n/a, na)

Dates: 6/18/2021

Meeting Times: 11:00 am - 12:00 pm

Starting Today
This class will be a one-hour demonstration.

- Use the Query Wizard
- Work with data in a query
- Use Query Design view
- Sort and find data
- Filter data
- Apply AND criteria
- Apply OR criteria
- Format a datasheet

Prerequisite: Some experience with Access.

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.

2. Specialty Projects Workshop - June

Program: Office Professional Applications Learning

Location: Online (n/a, na)

Dates: 6/21/2021 to 6/30/2021

Meeting Times: 2 hours to be arranged with instructor.

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

- Open ONLY to employees of districts subscribed to our Technology Support Service (TSS) and Office Automation (OA) CoSers
- 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 free and available ONLY to employees of districts that belong to the TSS or OA CoSers. See our website to check if your district is a member of either:
https://www.mhric.org/training/tss/tss-districts
https://www.mhric.org/training/office-automation/oa-districts

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

If you have any questions, please contact our Office Professional Applications Learning (OPAL) team at OPAL@mhric.org.

3. Access - Getting Started (D)

Program: Office Professional Applications Learning

Location: Online (n/a, na)

Dates: 7/7/2021

Meeting Times: 2:30 - 3:30 pm

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

4. Illustrator - Getting Started (D)

Program: Office Professional Applications Learning

Location: Online (n/a, na)

Dates: 7/7/2021

Meeting Times: 10:00 - 11:00 am

New
This class will be a one-hour demonstration.

- Differentiate between the various selection tools
- Use different selection techniques
- Recognize smart guides
- Save selections for future use
- Hide and lock Items
- Use tools and commands to align shapes and points: To each other, To the artboard
- Group and Ungroup items
- Work in isolation mode

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.

5. Making ADA Accessible Documents

Program: Office Professional Applications Learning

Location: Online (n/a, na)

Dates: 7/7/2021

Meeting Times: 8:30 am - 10:15 am

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

The ADA (Americans with Disabilities Act) Standards state that information technology, which includes web content, must be accessible to people with disabilities. In this class, we will address the basics of accessible web content by creating well-structured and accessible Word documents and Adobe PDFs. We will then use Adobe Acrobat Pro DC's Accessibility Tools to check documents for accessibility and fix problems.

Prerequisite: Some experience with Word.

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.

6. Chromebook Overview

Program: Office Professional Applications Learning

Location: Online (n/a, na)

Dates: 7/8/2021

Meeting Times: 10:45 am - 12:30 pm

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.

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

7. PowerPoint - Getting Started (D)

Program: Office Professional Applications Learning

Location: Online (n/a, na)

Dates: 7/8/2021

Meeting Times: 3:00 - 4:00 pm

This class will be a one-hour demonstration.

- Define presentation software
- Plan an effective presentation
- Examine the PowerPoint window
- Use templates
- Enter slide text
- Add a new slide
- Apply a design theme
- Compare presentation views
- Inserting Speaker notes
- Print a PowerPoint presentation

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.

8. Windows & File Management (D)

Program: Office Professional Applications Learning

Location: Online (n/a, na)

Dates: 7/8/2021

Meeting Times: 10:00 pm - 11:00 am

This class will be a one-hour demonstration.

- Understand files and folders
- Create and save a file
- Explore the files and folders on your computer
- Change file and folder views
- Open, edit, and save files
- Copy files
- Move and rename files
- Search for files and folders
- Delete and restore files

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.

9. Excel - Getting Started (D)

Program: Office Professional Applications Learning

Location: Online (n/a, na)

Dates: 7/9/2021

Meeting Times: 9:30 - 10:30 am

New
This class will be a one-hour demonstration.

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

10. Photoshop - Getting Started (D)

Program: Office Professional Applications Learning

Location: Online (n/a, na)

Dates: 7/12/2021

Meeting Times: 1:00 - 2:00 pm

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

11. PowerPoint - Links and Action Buttons (D)

Program: Office Professional Applications Learning

Location: Online (n/a, na)

Dates: 7/12/2021

Meeting Times: 1:00 pm - 2:00 pm

This class will be a one-hour demonstration.

PowerPoint - Links and Action Buttons
Jeopardy Game
- Create Slides
- Add Action button
- Add Home button
- Link to appropriate slides
- Make Slide duplicates
- Create rectangles for the points in the game
- Use the Selection pane to navigate the rectangles and name them strategically as this will be important for triggersv - Use triggered animation to disable used squares
Prerequisite: Some experience with PowerPoint.

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.

12. Excel - Working with Formulas and Functions (D)

Program: Office Professional Applications Learning

Location: Online (n/a, na)

Dates: 7/14/2021

Meeting Times: 9:30 - 10:30 am

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

13. Google Drive and G Suite Overview

Program: Office Professional Applications Learning

Location: Online (n/a, na)

Dates: 7/14/2021

Meeting Times: 10:45 am - 12:30 pm

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

14. Adobe Acrobat Pro DC: Editing PDF Basics

Program: Office Professional Applications Learning

Location: Online (n/a, na)

Dates: 7/15/2021

Meeting Times: 8:30 am - 10:15 am

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.

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

15. Word - Getting Started (D)

Program: Office Professional Applications Learning

Location: Online (n/a, na)

Dates: 7/15/2021

Meeting Times: 9:30 - 10:30 am

This class will be a one-hour demonstration.

- Explore the Word window
- Ribbon
- Start a document
- Save a document
- Select text
- Format text using the Mini toolbar
- Use a document template
- Navigate a document

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.

16. Excel - Lookup Functions (D)

Program: Office Professional Applications Learning

Location: Online (n/a, na)

Dates: 7/16/2021

Meeting Times: 9:30 - 10:30 am

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

17. Access - Building and Using Queries (D)

Program: Office Professional Applications Learning

Location: Online (n/a, na)

Dates: 7/19/2021

Meeting Times: 9:30 - 10:30 am

This class will be a one-hour demonstration.

- Use the Query Wizard
- Work with data in a query
- Use Query Design view
- Sort and find data
- Filter data
- Apply AND criteria
- Apply OR criteria
- Format a datasheet

Prerequisite: Some experience with Access.

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.

18. Excel Made Easy - Make Spreadsheets work for you

Program: Office Professional Applications Learning

Location: Online (n/a, na)

Dates: 7/19/2021

Meeting Times: 1:00 pm - 2:45 pm

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 how to create spreadsheets that work. Excel has multiple tools to make your tasks easier. These tools rely on spreadsheets being constructed properly. We will cover the basics of spreadsheet construction, and acquire skills that make Excel easy to work with such as formatting, sums, sorts and more.

Prerequisite: Some experience with Excel.

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.

19. Google Slides

Program: Office Professional Applications Learning

Location: Online (n/a, na)

Dates: 7/20/2021

Meeting Times: 8:30 am - 10:15 am

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

20. Adobe Acrobat Forms

Program: Office Professional Applications Learning

Location: Online (n/a, na)

Dates: 7/21/2021

Meeting Times: 10:45 am - 12:30 pm

New
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 fillable PDF forms in Adobe Acrobat. Whether starting from a scanned image of an old form or an idea that you have, we will step through the process of how to create interactive forms using Microsoft Word and Adobe Acrobat Pro DC.

Prerequisite: Some experience with Word.

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.

21. PowerPoint - Modifying a Presentation (D)

Program: Office Professional Applications Learning

Location: Online (n/a, na)

Dates: 7/21/2021

Meeting Times: 10:00 - 11:00 am

This class will be a one-hour demonstration.

- Enter text in Outline view
- Format text
- Convert text to SmartArt
- Insert and modify shapes
- Rearrange and merge shapes
- Edit and duplicate shapes
- Align and group objects
- Add slide footers

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.

22. Excel - Shortcuts, Tips & Tricks (D)

Program: Office Professional Applications Learning

Location: Online (n/a, na)

Dates: 7/22/2021

Meeting Times: 2:30 - 3:30 pm

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

23. Google Docs - Getting Started (D)

Program: Office Professional Applications Learning

Location: Online (n/a, na)

Dates: 7/22/2021

Meeting Times: 8:30 - 9:30 am

This class will be a one-hour demonstration.

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

24. Google Drive - "Shared with me" and "Shared drives"

Program: Office Professional Applications Learning

Location: Online (n/a, na)

Dates: 7/22/2021

Meeting Times: 8:30 am - 10:15 am

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

25. Word - Formatting Documents (D)

Program: Office Professional Applications Learning

Location: Online (n/a, na)

Dates: 7/23/2021

Meeting Times: 10:00 am - 11:00 am

This class will be a one-hour demonstration.

- Set Document margin
- Create section and columns
- Insert page breaks
- Insert page numbers
- Add headers and footers
- Insert a table
- Add footnotes and endnotes
- Insert citations
- Manage sources and create a bibliography

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.

26. Excel - Formatting a Worksheet (D)

Program: Office Professional Applications Learning

Location: Online (n/a, na)

Dates: 7/26/2021

Meeting Times: 3:00 - 4:00 pm

New
This class will be a one-hour demonstration.

- Format values
- Change font and font sizes
- Change font styles and alignment
- Adjust column width
- Insert and delete rows and columns
- Apply colors, patterns and borders
- Apply conditional formatting
- Rename and move a worksheet
- Check Spelling

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.

27. MS Office Templates

Program: Office Professional Applications Learning

Location: Online (n/a, na)

Dates: 7/26/2021

Meeting Times: 10:45 am - 12:30 pm

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.

- Define a template
- Use existing templates in Word and Excel
- Save our own document/spreadsheet as a template
- Edit/delete a template


Prerequisite: Some experience with Word and Excel.

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.

28. Outlook - Getting Started (D)

Program: Office Professional Applications Learning

Location: Online (n/a, na)

Dates: 7/26/2021

Meeting Times: 10:00 - 11:00 am

This class will be a one-hour demonstration.

- Communicate with email
- Use email address
- Create and send emails
- Understand folders
- Receive and reply to emails
- Send Attachments
- Forward and Organize emails

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.

29. Google Docs and Sheets Templates

Program: Office Professional Applications Learning

Location: Online (n/a, na)

Dates: 7/27/2021

Meeting Times: 8:30 am - 10:15 am

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

30. Google Sheets - Getting Started (D)

Program: Office Professional Applications Learning

Location: Online (n/a, na)

Dates: 7/27/2021

Meeting Times: 8:30 - 9:30 am

This class will be a one-hour demonstration.

- Create a new Sheet
- Basics data entry
- Basics of formatting
- Basics of functions/formulas: sum, average
- Organize into a folder
- Download to Excel
- Upload Excel to Google Sheets
- Share

Prerequisite: Some experience with internet browsers is helpful.

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.

31. Excel - Comparing Lists (D)

Program: Office Professional Applications Learning

Location: Online (n/a, na)

Dates: 7/28/2021

Meeting Times: 8:30 - 9:30 am

This class will be a one-hour demonstration.

- Remove duplicates based on one column
- Remove duplicates based on the entire row: Data/Remove Duplicates, Advanced Filter
- Finding uniques or duplicates among 2 different lists using conditional formatting (2 different methods): Using countif with range names, Selecting both lists simultaneously
- Possible additional topics: Compare Files, Data forms, Sorting

Prerequisite: Some experience with Excel.

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.

32. Google Forms - Getting Started

Program: Office Professional Applications Learning

Location: Online (n/a, na)

Dates: 7/28/2021

Meeting Times: 8:30am - 10:15am

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.

- Demo filling out a Google Form which displays each type of question available in forms
- Create a new form
- Create questions using the different question types
- Look at question options such as: add Title and Description, add Image, add Section
- Look at Settings options
- Preview the Form
- Send the form to be filled out vs Sharing the form 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 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.

33. Excel - Pivot Tables (D)

Program: Office Professional Applications Learning

Location: Online (n/a, na)

Dates: 7/29/2021

Meeting Times: 3:00 - 4:00 pm

This class will be a one-hour demonstration.

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

Prerequisite: Some experience with Excel.

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.

34. Google Forms - Branching into Sections

Program: Office Professional Applications Learning

Location: Online (n/a, na)

Dates: 7/29/2021

Meeting Times: 8:30 am - 10:15 am

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

35. Word - Editing Documents (D)

Program: Office Professional Applications Learning

Location: Online (n/a, na)

Dates: 7/29/2021

Meeting Times: 10:00 - 11:00 am

This class will be a one-hour demonstration.

- Cut and paste text
- Copy and paste text
- Use the Office clipboard
- Find and Replace text
- Check spelling and grammar
- Research information
- Add hyperlinks
- Work with document properties

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.

36. Google Calendar - Getting Started (D)

Program: Office Professional Applications Learning

Location: Online (n/a, na)

Dates: 7/30/2021

Meeting Times: 9:30 - 10:30 am

New
This class will be a one-hour demonstration.

- Create an event
- Add guests
- Add rooms, location, or conferencing
- Add an event description and attachments
- Choose an event color, calendar, and default visibility
- Set up notifications
- Save events
- Duplicating an event
- Update an existing event
- Change event owner
- Check guest responses
- Delete an event
- Restore a deleted event
- Reply to an invitation
- Propose a new time
- Open notes in Google Keep

Prerequisite: Some experience with Gmail.

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.

37. Excel - Working with Range Names (D)

Program: Office Professional Applications Learning

Location: Online (n/a, na)

Dates: 8/2/2021

Meeting Times: 10:00 - 11:00 am

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

38. Access - Using Forms (D)

Program: Office Professional Applications Learning

Location: Online (n/a, na)

Dates: 8/3/2021

Meeting Times: 2:30 - 3:30 pm

This class will be a one-hour demonstration.

- Use the Form Wizard
- Create a split form
- Use Form Layout View
- Add a field to a form
- Modify form controls
- Create calculations
- Modify tab order
- Insert an image
- Check Spelling

Prerequisite: Some experience with Access.

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.

39. Google Forms - Quizzes

Program: Office Professional Applications Learning

Location: Online (n/a, na)

Dates: 8/3/2021

Meeting Times: 8:30 am - 10:15 am

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 Quiz
- Look at Settings and Options
- Set up Questions, Answer Keys, and Feedback
- Look at Responses from students
- Grade Responses

Prerequisite: Some experience with Google Forms.

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.

40. Photoshop - Layer Basics (D)

Program: Office Professional Applications Learning

Location: Online (n/a, na)

Dates: 8/3/2021

Meeting Times: 2:30 - 3:30 pm

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

41. Word - Formatting Text, Paragraphs and Lists (D)

Program: Office Professional Applications Learning

Location: Online (n/a, na)

Dates: 8/3/2021

Meeting Times: 8:30 - 9:30 am

This class will be a one-hour demonstration.

- Format with fonts
- Use the Format Painter
- Change line and paragraph spacing
- Align paragraphs
- Work with tabs
- Work with indents
- Add bullets and numbering
- Add borders and shading
- Insert online pictures

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.

42. Excel - Working with Charts (D)

Program: Office Professional Applications Learning

Location: Online (n/a, na)

Dates: 8/4/2021

Meeting Times: 10:00 - 11:00 am

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

43. Excel Made Easy - Make Spreadsheets work for you

Program: Office Professional Applications Learning

Location: Online (n/a, na)

Dates: 8/4/2021

Meeting Times: 8:30 am - 10:15 am

New
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 how to create spreadsheets that work. Excel has multiple tools to make your tasks easier. These tools rely on spreadsheets being constructed properly. We will cover the basics of spreadsheet construction, and acquire skills that make Excel easy to work with such as formatting, sums, sorts and more.

Prerequisite: Some experience with Excel.

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.

44. Gmail - Getting Started (D)

Program: Office Professional Applications Learning

Location: Online (n/a, na)

Dates: 8/4/2021

Meeting Times: 2:30 - 3:30 pm

This class will be a one-hour demonstration.

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

45. Adobe Acrobat Pro DC: Editing PDF Basics

Program: Office Professional Applications Learning

Location: Online (n/a, na)

Dates: 8/5/2021

Meeting Times: 10:45 am - 12:30 pm

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

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

46. Google Docs - Getting Started (D)

Program: Office Professional Applications Learning

Location: Online (n/a, na)

Dates: 8/5/2021

Meeting Times: 2:30 - 3:30 pm

This class will be a one-hour demonstration.

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

47. PowerPoint - Inserting Objects into Presentation (D)

Program: Office Professional Applications Learning

Location: Online (n/a, na)

Dates: 8/5/2021

Meeting Times: 8:30 - 9:30 am

This class will be a one-hour demonstration.

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

48. Adobe Acrobat Forms

Program: Office Professional Applications Learning

Location: Online (n/a, na)

Dates: 8/9/2021

Meeting Times: 1:00 pm - 2:45 pm

New
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 fillable PDF forms in Adobe Acrobat. Whether starting from a scanned image of an old form or an idea that you have, we will step through the process of how to create interactive forms using Microsoft Word and Adobe Acrobat Pro DC.

Prerequisite: Some experience with Word.

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.

49. PowerPoint - Getting Started (D)

Program: Office Professional Applications Learning

Location: Online (n/a, na)

Dates: 8/9/2021

Meeting Times: 10:00 - 11:00 am

This class will be a one-hour demonstration.

- Define presentation software
- Plan an effective presentation
- Examine the PowerPoint window
- Use templates
- Enter slide text
- Add a new slide
- Apply a design theme
- Compare presentation views
- Inserting Speaker notes
- Print a PowerPoint presentation

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.

50. Excel - Data Analysis & Using Tables (D)

Program: Office Professional Applications Learning

Location: Online (n/a, na)

Dates: 8/10/2021

Meeting Times: 1:00 - 2:00 pm

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

51. Google Drive and G Suite Overview

Program: Office Professional Applications Learning

Location: Online (n/a, na)

Dates: 8/10/2021

Meeting Times: 8:30 am - 10:15 am

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

52. Mail Merge Using Microsoft Office (D)

Program: Office Professional Applications Learning

Location: Online (n/a, na)

Dates: 8/10/2021

Meeting Times: 10:00 - 11:00 am

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

53. Excel - Intro to Macros and VBA (D)

Program: Office Professional Applications Learning

Location: Online (n/a, na)

Dates: 8/11/2021

Meeting Times: 2:30 - 3:30 pm

This class will be a one-hour demonstration.

- Running Macros:
--- Macro Recorder, Shortcut Key
- Creating Macros:
--- Macro Recorder, The Visual Basic Editor
- Personal Macro Workbook
- Inserting a Macro Buttons:
--- Object, Toolbar

Prerequisite: Some experience with Excel.

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.

54. Google Sheets - Getting Started (D)

Program: Office Professional Applications Learning

Location: Online (n/a, na)

Dates: 8/11/2021

Meeting Times: 10:00 - 11:00 am

New
This class will be a one-hour demonstration.

- Create a new Sheet
- Basics data entry
- Basics of formatting
- Basics of functions/formulas: sum, average
- Organize into a folder
- Download to Excel
- Upload Excel to Google Sheets
- Share

Prerequisite: Some experience with internet browsers is helpful.

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.

55. Making ADA Accessible Documents

Program: Office Professional Applications Learning

Location: Online (n/a, na)

Dates: 8/11/2021

Meeting Times: 10:45 am - 12:30 pm

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

The ADA (Americans with Disabilities Act) Standards state that information technology, which includes web content, must be accessible to people with disabilities. In this class, we will address the basics of accessible web content by creating well-structured and accessible Word documents and Adobe PDFs. We will then use Adobe Acrobat Pro DC's Accessibility Tools to check documents for accessibility and fix problems.

Prerequisite: Some experience with Word.

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.

56. Access - Advanced Queries (D)

Program: Office Professional Applications Learning

Location: Online (n/a, na)

Dates: 8/12/2021

Meeting Times: 3:00 - 4:00 pm

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

57. PowerPoint - Links and Action Buttons (D)

Program: Office Professional Applications Learning

Location: Online (n/a, na)

Dates: 8/12/2021

Meeting Times: 10:00 am - 11:00 am

This class will be a one-hour demonstration.

PowerPoint - Links and Action Buttons
Jeopardy Game
- Create Slides
- Add Action button
- Add Home button
- Link to appropriate slides
- Make Slide duplicates
- Create rectangles for the points in the game
- Use the Selection pane to navigate the rectangles and name them strategically as this will be important for triggersv - Use triggered animation to disable used squares
Prerequisite: Some experience with PowerPoint.

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.

58. Word - Formatting Documents (D)

Program: Office Professional Applications Learning

Location: Online (n/a, na)

Dates: 8/12/2021

Meeting Times: 10:00 - 11:00 am

This class will be a one-hour demonstration.

- Set Document margin
- Create section and columns
- Insert page breaks
- Insert page numbers
- Add headers and footers
- Insert a table
- Add footnotes and endnotes
- Insert citations
- Manage sources and create a bibliography

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.

59. Illustrator - Using Shapes (D)

Program: Office Professional Applications Learning

Location: Online (n/a, na)

Dates: 8/13/2021

Meeting Times: 9:30 - 10:30 am

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

60. Access - Using Reports (D)

Program: Office Professional Applications Learning

Location: Online (n/a, na)

Dates: 8/16/2021

Meeting Times: 10:00 - 11:00 am

This class will be a one-hour demonstration.

- Use the Report Wizard
- Use Report Layout View
- Review Report Sections
- Apply group and sort orders
- Add subtotals and counts
- Resize and align controls
- Format a report
- Create mailing labels

Prerequisite: Some experience with Access.

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 Kathi Goodyear (845-255-1450 x1330 or kgoodyea@mhric.org) 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.

61. Excel - Working with Formulas and Functions (D)

Program: Office Professional Applications Learning

Location: Online (n/a, na)

Dates: 8/16/2021

Meeting Times: 3:00 - 4:00 pm

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

62. Google Slides

Program: Office Professional Applications Learning

Location: Online (n/a, na)

Dates: 8/16/2021

Meeting Times: 1:00 pm - 2:45 pm

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

63. Excel - Formatting a Worksheet (D)

Program: Office Professional Applications Learning

Location: Online (n/a, na)

Dates: 8/17/2021

Meeting Times: 8:30 - 9:30 am

This class will be a one-hour demonstration.

- Format values
- Change font and font sizes
- Change font styles and alignment
- Adjust column width
- Insert and delete rows and columns
- Apply colors, patterns and borders
- Apply conditional formatting
- Rename and move a worksheet
- Check Spelling

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.

64. PowerPoint - Adding Animations and Finishing a Presentation (D)

Program: Office Professional Applications Learning

Location: Online (n/a, na)

Dates: 8/17/2021

Meeting Times: 3:00 - 4:00 pm

This class will be a one-hour demonstration.

- Modify masters
- Customize the background and theme
- Use slide show commands
- Set slide transitions and timings
- Animate objects
- Use proofing and language tools
- Insert audio files: Time the music for when to start and stop
- Insert video: Trim the video to play to play a specific portion; Play the video full screen
- Pack up your fonts, sound files, and movies to play anywhere

Prerequisite: Some experience with PowerPoint.

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.

65. Google Drive - "Shared with me" and "Shared drives"

Program: Office Professional Applications Learning

Location: Online (n/a, na)

Dates: 8/18/2021

Meeting Times: 10:45 am - 12:30 pm

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

66. Word - Getting Started (D)

Program: Office Professional Applications Learning

Location: Online (n/a, na)

Dates: 8/18/2021

Meeting Times: 3:00 - 4:00 pm

This class will be a one-hour demonstration.

- Explore the Word window
- Ribbon
- Start a document
- Save a document
- Select text
- Format text using the Mini toolbar
- Use a document template
- Navigate a document

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.

67. Chromebook Overview

Program: Office Professional Applications Learning

Location: Online (n/a, na)

Dates: 8/19/2021

Meeting Times: 10:45 am - 12:30 pm

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

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

68. Excel - Shortcuts, Tips & Tricks (D)

Program: Office Professional Applications Learning

Location: Online (n/a, na)

Dates: 8/19/2021

Meeting Times: 8:30 - 9:30 am

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

69. Gmail - Getting Started (D)

Program: Office Professional Applications Learning

Location: Online (n/a, na)

Dates: 8/23/2021

Meeting Times: 2:30 - 3:30 pm

New
This class will be a one-hour demonstration.

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

70. Google Forms - Getting Started

Program: Office Professional Applications Learning

Location: Online (n/a, na)

Dates: 8/23/2021

Meeting Times: 1:00 pm - 2:45 pm

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

- Demo filling out a Google Form which displays each type of question available in forms
- Create a new form
- Create questions using the different question types
- Look at question options such as: add Title and Description, add Image, add Section
- Look at Settings options
- Preview the Form
- Send the form to be filled out vs Sharing the form 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 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.

71. Word - Editing Documents (D)

Program: Office Professional Applications Learning

Location: Online (n/a, na)

Dates: 8/23/2021

Meeting Times: 1:00 - 2:00 pm

This class will be a one-hour demonstration.

- Cut and paste text
- Copy and paste text
- Use the Office clipboard
- Find and Replace text
- Check spelling and grammar
- Research information
- Add hyperlinks
- Work with document properties

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.

72. Google Forms - Branching into Sections

Program: Office Professional Applications Learning

Location: Online (n/a, na)

Dates: 8/24/2021

Meeting Times: 1:00 pm - 2:45 pm

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

73. Word - Shortcuts, Tips & Tricks (D)

Program: Office Professional Applications Learning

Location: Online (n/a, na)

Dates: 8/24/2021

Meeting Times: 10:00 pm - 11:00 am

This class will be a one-hour demonstration.

- Customizing Word
- Keyboard Shortcuts
- Fonts
- Graphics
- Tables
- Headers/Footers
- Formatting
- Page Layout

Prerequisite: Some experience with Word.

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.

74. Excel - Intermediate Macros and VBA (D)

Program: Office Professional Applications Learning

Location: Online (n/a, na)

Dates: 8/25/2021

Meeting Times: 2:00 - 3:00 pm

This class will be a one-hour demonstration.

- Creating user defined functions
- Using loop structures
- Creating decision making code
- Overview of debugging code

Prerequisite: Some experience with Excel macros and VBA.

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.

75. Google Docs - Formatting Documents

Program: Office Professional Applications Learning

Location: Online (n/a, na)

Dates: 8/25/2021

Meeting Times: 10:45 am - 12:30 pm

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

76. Excel - Getting Started (D)

Program: Office Professional Applications Learning

Location: Online (n/a, na)

Dates: 8/26/2021

Meeting Times: 10:00 - 11:00 am

New
This class will be a one-hour demonstration.

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

77. Google Sheets - Conditional Formatting

Program: Office Professional Applications Learning

Location: Online (n/a, na)

Dates: 8/26/2021

Meeting Times: 10:45 am - 12:30 pm

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

78. Excel - Getting Started (D)

Program: Office Professional Applications Learning

Location: Online (n/a, na)

Dates: 9/20/2021

Meeting Times: 4:00 - 5:00 pm

New
This class will be a one-hour demonstration.

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

79. Photoshop - Getting Started (D)

Program: Office Professional Applications Learning

Location: Online (n/a, na)

Dates: 9/20/2021

Meeting Times: 2:30 - 3:30 pm

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

80. Word - Graphics (D)

Program: Office Professional Applications Learning

Location: Online (n/a, na)

Dates: 9/20/2021

Meeting Times: 1:00 - 2:00 pm

This class will be a one-hour demonstration.

-Add, arrange and format text boxes
-Insert clip art and pictures
-Draw AutoShapes
-Text wrapping, aligning and grouping objects
-Flipping and rotating
-Layering, shadows and 3-D
-WordArt

Prerequisite: Some experience with Word.

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.

81. MS Publisher - Getting Started (D)

Program: Office Professional Applications Learning

Location: Online (n/a, na)

Dates: 9/21/2021

Meeting Times: 11:30 am - 12:30 pm

This class will be a one-hour demonstration. MS Publisher - Getting Started
Creating a publication using a template
Adding and deleting pages
Inserting text from other files
Inserting graphics
Connecting text frames and adding "continued” notes
Inserting page numbers
Using Building Blocks such as advertisements and calendars
Working with the master pages

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.

82. PowerPoint - Getting Started (D)

Program: Office Professional Applications Learning

Location: Online (n/a, na)

Dates: 9/21/2021

Meeting Times: 8:30 - 9:30 am

This class will be a one-hour demonstration.

- Define presentation software
- Plan an effective presentation
- Examine the PowerPoint window
- Use templates
- Enter slide text
- Add a new slide
- Apply a design theme
- Compare presentation views
- Inserting Speaker notes
- Print a PowerPoint presentation

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.

83. Excel - Shortcuts, Tips & Tricks (D)

Program: Office Professional Applications Learning

Location: Online (n/a, na)

Dates: 9/22/2021

Meeting Times: 1:30 - 2:30 pm

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

84. Illustrator - Getting Started (D)

Program: Office Professional Applications Learning

Location: Online (n/a, na)

Dates: 9/22/2021

Meeting Times: 12:00 - 1:00 pm

This class will be a one-hour demonstration.

- Differentiate between the various selection tools
- Use different selection techniques
- Recognize smart guides
- Save selections for future use
- Hide and lock Items
- Use tools and commands to align shapes and points: To each other, To the artboard
- Group and Ungroup items
- Work in isolation mode

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.

85. PowerPoint - Modifying a Presentation (D)

Program: Office Professional Applications Learning

Location: Online (n/a, na)

Dates: 9/22/2021

Meeting Times: 3:00 - 4:00 pm

This class will be a one-hour demonstration.

- Enter text in Outline view
- Format text
- Convert text to SmartArt
- Insert and modify shapes
- Rearrange and merge shapes
- Edit and duplicate shapes
- Align and group objects
- Add slide footers

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.

86. Word Tables (D)

Program: Office Professional Applications Learning

Location: Online (n/a, na)

Dates: 9/22/2021

Meeting Times: 11:30 am - 12:30 pm

New
This class will be a one-hour demonstration.

Are you confident with word processing but get confused when you have to create or work with tables? If so, then this class is for you. Topics will include creating tables; adjusting table size; adding, deleting, and moving rows and columns; merging and splitting cells; working with borders and shading; sorting; and more. With this new knowledge, you will be able to create schedules, calendars, resumes, and lists with ease.

Prerequisite: Some experience with Word.

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.

87. Access - Building and Using Queries (D)

Program: Office Professional Applications Learning

Location: Online (n/a, na)

Dates: 9/23/2021

Meeting Times: 1:00 - 2:00 pm

This class will be a one-hour demonstration.

- Use the Query Wizard
- Work with data in a query
- Use Query Design view
- Sort and find data
- Filter data
- Apply AND criteria
- Apply OR criteria
- Format a datasheet

Prerequisite: Some experience with Access.

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.

88. Google Forms - Quizzes (D)

Program: Office Professional Applications Learning

Location: Online (n/a, na)

Dates: 9/23/2021

Meeting Times: 3:00 pm - 4:00 pm

New
This class will be a one-hour demonstration.

- Create a Quiz
- Look at Settings and Options
- Set up Questions, Answer Keys, and Feedback
- Look at Responses from students
- Grade Responses

Prerequisite: Some experience with Google Forms.

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.

89. Google Calendar - Getting Started (D)

Program: Office Professional Applications Learning

Location: Online (n/a, na)

Dates: 9/24/2021

Meeting Times: 10:00 - 11:00 am

New
This class will be a one-hour demonstration.

- Create an event
- Add guests
- Add rooms, location, or conferencing
- Add an event description and attachments
- Choose an event color, calendar, and default visibility
- Set up notifications
- Save events
- Duplicating an event
- Update an existing event
- Change event owner
- Check guest responses
- Delete an event
- Restore a deleted event
- Reply to an invitation
- Propose a new time
- Open notes in Google Keep

Prerequisite: Some experience with Gmail.

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.

90. Excel - Working with Formulas and Functions (D)

Program: Office Professional Applications Learning

Location: Online (n/a, na)

Dates: 9/27/2021

Meeting Times: 1:00 - 2:00 pm

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

91. PowerPoint - Inserting Objects into Presentation (D)

Program: Office Professional Applications Learning

Location: Online (n/a, na)

Dates: 9/27/2021

Meeting Times: 2:30 - 3:30 pm

This class will be a one-hour demonstration.

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

92. Word Styles (D)

Program: Office Professional Applications Learning

Location: Online (n/a, na)

Dates: 9/27/2021

Meeting Times: 11:30 am - 12:30 pm

This class will be a one-hour demonstration.

Styles in Word help you to create consistent, well formatted documents. Styles also make it easy to navigate through long documents using the Navigation Pane. We will see how to apply Styles, Style Sets, Themes, and how to modify and create Styles.

Prerequisite: Some experience with Word.

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.

93. Google Sheets - Getting Started (D)

Program: Office Professional Applications Learning

Location: Online (n/a, na)

Dates: 9/28/2021

Meeting Times: 1:00 - 2:00 pm

New
This class will be a one-hour demonstration.

- Create a new Sheet
- Basics data entry
- Basics of formatting
- Basics of functions/formulas: sum, average
- Organize into a folder
- Download to Excel
- Upload Excel to Google Sheets
- Share

Prerequisite: Some experience with internet browsers is helpful.

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.

94. Word - Forms (D)

Program: Office Professional Applications Learning

Location: Online (n/a, na)

Dates: 9/28/2021

Meeting Times: 11:30 am - 12:30 pm

New
This class will be a one-hour demonstration.

- Display the Developer tab on the ribbon
- Show Legacy Form tools
- Review Word Templates
- Create the document that will be the form
- Add Controls
- Set Control properties
- Show how to protect the entire Form, or parts of the Form
- Save as a Word Template
- Fill out the Form

Prerequisite: Some experience with Word.

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.

95. Access - Automating with VBA and Macros (D)

Program: Office Professional Applications Learning

Location: Online (n/a, na)

Dates: 9/29/2021

Meeting Times: 3:00 - 4:00 pm

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

96. Google Docs - Getting Started (D)

Program: Office Professional Applications Learning

Location: Online (n/a, na)

Dates: 9/29/2021

Meeting Times: 1:30 - 2:30 pm

New
This class will be a one-hour demonstration.

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

97. Mail Merge Using Microsoft Office (D)

Program: Office Professional Applications Learning

Location: Online (n/a, na)

Dates: 9/29/2021

Meeting Times: 12:00 - 1:00 pm

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

98. Word Long Documents, Manuals & Handbooks (D)

Program: Office Professional Applications Learning

Location: Online (n/a, na)

Dates: 9/29/2021

Meeting Times: 11:30 am - 12:30 pm

This class will be a one-hour demonstration.

How to work with lengthy documents in Word
Work with page numbering
Document sections
Table of Contents
Indexes
Styles
Tables that span multiple pages
Bookmarks
Cross-references

Prerequisite: Experience with Word.

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.

99. PowerPoint - Adding Animations and Finishing a Presentation (D)

Program: Office Professional Applications Learning

Location: Online (n/a, na)

Dates: 9/30/2021

Meeting Times: 10:00 - 11:00 am

This class will be a one-hour demonstration.

- Modify masters
- Customize the background and theme
- Use slide show commands
- Set slide transitions and timings
- Animate objects
- Use proofing and language tools
- Insert audio files: Time the music for when to start and stop
- Insert video: Trim the video to play to play a specific portion; Play the video full screen
- Pack up your fonts, sound files, and movies to play anywhere

Prerequisite: Some experience with PowerPoint.

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.