Embedded Files
Google Sheets 101 for Data Analysis and More
Google Sheets 101 for Data Analysis and More
Learn to use basic functions in Google Sheets for creating graphs and streamlining data analysis. After this session, educators will be able to use functions, formulas, and other tools in spreadsheets. You can even teach this same lesson to your students!
Resources
Resources
Practice Sheets Activity - Use the template to make your own copy to use in the session. Feel free to make another copy to send to your students in Classroom.
Practice
Practice
Selecting a range (Shift + click)
Create charts
Use functions & formulas
replicate functions
select cells and drag functions from Explore tab
try the =GoogleTranslate & COUNTIF functions
Fill & format cells
Conditional formatting
Split cell contents (Data ⇒ Split text to columns ⇒ Separator)
Add a row
Merge cells & change cell size
Line break (Ctrl + Enter)
Add new sheet & explore tab menus
Add comments
Add checkboxes
Use Kern's templates to practice
Try one of Mr. V's design templates
A More Advanced Tip: =GoogleTranslate formula
A More Advanced Tip: =GoogleTranslate formula
=GoogleTranslate in Sheets.webmReport abuse