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.

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.

Microsoft Teams

Microsoft Whiteboard