Making magic with Google Sheets

A presentation at NERDSummit by Michael Miles

Our lives are structured by the data we resource and how well we can understand it. From keeping track of books we all want to read, managing our finances, to planning team allocations for our projects. For all this there has been a long standing tool to help us manage and sort our data… spreadsheets.

In this session attendees will learn how to utilize spreadsheets (specifically Google Sheets) to almost magically organize, tabulate, process and analyze data for problems small and large.

Attendees will walk away understanding how to approach structuring data for a spreadsheet, how to use basic functions to transform/analyze data, manipulate data with complex features and format data for easy review.

Resources

The following resources were mentioned during the presentation or are useful additional information.