Link: UCOP's e-newsletter

Stay Informed. Stay Connected.

Excel Power BI (Session 1 of 3)

Learn Dashboards and reporting using Excel and Power BI, and is ideal for Analysts and staff interested in dashboards and reporting. What You’ll Learn • Preparing Excel data for Power BI • Building Power BI visuals • Designing


Excel Intermediate/Advanced (Session 2 of 2)

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


Excel Intermediate/Advanced (Session 1 of 2)

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


Excel Power Pivot (Session 2 of 2)

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


Excel Power Pivot (Session 1 of 2)

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


Excel: Advanced Data Analysis Session 2

Learn advanced Excel methods for deeper insights, and is Ideal Intermediate Excel users and analysts. What You’ll Learn:  • Advanced PivotTables • Lookup functions (XLOOKUP, INDEX/MATCH) • Trend and forecasting tools • Scenario analysis • Data modeling concepts Software Requirements Microsoft Excel (Microsoft


Excel: Advanced Data Analysis (Session 1 of 2)

Learn advanced Excel methods for deeper insights, and is Ideal Intermediate Excel users and analysts. What You’ll Learn:  • Advanced PivotTables • Lookup functions (XLOOKUP, INDEX/MATCH) • Trend and forecasting tools • Scenario analysis • Data modeling concepts Software Requirements Microsoft Excel (Microsoft


Excel: Introduction to Data Analysis Session 2

This course is an essential Excel tools for data‑driven work, and is Ideal For Beginners to intermediate Excel users and administrative staff. What You’ll Learn Cleaning and preparing data Tables, sorting, and filtering Basic formulas Charts and visual summaries Intro to PivotTables Software


Excel: Introduction to Data Analysis (Session 1 of 2)

Essential Excel tools for data‑driven work. Software Requirements Microsoft Excel (Microsoft 365 desktop version) Recommended Setup A dual‑monitor setup is recommended for the best learning experience. Participants with a single screen can still fully participate; simple adaptations