CTL Grad Studio: USING SPREADSHEETS TO BOOST PRODUCTIVITY

Stumped by Microsoft Excel in your classes or research? Come to this studio to learn to organize, manage and wrangle those datasets.

Have your STEM classes required Microsoft Excel for their models? Are you having trouble wrangling your research data? This workshop will walk you through exercises to help you organize your research data, manage your time better, and make your datasets feel less imposing.

Specifically, we will cover:

• Speedy navigation through a workbook
• Basic functions (sum, average, min/max)
• Filtering and sorting
• Advanced/conditional functions (sumifs, countifs, averageifs)
• Lookups (vlookup and index-match)
• Text manipulation
• How to make your Excel graphs look like they didn't come from Excel

All ability levels are welcome. Just make sure to have Microsoft Excel installed before the workshop! Students can download Microsoft Office for free.

REGISTER HERE

This Grad Studio is presented by the Peer Learning Consultant Program at the Center for Teaching and Learning. For more information about the program and upcoming events, visit studentlearning.stanford.edu/events. For any questions or inquiries, please contact us at academicskills@stanford.edu.

-----------------------------

What are Grad Studios?

A typical Grad Studio starts with activities and discussions centered around a learning and research management topic, followed by a dedicated studio time where students can:

• Apply activity and discussion takeaways to their own graduate work
• Follow-up with Peer Learning Consultants on academic strategies
• Connect with other students to share their experiences

Grad Studios are open to all graduate students, including co-term, Master’s, and PhD students. For Engineering Grad Studios, registration priority will be offered to School of Engineering graduate students.

Learn more about Grad Studios here