Excel Intermediate/Advanced - Session 1 of 2
2026-03-04 09:00 - 12:00 (America/Los_Angeles) | Online
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 three-hour session you will become aware of a few core Excel features that you can use right away and that other capabilities do exist that you can build on later as your Excel knowledge increases. We start with these features, and if time permits, cover other interesting features.

SumIFs, AveregeIFs, CountIFs : Get what you need from your data with minimal effort
Tables (with structured referencing): Look good and be organized
Pivot Tables: The easiest, best method to get unexpected and expected answers from you giant, messy data set

You must attend both sessions. Second session is Wednesday, March 11, 9 AM- 12PM

Smartsheet Essentials: Project Planning Made Simple
2026-03-05 10:00 - 12:00
This foundational session is designed for new users and project managers seeking to understand how to leverage Smartsheet for project planning and execution. Through practical demonstrations and hands-on activities, participants will gain the knowledge to set up and manage projects confidently, using features such as Gantt charts, task assignments, and resource allocation. Key Takeaways:

Understand Smartsheet’s project management basics, including workspaces and sheet creation.
Build and manage Gantt charts with dependencies and critical paths.
Assign tasks and manage resources effectively.
Explore Smartsheet templates for efficient project planning.
Learn best practices for reporting project progress.

This is part of the | UCOP Project Management Collection

Accessible PDF Documents
2026-03-25 13:00 - 14:30
Building off the Creating Accessible Documents 1: MS Office training, Accessible PDF Documents offers a deep dive into using Adobe Acrobat Pro to manipulate, tag, and test PDF documents for accessibility. We will cover tagging documents from scratch, what common accessibility errors are, tables, and building accessible PDF forms. In order to fully participate in this class, you will need to have Adobe Acrobat Pro installed (not just Acrobat Reader). Prerequiste course: Creating Accessible Documents 1: MS Office training
