Maximize your Excel skills and earn a learning certificate by participating in the UCOP Learning and Development Data Analysis Series.

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

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

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

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

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

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

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

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,