Session Description
Let’s get a little geeky with Google Sheets. This session will give you hands-on experience with some of the features built into Sheets that will save you time and solve problems of practice. Learn some of the powerful tricks that Sheets can do that are missing from other spreadsheet applications you might know. We’ll be sure to explore some advanced formula as well as powerful graphs, maps and charts. Some spreadsheet knowledge will be helpful, but a spirit of exploration and a desire to make your life easier are required.
Session Resources:bit.ly/jrasexysheets
Notes
- Filter views will save filter view per user if sharing a large spreadsheet.
- Command + F for find (also access to find and replace)
- Split function: =SPLIT(H2, ” “) [will split a name up from combined to separate first name and second name]
- Capitalisation functions: =PROPER(H2) [capitilises name]; =UPPER(F2); =LOWER(F2)
- Unique function: =UNIQUE(A2:e) [summarises the unique records from a large list]
- Conditional formating: highlight the entire row Conditional Row Format
=$F2=”VGA” Apply A2:M. Also alternate colour rows (great for printing) - Sparklines for in cell mini graphs
- Create a graph with map data fro cities or countries.
- Embed graphs in blogs websites and they will update when you update the data in the sheet.
- Create a Gapminder type graph (interactive) but data must be formatted in table correctly.
Link to practice sheet.
Link to session websites.
