Training

Calendar and Events

Upcoming Events

Tuesday, October 23, 2018

Job Interview Practice: Becar353

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

 Terrie Moore

 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 Excel Spreadsheet Design and Formatting (BETEC011): Betec011

Workshop: Technology and Systems Training | October 23 | 1-4 p.m. | 24 University Hall

 Kathleen Valerio

 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 >

HTML Fundamentals (BETEC035)

Workshop: Technology and Systems Training | October 23 | 1:30-4 p.m. | S300T Haas School of Business

 Keith Samsell, Central HR, 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...   More >

Wednesday, October 24, 2018

Identifying and Addressing Workplace Bullying: Beomb002

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

 Ombuds

Thursday, October 25, 2018

MEP Looking In/Looking Out: Exploring Workplace Diversity at Cal

Workshop: Conflict Resolution and Prevention Training: Manager and Supervisor Development: Multicultural Education: Professional Skills Development | October 25 | 1-3:30 p.m. | 24 University Hall

 Equity and Inclusion, Vice Chancellor

This workshop engages participants in exploring human diversity by reflecting on what makes individuals unique and how it affects one’s worldview. Through telling stories, participants learn more about themselves and others in their organization. This interactive workshop also provides opportunities to practice communication skills for understanding across difference. By the end of this workshop...   More >

Looking in/ Looking out: Exploring Workplace Diversity at Cal: Beeqi003-181025

Workshop: Multicultural Education | October 25 | 1-3:30 p.m. | 24 University Hall

 Sidalia Reel

 Human Resources

This workshop engages participants in exploring human diversity by reflecting on what makes individuals unique and how it affects one’s worldview. Through telling stories, participants learn more about themselves and others in their organization. This interactive workshop also provides opportunities to practice communication skills for understanding across difference. By the end of this workshop...   More >

Tuesday, October 30, 2018

Microsoft Excel Spreadsheet Design and Formatting (BETEC011): Betec011

Workshop: Technology and Systems Training | October 30 | 1-4 p.m. | 24 University Hall

 Kathleen Valerio

 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 Access Action Queries: Betec037

Workshop: Professional Skills Development: Technology and Systems Training | October 30 | 1:30-4 p.m. | 28 University Hall

 Keith Samsell

 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 >

Thursday, November 1, 2018

All Things Financial: An Update from Financial Aid with Nicole Hill: Becox084

Workshop: Professional Skills Development: Other | November 1 | 2:30-3 p.m. | Stephens Hall, Geballe Room

 Nicole Hill

 Human Resources

Best of the Best: An Encore Presentation of the NACADA Region 9 Best of Conference Presentation - Minor Setback for Major Comeback with B. Yuki Burton, Angel Klyce and Miguel Eagmiguel: Becox085

Workshop: Professional Skills Development: Other | November 1 | 3:15-4:30 p.m. | Stephens Hall, Geballe Room

 B. Yuki Burton; Angel Klyce; Miguel Eagmiguel

 Human Resources

Monday, November 5, 2018

Adobe Acrobat Fundamentals (BETEC038): Betec038

Workshop: Technology and Systems Training | November 5 | 1-4 p.m. | 28 University Hall

 Kathleen Valerio

 Human Resources

This course details the process of designing PDF (Portable Document Format) files using Adobe Acrobat. Emphasis is placed on design tools, content management, form design basics, and integration with Microsoft Office applications.

Learning Objectives
* Identify the elements of the Acrobat user interface and workspace.
* Use multiple views to navigate documents and access specific functions...   More >

Wednesday, November 7, 2018

Microsoft Excel Charts: Betec022

Workshop: Professional Skills Development: Technology and Systems Training | November 7 | 1-4 p.m. | 28 University Hall

 Kathleen Valerio

 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, November 8, 2018

Microsoft Excel Scenario Analysis (BETEC032)

Workshop: Technology and Systems Training | November 8 | 1:30-4 p.m. | S300T Haas School of Business

 Keith Samsell, Central HR, 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 >

Wednesday, November 14, 2018

HCM/Read Only: Becss234

Workshop: Professional Skills Development: Technology and Systems Training | November 14 | 9-11 a.m. | 239 Campus Shared Services (1608 4th Street, Berkeley)

 Ying Y Kuah, Campus Shared Services

 Human Resources

Objectives: Learn HCM terminology Understand the Human Resources process flow Learn how to sign on and navigate HCM Search/inquire within the HCM system.

Thursday, November 15, 2018

First Take / Second Look: Exploring Unconscious Bias: Beeqi001-181115

Workshop: Multicultural Education | November 15 | 1-3:30 p.m. | 24 University Hall

 Sidalia Reel

 Human Resources

