Training

Calendar and Events

Upcoming Events

Wednesday, January 10, 2018

Microsoft Word Document Design and Formatting

Course | January 10 | 1-4 p.m. | 28 University Hall

 Kathleen Valerio, Central Human Resources, Learning and Development

 Human Resources

Learn how to work more efficiently in Microsoft Word by understanding the fundamentals of document layout and design.

* Effectively use Styles and Formatting.
* Insert bulleted lists, section and page breaks.
* Build Tables or embed from Excel.
* Insert Images, use WordArt, add borders and wrap text.
* Add headers, Footers, page counts, and Quick Parts.
* Add links within a document or to...   More >

Tuesday, January 16, 2018

Microsoft Excel Data Validation and Security

Course | January 16 | 1:30-4 p.m. | 28 University Hall

 Keith Samsell

 Human Resources

This course details the process of configuring a wide array of options to protect the integrity and accuracy of data in a Microsoft Excel workbook. Emphasis is placed on protection settings, value and format manipulation, exception reporting, and workbook diagnostic tools.

Learning Objectives
* Propagate consistent data values and formatting using worksheet groups.
* Create custom AutoFill...   More >

Wednesday, January 17, 2018

Google Sheets Spreadsheet Design and Formatting

Course | January 17 | 9 a.m.-12 p.m. | 28 University Hall

 Kathleen Valerio, Central Human Resources, Learning and Development

 Human Resources

Spreadsheet Basics: These features are similar to Microsoft Excel.

* Insert and format data.
* Use AutoFill.
* Insert/delete, hide and unhide rows and columns.
* Name, move, add and delete sheets.
* Apply filters and sorts.
* Export files to Excel and/or upload to Google Drive.
* Insert/delete comments.
* Do simple functions (e.g. Sum, Average, Count).
* Create charts and...   More >

Thursday, January 18, 2018

Planning Your Next Career Move

Workshop: Career Development/Job Search Skills | January 18 | 12-1:30 p.m. | CR-24 University Hall

 Terrie Moore, Staff Career Development Program, Central Human Resources, Learning and Development

 Human Resources

You have goals for your job, but how about your career? Being ready for your next career move means preparing early. In this workshop, you’ll begin to frame a goal and a plan to build and sustain momentum.

Tuesday, January 23, 2018

Microsoft Word Mail Merge Automation

Course | January 23 | 1:30-4 p.m. | 28 University Hall

 Keith Samsell, Training Lead, Learning and Development

 Human Resources

This course details the process of performing automated electronic mail merges. Emphasis is placed on data source connections, integration and formatting of static and dynamic content, document layout types, and mail merge feature differences with Microsoft Publisher.

Learning Objectives
* Create calculated fields for use in merge documents.
* Prepare and format static document content for...   More >

Wednesday, January 24, 2018

Interests in Life and Work

Workshop: Career Development/Job Search Skills | January 24 | 12-1:30 p.m. | CR-24 University Hall

 Chris McLean

 Human Resources

"The term “Interests” has very specific meaning in career development. Clarify how your interests influence the work you enjoy through the Strong Interest Inventory. Explore how interests relate to job families and opportunities on campus.

PRE-WORK REQUIRED. Instructions for taking the “Strong Interest Inventory” (at least 3 days in advance) will be sent in your registration confirmation."

Google Forms Design

Course | January 24 | 1-4 p.m. | 28 University Hall

 Kathleen Valerio, Central Human Resources, Learning and Development

 Human Resources

Learn how to work with Google Forms. Create questionnaires, quizzes, surveys, or collect e-mail addresses for newsletters. With Google Forms you can collect and analyze data directly in your web browser.

Build a form from scratch using various question types:

* short answer
* multiple choice
* check boxes
* drop down selection
* linear scales
* multiple choice grids

Collaborate...   More >

Microsoft Excel Query Editor

Course | January 24 | 1:30-4 p.m. | 239 Campus Shared Services (1608 4th Street, Berkeley)

 Keith Samsell, Training Lead, Learning and Development

 Human Resources

This course focuses on the utilization of the embedded Microsoft Excel Query Editor to connect to multiple data sources in order to extract, manipulate, or compare datasets. Query results are loaded to the host Excel application to leverage other business intelligence features.

Learning Objectives
• Identify the elements of the Microsoft Excel Query Editor.
• Connect the Query Editor to...   More >

Thursday, January 25, 2018

Keys Track 1a- Principles of Supervision: Setting the Context

Course | January 25 | 12:30-4:30 p.m. | 24 University Hall

 Paul Carroll

 Human Resources

OPTIONS
This course will help participants understand the role of the supervisor, and its relationship to the organization. We will focus on what a supervisor needs to know and do, how to use influence when you don’t have control, and the resources available to help you be more effective. We will also look at how to motivate and retain engaged employees. This workshop addresses the following...   More >

Tuesday, January 30, 2018

Buying Your First Home (BEUHS341)

Workshop: Health and Wellness | January 30 | 12:10-1:30 p.m. | Tang Center, University Health Services, Section Club Room

 Patrick Ignacio, Banking Industry Expert

 Tang Center (University Health Services)

California housing markets are constantly changing, and there are overwhelming amounts of information available to the public, making it hard to know where to start. During the most recent housing crisis, financing options also changed (and in some cases disappeared altogether). As a result you may be asking yourself, what programs are available to me and how will they fit my personal situation?...   More >

 

  Enroll online

Wednesday, January 31, 2018

Keys Track 3d- Supervising in a Union Environment

Course | January 31 | 1-4 p.m. | 24 University Hall

 Julie Hoxie

 Human Resources

Supervisors will learn how to manage their represented employees within the constraints of the laws and the labor contracts. They will also learn about management rights, employee rights and union rights, and how to communicate with represented employees and unions. This workshop addresses the following Core Competencies: * Inclusiveness * Managing People * Communication

