Staff Training

-

Friday, February 15, 2019

    • 9:00 am - 12:00 pm   Fri morning
    • UIUC -- location to be announced

    In this 3-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. Learn about control properties, form properties and setting tab order.  Create a subform and learn about switchboard and navigation forms.

    • 12:00 - 1:00 pm
    • 314 Main Library. Take the north stairwell (Armory and Wright Street entrance) to the 3rd floor of the Main Library and make a left at the top of the stairs.

Monday, February 18, 2019

Tuesday, February 19, 2019

    • 9:00 - 11:00 am   **NEW TIME** Tue morning
    • UIUC -- location to be announced

    In this 2-hour short course you will learn how to add, divide, multiply, and subtract by entering formulas into Excel 2016 worksheets. Other topics will include an exploration of just a few of the hundreds of functions available in Excel. We will learn how to find a specific function, as well as how to get help while entering arguments.

    • 10:00 am - 12:00 pm   Tue morning
    • Illini Hall, Room 27 (lower level; NW corner of John & Wright Streets, Champaign)

    In this 2-hour workshop, participants will learn how to adjust a photo’s color and brightness in Lightroom; crop, straighten, and fix perspective, brush over certain parts of a photo for local adjustments; and work with photos on multiple devices. No prior knowledge of Lightroom is required.

    • 2:00 - 3:30 pm
    • 314 Main Library. Take the north stairwell (Armory and Wright Street entrance) to the 3rd floor of the Main Library and make a left at the top of the stairs.

Wednesday, February 20, 2019

Thursday, February 21, 2019

    • 11:00 am - 12:00 pm
    • 314 Main Library. Take the north stairwell (Armory and Wright Street entrance) to the 3rd floor of the Main Library and make a left at the top of the stairs.

    • 2:00 - 3:00 pm
    • 314 Main Library. Take the north stairwell (Armory and Wright Street entrance) to the 3rd floor of the Main Library and make a left at the top of the stairs.

Friday, February 22, 2019

Monday, February 25, 2019

    • 11:00 am - 12:00 pm
    • 314 Main Library. Take the north stairwell (Armory and Wright Street entrance) to the 3rd floor of the Main Library and make a left at the top of the stairs.

    • 1:00 - 4:00 pm   Mon afternoon
    • UIUC -- location to be announced

    This 3-hour class introduces the 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, action queries, find duplicates query, unmatched records query and basic SQL query.

    • 3:00 - 4:00 pm
    • 314 Main Library. Take the north stairwell (Armory and Wright Street entrance) to the 3rd floor of the Main Library and make a left at the top of the stairs.

Tuesday, February 26, 2019

    • 9:00 am - 12:00 pm   Tu morning
    • UIUC -- location to be announced

    In this 3-hour class learn how to create and work with Access reports. Create a basic report and explore layout and design view. Use the report wizard to create reports. In design view add controls and set properties for those controls; learn about calculated controls, apply sort & group feature to report data, finish up with graphics (themes and conditional formatting).

    • 1:00 - 2:00 pm
    • 314 Main Library. Take the north stairwell (Armory and Wright Street entrance) to the 3rd floor of the Main Library and make a left at the top of the stairs.

    • 3:00 - 4:00 pm
    • 314 Main Library. Take the north stairwell (Armory and Wright Street entrance) to the 3rd floor of the Main Library and make a left at the top of the stairs.

Wednesday, February 27, 2019

Thursday, February 28, 2019

Friday, March 1, 2019

    • 10:00 am - 12:00 pm   Fri morning
    • UIUC -- location to be announced

    In this short course you will learn how to use some of the data analysis features and tools in Excel 2016. Topics will include learning the basics of PivotTables; using subtotals in a list of data; setting up data validation rules; using Goal Seek, Solver, Scenarios and more.

Monday, March 4, 2019