This workshop engages staff in a discussions regarding how we may be not always aware of how we may be engaging in behaviors that might be problematic for others, as well as what to do about situations where we may be on the receiving end of biased behavior. The workshop features interactive learning, variation in group size and discussions. The outcomes of the workshop are: • To understand what...   More >

Microsoft Excel Query Editor (BETEC025)

Workshop: Technology and Systems Training | November 15 | 1:30-4 p.m. | S300T Haas School of Business

 Keith Samsell, Central HR, 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 >

Tuesday, November 20, 2018

HCM/Data Entry: Becss235

Workshop: Professional Skills Development: Technology and Systems Training | November 20 | 9 a.m.-4 p.m. | 239 Campus Shared Services (1608 4th Street, Berkeley)

 Ying Y Kuah, Campus Shared Services

 Human Resources

Objectives: Learn HCM terminology Understand the Human Resources process flow Learn how to sign on and navigate HCM Search, enter, and update records within the HCM system

Tuesday, November 27, 2018

Microsoft Excel Formulas and Functions: Betec007

Workshop: Technology and Systems Training | November 27 | 1:30-4 p.m. | 24 University Hall

 Keith Samsell

 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 >

Friday, November 30, 2018

Disruptive Advising and the e-portfolio with Elizabeth Wilcox (originally delivered at the University of Notre Dame conference on Advising Highly Talented Undergraduates): Becox086

Workshop: Professional Skills Development: Other | November 30 | 3-3:30 p.m. | Stephens Hall, Geballe Room

 Elizabeth Wilcox

 Human Resources

The Inflexible Student with Elizabeth Wilcox: Becox087

Workshop: Professional Skills Development: Other | November 30 | 3:45-4:45 p.m. | Stephens Hall, Geballe Room

 Elizabeth Wilcox

 Human Resources

Tuesday, December 4, 2018

Certificate Program in Human Resource Management Online Information Session

Information Session | December 4 | 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

Microsoft Word Mail Merge Automation: Betec034

Workshop: Professional Skills Development: Technology and Systems Training | December 4 | 1:30-4 p.m. | 28 University Hall

 Keith Samsell

 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, December 5, 2018

Collaborating Effectively in the Workplace: Beomb002

Workshop | December 5 | 9 a.m.-12:30 p.m. | 24 University Hall

 Ombuds

Microsoft OneNote Fundamentals: Betec028

Workshop: Professional Skills Development: Technology and Systems Training | December 5 | 1-4 p.m. | 28 University Hall

 Kathleen Valerio

 Human Resources

""This course details the process of managing information in a structured format using Microsoft OneNote notebooks. Emphasis is placed on data management and formatting, embedded objects and drawing tools, recorded audio and video notes, and protection of sensitive data.

• Identify the elements of the Microsoft OneNote interface.
• Structure Notebooks using Pages, Subpages, Sections, and...   More >

Thursday, December 6, 2018

Let's Talk: Engaging in Cross-Cultural Communication: Beeqi004-181206

Workshop: Multicultural Education | December 6 | 1-4 p.m. | 24 University Hall

 Sidalia Reel

 Human Resources

This workshop engages participants in conversations regarding “what gets in the way” when communicating across difference. This workshop reviews interactive communication theory and U.S. domestic dynamics of Human Diversity. Participants will work with each other in discussing and applying this information in varied situations. By the end of this workshop participants will: •Increase awareness of...   More >

Tuesday, December 11, 2018

Microsoft PowerPoint Advanced Visual Design (BETEC039)

Workshop: Technology and Systems Training | December 11 | 1:30-4 p.m. | S300T Haas School of Business

 Keith Samsell, Central HR, 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 >

Microsoft PowerPoint Advanced Visual Design: Betec039

Workshop: Professional Skills Development: Technology and Systems Training | December 11 | 1:30-4 p.m. | S300T Haas School of Business

 Keith Samsell

 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 >

Wednesday, December 12, 2018

HCM/Read Only: Becss234

Workshop: Professional Skills Development: Technology and Systems Training | December 12 | 9-11 a.m. | 239 Campus Shared Services (1608 4th Street, Berkeley)

 Ying Y Kuah, Campus Shared Services

 Human Resources

Objectives: Learn HCM terminology Understand the Human Resources process flow Learn how to sign on and navigate HCM Search/inquire within the HCM system.

Thursday, December 13, 2018

Microsoft Excel Database and Lookup Functions: Betec024

Workshop: Professional Skills Development: Technology and Systems Training | December 13 | 1:30-4 p.m. | 239 Campus Shared Services (1608 4th Street, Berkeley)

 Keith Samsell

 Human Resources