Microsoft Excel VBA Function Programming

Workshop | January 31 | 1:30-4 p.m. | 28 University Hall

 Keith Samsell, Central Human Resources, Learning and Development

 Human Resources

This course details the process by which custom, user-defined functions are created using the Visual Basic for Applications (VBA) programming language. Once defined, VBA functions may be used in Microsoft Excel to produce custom calculated outcomes that extend beyond the capabilities of the standard Excel function library. Learning Objectives: * Understand the VBA Project hierarchy and...   More >

Thursday, February 1, 2018

F1 - Research Administration Overview: Berdp001

Workshop | February 1 | 9 a.m.-12 p.m. | 24 University Hall

 Jeremy Linneman, Central Human Resources, Learning and Development

 Human Resources

Synopsis: An introductory workshop that provides an overview of the RAPDP curriculum, roles and responsibilities of central campus offices, the award lifecycle, and the campus systems relevant to Research Administration. Learning Objectives:
•Recognize the roles and responsibilities of key players in Research Administration
•Identify and locate the campus offices and their policies,...   More >

Career Connections: Human Resources

Miscellaneous | February 1 | 6-8 p.m. |  Career Center (2440 Bancroft Way)

 Cal Alumni Association, Career Center, The Berkeley Network

CAA has teamed up with the UC Berkeley Career Center to help students make connections and gain clarity in their career pursuits.

For each of these casual networking events, we are seeking a diverse group of alumni to showcase a variety of careers. The events require no prep—simply chat with interested students, share your path from Cal to career, and offer advice to those who hope to follow...   More >

 

  Register online

Tuesday, February 6, 2018

Work Style and Your Career

Workshop: Career Development/Job Search Skills | February 6 | 12-1:30 p.m. | University Hall, CR-198

 Terrie Moore, Staff Career Development Program, Central Human Resources, Learning and Development

 Human Resources

"It’s no surprise that people like to approach tasks differently. Understanding your preferences and those associated with various work roles can help you make informed effective choices. This workshop uses the Myers-Briggs Type Indicator.

PRE-WORK REQUIRED. Instructions for taking the “Myers-Briggs Type Indicator” (at least 3 days in advance) will be sent in your registration confirmation. "

Borrowing Basics (BEUHS358)

Workshop: Health and Wellness | February 6 | 12:10-1:30 p.m. | Tang Center, University Health Services, Section Club Room

 Richard P. Ruiz, Vice President, East Bay Region, Bank of the West

 Tang Center (University Health Services)

his borrowing basics seminar provides a comprehensive overview of critical information related to consumer lending options. The session topics include a review of different credit types, costs associated with obtaining credit, your rights as a borrower, what creditors review when making a credit decision and ideas on how to manage your credit. This option would likely have a broader appeal to...   More >

 

  Enroll online

Microsoft Excel Formulas and Functions

Course | February 6 | 1:30-4 p.m. | 239 Campus Shared Services (1608 4th Street, Berkeley)

 Keith Samsell, Training Lead, Learning and Development

 Human Resources

This course details the process by which calculations are created in Microsoft Excel workbooks. Emphasis is placed on the underlying theory and syntax of formulas and functions, as well as their complimentary abilities and use cases.

Learning Objectives

* Understand the fundamental differences of values vs. formats.
* Use AutoCalculate to display summary information from multiple cells.
*...   More >

Wednesday, February 7, 2018

KEYS Track 1b- Creating an Inclusive Work Environment

Course | February 7 | 9 a.m.-4 p.m. | 24 University Hall

 Sid Reel

 Human Resources

This course will explore the importance of creating inclusive work environments and effective teams. We will examine the principles of equity and inclusion, emotional intelligence, and multi-generational workforce issues. The class will finish with an Interactive Theater presentation and participatory discussion. By applying these principles and treating people with fairness and respect,...   More >

bMail Fundamentals

Course | February 7 | 1-4 p.m. | 28 University Hall

 Kathleen Valerio, Central Human Resources, Learning and Development

 Human Resources

bMail is Berkeley's version of Google Mail.

This class looks at ways Google Apps are integrated (Mail, Calendar, Drive). Learn basic navigation, how to compose and respond to e-mails, set up your account signature and vacation messages, activate useful labs, create groups and manage contacts, use e-mail to generate a calendar event and vice versa. Create and manage Labels and Filters, use...   More >

Thursday, February 8, 2018

F2 - Research in a Regulatory Environment: Berdp005

Workshop | February 8 | 9 a.m.-12 p.m. | 24 University Hall

 Jeremy Linneman, Central Human Resources, Learning and Development

 Human Resources

An introductory workshop that presents key concepts in compliance and cost policy, including an overview of the regulatory hierarchy, the delegation of authority, and the types of research agreements managed by RAs.

Learning Objectives:
•State why there are regulations in research and name direct consequences of non-compliance
•Define the Federal and University guidelines involved in...   More >

Tuesday, February 13, 2018

Microsoft Excel Linking and Referencing Calculations

Course | February 13 | 1:30-4 p.m. | 28 University Hall

 Keith Samsell, Training Lead, Learning and Development

 Human Resources

This course details the process of establishing links between data sources using manual and automated methods. Emphasis is placed on supplemental referencing syntax to establish and manage calculation links.

Learning Objectives
* Leverage Structured Reference syntax for Table objects.
* Utilize Relative and Absolute referencing syntax to effectively replicate calculations.
* Link cell...   More >

Thursday, February 15, 2018

Workplace Civility: Respect in Action

Workshop | February 15 | 9 a.m.-12 p.m. | University Hall, Room 24

 Julia Horvath, Staff Ombuds Office

 Staff Ombuds Office

