Online Training Feedback Form

If you've recently taken a professional training, on or off campus, CSTDAC and Human Resources would like to know about your experience. Use this form to give your feedback so trainings know what to keep, and what to change. With more feedback, the trainings can evolve to be more effective tools. Click Here to access the form.

Excel Mentor Group

Tips, tricks, and ways to make your financial spreadsheet work for you! All levels of expertise are welcome. Topics we'll cover include formatting, formulas, filtering, sorting, linking sheets, and pivot tables. Feel free to bring "real world" examples from your office and we'll problem solve together.

The Classified Staff Training and Development Advisory Committee (CSTDAC) would like to invite you to join the Excel Mentor Group. Mentors groups are a way for staff to get advice, learn new things, share information, and make connections with others. Below is the information on meetings and the first topic. The group will start off with the basics but will progress to much more in-depth topics.

If you would like to join the list serve to receive updates about meetings, topics and to participate in Q&A please send a message to Nargas at not@uoregon.edu.

Facilitators:
Nicole Nelson, 6-0618, nnelson@uoregon.edu
Nargas Oskui, 6-1688, not@uoregon.edu

Excel meetings:
Where - Edmiston Classroom (room 144) in the Knight Library
When - 10a.m. - 11:30 a.m.
Date - Last Thursday of the month.

Topics:
-Applying Styles continued
-Grants or Projecting Project Expenses
-Doing Variance Reports
-Working with Comments
-Create a hyperlink
-Use Web-based Research Tools

Assignment:
Please put together a budget of expenses incorporating excel functions covered from our previous sessions. (examples: grocery list, personal/business expenditures…)

Useful websites:
http://www.internet4classrooms.com/on-line_excel.htm
http://www.usd.edu/trio/tut/excel/
http://teachers.teach-nology.com/themes/comp/spreadsheets/
http://www.baycongroup.com/el0.htm

Filemaker Pro Essentials (NOTE: This class is likely to be cancelled due to injury/recovery of the mentor. A podcast version of this class may become available.)

Anyone interested in database design with Filemaker Pro is welcome to attend. No reservation is required.

Place/Time:
Reed Seminar Room, (235 Knight Library)
Tuesdays (on dates indicated below) from 10:00-12:00

Dates: (NOTE: Postponed to January due to injury)
- Introduction to Filemaker Pro 8.0
- Basic Design & Data Validation Strategies
- Relational Concepts - Internal Tables vs. External Files
- Report Design
- Powerful New Features of Instant Web Publishing
- Scriptwriting

Class assignments and sample files are also available for download in Blackboard. Search for “Filemaker” in the Course Catalogue. I also have Filemaker mini-lessons available at: http://interact.uoregon.edu/techweb/COEworkshops.html including creating a subsummary report and creating a crosstabular report.

Class Facilitator:
Mary Harrsch, 6-3554, mharrsch@uoregon.edu

Web Mechanics

This group of UO classified staff and faculty get together regularly to mentor and assist each other with web publishing. Although there are no prerequisites, basic skills in computer usage is necessary.

Place/Time:
235 Knight Library, Reed Seminar Room (usually)
12:00-1:00 pm, 3rd Wednesday of each month, October through June

For Topics - go to our website: http://webmechanics.uoregon.edu/webpublinks.htm

Facilitator: Eric Grape, 6-2378, egrape@uoregon.edu

Top of Page