Education > Software Systems > Spreadsheets 101
Start with this case study and some simple practices to introduce the idea of google sheets.
Key Strokes you will need to know. Most are basic. A few at are not intuitive
Key Strokes you will need to know. Most are basic. A few at are not intuitive
- Ctl-C and Ctl-v for cells, the stuff in cells, column(s), row(s)
- Ctl-x and backspace for deleting
- Ctl-shift-V for past special values only as a keystroke
- Ctrl-shift-arrow (down/up/right/left) to bulk select (can do ctrl-shift-arrow right to grab a row, and then with ctrl-shift still down, click arrow down to get entire data set selected) (VERY IMPORTANT)
- Paste Special - values and format
- Freeze Rows, sort sheets by column with frozen rows
- Sort Range (not sheet), and do it by a row other than the first row
- Ctrl - Arrow down and Ctrl-Arrow up for jumping around (VERY IMPORTANT)
- You are at the bottom of a large data table with frozen rows at top. You want to get to the first rows of data. do NOT scroll up to get there. click into cell in the frozen area, then arrow down until you go past the botton frozen row. (VERY IMPORTANT).
- To fill the download set ID on the rawTxns worksheet, click into first cell in row and type the value and leave the cell. THEN, highl;ight the cell. Then click on little X in bottom right corner of cell to autofill down.