Learn practical steps for promoting civility at work, including guidelines for considerate conduct and ideas for creating a more inclusive work environment. Participants will also learn how to help their unit establish group norms and effective ways to respond to rudeness.

Google Docs Document Design and Formatting

Course | February 15 | 1-4 p.m. | 28 University Hall

 Kathleen Valerio, Central Human Resources, Learning and Development

 Human Resources

Learn how to generate, edit, share, and collaborate in Google Docs. Learn how to work with Styles, use bullets, format text, insert images and tables, set tab spacing, add headers and footers, see word count, use research tools, and translate documents into other languages.

Topics in common with Microsoft Word:

* Effectively use Styles and Formatting.
* Insert bulleted lists, Tables.
*...   More >

Thursday, February 22, 2018

F3 - Customer Service for the RA: Berdp007

Workshop | February 22 | 9-11 a.m. | 24 University Hall

 Jeremy Linneman, Central Human Resources, Learning and Development

 Human Resources

A soft skills workshop that covers essential customer service and workplace communication techniques, with a special emphasis on setting up, preparing for, facilitating, and debriefing an RA’s initial meeting with their PIs.
Learning Objectives:
•Identify the primary and secondary customers of a Research Administrator
•Recognize what it means to provide stellar customer service
•Utilize...   More >

KEYS Track 2d- Communicating Goals and Expectations

Course | February 22 | 12:30-4:30 p.m. | 24 University Hall

 Kathy Mendonca

 Human Resources

Participants will learn how goals and performance standards fit into the performance management cycle and the performance evaluation process, understand the differences and similarities between setting goals and establishing performance standards, write goals and performance standards using SMART criteria, and align individual goals with department and organizational goals. This workshop...   More >

Tuesday, February 27, 2018

The Skills You Bring

Workshop: Career Development/Job Search Skills | February 27 | 12-1:30 p.m. | CR-24 University Hall

 Terrie Moore, Staff Career Development Program, Central Human Resources, Learning and Development

 Human Resources

The skills you enjoy and feel confident about contribute to strong performance and high satisfaction. Explore your transferable skills – the ones that support your career mobility and adaptability.

Wednesday, February 28, 2018

KEYS Track 2f- Delegation Skills

Course | February 28 | 12:30-4:30 p.m. |  University Hall

 Kathy Mendonca

 Human Resources

THIS WORKSHOP IS FOR SUPERVISORS AND MANAGERS ONLY. This workshop will explore the delegation process and its benefits to the individual, team and organization. Participants will learn skills in: • Planning and preparing to delegate a task • Communicating effectively for delegating • Planning follow-up and successful project completion This workshop addresses the following Core Competencies: •...   More >

Thursday, March 1, 2018

PD1 - Budget Development: berdp003

Workshop | March 1 | 9 a.m.-4 p.m. | 28 University Hall

 Jeremy Linneman, Central Human Resources, Learning and Development

 Human Resources

An Excel-based workshop that guides participants through how to create a proposal budget and narrative justification that is compliant with sponsor restrictions and consistent with University HR policies. Participants will learn to build budgets from scratch, as well as by using the CSS templates.
Learning Objectives:
•Recognize the policy and compliance considerations in preparing a proposal...   More >

Tuesday, March 6, 2018

KEYS Track 2e- Coaching for Performance and Development

Course | March 6 | 8:30 a.m.-4:30 p.m. |  University Hall

 Inette Dishler

 Human Resources

Participants will learn the differences between coaching for performance and coaching for development, know how to prepare for a coaching conversation, learn and use a coaching model, and practice and prepare to give both positive and constructive feedback. This workshop addresses the following Core Competencies: * Inclusiveness * Managing People * Communication * Quality Improvement

Microsoft Project Fundamentals

Course | March 6 | 1:30-4 p.m. | 28 University Hall

 Keith Samsell, Training Lead, Learning and Development

 Human Resources

This foundation course combines industry-standard project management theory with practical application using Microsoft Project to plan, execute, and track progression throughout the project lifecycle.

Learning Objectives

* Define key project management concepts.
* Identify the elements and views of the Microsoft Project interface.
* Set the scheduling direction of new projects.
* Create...   More >

Wednesday, March 7, 2018

Collaborating Effectively in the Workplace

Workshop | March 7 | 9 a.m.-12:30 p.m. | University Hall, Room 24

 Sara Thacker, Staff Ombuds Office

 Staff Ombuds Office

To be successful in the rapidly changing workplace, where jobs and people change fast – staff must be able to collaborate with a variety of people within and outside the organization who have the skills, resources, and influence to tackle increasing complex challenges. Collaboration is a skill and a set of practices that are rarely taught in the workplace. In this course staff will learn about...   More >

Thursday, March 8, 2018

PD1 - Budget Development: berdp003

Workshop | March 8 | 9 a.m.-4 p.m. | 28 University Hall

 Jeremy Linneman, Central Human Resources, Learning and Development

 Human Resources

An Excel-based workshop that guides participants through how to create a proposal budget and narrative justification that is compliant with sponsor restrictions and consistent with University HR policies. Participants will learn to build budgets from scratch, as well as by using the CSS templates.

Learning Objectives:
•Recognize the policy and compliance considerations in preparing a...   More >

Effective Resume Writing

Workshop: Career Development/Job Search Skills | March 8 | 12-1:30 p.m. | CR-24 University Hall

 Linda Lundberg, Transition Services Lead, HR Policy and Labor Relations

 Human Resources

Create a resume that gets attention and results. Learn how to create a document that highlights your transferable skills and the strengths of your unique work history.

Monday, March 12, 2018

Certificate Program in Human Resource Management Online Information Session

