Excel

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

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...

Lia Chin-Purcell

Consultant
School of Information

Hello! I am a first-year Masters's student at the School of Information in the MIMS program with a focus is in data science and ethics. Before joining Berkeley, I studied computer science at the University of Puget Sound.

Jennifer Kaplan

Consultant
French

Jennifer is a first-year graduate student in the Romance Languages & Literatures program here at Berkeley. She has experience conducting ethnographic fieldwork and is passionate about qualitative research methods.

Tiffany Hamidjaja

Consultant
Sociology

Hello! I’m a Sociology Ph.D. student and National Science Foundation Graduate Research Fellow. My research focuses on children of incarcerated parents as collateral consequences of mass incarceration and the criminal justice system. My two current projects examine: 1) the traumatic impact of viewing a parental arrest on a child in their understanding of criminality, law enforcement, and delinquency outcomes and 2) the compounding effect of parental incarceration and the child welfare system on children. Before joining Berkeley, I was a research assistant at Columbia University...

Tiffany Taylor

PhD Student
Anthropology

Tiffany Taylor is a doctoral student at the University of California, Berkeley. Previously, she received a Master of Public Health in Epidemiology from Columbia University's Mailman School of Public Health. She graduated from the University of Chicago with majors in Political Science, Sociology, and Comparative Race and Ethnic Studies (Asian American Studies). Some of her research interests include social medicine, educational sociology, and social demography. Additional interests include pilates, yoga, and fashion.