Staff Training

-

Thursday, September 29, 2022

    • 10:00 am - 12:00 pm   Thurs. afternoon
    • Digital Computer Lab 1304 W. Springfield Ave., Urbana, IL Rm L410 (lower level)

    In this 2 hr workshop, participants will learn how to create and work with Access tables. We will create a table using application parts and also from scratch.  We will create a primary key and start entering data. We will work with fields in a table from adding, deleting, re-arranging to setting field properties. Finish up using lookup fields and calculated fields

    • 1:00 - 3:00 pm   Thur afternoon

    In this 2-hour online workshop we will explore the Visio interface and create graphics. Visio comes with diagram-specific shapes and tools that enable you to quickly create professional-looking flowcharts, organization charts, timelines, & more. We will learn how to create some basic shapes, and connect, distribute, and align them with Auto-connect. Register by 8 for link.

Friday, September 30, 2022

    • 10:00 am - 12:00 pm   Fri. morning
    • Digital Computer Lab 1304 W. Springfield Ave., Urbana, IL Rm L410 (lower level)

    In this 2-hour online workshop we will explore the whole set of features for managing information in Excel tables. These features make all the typical tabular manipulations—sorting, filtering, analyzing, and formatting, easier than ever.

Tuesday, October 4, 2022

    • 1:00 - 3:00 pm   Tu afternoon
    • L410 Digital Computer Lab, 1304 W Springfield, Urbana

    n this 2-hour in-person, instructor led short course you will learn how to specific features and tips on managing email more efficiently from conversation view to rules to pre-sort messages and moving folders around.

Wednesday, October 5, 2022

    • 9:00 - 11:00 am   W morning

    This 2 hour Outlook Calendar live workshop, participants will learn to schedule & edit appointments; work with calendar labels and tasks displayed on the Calendar. We will schedule with the Scheduling Assistant, practice scheduling a conference room, and discuss scheduling Online Meetings, and discuss calendar permissions. Link sent if registered by 8 am

    • 10:00 - 11:00 am   Wed morning
    • online

    In this 1 hour short online course you will learn how to work with Excel Pivot Tables and Pivot Charts. Topics include learning how to create a Pivot Table; rearrange and then format the data; set filters including the use of Slicers and Timelines; and finally creating a Pivot Chart of the data in the Pivot Table. This workshop is aimed at beginner users of Pivot Tables.

Thursday, October 6, 2022

    • 9:00 - 10:00 am   Th morning

    We have many options for scheduling online meetings these days. We will use Outlook for a central place to keep track of several kinds of online meetings and to make sure we have reminders. We will look at recommendations for scheduling with Skype for Business, Zoom and Microsoft Teams. Link sent if registered by 8 am.

    • 10:00 am - 12:00 pm   Thurs morning
    • L410 Digital Computer Lab, 1304 W. Springfield Ave., Urbana

    In this 2-hour in-person workshop we will explore the Word interface while we type text on a page, fix spelling errors, change spacing and page margins, and save our work. We will practice navigating the document; select text to make revisions; and move text by cutting and pasting. Formatting tools will be next, where we will learn how to emphasize text.

    • 1:00 - 3:00 pm   Thurs. afternoon
    • L410 Digital Computer Lab, 1304 W. Springfield Ave., Urbana

    In this 2-hour in-person workshop we will explore the mail merge features in Word including working with various data sources such as Excel and Access; working with rules; and creating and printing labels. We will also take a look at email merges using Outlook.

Friday, October 7, 2022

    • 10:00 am - 12:00 pm   Fri. morning
    • L410 Digital Computer Lab 1304 W. Springfield Ave., Urbana

    In this 2-hour in-person session, we will work with graphics in Microsoft Word. Topics covered will include learning how to add pictures and online images in a Word document; work with shapes; format, resize, move and crop images, and finish with creating and modifying an organization chart.

Tuesday, October 11, 2022

    • 10:00 - 11:00 am   Tues. morning
    • online

    In this 1-hour online course, you will learn about conditional formatting of data in Microsoft Excel. Topics will also include applying special formatting to numbers.

    • 2:00 - 3:00 pm   Tue afternoon

    Microsoft Teams is a communications platform available through MS Office 365. During this two-hour live online workshop, we will focus on the Teams experience from a team member’s perspective. Topics will include learning how to navigate Teams ; communicating in Teams (including chat); setting and managing notifications of Team activity. Link sent if registered by noon.

