Maximize your Excel skills and earn a learning certificate by participating in the UCOP Learning and Development Data Analysis Series. You’ll learn how to use several tools within Microsoft Excel to organize data, present it cohesively and utilize it in decision-making. Classes will build upon each other, building your skills and knowledge over time.

This series runs twice a year, and all four courses are required for the certificate of completion. If you’ve finished any series course within the last two years, it will count towards your certificate. We recommend, but do not require, that you attend the series in the order they are offered below.

Sign up for certificate classes today

Select the course name to register; classes take place virtually and listings reflect Pacific Time.

Excel Introduction to Data Analysis
Aug. 19 and Aug. 26, 9 a.m. – 12 p.m.
Learn how to use Excel’s built-in data analysis tools to better understand your records and use them for decision-making purposes. We’ll cover analyzing data in lists and tables, summary-based IF Functions, chart tools, and building and working with PivotTables and PivotCharts.

Excel Advanced Data Analysis
Sept. 8 and Sept. 15, 9 a.m. – 12 p.m.
In this two-part class, we’ll focus on essential advanced Excel skills. Topics will include:

• Working with multiple worksheets and workbooks, sharing and protecting workbooks, and automating workbook functionality, including an introduction to macros and VBA
• Dynamic arrays, including filter, sort by, unique and other functions
• Auditing tools
• Forecasting data, including determining trends, utilizing the analyze data tool,  building forecast sheets and creating sparklines
• Data mapping

Excel Power Pivot
Oct. 7 and Oct. 9, 9 a.m. – 12 p.m.
Advance your Excel skills by learning Power Pivot! In this class, you’ll become familiar with using PowerPivot to import and manipulate data, create reports, use DAX functions and distribute data.

Excel Power BI
Nov. 5 and Nov. 18, 9 a.m. – 12 p.m.
Learn about and practice using Power BI in this three-session workshop. Attendees will learn how to connect to data sources; perform data cleaning, profiling and shaping; visualize data and create interactive visualizations; enhance reports and dashboards; and publish and share reports and dashboards. You will need Power BI Desktop installed on your computer for this class. Learn how to request software.

For questions about these courses, contact ucopld@ucop.edu.

About

View all post by