Google Sheets
Click an icon below to learn more about that tool.
Below is a list of skills you should know to be able to pass the Level One and Level Two Certifications
Below is a list of skills you should know to be able to pass the Level One and Level Two Certifications
Level One
Level One
- Create a Google Sheet
- Spreadsheet Vocabulary
- Formatting cells
- Using Formula and Functions including Sum, Average, Unique, Count, If
- Sorting Numbers, Text, or Dates
- Organize Data Collected in a Google Sheet
- Analyze the Data in a Google Sheet with Charts and Graphs
- Trendlines
- Copy and paste a Chart to Docs or Slides
- Publish Results from a Google Sheet
- Share Sheets with others
- Protecting sheets and ranges
Level Two
Level Two
- Create a Chart or Graph in Google Sheets including a Motion Chart, Radar Chart
- Create a Pivot table to analyze large data sets
- Use functions including Sort, Filter, CountIF, SumIF, Sum, Unique
- Use the Filter Tool and Filter Views
- Applying Conditional Formatting to efficiently display results
- Use Sparklines
- Import Data Sets and Spreadsheets