Training

Calendar and Events

Upcoming Events

Tuesday, August 21, 2018

Job Search Effectiveness: Becar355

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

 Terrie Moore

 Linda Lundenberg

 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.

Wednesday, August 22, 2018

Microsoft Excel Linking and Referencing Calculations: Betec033

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

 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 >

Tuesday, August 28, 2018

Microsoft Access Query Design: Betec018

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

 Keith Samsell

 Human Resources

Wednesday, August 29, 2018

Work Style and Your Career: Becar151

Workshop: Career Development/Job Search Skills: Professional Skills Development | August 29 | 12-1:30 p.m. | 370 Dwinelle Hall

 Terrie Moore

 Human Resources


Thursday, September 6, 2018

Microsoft Excel Data Validation and Security: Betec031

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

 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 >

Sunday, September 9, 2018

Effective Resume Writing: Becar350

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

 Linda Lundenberg

 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.

Wednesday, September 12, 2018

HCM/Read Only: Becss234

Workshop: Professional Skills Development: Technology and Systems Training | September 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.

Your Values at Work: Becar150

Workshop: Career Development/Job Search Skills: Professional Skills Development | September 12 | 12-1:30 p.m. | 370 Dwinelle Hall

 Terrie Moore

 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.

Qualtrics Survey Design: Betec036

Workshop: Professional Skills Development: Technology and Systems Training | September 12 | 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, September 18, 2018

Program Management Leadership Intensive Workshop: Bus Adm 1075

Workshop: Manager and Supervisor Development: Professional Skills Development | September 18 – 20, 2018 every day | 9 a.m.-5 p.m. | 213 UC Berkeley Extension (Golden Bear Center)

 Elie Asmar, M.S.E., CKM, PMP, Co-Founder and President, Interpro.com

 Tom Kendrick, M.B.A., M.S.E.E., PMP

 Human Resources, UC Berkeley Extension

Program management involves simultaneously managing multiple interrelated projects. In this three-day intensive workshop, you learn practical skills and strategies to decompose a complex deliverable into manageable pieces, and to identify and develop coherent plans for managing interproject dependencies.You also gain insight into providing effective project-level guidance when leading a...   More >

HCM/Data Entry: Becss235

Workshop: Professional Skills Development: Technology and Systems Training | September 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

Your Professional Online Network: Becar354

Workshop: Career Development/Job Search Skills: Professional Skills Development | September 18 | 12-1 p.m. | 24 University Hall

 Robyn Pease

 Human Resources

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

Microsoft Excel PivotTables and PivotCharts (BETEC009)

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

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

Microsoft Excel PivotTables and PivotCharts: Betec009

Workshop: Professional Skills Development: Technology and Systems Training | September 18 | 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, September 19, 2018

Program Management Leadership Intensive Workshop: Bus Adm 1075

Workshop: Manager and Supervisor Development: Professional Skills Development | September 18 – 20, 2018 every day | 9 a.m.-5 p.m. | 213 UC Berkeley Extension (Golden Bear Center)

 Elie Asmar, M.S.E., CKM, PMP, Co-Founder and President, Interpro.com

 Tom Kendrick, M.B.A., M.S.E.E., PMP

 Human Resources, UC Berkeley Extension

Program management involves simultaneously managing multiple interrelated projects. In this three-day intensive workshop, you learn practical skills and strategies to decompose a complex deliverable into manageable pieces, and to identify and develop coherent plans for managing interproject dependencies.You also gain insight into providing effective project-level guidance when leading a...   More >

Thursday, September 20, 2018

Program Management Leadership Intensive Workshop: Bus Adm 1075

Workshop: Manager and Supervisor Development: Professional Skills Development | September 18 – 20, 2018 every day | 9 a.m.-5 p.m. | 213 UC Berkeley Extension (Golden Bear Center)

 Elie Asmar, M.S.E., CKM, PMP, Co-Founder and President, Interpro.com

 Tom Kendrick, M.B.A., M.S.E.E., PMP

 Human Resources, UC Berkeley Extension

Program management involves simultaneously managing multiple interrelated projects. In this three-day intensive workshop, you learn practical skills and strategies to decompose a complex deliverable into manageable pieces, and to identify and develop coherent plans for managing interproject dependencies.You also gain insight into providing effective project-level guidance when leading a...   More >

Tuesday, September 25, 2018

Microsoft Project Fundamentals (BETEC001)

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

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

Microsoft Project Fundamentals: Betec001

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

 Keith Samsell

 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, September 26, 2018

First take/ second look: Exploring Unconscious Bias

Workshop: Conflict Resolution and Prevention Training: Manager and Supervisor Development: Multicultural Education: Professional Skills Development | September 26 | 9-11:30 a.m. | 24 University Hall

 Equity and Inclusion, Vice Chancellor

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 >