Information Session | March 12 | 12-1 p.m. |  Online

 UC Berkeley Extension

Discover how this certificate, approved by the Human Resource Certification Institute, can help you make the most of growing opportunities in human resource management.

  Register online

Tuesday, March 13, 2018

KEYS Track 3c- K15: Compensation and Benefits – What Every Supervisor Needs to Know

Course | March 13 | 12:30-4:30 p.m. | 24 University Hall

 Janet Suko, Monica Buccellato, and Scott Dinkelspiel, CHR: Total Rewards, Benefits and Compensation

 Human Resources

This workshop will cover the basics of managing compensation and understanding the benefits structure at UC Berkeley. The Compensation session will provide guidance on how to address frequently asked compensation questions, including: • How do I determine the appropriate salary for a new hire? • What is an appropriate promotional increase? • When is an equity adjustment appropriate? • When should...   More >

Microsoft Excel Nested and Logical Functions

Course | March 13 | 1:30-4 p.m. | 28 University Hall

 Keith Samsell, Training Lead, Learning and Development

 Human Resources

This course details the theory and syntax of nested Functions, including the integration of Logical Functions as well as the integration of Formulas with Functions. Calculation auditing features are reviewed to provide methods of inspecting concealed processing steps.

Please note: Although there is no required prerequisite for this course, it is highly recommended to attend Microsoft Excel...   More >

Wednesday, March 14, 2018

Microsoft Word Document Design and Formatting

Course | March 14 | 9 a.m.-12 p.m. | 28 University Hall

 Kathleen Valerio, Central Human Resources, Learning and Development

 Human Resources

Learn how to work more efficiently in Microsoft Word by understanding the fundamentals of document layout and design.

* Effectively use Styles and Formatting.
* Insert bulleted lists, section and page breaks.
* Build Tables or embed from Excel.
* Insert Images, use WordArt, add borders and wrap text.
* Add headers, Footers, page counts, and Quick Parts.
* Add links within a document or to...   More >

Thursday, March 15, 2018

PD2 - Proposal Development: berdp101

Workshop | March 15 | 9 a.m.-12 p.m. | 24 University Hall

 Jeremy Linneman, Central Human Resources, Learning and Development

 Human Resources

An intermediate workshop that explores the pre-award processes for analyzing requests for proposals, proposal preparation and assembly, submitting a proposal for institutional review via Phoebe, and submission to sponsor.

Learning Objectives:
•Distinguish between different kinds of proposal submissions
•Locate funding announcements, proposal requirements and sponsor guidelines
•Create a...   More >

Your Values at Work

Workshop: Career Development/Job Search Skills | March 15 | 12-1:30 p.m. | University Hall, CR-150

 Terrie Moore, Staff Career Development Program, Central Human Resources, Learning and Development

 Human Resources

Values contribute to the meaning and satisfaction we find in work. This workshop offers a chance to clarify your highest-priority work related values, and explore avenues for enhancing alignment in your values and your work.

Microsoft PowerPoint Advanced Visual Design

Course | March 15 | 1:30-4 p.m. | 28 University Hall

 Keith Samsell, Training Lead, Learning and Development

 Human Resources

This course details the process of leveraging advanced development and design tools to visually enhance presentations and embedded objects. Emphasis is placed on content design and management tools, user-defined effects and actions, and Object Linking and Embedding (OLE).

Learning Objectives
* Divide large presentations into logical grouped Sections.
* Create custom slide shows for...   More >

Tuesday, March 20, 2018

Your Professional Online Network

Workshop: Career Development/Job Search Skills | March 20 | 12-1 p.m. | CR-24 University Hall

 Robyn Pease, Talent Manager, University Development and Alumni Relations, Shared Services Human Resource

 Human Resources

Put your best digital foot forward by using LinkedIn to highlight career accomplishments and research companies, people and job opportunities.

Microsoft Excel Linking and Referencing Calculations

Course | March 20 | 1:30-4 p.m. | 239 Campus Shared Services (1608 4th Street, Berkeley)

 Keith Samsell, Training Lead, Learning and Development

 Human Resources

This course details the process of establishing links between data sources using manual and automated methods. Emphasis is placed on supplemental referencing syntax to establish and manage calculation links.

Learning Objectives
* Leverage Structured Reference syntax for Table objects.
* Utilize Relative and Absolute referencing syntax to effectively replicate calculations.
* Link cell...   More >

Wednesday, March 21, 2018

FM1 - New Awards: berdp202

Workshop | March 21 | 9 a.m.-12 p.m. | 24 University Hall

 Jeremy Linneman, Central Human Resources, Learning and Development

 Human Resources

An intermediate workshop that details the processes for setting up a newly finalized sponsored award, including interpreting a Notice of Award, and processing a BFS budget upload.

Learning Objectives:
•Interpret a Phoebe Award Summary and the related Terms & Conditions
•Summarize the information a PI needs to know about a new fund
•List the steps in setting up a fund for use
•Explain...   More >

Microsoft Excel Charts

Course | March 21 | 1-4 p.m. | 28 University Hall

 Kathleen Valerio, Central Human Resources, Learning and Development

 Human Resources

Course Description
This course details the process of chart creation and manipulation in Microsoft Excel. Emphasis is placed on proper structure of source data, functional differences of various chart types, and conversion of charts into pictures for use in other programs.

Learning Objectives
* Understand the functional differences of Charts versus PivotCharts.
* Use best practices for...   More >

Thursday, March 22, 2018

KEYS Track 3a- K14: Recruiting and Hiring Staff

Course | March 22 | 9 a.m.-4 p.m. | 24 University Hall

 Tara Hertstein and Marc Ovalle

 Human Resources