Tuesday, March 5, 2019

    • 9:00 am - 12:00 pm   TuTh mornings
    • UIUC -- location to be announced

    • 1:00 - 3:00 pm   Tues afternoon
    • Illini Hall, room 27 (lower level; NW corner of John & Wright Streets, Champaign)

    In this 2-hour workshop, participants will learn how to create and open Illustrator documents, navigate the user interface, use vector shapes to create a logo that looks good on screen and in print. No prior knowledge of Illustrator is required.

    • 2:00 - 3:00 pm
    • 314 Main Library. Take the north stairwell (Armory and Wright Street entrance) to the 3rd floor of the Main Library and make a left at the top of the stairs.

Wednesday, March 6, 2019

    • 9:00 am - 12:00 pm   WF mornings
    • Illini Hall, room 27 (lower level; NW corner of John & Wright Streets, Champaign)

    This 6-hour course introduces the basics of Adobe Illustrator. Topics will include design principles, elements, and graphics composition; creating documents containing basic shapes and customized paths. We will also learn how to insert text and typographical characters.

    • 12:00 - 1:00 pm
    • 314 Main Library. Take the north stairwell (Armory and Wright Street entrance) to the 3rd floor of the Main Library and make a left at the top of the stairs.

    • 2:00 - 3:00 pm
    • 314 Main Library. Take the north stairwell (Armory and Wright Street entrance) to the 3rd floor of the Main Library and make a left at the top of the stairs.

Thursday, March 7, 2019

Monday, March 11, 2019

Tuesday, March 12, 2019

    • 10:00 - 11:00 am
    • 314 Main Library. Take the north stairwell (Armory and Wright Street entrance) to the 3rd floor of the Main Library and make a left at the top of the stairs.

    • 10:00 am - 12:00 pm   Tues. morning
    • UIUC -- location to be announced

    Have you been asked to put together a PowerPoint presentation, but you're not sure how to start? Take this short course and learn the basics, including how to use the new 2016 interface to create slides and put content on them; format and custom design the slides; and prepare speaker notes and handouts.

    • 11:00 am - 12:00 pm
    • 314 Main Library. Take the north stairwell (Armory and Wright Street entrance) to the 3rd floor of the Main Library and make a left at the top of the stairs.

Wednesday, March 13, 2019

    • 9:00 - 11:00 am   Wed morning
    • UIUC -- location to be announced

    Wish you had a smarter, more efficient way to arrange your Outlook 2016 email and more? In this two-hour workshop, you will learn how to use the conversation view; how to insert a screenshot into a message; sorting messages; advanced searching techniques, including filters; working with folders; using flags, color categories, and rules.

    • 1:00 - 2:00 pm
    • 314 Main Library. Take the north stairwell (Armory and Wright Street entrance) to the 3rd floor of the Main Library and make a left at the top of the stairs.

    • 2:00 - 3:00 pm
    • 314 Main Library. Take the north stairwell (Armory and Wright Street entrance) to the 3rd floor of the Main Library and make a left at the top of the stairs.

Thursday, March 14, 2019

    • 9:00 - 11:00 am   Thur morning
    • Illini Hall, room 27 (lower level; NW corner of John & Wright Streets, Champaign)

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

    • 2:00 - 3:00 pm
    • 314 Main Library. Take the north stairwell (Armory and Wright Street entrance) to the 3rd floor of the Main Library and make a left at the top of the stairs.

Monday, March 25, 2019

Tuesday, March 26, 2019

    • 1:00 - 4:00 pm   Tue/Wed aft
    • Illini Hall, Room 27 (lower level; NW corner of John & Wright Streets, Champaign)

    This 6 hour course will prepare you to use the most common basic features of Adobe Photoshop CC.

    • 1:00 - 4:00 pm   Tu/Th afternoon
    • UIUC -- location to be announced

    In this 6-hour course, attendees will begin by exploring the PowerPoint 2016 interface. Next we will create and save a presentation; view and navigate, and edit text on slides; add and modify graphical objects in a presentation; work with tables and charts; and prepare to deliver a presentation.

    • 2:00 - 3:00 pm
    • 314 Main Library. Take the north stairwell (Armory and Wright Street entrance) to the 3rd floor of the Main Library and make a left at the top of the stairs.

Wednesday, March 27, 2019

