Spreadsheets 201: Advanced Spreadsheet Uses for Research

In this workshop, participants will learn about advanced uses for spreadsheets including using spreadsheets to replace other programs and adapting spreadsheets as a custom tool for a given project. The instructor will use a number of examples from his own projects including using spreadsheets as a replacement for transcription software and using spreadsheets for linguistic and textual analysis. We will also look at advanced formulae and how to use them to enhance your workflow and do things beyond what they were originally intended, how to use conditional formatting to speed up workflow, use of PivotTables, and some advanced graphing functions. As a part of this workshop, participants are encouraged to bring their laptops and current spreadsheet projects to the workshop and the instructor will assist with any current issues you may be facing with your spreadsheets for the final hour of the workshop.