Excel

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

Shusheng Li

UTech
Data Science
Economics

Shusheng is currently a third-year undergraduate student studying Data Science and Economics. He is currently a part of the UTech Management team at D-Lab. Shusheng loves playing all types of sports because it's a great way to stay fit and be together with friends. Working as a UTech Front desk, Shusheng loves helping others and directing them to the right resources available.

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.

Daniel Lobo

Graduate Student Researcher (GSR)
Sociology

Hi, my name is Daniel and I’m a Ph.D. student in the Department of Sociology. I’m interested in social theory, education, and social media. One question I’m thinking about right now is under what conditions are universities' sites of social mobility vs. sites of social reproduction. I’m originally from Boston, MA, but have lived in NYC and LA since undergrad. I hold a BA in Social Studies, with high honors, from Harvard College. I identify as Black, queer, and working-class (first-gen).

Michael Ruiz

Senior Data Science Fellow
Psychology

Michael earned his B.A.in Psychology from UC Berkeley and currently works as the manager of Professor Okonofua's Equity, Diversity, and Empathy Navigation Sciences Lab in the UC Berkeley Psychology department.

Bo Yun Park

Postdoc
D-Lab

I am a Postdoctoral Scholar in the D-Lab at the University of California, Berkeley. My research lies at the intersection of political, cultural, and transnational sociology. I am particularly interested in dynamics of social inclusion and exclusion, social change, technology, and digital politics. My dissertation investigated how political strategists in France and the United States craft narratives of political leadership for presidential candidates in the digital age. I received my Ph.D. in Sociology at Harvard University, where I was affiliated with the Institute for Quantitative Social...

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

Frances Leung

Data Science Fellow
School of Information

Frances Leung is a master’s student at UC Berkeley School of Information where she focuses her studies in information and data science. She has a keen interest in leveraging data-driven insights to better understand consumer behaviors and the world around us. In her professional work as a management consultant, she advises retailers and consumer businesses on digital transformation and creating web/mobile experiences that delight consumers through a human-centered approach. Frances holds a Master in Business Administration from York University, Schulich School...