Whether you’re organizing a project, working with a large dataset or building a report, the right tools can make the work easier.

Learn High level Excel skills for analysis and reporting., and is ideal For Experience Excel users and analysts. What You’ll Learn • Advanced formulas and functions • Conditional formatting • Data validation • PivotTables and PivotCharts • Forecasting tools • Dashboards

Learn Data modeling and BI fundamentals using Excel, and is ideal for Analysts and staff working with large datasets. What You’ll Learn • Data modeling • Relationships • DAX calculations • Measures and KPIs • PivotTables from data models Software Requirements Microsoft

Learn Data modeling and BI fundamentals using Excel, and is ideal for Analysts and staff working with large datasets. What You’ll Learn • Data modeling • Relationships • DAX calculations • Measures and KPIs • PivotTables from data models Software Requirements Microsoft

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

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