Skip to content Skip to site navigation Skip to service navigation

Tech Talks: Excel Data Analysis and Dynamic Array Formulas

Excel is rapidly evolving, bringing powerful new features to enhance your data analysis capabilities.

One of the most exciting developments is dynamic arrays, transforming how we handle data. Join us for this 30-minute Tech Talk, where you'll discover the incredible potential of dynamic arrays and array formulas. Prepare for your eureka moment as you learn to leverage these tools for more efficient and insightful data analysis.

This session will cover: 

  • Introduction to Dynamic Arrays
  • Key Functions and Formulas
  • Practical Applications​


Speaker: Igor Ovchinnikov

Igor Ovchinnikov has been teaching software productivity classes for over 20 years. Stanford staff have enjoyed his training since around 2007. His training philosophy stems from a strong belief that learning is a perpetual cycle of discoveries and improvement.

Register

Custom training workshops are available for this program

Technology training sessions structured around individual or group learning objectives. Learn more about custom training

University IT Technology Training sessions are available to a wide range of participants, including Stanford University staff, faculty, students, and employees of Stanford Hospitals & Clinics, such as Stanford Health Care, Stanford Health Care Tri-Valley, Stanford Medicine Partners, and Stanford Medicine Children's Health.

Additionally, some of these programs are open to interested individuals not affiliated with Stanford, allowing for broader community engagement and learning opportunities.