Thursday, March 28, 2019

Monday, April 1, 2019

Tuesday, April 2, 2019

    • 9:00 - 11:00 am   Tue morning
    • Illini Hall, Room 27 (lower level; NW corner of John & Wright Streets, Champaign)

    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.

    • 1:00 - 4:00 pm   Tu afternoon
    • UIUC -- location to be announced

    In this 3 hour course, we will go beyond how the program works to include organizational strategies and tips to hyperlink to other notebooks and files, integrating with the rest of MS Office including linking to Outlook with Tasks to add reminders, Meeting notes that integrate with Skype for Business and other meetings, and other tips to boost the power of OneNote.

    • 2:00 - 3:00 pm
    • 314 Main Library. Take the north stairwell (Armory and Wright Street entrance) to the 3rd floor of the Main Library and make a left at the top of the stairs.

Wednesday, April 3, 2019

    • 9:00   Wed, 9-4, lunch on your own
    • Illini Hall, room 27 (lower level; NW corner of John & Wright Streets, Champaign)

    InDesign is a desktop publishing program that combines incredible power and flexibility with a surprisingly easy-to-use interface -- for creating or editing everything from simple posters and brochures to multi-chapter books. We will do the basics in this 6 hour class.

    • 1:00 - 2:30 pm
    • 314 Main Library. Take the north stairwell (Armory and Wright Street entrance) to the 3rd floor of the Main Library and make a left at the top of the stairs.

Thursday, April 4, 2019

Friday, April 5, 2019

Monday, April 8, 2019

    • 10:00 am - 12:00 pm   Mon morning
    • Illini Hall, Room 27 (lower level; NW corner of John & Wright Streets, Champaign)

    • 1:00 - 4:00 pm   M and W afternoons
    • Illini Hall, Room 27 (lower level; NW corner of John & Wright Streets, Champaign)

    Extend your InDesign skills even further by learning to use InDesign's more advanced features effectively. We'll work more deeply with styles. You'll use clipping paths to reveal only part of an image, create type outlines, and create Bezier paths. We'll also import layered files, merge data into documents and create a book with table of contents and references.

    • 2:00 - 3:00 pm
    • 314 Main Library. Take the north stairwell (Armory and Wright Street entrance) to the 3rd floor of the Main Library and make a left at the top of the stairs.

Tuesday, April 9, 2019

    • 9:00 am - 12:00 pm   Tu and Th mornings
    • UIUC -- location to be announced

    In this 6-hour course, you will import and export data into Excel 2016, work with conditional formatting, and learn about macros. Additional topics will include summarizing data using subtotals and data validation; and analyzing data using Goal Seek and Solver along with what if scenarios. Prerequisite: Completion of Excel 2016 Level 1 or equivalent knowledge

    • 11:00 am - 12:00 pm
    • 314 Main Library. Take the north stairwell (Armory and Wright Street entrance) to the 3rd floor of the Main Library and make a left at the top of the stairs.

    • 1:00 - 3:00 pm   Tues afternoon
    • UIUC -- location to be announced

    This two-hour short course will introduce you to Microsoft's latest version of its relational database application, Access 2016. Attendees will take a tour of the objects in an Access database, including tables, queries, forms, and reports and spend some time working in the most important of all the objects--tables.

    • 1:00 - 3:00 pm   Tu afternoon
    • Illini Hall, Room 27 (lower level; NW corner of John & Wright Streets, Champaign)

    • 4:00 - 5:00 pm
    • 314 Main Library. Take the north stairwell (Armory and Wright Street entrance) to the 3rd floor of the Main Library and make a left at the top of the stairs.

    • 5:00 - 6:00 pm
    • 314 Main Library. Take the north stairwell (Armory and Wright Street entrance) to the 3rd floor of the Main Library and make a left at the top of the stairs.

Wednesday, April 10, 2019

Thursday, April 11, 2019

