Excel

Marina Blum

Data Science Fellow
School of Public Health

Marina is a master's student in the Health and Social Behavior division of the School of Public Health. She has extensive experience in ATLAS.ti and can help you get the most out of the program. She is passionate about data visualization, and is happy to help with related questions and questions on qualitative methods.

Maya Samuels-Fair

Instructor, Consultant
Integrative Biology

Maya is an Integrative Biology Ph.D. student in the Finnegan Marine Paleobiology Lab, where she studies life-history evolution and diversity patterns in the marine invertebrate fossil record. She is happy to help with statistical analyses, data visualizations, and simulations in R. She also has recently been dabbling in image analysis, including python-based machine learning and 3D Slicer extension development, and would love to help other newcomers get started.

Bobo Kwok

UTech
Data Science

I am an undergraduate student studying Data Science with an emphasis in Applied Mathematics & Modeling. I enjoy storytelling through data visuals and learning new visualization tools.

Erin Manalo-Pedro

Research Fellow
Community Health Sciences (UCLA)

Erin Manalo-Pedro is a Ph.D. student in the Department of Community Health Sciences at the UCLA Fielding School of Public Health with a minor in education. She focuses her racial health equity research on curriculum, the health workforce, and political interventions for communities of color. Drawing from Public Health Critical Race Praxis and Pinayism, she aims to use methods, like natural language processing and counter storytelling, to document the subtleties of structural racism and resistance from marginalized groups.

To guide her interdisciplinary approach, Erin leverages...

Caroline Figueroa, MD, Ph.D.

Research Fellow, Digital Health Social Justice Project Lead
School of Social Welfare
Digital Health Social Justice

Caroline Figueroa, MD Ph.D., is a Postdoctoral Scholar at UC Berkeley School of Social Welfare. She obtained her MD degree and Ph.D. degree at the University of Amsterdam in the Netherlands. Her Ph.D. research took place at the University of Amsterdam and at the University of Oxford, where she studied cognitive and neurobiological vulnerability factors for recurrence of depression in patients remitted from Major Depressive Disorder. Current research interest is on digital interventions for depression, with an emphasis on developing cutting-edge innovations that tailor to the needs of...

Lawrence Y. Tello

Master's Student
School of Public Health

I am an MPH candidate in Epidemiology & Biostatistics at the School of Public Health. Prior to graduate school, I worked on Psychology and Neuroscience studies. My research interest revolves around psychiatric epidemiology with a focus on suicide prevention. Currently, I am working as an Epidemiologist/Data Analyst for the California Department of Public Health. I love working with messy data, solving coding challenges, and data visualization.

Katherine Wolf

Adjunct Fellow
Environmental Science, Policy, and Management

Doctoral student in Rachel Morello-Frosch's laboratory in the Department of Environmental Science, Policy, and Management working at the intersection of environmental epidemiology, environmental justice, and causal inference. Particularly interested in developing quantitative methods to investigate the operation of social power in environmental monitoring regimes in the United States.

Excel Fundamentals: Lookups with INDEX-MATCH-MATCH

April 18, 2022
Connor Haley

Last week marked the D-Lab’s inaugural “Excel Fundamentals” workshop, and to celebrate I am sharing one of my favorite Excel functions: INDEX-MATCH-MATCH. By combining the INDEX and MATCH functions, we can create a faster and more flexible lookup than the typical approach with VLOOKUP.

First, let’s explore the INDEX function and its three arguments: INDEX(where, down, across). It returns the value of a single cell within a block of data. It knows which cell we are...

Harry Li

UTech
Data Science
Cognitive Science

Hello! I am a third-year undergraduate studying Data Science and Cognitive Science. I love what I'm studying and am also passionate about education policy reform and teaching in general. I'm also a big fan of the Los Angeles Lakers, trying out new recipes, gaming, and fitness!

Eileen Cahill

D-Lab Alumni
School of Information

Eileen is currently a first year Information Management and Systems student committed to studying human-centered design for the utility and usability of healthcare systems. She spent the last few years working in genomic research program analysis and management at the National Human Genome Research Institute. Prior to that, Eileen attended Georgetown University where she studied biology and studio art. During this time, she performed research on water contaminants in an analytical chemistry lab as well as research on estrogen mimicking compound effects on Zebrafish in a brain...