Learn how to effectively recruit and hire staff based on federal and state regulations and UC policies to conduct consistent, legal, and fair hiring processes. This entails all stages of the full-cycle recruitment process to include proper job description creation, how to apply principles of inclusion, manage Special Placement Candidate and Medical Separation applicants and qualify applicants...   More >

Tuesday, March 27, 2018

Microsoft Access Action Queries

Course | March 27 | 1:30-4 p.m. | 239 Campus Shared Services (1608 4th Street, Berkeley)

 Keith Samsell, Training Lead, Learning and Development

 Human Resources

This course details the process of designing Action Queries using a Microsoft Access database interface in order to manipulate values in local and external data sources. Emphasis is placed on Action Query types, Select Query conversion, and automation triggers of one or more sequential queries.

Learning Objectives
* Connect to local and external data sources.
* Design Queries to manipulate...   More >

Wednesday, March 28, 2018

FM2 - Federal Cost Policy and Compliance: berdp206

Workshop | March 28 | 9 a.m.-12 p.m. | 24 University Hall

 Jeremy Linneman, Central Human Resources, Learning and Development

 Human Resources

An intermediate workshop on Federal cost policy that details how the OMB Circulars are implemented, covers the changes in the new Uniform Guidance, and explores some specific compliance issues like the Federal Acquisition Regulation and Participant Support.

Learning Objectives:
•Identify the RA’s responsibilities regarding financial compliance
•Describe the Federal Acquisition Regulation...   More >

Thursday, March 29, 2018

KEYS Track 3b- K16: ADA/FMLA – What Every Supervisor Needs to Know

Course | March 29 | 1-4:30 p.m. | 24 University Hall

 Theresa McLemore, HR Policy and Labor Relations

 Human Resources

THIS WORKSHOP IS FOR SUPERVISORS AND MANAGERS ONLY. Please arrive on time for class . Ten minutes after the workshop starts, vacant seats will be given to those on the waitlist. Topics covered in this workshop include current information about the laws, eligibility, rights and responsibilities, and how these laws interact with one another. The workshop introduces the Interactive Process of the...   More >

Tuesday, April 3, 2018

KEYS Track 1f- K4: Building Teams

Course | April 3 | 12:30-4:30 p.m. | 24 University Hall

 Kathy Mendonca, Central Human Resources, Learning and Development

 Human Resources

THIS WORKSHOP IS FOR SUPERVISORS AND MANAGERS ONLY. This workshop identifies characteristics of an effective team, the tools needed to build one, and provides an opportunity for participants to assess their own team's effectiveness and needs. Participants will explore the stages of team development and the leader's role, and create an action plan to help build an effective team. This workshop...   More >

Microsoft Excel PivotTables and PivotCharts

Course | April 3 | 1:30-4 p.m. | 28 University Hall

 Keith Samsell, Training Lead, Learning and Development, Central Human Resources, Learning and Development

 Human Resources

This course details the process by which large data sets are organized, formatted, summarized, and interactively manipulated using Tables, PivotTables, and PivotCharts.

Learning Objectives

* Convert data ranges into Tables to organize and analyze values using single and multi-field sorts, filters, and totals.
* Create Structured Reference Calculations using formulas and functions within...   More >

Wednesday, April 4, 2018

Interviewing for the Job

Workshop: Career Development/Job Search Skills | April 4 | 12-1:30 p.m. | CR-24 University Hall

 Terrie Moore, Staff Career Development Program, Central Human Resources, Learning and Development

 Human Resources

Job interview skills are important whether you are switching fields, seeking an advanced position along your current path, or just keeping your skills sharp. This workshop provides an effective framework for expressing your qualifications.

Thursday, April 5, 2018

FM3 - Non-Federal Cost Policy and Compliance: berdp207

Workshop | April 5 | 9 a.m.-12 p.m. | 24 University Hall

 Jeremy Linneman, Central Human Resources, Learning and Development

 Human Resources

An intermediate workshop that builds upon Federal Cost Policy and Compliance by using case studies to explore the types of terms and conditions often found in Non-Federal sponsored agreements.

Learning Objectives:
•Recognize the obligation to spend and report in accordance with the agreement
•Identify the RA’s responsibilities regarding financial compliance (from cradle to grave)...   More >

Tuesday, April 10, 2018

KEYS Track 1d- K13: Leading Change

Course | April 10 | 9 a.m.-3 p.m. | 24 University Hall

 Kathy Mendonca, Central Human Resources, Learning and Development

 Human Resources

The campus is undergoing unprecedented organizational change, and the supervisor plays a pivotal role in its success. This workshop will provide necessary knowledge and skills to support the supervisor in leading change. In this class, we will: •Describe the organizational approach to change •Identify the supervisor’s role in change management and the skills required •Explore resistance to...   More >

Microsoft Excel Database and Lookup Functions

Course | April 10 | 1:30-4 p.m. | 28 University Hall

 Keith Samsell, Training Lead, Learning and Development

 Human Resources

This course details a family of related Excel features and function calculations commonly used in conjunction with large data Ranges or Tables. Emphasis is placed on proper use cases and syntax, and introduces alternative methods to view flat file data on a record-by-record basis.

Learning Objectives
* Understand the differences between Ranges and Tables.
* Review the structure and syntax of...   More >

Wednesday, April 11, 2018

bMail Fundamentals

Course | April 11 | 9 a.m.-12 p.m. | 28 University Hall

 Kathleen Valerio, Central Human Resources, Learning and Development

 Human Resources

bCal is Berkeley's version of Google Calendar.

Learn how to:

* Create and use groups to share content and/or schedule a video call.
* Create repeating meetings and/or all day events.
* Use “find a time” to schedule appointments; invite guests and resources to an event.
* Add location details through Google Maps and attachments.
* Monitor RSVP’s and follow up with people based on their...   More >

