Google Sheets
Google Sheets is available to all PCC staff and PCC students who have begun the current term and are registered for classes. Before the first day of a student’s registered term, students will only have access to PCC Google Email, not Google Drive or additional Google Applications.
With Google Sheets, everyone can work together on the same spreadsheet simultaneously. Use formulas, functions, and formatting options to save time and simplify common spreadsheet tasks.
As the creators of Google Sheets, Google creates the best helpful information on the subject. We’ve curated a list of commonly asked questions to help you get answers faster. If the answer you’re looking for isn’t here, look at Google’s full help topics on Google Sheets.
Get started with Google Sheets
- How to use Google Sheets
- Switch to Google Sheets from Microsoft Excel
- Create, view, or download a file
- Create a file from a template
- Edit and format a spreadsheet
Edit and format a spreadsheet
- Edit and format a spreadsheet
- Add or move columns and cells
- Freeze or merge rows and columns
- Protect, hide, and edit sheets
- Format numbers in a spreadsheet
Use functions and formulas
- Google Sheets function list
- Add formulas and functions
- See the sum and average
- IF function
- QUERY function
Work with data
- Create and use pivot tables
- Customize a pivot table
- Reference data from other sheets
- Using arrays in Google Sheets
- Import data sets and spreadsheets
Sort, filter, or format data
- Sort and filter your data
- Create an in-cell dropdown list
- Use conditional formatting rules in Google Sheets
- Split text, remove duplicates, or trim whitespace
- Add and use checkboxes
Create and edit charts
Benefits
- G Suite for Education core services
Service availability
24/7