Classes and Workshops
- Pre-registration is required for all classes. See individual listings for the date that registration opens for that particular class.
- All classes listed below take place in downtown Oakland.
- Log into UC Learning Center (UCLC) to pre-register and see full class description and location. (See instructions at bottom of this page.)
- For general information about learning and development opportunities at UCOP, visit the Local Human Resources webpage.
SharePoint Intermediate — Site Administration
Date: June 13, 2018
Time 1:30–4:30 p.m.
SharePoint is a powerful tool that provides collaboration team sites for workgroups to share documents, calendars, project information to name a few. For SharePoint to be effective, the day-to-day team site administration needs to be in the hands of the teams rather than a central authority. Therefore individuals in the business units need the knowledge to administer team sites. This workshop focuses on the primary skills necessary for site administration such as permissions, site and list creation, page editing and navigation.
- Permissions overview
- Permissions Best Practices
- Site Management
- Lists and Libraries
Web pages and Web Parts Hands-on exercises:
- Create a site
- Configure permissions
- Modify navigation
- Edit the site’s homepage
- Add Web Parts
- Create a site column and apply to pre-existing lists
- SharePoint Fundamentals Class or hands-on experience
- You are or plan to become a site administrator
Get to the Point — Effective Business Writing
Date: June 19, 2018
Time: 8:30 a.m.–4:30 p.m.
Learn to get your point across quickly, clearly, concisely and powerfully. Learn practical tips and tools that can be used immediately to make your written communications — no matter what they are — more effective. This course helps students improve their business writing. Students will learn to eliminate wordy and unclear language that frustrates readers, who have neither the time nor patience to decode an unclear message. Participants will be given practical tips and tools that can be used immediately to make written communications — no matter what they are — more effective.
- Facing the crucial issues: determining your purpose and analyzing your audience
- Organizing and formatting: getting beyond the traditional outline, writing powerful openings and writing for high skim value
- Writing clearly and concisely: using powerful verbs and eliminating extra words and jargon.
Participants are strongly encouraged to bring a sample of their writing to the class for individual help.
We recommend that participants have already completed the Write Right! Business Writing Basics course.
Excel 2016 – Pivot Tables
Date: June 20, 2018
Time: 9 a.m.–4 p.m.
The pivot table in Excel is arguably the most powerful tool in the entire Microsoft Office suite. When the success of the organization relies on the ability of its employees to analyze complex data efficiently and quickly, it is essential that you master pivot tables. A pivot table is a data summarization tool that can automatically sort, group, count, filter, report, and summate data with simple dragging and dropping. UCOPs pivot tables training will enhance your ability to manipulate, analyze, and interpret large quantities of data and empower you to make effective, data-driven solutions.
Through hands-on lessons in our computer lab, accompanied by the pivot tables training curriculum, you will learn to:
- Import and prepare large datasets into Excel
- Setup data and create a pivot table
- Understand source data considerations
- Respond to changes in source data
- Work with Report Layout options
- Group PivotTable data and create Calculated Fields
- Sort and filter data
- Create data subsets and extract detail from a pivot table
- Create a Pivot Chart
- and much more
How to Register
To register for any of these classes, go to the UC Learning Center:
- Log in using your UCOP login and password
- Using the Search box on the left, type in the name of the class you want
- Click the session you want, then click on the Register box and Submit
If you enroll in a class and are unable to attend, please be sure to cancel your registration so that your slot can be made available to others interested in the class. Cancel through the UC Learning Center 48 hours before the scheduled class time, or contact Learning & Development.