Link: UCOP's e-newsletter

Stay Informed. Stay Connected.

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.

OCTOBER 2017

Excel Intermediate

Date: Thursday, Oct. 19
Time: 9 a.m. to 4 p.m.
Registration opens: Open now

Microsoft Excel 2010 offers powerful charting and graphing abilities, an unmatched set of mathematical and statistical functions, and secure tools for sharing spreadsheets with others, making it the most widely-used spreadsheet application worldwide.  This class is taught by instructors who bring years of practical experience to the classroom, so that you will be readily able to apply what you learn. Participants in this course learn to:

  • Manage large, interconnected sets of data with linked workbooks.
  • Apply an Office theme for a consistent appearance between spreadsheets and other documents.
  • Add distinctive background images and watermarks to spreadsheets for branding or security.
  • Consolidate multiple rows of data into collapsible outlines.
  • Use powerful data filters and sorting to target specific data for analysis.
  • Create professional-looking charts that accentuate key data with advanced formatting techniques and graphic elements.
  • Test formulas and trace errors with Error Checking and Auditing tools.
  • Prevent data corruption or deletion by protecting a workbook, or specific cells.
  • Allow multiple users to edit a spreadsheet simultaneously, without creating inconsistencies between versions.
  • Create and edit Excel templates with common data and formatting for your specific needs.

NOVEMBER 2017

Excel Advanced

Date: Thursday, Nov. 2
Time: 9 a.m. to 4 p.m.
Registration opens: Open now

Excel Advanced is targeted at experienced Excel users and builds on the key concepts learned from the Introduction and Intermediate courses.  Content focuses on importing and exporting data, formatting numbers, working with ranges, working with macros, data analysis tools, summarizing data, using “what-if” data analysis and expands on workgroup collaboration.  This full day class is hands-on and highly interactive.

SharePoint – Document Management

Date: Wednesday, Nov. 8
Time: 9 a.m. to 12 p.m.
Registration opens: Open now

SharePoint is a powerful tool to manage documents and other files by providing secured, web-based document libraries. There are many features of libraries that can make your SharePoint experience a success, but it is equally important to understand the common pitfalls to avoid. This workshop takes a deep dive into SharePoint’s document management features including those that are often overlooked or underutilized. Of equal importance are the best practices that will be woven into the workshop. Prerequisites: SharePoint Fundamentals Class or hands-on experience; desire and the time to adopt these techniques on the job.

Project Management, Part 3 – Scheduling and Tracking

Date: Thursday, Nov. 9
Time: 8:30 a.m. to 12:30 p.m.
Registration opens: Open now

Part 3 of a 3 part course series. In this course, students learn how to convert a project plan and estimates into a project schedule, and to track and communicate project status.

Excel for Power Users

Date: Thursday, Nov. 16
Time: 9 a.m. to 4 p.m.
Registration opens: Open now

Microsoft Excel’s array of analytic capabilities make it an invaluable problem-solving tool in any context. However, to use Excel’s most sophisticated features effectively requires more than a knowledge of the application’s formulas and menu options. To take mastery of Excel to the next level requires the ability to apply Excel’s arsenal of analytic tools to derive meaning from the data and arrive at more effective solutions. Excel for Power Users training provides the learner with practical experience using the application’s most powerful features and sophisticated data analysis techniques to develop better solutions faster, and implement those solutions with a greater understanding of the complex set of factors which affect business outcomes.

Get to the Point! Effective Business Writing

Date: Wednesday, Nov. 29
Time: 8:30 a.m. to 4:30 p.m.
Registration opens: Open now

We recommend that participants have already completed the Write Right! Business Writing Basics course.

Being able to articulate one’s point quickly, clearly, concisely and powerfully is a critical skill in effective writing.  This one day workshop provides practical tips and tools that can immediately be used to improve  written communications.

Topics include:

  • Facing the crucial issues: determining purpose and analyzing 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

ΩΩΩ

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 John Blake in Learning & Development at 510-587-6258 or john.blake@ucop.edu.