What you'll learn

Datasets can be difficult to understand when records are not organized and important patterns are hidden. In this course, Sort, Filter, and Explore Data in Google Sheets, you will gain the ability to organize and examine datasets efficiently. First, you will explore how to safely sort text, numeric, and date fields using sorting tools and the SORT function. Next, you will discover how to filter data using values, conditions, formulas, and filter views. Finally, you will learn how to use summary functions, conditional formatting, visual cues, and Gemini to identify patterns, outliers, gaps, and possible data quality issues. When you are finished with this course, you will have the skills and knowledge of Google Sheets needed to organize datasets, investigate initial findings, and prepare data for deeper analysis.