"Course Description
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...   More >

Monday, December 17, 2018

Microsoft Excel Spreadsheet Design and Formatting: Betec011

Workshop: Technology and Systems Training | December 17 | 1-4 p.m. | 28 University Hall

 Kathleen Valerio

 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, December 18, 2018

HCM/Data Entry: Becss235

Workshop: Professional Skills Development: Technology and Systems Training | December 18 | 9 a.m.-4 p.m. | 239 Campus Shared Services (1608 4th Street, Berkeley)

 Ying Y Kuah, Campus Shared Services

 Human Resources

Objectives: Learn HCM terminology Understand the Human Resources process flow Learn how to sign on and navigate HCM Search, enter, and update records within the HCM system

Tuesday, January 8, 2019

Microsoft Access Database Relationships: Betec017

Workshop: Technology and Systems Training | January 8 | 1:30-4 p.m. | 28 University Hall

 Keith Samsell

 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 >

Tuesday, January 15, 2019

Microsoft Excel VBA Function Programming: Betec010

Workshop: Technology and Systems Training | January 15 | 1:30-4 p.m. | 28 University Hall

 Keith Samsell

 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 >

Tuesday, January 22, 2019

Microsoft Excel Formulas and Functions: Betec007

Workshop: Technology and Systems Training | January 22 | 1:30-4 p.m. | S300T Haas School of Business

 Keith Samsell

 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 >

Tuesday, January 29, 2019

Microsoft Excel PivotTables and PivotCharts (BETEC009): Betec009

Workshop: Technology and Systems Training | January 29 | 1:30-4 p.m. | S300T Haas School of Business

 Keith Samsell

 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, February 6, 2019

Google Forms Design: Betec008

Workshop: Technology and Systems Training | February 6 | 1-4 p.m. | 28 University Hall

 Kathleen Valerio

 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 >

Saturday, February 9, 2019

Workplace Civility: Respect in Action

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

 Ombuds

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.

Monday, February 25, 2019

Microsoft Excel Nested and Logical Functions: Betec023

Workshop: Technology and Systems Training | February 25 | 1:30-4 p.m. | 28 University Hall

 Keith Samsell

 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 >

Tuesday, March 5, 2019

Google Sheets Spreadsheet Design and Formatting: Betec004

Workshop: Technology and Systems Training | March 5 | 9 a.m.-12 p.m. | 28 University Hall

 Keith Samsell

 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 >

Wednesday, March 6, 2019

Adobe Acrobat Fundamentals: Betec038

Workshop: Technology and Systems Training | March 6 | 1-4 p.m. | 28 University Hall

 Kathleen Valerio

 Human Resources

This course details the process of designing PDF (Portable Document Format) files using Adobe Acrobat. Emphasis is placed on design tools, content management, form design basics, and integration with Microsoft Office applications.

Learning Objectives
* Identify the elements of the Acrobat user interface and workspace.
* Use multiple views to navigate documents and access specific functions...   More >

Wednesday, March 13, 2019

Microsoft Excel Query Editor: Betec025

Workshop: Technology and Systems Training | March 13 | 1:30-4 p.m. | 28 University Hall

 Keith Samsell

 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, March 20, 2019

Identifying and Addressing Workplace Bullying

Workshop | March 20 | 9 a.m.-3 p.m. | 24 University Hall

 Ombuds

Tuesday, April 9, 2019

Microsoft Excel PivotTables and PivotCharts: Betec009

Workshop: Technology and Systems Training | April 9 | 1:30-4 p.m. | 28 University Hall

 Keith Samsell

 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 10, 2019

Qualtrics Survey Design: Betec036

Workshop: Technology and Systems Training | April 10 | 1-4 p.m. | 28 University Hall

 Kathleen Valerio

 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 >

Tuesday, April 30, 2019

Microsoft Visio Fundamentals: Betec014

Workshop: Technology and Systems Training | April 30 | 1:30-4 p.m. | 239 Campus Shared Services (1608 4th Street, Berkeley)

 Keith Samsell

 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, May 8, 2019

Collaborating Effectively in the Workplace

Workshop | May 8 | 9 a.m.-12:30 p.m. | 24 University Hall

 Ombuds

bMail Fundamentals: Betec005

Workshop: Technology and Systems Training | May 8 | 1-4 p.m. | 28 University Hall

 Kathleen Valerio

 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 >

Wednesday, June 12, 2019

Microsoft Excel Linking and Referencing Calculations: Betec033

Workshop: Technology and Systems Training | June 12 | 1:30-4 p.m. | 28 University Hall

 Keith Samsell

 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 >