Link: UCOP's e-newsletter

Stay Informed. Stay Connected.

Loading Events

« All Events

Excel Advanced Data Analysis

Tuesday, October 18, 9:00 am12:00 pm

Must attend both sessions:

  • Tuesday, October 18: 9:00am – 12:00pm
  • Tuesday, October 25: 9:00am – 12:00pm

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