Link: UCOP's e-newsletter

Stay Informed. Stay Connected.

Loading Events

« All Events

  • This event has passed.

Excel: Advanced Data Analysis – Session 1

Thursday, September 14, 2023, 9:00 am12:00 pm

In this two-part class, participants will learn:

  • Essential Excel Skills
  • Work with multiple worksheets and workbooks
  • Share and protect workbooks
  • Automate workbook functionality
  • Introduction to Macros and VBA
  • Dynamic arrays
  • FILTER, SORTBY, UNIQUE and other functions
  • Auditing Tools
  • Forecast data
  • Trends, Analyze Data tool, and Forecast Sheet
  • Create sparklines
  • Map data
  • Maps and 3D Maps

Participants must attend both sessions:

  • Thursday, September 14 (9am-12pm)
  • Thursday, September 21 (9am-12pm)

Note: Excel: Introduction to Data Analysis is a prerequisite to this class.