264 Hesburgh Library (Technology Commons)
Explore Google Sheets to master functions, formatting, and data visualization to produce actionable insights.
Unlock the power of Google Sheets in this hands-on workshop designed for spreadsheet beginners. You'll learn to navigate the interface, work efficiently with data, and apply essential functions to uncover valuable insights. You’ll explore formatting techniques, sorting and filtering tools, and visualization methods to make data more readable and actionable. In this workshop, you'll gain practical, real-world data-wrangling skills that you can apply immediately. Whether you're managing projects, analyzing trends, or organizing information, these foundational skills will boost your efficiency and confidence in working with quantitative data.
Prerequisites:
None
Learning goals:
- Master the interface—Understand the layout, menus, and basic functions of Google Sheets.
- Work with data—Import, clean, and appropriately type and format data.
- Master essential function types—Learn to create insights with mathematical, spillable, volatile, conditional, and lookup functions.
- Create visual insights—Use conditional formatting, filter views, and advanced sort-and-filter functions to create insights on the fly.
- Optimize readability—Use styling to improve readability and usability.
