Microsoft Excel Intermediate Workshop

UCSF Staff
(this workshop assumes that you have taken our Beginner Excel Workshop 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)
 
This virtual, half-day, instructor-led workshop is for business users who are already familiar with Microsoft Excel and want to take their skills to the next level. Learn powerful techniques that can help save significant time, analyze data and extract important business insights, present information in a compelling way, and collaborate with others more effectively. 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, including 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. Includes dozens of shortcuts and tips that can be applied on a daily basis.

Location: Virtual (Zoom)

Cost: There is no fee to attend. Late cancellations and no-shows will incur a $75 fee. Each participant is responsible for cancelling their own registration before the cancellation deadline (5 days before).

Time: 8:30am - 12pm.

Flyer: View and share the Microsoft Excel Intermediate Workshop flyer!

Register in the UC Learning Center (MyAccess login required)