Thursday, April 12, 2018

FM4 - Fund Management: berdp203

Workshop | April 12 | 9 a.m.-12 p.m. | 24 University Hall

 Jeremy Linneman, Central Human Resources, Learning and Development

 Human Resources

An intermediate workshop the covers the monthly reporting and reconciliation process (using PI Portfolio), including updating projections, fulfilling the SAS-115 requirements, and processing corrective transactions such as expense transfers.

Learning Objectives:
•Understand the importance of implementing key financial controls throughout the life of an award
•Perform the day-to-day...   More >

HTML Fundamentals

Course | April 12 | 1:30-4 p.m. | 239 Campus Shared Services (1608 4th Street, Berkeley)

 Keith Samsell, Training Lead, Learning and Development

 Human Resources

This course details the process of developing web pages using Hypertext Markup Language (HTML). Emphasis is placed on HTML theory and syntax, common tags and tag attributes, and the integration of graphics and color to enhance formatting and branding.

Learning Objectives
* Understand the relationship between website content and the infrastructure of the Internet.
* Formulate Uniform Resource...   More >

Tuesday, April 17, 2018

Microsoft Word Document Design and Formatting

Course | April 17 | 9 a.m.-12 p.m. | 239 Campus Shared Services (1608 4th Street, Berkeley)

 Kathleen Valerio, Central Human Resources, Learning and Development

 Human Resources

Learn how to work more efficiently in Microsoft Word by understanding the fundamentals of document layout and design.

* Effectively use Styles and Formatting.
* Insert bulleted lists, section and page breaks.
* Build Tables or embed from Excel.
* Insert Images, use WordArt, add borders and wrap text.
* Add headers, Footers, page counts, and Quick Parts.
* Add links within a document or to...   More >

Wednesday, April 18, 2018

KEYS Track 2c-K13: Taking Disciplinary Action

Course | April 18 | 9 a.m.-12:30 p.m. | 24 University Hall

 Bianca Bowman, HR Policy and Labor Relations

 Human Resources

Participants will be provided with information and skills needed to more confidently deal with unacceptable employee behavior and performance. They will learn the Seven Tests of Just Cause as a framework for disciplinary action, and the disciplinary alternatives and ways to determine which ones are appropriate. This workshop addresses the following Core Competencies: * Inclusiveness * Managing...   More >

Thursday, April 19, 2018

FM5 - HR for the RA: berdp309

Workshop | April 19 | 9 a.m.-12 p.m. | 24 University Hall

 Jeremy Linneman, Central Human Resources, Learning and Development

 Human Resources

An intermediate workshop that explores the types of research appointments used on sponsored awards, as well as the compliance issues associated with PI effort and how the Effort Reporting System is used to track and report effort.

Learning Objectives:
•Define Effort and explain the appointment types that are used with research funds
•Distinguish between the most common types of faculty...   More >

Navigating the System: Social Security Retirement (BEUHS327)

Workshop: Health and Wellness | April 19 | 12:10-1:30 p.m. | Tang Center, University Health Services, Section Club Room

 Walter Herbert, Social Security Administration

 Tang Center (University Health Services)

Worried about what to expect from Social Security? Find out what Social Security retirement benefits and options are available to you and your family (including divorced spouse benefits), as well as when and how to file a claim.

 

  Enroll online

Wednesday, April 25, 2018

Microsoft PowerPoint Fundamentals

Course | April 25 | 1-4 p.m. | 28 University Hall

 Kathleen Valerio, Central Human Resources, Learning and Development

 Human Resources

This foundation course details the process of developing structured PowerPoint presentations and enhancing those presentations by integrating formatting features, visual elements, animations, and slide transitions.

Learning Objectives
• Identify the elements of the Microsoft PowerPoint Interface.
• Understand the functional purpose of each PowerPoint view.
• Develop a presentation slide...   More >

Thursday, April 26, 2018

FM6 - Closeouts: berdp204

Workshop | April 26 | 9 a.m.-12 p.m. | 24 University Hall

 Jeremy Linneman, Central Human Resources, Learning and Development

 Human Resources

Synopsis: An intermediate workshop the breaks down the process for closing a sponsored award, including the roles and responsibilities of the RA and the CGA analyst, how to complete an accrual journal as part of a Closeout, and how a Closeout is submitted in BFS.

Learning Objectives:
•Identify the steps and timeline to closeout an award
•Identify the steps to complete the financial...   More >

Tuesday, May 1, 2018

Your UC Retirement System (BEUHS346)

Workshop: Health and Wellness | May 1 | 12:10-1:30 p.m. | Tang Center, University Health Services, Section Club Room

 Eric Schreiber, Retirement Planner, Fidelity Investments

 Tang Center (University Health Services)

