Link: UCOP's e-newsletter

Stay Informed. Stay Connected.

Excel Power Pivot (Session 2 of 2)

Advance your Excel skills with learning Power Pivot. In this class you will: Become familiar with the PowerPivot application and import data. Manipulate data in a PowerPivot worksheet. Create reports using PowerPivot data. Use


Excel Power Pivot (Session 1 of 2)

Advance your Excel skills with learning Power Pivot. In this class you will: Become familiar with the PowerPivot application and import data. Manipulate data in a PowerPivot worksheet. Create reports using PowerPivot data. Use


Excel Macro and VBA (Session 1 of 2)

Advance your Excel skills by learning VBA/Macros. In this class you will first become familiar with recording repetitive steps with Macros, then altering code, and learning about VBA scope. Then, you will experience Visual


Excel Macro and VBA (Session 2 of 2)

Advance your Excel skills by learning VBA/Macros. In this class you will first become familiar with recording repetitive steps with Macros, then altering code, and learning about VBA scope. Then, you will experience Visual


Excel Power BI (Session 3 of 3)

In this class, users will learn about and practice using Power BI. Users will learn how to: Connect to data sources. Perform data cleaning, profiling, and shaping. Visualize data with Power BI. Create interactive


Excel Power BI (Session 2 of 3)

In this class, users will learn about and practice using Power BI. Users will learn how to: Connect to data sources. Perform data cleaning, profiling, and shaping. Visualize data with Power BI. Create interactive


Excel Power BI (Session 1 of 3)

In this class, users will learn about and practice using Power BI. Users will learn how to: Connect to data sources. Perform data cleaning, profiling, and shaping. Visualize data with Power BI. Create interactive


Excel Advanced Data Analysis

Prerequisite – Intro to Data Analysis Excel Data Analysis Advanced: In this two-part class, participants will learn: Essential Excel Skills Work with multiple worksheets and workbooks. Share and protect workbooks. Automate workbook functionality Introduction to Macros and VBA Dynamic arrays FILTER, SORTBY,


Excel Advanced Data Analysis (Session 1 of 2)

Prerequisite- Intro to Data Analysis Excel Data Analysis Advanced: In this two-part class, participants will learn: Essential Excel Skills Work with multiple worksheets and workbooks. Share and protect workbooks. Automate workbook functionality Introduction to Macros and VBA Dynamic arrays FILTER, SORTBY, UNIQUE


Excel Intermediate/Advanced – Session 1 of 2

Microsoft Excel has hundreds of features and hundreds of functions. Getting the right feature, at the right time, used in the right way, in the right sequence is very often a problem. In this


UCOP Excel Intro To Data Analysis

Making sense of your data is essential in making key decisions for your organization. Master the use of Excel and change the way you do business. This course will teach you how to use


UCOP Excel Pivot Table Techniques

This class will visualize data insights (Charts and KPIs). We will blend data from sources, clean data, explore various views of the data set, and create