Interviewing for the Job: Becar352

Workshop: Career Development/Job Search Skills: Professional Skills Development | September 26 | 12-1:30 p.m. | 370 Dwinelle Hall

 Linda Lundenberg

 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.

Tuesday, October 2, 2018

Microsoft Excel Nested and Logical Functions (BETEC023)

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

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

Microsoft Excel Nested and Logical Functions: Betec023

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

 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 >

Thursday, October 4, 2018

Informational Interviewing: Becar351

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

 Linda Lundenberg

 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.

Friday, October 5, 2018

The Power of Self-Compassion: Becox080

Workshop: Professional Skills Development: Other | October 5 | 2:30-3:15 p.m. | Stephens Hall, Geballe Room

 Alicia Mandac

 Human Resources

The Future of Advising (a pecha kucha featuring Isela Pena Rager, Chetan Chowdry, Elizabeth Storer, Amy Azuma, Zachary Chestnut, Heidi Church and Omar Ramirez): Becox081

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

 Isela Pena Rager; Chetan Chowdry; Elizabeth Storer; Amy Azuma; Zachary Chestnut; Heidi Church; Omar Ramirez

 Human Resources

Tuesday, October 9, 2018

Microsoft Access Report Design: Betec027

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

 Keith Samsell

 Human Resources

"This course details the process of creating new Report objects in a Microsoft Access database. Emphasis is placed on core functional concepts of data visibility from Tables and Queries, Controls and Control properties, design and formatting, and summary Controls.

• Understand the purpose and interdependencies of the six major database object types.
• Understand the functional concepts of...   More >

Wednesday, October 10, 2018

HCM/Read Only: Becss234

Workshop: Professional Skills Development: Technology and Systems Training | October 10 | 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.

Mep - Let's Talk: Engaging in Cross-cultural Communication

Workshop: Conflict Resolution and Prevention Training: Manager and Supervisor Development: Multicultural Education: Professional Skills Development | October 10 | 9 a.m.-12 p.m. | 24 University Hall

 Equity and Inclusion, Vice Chancellor

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, October 16, 2018

Intensive Workshop in Emotional Intelligence for Leaders: Bus Adm 1102

Workshop: Career Development/Job Search Skills: Conflict Resolution and Prevention Training: Manager and Supervisor Development: Professional Skills Development | October 16 – 17, 2018 every day | 9 a.m.-5 p.m. | 213 UC Berkeley Extension (Golden Bear Center)

 Danielle Harlan, M.A., Ph.D, Founder and CEO, Center for Advancing Leadership and Human Potential

 UC Berkeley Extension

Learn to use emotional intelligence (EI) to communicate more effectively and improve your interactions with co-workers, staff and management. Through a combination of self-assessments, personal-reflection and group activities, scenario role playing, and interactive classroom discussion, you’ll gain exposure and practice using EI to successfully navigate various social and professional situations...   More >

HCM/Data Entry: Becss235

Workshop: Professional Skills Development: Technology and Systems Training | October 16 | 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

Wednesday, October 17, 2018

Intensive Workshop in Emotional Intelligence for Leaders: Bus Adm 1102

Workshop: Career Development/Job Search Skills: Conflict Resolution and Prevention Training: Manager and Supervisor Development: Professional Skills Development | October 16 – 17, 2018 every day | 9 a.m.-5 p.m. | 213 UC Berkeley Extension (Golden Bear Center)

 Danielle Harlan, M.A., Ph.D, Founder and CEO, Center for Advancing Leadership and Human Potential

 UC Berkeley Extension

Learn to use emotional intelligence (EI) to communicate more effectively and improve your interactions with co-workers, staff and management. Through a combination of self-assessments, personal-reflection and group activities, scenario role playing, and interactive classroom discussion, you’ll gain exposure and practice using EI to successfully navigate various social and professional situations...   More >

bCal Fundamentals: Betec003

Workshop: Professional Skills Development: Technology and Systems Training | October 17 | 9 a.m.-12 p.m. | 28 University Hall

 Kathleen Valerio

 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...   More >

Friday, October 19, 2018

Fraud Alert: Identifying and Addressing Impostor Syndrome with Amy Honigman: Becox082

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

 Amy Honigman

 Human Resources

The College of Wellness with Ricky Vides: Becox083

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

 Ricky Vides

 Human Resources

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.

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 >

HTML Fundamentals: Betec035

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

 Keith Samsell

 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 >

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 >

Tuesday, October 30, 2018

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

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 >

Microsoft Excel Scenario Analysis: Betec032

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

 Keith Samsell

 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

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 >

Microsoft Excel Query Editor: Betec025

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

 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 >

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

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

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

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 >

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 >

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 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 >

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 >

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 >

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 >