Excel

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.

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

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.