Spreadsheet

SHEETS (Spreadsheet Commands, Functions and Calculations)

• Split, Concatenate, Transpose, [4:49]  ss-file

• ImportRange command to link spreadsheets [7:27]

• Quickwrites - Collaborative Spreadsheets [6:44]

• Sorting on a calculated column [3:37] - ss-file

• Count, CountA, CountIF, CountIFS, CountBlank [8:10] - spreadsheet - SoCal Birds

• Data Validation [4:46] - ss-file 

• Filter [9:43] - ss file

• Translate [3:49] - ss file 

• Absolute and Relative References [2:31] - ss file

• Performing operations on data in a remote spreadsheet [6:15]

SHEETS (Spreadsheets - Graphing, Charting)

• Scatter plot [6:49] 

• Combination Plots [4:47]

• Area Plots [2:39]

• Pie Charts [2:07]

• Annotating Data Points [3:58]

• Column & Bar Graphs [1:51]

• Max, Min, Ave, Median, Average, % [6:02]

• Line of Best Fit [3:41]

• Creating combination charts [32:42]

SHEETS (Quickwrites, Applications)

• Quickwrites - Collaborative Spreadsheets [6:44]