In this lesson, you analyzed sales data in a community fundraising spreadsheet to makeit more useful for you and your collaborators, to present it to others, and to help you makebusiness decisions based on the data. To do this you:used filters to separate your data and focus on only the information you need,created filter views to see multiple versions of your sheet and share specific views withothers,used the SUM and COUNTIF functions to complete calculations with your data,inserted charts to isolate particular data and display it visually,shared and collaborated in your sheet with comments,used version history to see what changes were made when,and downloaded your project as another file type.
The skills you learned in this lesson are useful for other types of spreadsheets, aswell. For instance, you might usefilters to narrow down task owners in a project tracker,the SUM and COUNTIF functions to make calculations in a budget,charts to demonstrate time spent on a personal project,or sharing and collaborating in a contact sheet for community volunteers.
Keep creating new spreadsheets to master the skills you learned in this lesson.
You can explore more G Suite Certification lessons to learn and practice with other applications!
1. Introduction to G Suite Certification: Sheets - Part 2
2. Sheets: Create Filters and Use Filter Views
3. Sheets: Use Filters to Count, Add, and Summarize Data in a Table — Use Sheets and COUNT
4. Sheets: Use the SUM Function to Analyze Data
5. Sheets: Display Data in a Chart — Create, Insert, and Modify Charts, and Protect Sheets and Ranges
6. Sheets: Use COUNTIF to Generate Numeric Data with Text Values
7. Sheets: Share and Collaborate — Add Comments, View Revision History, and Download Spreadsheets as File Types