Microsoft Excel Intermediate Workshop

UCSF Staff
This ((Virtual)) workshop is for business users who are already familiar with Microsoft Excel and want to take their skills to the next level. In this workshop, users learn powerful techniques that can help them save significant time, analyze data and extract important business insights, present information in a compelling way, and collaborate with others more effectively. This workshop assumes that you have taken the beginner Excel or used Excel for six months and are familiar with the fundamentals and have some experience creating workbooks, worksheets, cells, ranges, and using a variety of functions and formulas.
 
Key topics covered:
 
  • Data manipulation: Managing budgets and projections, as well as handling large lists of data. Basic and advanced formulas, 3-D ranges, sorting and filtering techniques, database functions, and several other features are covered.
  • Data entry and validation: Using Excel's ability to gather and validate data when applicable. This includes validation rules and conditional formatting.
  • Collaboration: Enabling multiple users to review and edit workbooks by sharing them on the network or via e-mail. Protecting sheets or cells within a sheet to ensure data integrity and confidentiality. Tracking changes, reviewing changes, and accepting changes.
  • Efficiency: Using templates and styles to reuse worksheets, and to set standards and ensure consistency. This also includes dozens of shortcuts and tips that can be applied on a daily basis.

Location: Given the current environment we are converting to virtual sessions. Participants will receive an email with a zoom meeting invite 2 business days before the session.

Cost: Each participant is responsible for canceling their own registration before the cancellation deadline. Not doing so will result in a $35 cancellation fee. This applies to both late cancellation and no show.

Time: 1pm - 4:30pm.

Registration: Click here to register.

Flyer: Click here for a flyer.