Wednesday, October 12, 2022

    • 9:00 - 11:00 am   Wed. morning
    • online

    In this short online course you will learn how to use some of the data analysis features and tools using Excel. Topics will include learning how to subtotal a list of data; set up data validation rules; use Goal Seek, Solver, and Scenarios and basic data tables.

    • 9:00 - 11:00 am   Wed morning

    Join us in a live, online session using OneNote 365 where we will discuss the structure of notebooks, practice putting data into them, and explore the interconnectivity of Microsoft applications with OneNote. This session is aimed for beginner users of OneNote. Link sent if registered by 8 am

    • 3:00 - 5:00 pm   W afternoon

    In this two-hour Illustrator session, we will go over recommended resources and tutorials, then participants will be introduced to the user interface while creating a vector graphic logo. This workshop is online; register by noon to be sent the link.

Thursday, October 13, 2022

    • 10:00 am - 12:00 pm   Thurs. morning
    • Digital Computer Lab 1304 W. Springfield Ave., Urbana, IL Rm L410 (lower level)

    In this 2-hour course learn how to create and work with Access forms. Create a new form using the form wizard and explore layout and design view. Add and modify form controls including a calculated control and lookup control.

    • 1:00 - 3:00 pm   Thurs. afternoon
    • L410 Digital Computer Lab, 1304 W. Springfield Ave., Urbana

    Have you been asked to put together a PowerPoint presentation, but you're not sure how to start? Participate in this short in-person course and learn the basics, including how to create slides and put content in them. We will also learn how to format and custom design the slides.

    • 3:00 - 5:00 pm   Th afternoon

    In this 2-hour workshop, participants will learn the basics of using the drawing tools in Adobe Illustrator CC, including how to use the Pencil and Curvature tools, how to edit paths. Then we will look at layers, including how to create, edit, and organize content. We will also learn the basics of transforming and editing artwork in Adobe Illustrator.

Tuesday, October 18, 2022

    • 2:00 - 3:00 pm   Tues afternoon

    Microsoft Teams is a communications platform available through MS Office 365. During this two-hour live online workshop, we will focus on the Teams experience from a team member’s perspective. Topics include learning how to navigate Teams ; communicating with others in Teams (including chat); setting and managing notifications of Team activity. Link sent if registered by 8

Wednesday, October 19, 2022

    • 9:00 - 11:00 am   W morning

    In this 2-hour workshop, participants will learn how to create and open InDesign documents, navigate the user interface, modify a document, import graphics, and manipulate basic text and text frames. Register by noon to receive the Zoom link.

    • 1:00 - 3:00 pm   Wed. afternoon
    • online

    This 2-hour online class introduces the Access query object.  Topics include working in design view; creating a simple query by adding and removing fields and adding criterion. We will create multi-table queries; calculated fields and set field properties; explore a totals query, parameter query, and action queries.

    • 3:00 - 5:00 pm   W afternoon
    • L410 Digital Computer Lab, 1304 W Springfield, Urbana

    In this 2-hour in[person, instructor led workshop we will explore the Visio interface and create graphics. Visio comes with diagram-specific shapes and tools that enable you to quickly create professional-looking flowcharts, organization charts, timelines, & more. We will learn how to create some basic shapes, and connect, distribute, and align them with Auto-connect.

Thursday, October 20, 2022

    • 9:00 - 11:00 am   Th morning

    Register for this 2-hour Outlook session to learn about specific features and tips for using Outlook more productively. Zoom link sent if registered by 8 am.

    • 10:00 am - 12:00 pm   Thurs. morning
    • L410 Digital Computer Lab, 1304 W. Springfield Ave., Urbana

    In this 2-hour in-person course, you will become familiar with the Excel's interface. Topics will also include entering, editing, and formatting data in a worksheet, performing basic formulas, printing and using Help.

    • 1:00 - 3:00 pm   Thur afternoon

    Join us in an online session using OneNote where we will discuss the structure of notebooks and how OneNote notebooks work within MS Teams. Prereq: understand Teams and MS OneNote. Link sent if registered by 8 am