- Learning Path Libraries: This path is only available in the libraries listed. To access this path, purchase a license for the corresponding library.
- Data
Google Sheets for Data Analysts
Google Sheets is a cloud-based spreadsheet application that analysts use to import, clean, and analyze data and share findings with stakeholders. This learning path takes you through the full analysis workflow: bringing in data from files and external sources, cleaning and validating it, writing reliable formulas, combining datasets with lookups and QUERY, summarizing with pivot tables, and building interactive dashboards. You'll also learn how to use Gemini in Google Sheets to speed up work and verify results.
**This learning path is actively in production. More content will be added to this path as it gets published and becomes available in the library. To view the full list of content to be included in this Path, click the "About this path" tab below.**
Content in this path
Google Sheets for Data Analysts
Try this learning path for free
What You'll Learn
- How to import and organize data in Google Sheets
- How to clean and prepare data in Google Sheets
- How to sort, filter, and explore data in Google Sheets
- How to transform data in Google Sheets
- How to query and combine data in Google Sheets
- How to summarize and analyze data in Google Sheets
- How to visualize and present data in Google Sheets
- 1. Import and Organize Data in Google Sheets (Video)
- 2. Clean and Prepare Data in Google Sheets (Video)
- 3. Clean a Dataset in Google Sheets (Lab)
- 4. Sort, Filter, and Explore Data in Google Sheets (Video)
- 5. Sort and Filter a Dataset in Google Sheets (Lab)
- 6. Transform Data in Google Sheets (Video)
- 7. Transform a Dataset in Google Sheets (Lab)
- 8. Query and Combine Data in Google Sheets (Video)
- 9. Summarize and Analyze Data in Google Sheets (Video)
- 10. Visualize and Present Data in Google Sheets (Video)
- 11. Visualize a Dataset in Google Sheets (Lab)
- Learners interested in this path should be familiar with core data analysis concepts and techniques. No prior experience with Google Sheets is required.
Learn with the best
