Parish, School or Site | Contact Us
Home /

My DioErie: Computer Training Materials


Windows 11 system requirements – is your PC compatible? | TechRadar
Computer Training Resources: 

A/V equipment:
Setting up/Breaking down the old projector screen:  This walk-through explains various ports available on laptops for use with external devices like monitors, projectors and USB drives or a keyboard or mouse.

Common ports:

Common laptop ports: This walk-through explains various ports available on laptops for use with external devices like monitors, projectors and USB drives or a keyboard or mouse.
Common desktop computer ports: This walk-through explains various ports available on desktop computer for use with external devices like monitors, projectors and USB drives or a keyboard or mouse.


How to properly wrap your computer's power cord. This video will ask you to log in to Microsoft Stream.   Use your eriercd.org email/password.

Microsoft Excel

Conditional Formatting:   Conditional formatting makes it easy to highlight certain values or make particular cells easy to identify. This changes the appearance of a cell range based on a condition (or criteria). You can use conditional formatting to highlight cells that contain values which meet a certain condition.
Filtering:  Filtering, as the name suggests, can help you eliminate unnecessary data. For example, if you want a group of people who live in Erie, you can filter the "City Name" field for Erie.   Filtering is dynamic meaning if you add 12 records and two of those records have addresses in Erie, the next time you filter, those 2 records will appear.  Used with “conditional formatting” filtering becomes even more important.  Be sure to watch the above conditional formatting videos.
Removing blank spaces:  https://www.facebook.com/reel/293712420033915

Microsoft Teams

Microsoft Whiteboard