Link: UCOP's e-newsletter

Stay Informed. Stay Connected.

Loading Events

« All Events

Excel Advanced Data Analysis – Session 2

Wednesday, September 24, 9:00 am – 12:00 pm

Excel Data Analysis Advanced: 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

Prerequisite- Intro to Data Analysis