Overview of retirement benefits offered by UC. Covers primary benefits (pension/Choice) that provide a foundation for retirement income and voluntary benefits that offer additional savings opportunities (403(b), 457(b) and DC plans

 

  Enroll online

Wednesday, May 2, 2018

Informational Interviewing

Workshop: Career Development/Job Search Skills | May 2 | 12-1 p.m. | CR-24 University Hall

 Linda Lundberg, Transition Services Lead, HR Policy and Labor Relations

 Human Resources

Thinking about an interesting career move? Have questions about the field or how to get there? Expand your career strategy toolkit by learning how to conduct effective informational interviews.

Thursday, May 3, 2018

ST2 - Cost Share: berdp210

Workshop | May 3 | 9 a.m.-12 p.m. | 24 University Hall

 Jeremy Linneman, Central Human Resources, Learning and Development

 Human Resources

A specialty workshop that details the processes for proposing, setting up, tracking, and reporting on cost share commitments to a sponsored project.

Learning Objectives:
•Define what cost sharing is and identify applicable policies
•Describe the PI and RA roles in securing, monitoring and reporting on cost share commitments
•Identify the risks of non-compliance to the campus,...   More >

Tuesday, May 8, 2018

Microsoft Excel VBA Function Programming

Course | May 8 | 1:30-4 p.m. | 28 University Hall

 Keith Samsell, Training Lead, Learning and Development

 Human Resources

This course details the process by which custom, user-defined functions are created using the Visual Basic for Applications (VBA) programming language. Once defined, VBA functions may be used in Microsoft Excel to produce custom calculated outcomes that extend beyond the capabilities of the standard Excel function library.

Learning Objectives

* Understand the VBA Project hierarchy and...   More >

Thursday, May 10, 2018

PD4 - Developing Large and Complex Proposals: berdp103

Workshop | May 10 | 9 a.m.-12 p.m. | 24 University Hall

 Jeremy Linneman, Central Human Resources, Learning and Development

 Human Resources

Synopsis: A specialty workshop that integrates topics from other workshops to explore developing larger, more complex proposals, including working with the Berkeley Research Development Office.

Learning Objectives:
•Identify different types of complex projects and their characteristics
•Locate the applicable funding announcement and sponsor guidelines for proposal submission
•Identify...   More >

Tuesday, May 15, 2018

Job Interview Practice

Workshop: Career Development/Job Search Skills | May 15 | 12-1:30 p.m. | CR-24 University Hall

 Paula Jung

 Terrie Moore, Staff Career Development Program, Central Human Resources, Learning and Development

 Human Resources

Practice what you learned in Interviewing for the Job in this supportive small-group practice session. Nothing helps build confidence quite like practice and supportive feedback.

Microsoft Access Table Design

Course | May 15 | 1:30-4 p.m. | 28 University Hall

 Keith Samsell, Training Lead, Learning and Development

 Human Resources

This course details the process of creating new Table objects in a Microsoft Access database. Emphasis is placed on fields and properties, Primary Keys and referential integrity, record management, and Datasheet formatting.

Learning Objectives
* Understand the purpose and interdependencies of the six major database object types.
* Contrast flat file data storage against relational database...   More >

Wednesday, May 16, 2018

Qualtrics Survey Design

Course | May 16 | 1-4 p.m. | 28 University Hall

 Kathleen Valerio, Central Human Resources, Learning and Development

 Human Resources

This course details the process of designing and distributing surveys using the UC Berkeley instance of Qualtrics. Emphasis is placed on question design, data validation, survey distribution methods, response statistics, and security permissions.

Learning Objectives
* Identify the steps for Qualtrics account access at UC Berkeley.
* Configure user-specific account settings.
* Design new...   More >

Thursday, May 17, 2018

Identifying and Addressing Workplace Bullying

Workshop | May 17 | 9 a.m.-3 p.m. | University Hall, Room 24

 Sara Thacker, Staff Ombuds Office

 Staff Ombuds Office

Bullying can take many forms, some of which are obvious and others of which, though more indirect, can be equally destructive to working relationships. Participants will learn about how to recognize bullying behavior; how to distinguish bullying from incivility; what climates encourage bullying; the impact of workplace bullying; options for how bystanders can effectively respond; and constructive...   More >

Tuesday, May 22, 2018

Microsoft Excel Query Editor

Course | May 22 | 1:30-4 p.m. | 28 University Hall

 Keith Samsell, Training Lead, Learning and Development

 Human Resources

This course focuses on the utilization of the embedded Microsoft Excel Query Editor to connect to multiple data sources in order to extract, manipulate, or compare datasets. Query results are loaded to the host Excel application to leverage other business intelligence features.

Learning Objectives
• Identify the elements of the Microsoft Excel Query Editor.
• Connect the Query Editor to...   More >

Wednesday, May 23, 2018

Job Search Effectiveness

Workshop: Career Development/Job Search Skills | May 23 | 12-1:30 p.m. | CR-24 University Hall

 Terrie Moore, Staff Career Development Program, Central Human Resources, Learning and Development

 Linda Lundberg, Lead, Transition Services, Central Human Resources, HR Policy & Labor Relations

 Human Resources

We all know the importance of writing a good resume and responding to interview questions. But these tasks don’t stand alone. This workshop explores the structure of an effective job search in the UC Berkeley context.

Thursday, May 24, 2018

Microsoft PowerPoint Advanced Visual Design

Course | May 24 | 1:30-4 p.m. | 239 Campus Shared Services (1608 4th Street, Berkeley)

 Keith Samsell, Training Lead, Learning and Development

 Human Resources

This course details the process of leveraging advanced development and design tools to visually enhance presentations and embedded objects. Emphasis is placed on content design and management tools, user-defined effects and actions, and Object Linking and Embedding (OLE).

Learning Objectives
* Divide large presentations into logical grouped Sections.
* Create custom slide shows for...   More >

Tuesday, May 29, 2018

Microsoft Excel Scenario Analysis

Course | May 29 | 1:30-4 p.m. | 28 University Hall

 Keith Samsell, Training Lead, Learning and Development

 Human Resources

This course details the process of analyzing data scenarios using Microsoft Excel calculations and feature sets. Emphasis is placed on detection of cell and range equivalencies and anomalies.

Learning Objectives
* Create formulas and functions to validate equal cell values or detect discrepancies.
* Generate Sparklines to graphically render variations in data sets.
* Create conditional...   More >

Tuesday, June 5, 2018

Microsoft Visio Fundamentals

Course | June 5 | 1:30-4 p.m. | 28 University Hall

 Keith Samsell, Training Lead, Learning and Development

 Human Resources

This course details the process by which Microsoft Visio diagrams are developed using Stencils, Shapes, Connectors, and through the incorporation of design tools and visual aids. Emphasis is placed on common diagram types and object organization using multi-page and multi-layer design layouts.

Learning Objectives
* Understand diagramming concepts and the relationships between Drawings,...   More >

Wednesday, June 13, 2018

Microsoft Spreadsheet Design and Formatting

Course | June 13 | 9 a.m.-12 p.m. | 239 Campus Shared Services (1608 4th Street, Berkeley)

 Kathleen Valerio, Central Human Resources, Learning and Development

 Human Resources

Spreadsheet Basics: Learn how to navigate in and across spreadsheets. Use AutoFill to build spreadsheets and link them into quarterly reports with basic equations in Microsoft Excel.

Learning objectives:

* Insert and format data.
* Use AutoFill.
* Insert/delete hide and unhide rows and columns.
* Name, move, add and delete worksheets.
* Apply filters and sorts.
* Export files to Excel...   More >

Microsoft Publisher Fundamentals

Course | June 13 | 1:30-4 p.m. | 239 Campus Shared Services (1608 4th Street, Berkeley)

 Keith Samsell, Training Lead, Learning and Development

 Human Resources

This comprehensive foundation course details the process of using Microsoft Publisher for desktop publishing; including the development and design of publications that incorporate text, graphics, and objects for internal production or commercial printing.

Learning Objectives
• Identify the elements of the Microsoft Publisher interface.
• Define page layout and structure to organize pages and...   More >

Tuesday, June 19, 2018

Workplace Civility: Respect in Action

Workshop | June 19 | 9 a.m.-12 p.m. | University Hall, Room 24

 Julia Horvath, Staff Ombuds Office

 Staff Ombuds Office

Learn practical steps for promoting civility at work, including guidelines for considerate conduct and ideas for creating a more inclusive work environment. Participants will also learn how to help their unit establish group norms and effective ways to respond to rudeness.

Microsoft Excel 3D Geo Mapping

Course | June 19 | 1:30-4 p.m. | 28 University Hall

 Keith Samsell, Training Lead, Learning and Development

 Human Resources

This course details the process of producing three-dimensional, interactive maps using data values contained within a Microsoft Excel workbook. Emphasis is placed on geocoding location fields, definition of map properties, and assembly of scenes into guided video tours of multiple data perspectives.

Learning Objectives
* Compare and contrast 3D Maps, Charts, PivotTables, and PivotCharts...   More >

Wednesday, June 20, 2018

bDrive and Box File Sharing

Course | June 20 | 9 a.m.-12 p.m. | 28 University Hall

 Kathleen Valerio, Central Human Resources, Learning and Development

 Human Resources

Learn to store and share files using Google Drive and Box. Each application has different strengths and limitations, explore which one better suits your workflow depending on your use case. Each application offers the ability to set permission levels per document or folder as Private, UC Berkeley, anyone with a link, or Public. You may also ask others to contribute as editors, make suggestions,...   More >

Tuesday, July 10, 2018

Microsoft Access Database Relationships

Course | July 10 | 1:30-4 p.m. | 28 University Hall

 Keith Samsell, Training Lead, Learning and Development

 Human Resources

This course details the concepts and practices of designing a relational Microsoft Access database. Emphasis is placed on Table normalization strategies, defining multi-table relationships, and understanding the implications and benefits of a relational environment on other database objects such as Queries, Forms, and Reports.

Learning Objectives
* Understand the purpose and interdependencies...   More >

Wednesday, July 11, 2018

Microsoft Excel Spreadsheet Design and Formatting

Course | July 11 | 9 a.m.-12 p.m. | 28 University Hall

 Kathleen Valerio, Central Human Resources, Learning and Development

 Human Resources

Spreadsheet Basics: Learn how to navigate in and across spreadsheets. Use AutoFill to build spreadsheets and link them into quarterly reports with basic equations in Microsoft Excel.

Learning objectives:

* Insert and format data.
* Use AutoFill.
* Insert/delete hide and unhide rows and columns.
* Name, move, add and delete worksheets.
* Apply filters and sorts.
* Export files to Excel...   More >

Tuesday, July 17, 2018

HTML Fundamentals

Course | July 17 | 1:30-4 p.m. | 28 University Hall

 Keith Samsell, Training Lead, Learning and Development

 Human Resources

This course details the process of developing web pages using Hypertext Markup Language (HTML). Emphasis is placed on HTML theory and syntax, common tags and tag attributes, and the integration of graphics and color to enhance formatting and branding.

Learning Objectives
* Understand the relationship between website content and the infrastructure of the Internet.
* Formulate Uniform Resource...   More >

Wednesday, July 18, 2018

Microsoft PowerPoint Fundamentals

Course | July 18 | 1-4 p.m. | 28 University Hall

 Kathleen Valerio, Central Human Resources, Learning and Development

 Human Resources

This foundation course details the process of developing structured PowerPoint presentations and enhancing those presentations by integrating formatting features, visual elements, animations, and slide transitions.

Learning Objectives
• Identify the elements of the Microsoft PowerPoint Interface.
• Understand the functional purpose of each PowerPoint view.
• Develop a presentation slide...   More >

Wednesday, July 25, 2018

Microsoft Excel 3D Geo Mapping

Course | July 25 | 1:30-4 p.m. | 239 Campus Shared Services (1608 4th Street, Berkeley)

 Keith Samsell, Training Lead, Learning and Development

 Human Resources

This course details the process of producing three-dimensional, interactive maps using data values contained within a Microsoft Excel workbook. Emphasis is placed on geocoding location fields, definition of map properties, and assembly of scenes into guided video tours of multiple data perspectives.

Learning Objectives
* Compare and contrast 3D Maps, Charts, PivotTables, and PivotCharts...   More >