Monday, April 15, 2019

    • 1:00 - 4:00 pm   Mon and Wed afternoons
    • UIUC -- location to be announced

    This 6-hour, hands-on course is an intro to web page design using Dreamweaver CC. Students will become familiar with the Dreamweaver environment, interface elements, layout customization, website creation and publishing. Activities will include creating a new site, laying out basic pages and text, using text styles and containers, inserting images, uploading a simple site.

Tuesday, April 16, 2019

Wednesday, April 17, 2019

    • 9:00 am - 12:00 pm   W morning
    • UIUC -- location to be announced

    In this three-hour workshop attendees 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. Finally, we will work with fields in a table from adding, deleting, re-arranging to setting field properties and finally lookup fields and calculated fields.

    • 2:30 - 4:00 pm
    • 314 Main Library. Take the north stairwell (Armory and Wright Street entrance) to the 3rd floor of the Main Library and make a left at the top of the stairs.

Thursday, April 18, 2019

    • 10:00 am - 12:00 pm   Thur morning
    • UIUC -- location to be announced

    A properly designed database makes it easier to work with up-to-date, accurate information. Investing the time required to learn the principles of good relational database design ensures that you will end up with a database that meets your needs and can easily accommodate change. This new workshop provides guidelines for planning an Access database.

Monday, April 22, 2019

    • 10:00 am - 12:00 pm   Mon morning
    • Illini Hall, Room 27 (lower level; NW corner of John & Wright Streets, Champaign)

    In this 2-hour workshop, participants will learn how to adjust a photo’s color and brightness in Lightroom; crop, straighten, and fix perspective, brush over certain parts of a photo for local adjustments; and work with photos on multiple devices. No prior knowledge of Lightroom is required.

    • 1:00 - 3:00 pm   Mon afternoon
    • UIUC -- location to be announced

    In this 2-hour short course you will learn how to comfortably move around in the Excel 2016 environment. Additional topics will include entering text and values in a worksheet, basic formatting, printing and using Help.

    • 1:00 - 4:00 pm   Mon/Tue afternoons
    • Illini Hall, Room 27 (lower level; NW corner of John & Wright Streets, Champaign)

    This 6-hour course introduces the basics of Adobe Lightroom. Participants will work on the organization and management of photos, learning the Lightroom environment, managing images and workflow, reviewing images, sorting and organizing images as well as managing an image catalog.

Tuesday, April 23, 2019

    • 9:00 am - 12:00 pm   Tues. morning
    • UIUC -- location to be announced

    In this 3-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. Learn about control properties, form properties and setting tab order.  Create a subform and learn about switchboard and navigation forms.

Wednesday, April 24, 2019

    • 9:00 am - 12:00 pm   Wed & Thurs mornings
    • Illini Hall, Room 27 (lower level; NW corner of John & Wright Streets, Champaign)

    Lightroom Level 2 is the second course in Lightroom, utilizing the Develop module, to concentrate on making image corrections in a non-destructive manner. Topics include: Develop module basics, Image adjustment basics, working with color, fixing common image problems like straightening and cropping, as well as more advanced topics like creating snapshots and panoramas.

    • 10:00 am - 12:00 pm   Wed morning
    • UIUC -- location to be announced

    • 1:00 - 3:00 pm   Wed afternoon
    • UIUC -- location to be announced

    In this 2-hour short course you will learn how to add, divide, multiply, and subtract by entering formulas into Excel 2016 worksheets. Other topics will include an exploration of just a few of the hundreds of functions available in Excel. We will learn how to find a specific function, as well as how to get help while entering arguments.

Thursday, April 25, 2019

    • 1:00 - 4:00 pm   Thurs afternoon
    • UIUC -- location to be announced

    This 3-hour class introduces the 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, action queries, find duplicates query, unmatched records query and basic SQL query.

Monday, April 29, 2019

    • 3:00 - 5:00 pm   Mon afternoon
    • UIUC -- 27 Illini Hall

    In this 2-hour workshop, participants will access, organize, and share creative assets for use in your Adobe desktop and mobile apps. We will practice using Adobe’s CC Libraries in applications as well as using the Web interface to load frequently used assets, such as logos, wordmarks and colors. We will explore sharing and collaborating with colleagues.

