Embedded Files
Advancing at your own pace
Advancing at your own pace
Class Code: tv64t
Class Code: tv64t
Earning a Badge
Earning a Badge
If you would like to skip the Google Sheets Novice Level and jump right into the Google Sheets Intermediate Level, please, work through each of these videos, and complete the same steps in your practice spreadsheet linked on each respective page.
Feel free to work through all three levels at your own pace and refer back to this site as you find the need.
We will cover:
Save time! Import data
Save time! Import data
file types
file compatibility
from Excel (alone) to Sheets (a team)
formatting Data
formatting Data
using the NEW Explore Feature for quick and dirty formatting
splitting columns
merging data in multiple columns
app smashing to fix formatting
conditional formatting
writing beyond-basic formulas
writing beyond-basic formulas
ledger formulas
count
countif
organizing Data
organizing Data
format data
number vs. text
dates
phone numbers
special formatting
alignment
copy formulas vertically
copy formulas horizontally
freeze panes
select all button or control + A
sort function
applying filters
inserting comments about a particular cell
Collaborating within Sheets
Collaborating within Sheets
Using the comment feature to assign jobs
Using the comment feature to give feedback or ask questions
Using the chat feature to instant message people who are in the file simultaneously
Google Sites
Report abuse