Tuesday, April 30, 2019

    • 10:00 am - 12:00 pm   Tues. morning
    • UIUC -- location to be announced

    • 10:00 am - 12:00 pm   Tues. morning
    • UIUC -- location to be announced

    • 1:00 - 4:00 pm   Tu afternoon
    • UIUC -- location to be announced

    In this 3-hour class learn how to create and work with Access reports. Create a basic report and explore layout and design view. Use the report wizard to create reports. In design view add controls and set properties for those controls; learn about calculated controls, apply sort & group feature to report data, finish up with graphics (themes and conditional formatting).

    • 3:00 - 5:00 pm   Tues afternoon
    • Illini Hall, room 27 (lower level; NW corner of John & Wright Streets, Champaign)

    In this 2-hour workshop, participants will learn how to create and open Illustrator documents, navigate the user interface, use vector shapes to create a logo that looks good on screen and in print. No prior knowledge of Illustrator is required.

Wednesday, May 1, 2019

    • 10:00 am - 12:00 pm   Wed morning
    • UIUC -- location to be announced

    Wish you had a smarter, more efficient way to arrange your Outlook 2016 email and more? In this two-hour workshop, you will learn how to use the conversation view; how to insert a screenshot into a message; sorting messages; advanced searching techniques, including filters; working with folders; using flags, color categories, and rules.

Thursday, May 2, 2019

    • 10:00 am - 12:00 pm   Th morning
    • UIUC -- location to be announced

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

Friday, May 3, 2019

    • 9:00 - 11:00 am   Fri morning
    • Illini Hall, Room 27 (lower level; NW corner of John & Wright Streets, Champaign)

    In this 2-hour workshop participants will learn how to use Photoshop to do basic photo correction, use selection tools, manipulate, save, and store images. No prior knowledge of Photoshop is required.

Monday, May 6, 2019

    • 1:00 - 4:00 pm   Mon & Tues afternoons
    • Illini Hall, Room 27 (lower level; NW corner of John & Wright Streets, Champaign)

    This 6 hour course will prepare you to use the most common basic features of Adobe Photoshop CC.

Tuesday, May 7, 2019

Wednesday, May 8, 2019

    • 9:00 am - 12:00 pm   WTh mornings
    • Illini Hall, room 27 (lower level; NW corner of John & Wright Streets, Champaign)

    This 6-hour course introduces the basics of Adobe Illustrator. Topics will include design principles, elements, and graphics composition; creating documents containing basic shapes and customized paths. We will also learn how to insert text and typographical characters.

    • 1:00 - 3:00 pm   Wed afternoon
    • UIUC -- location to be announced

Thursday, May 9, 2019

Monday, May 13, 2019

    • 1:00 - 3:00 pm   Mon afternoon
    • UIUC -- location to be announced

    Have you been asked to put together a PowerPoint presentation, but you're not sure how to start? Take this short course and learn the basics, including how to use the new 2016 interface to create slides and put content on them; format and custom design the slides; and prepare speaker notes and handouts.

Tuesday, May 14, 2019

    • 9:00 am - 12:00 pm   Tu/Th mornings
    • UIUC -- location to be announced

    In this 6-hour course, attendees will begin by exploring the PowerPoint 2016 interface. Next we will create and save a presentation; view and navigate, and edit text on slides; add and modify graphical objects in a presentation; work with tables and charts; and prepare to deliver a presentation.

Monday, May 20, 2019

    • 1:00 - 4:00 pm   Mon & Wed afternoons
    • UIUC -- location to be announced

    This 6-hour, hands-on course is an intro to web page design using Dreamweaver CC. Students will become familiar with the Dreamweaver environment, interface elements, layout customization, website creation and publishing. Activities will include creating a new site, laying out basic pages and text, using text styles and containers, inserting images, uploading a simple site.

Wednesday, May 22, 2019

Thursday, May 23, 2019

    • 1:00 - 3:00 pm   Thurs morning
    • Illini Hall, room 27 (lower level; NW corner of John & Wright Streets, Champaign)

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