CORONAVIRUS UPDATE: The library is closed effective Tuesday, March 24th. Continuing services will include: access to online materials; reference, class or research consultations; and assistance with securing expanded online access to curriculum-based and/or research materials. For more information see the Georgetown Libraries COVID-19 Updates and Resources page and the Library's COVID-19 FAQ.
This workshop is for anyone looking to make the most of Excel for cleaning and/or analyzing your data. It will give you step-by-step practice with some of the most helpful formulas, tips, and tools to save you time working with large data sets in Excel. Learn how to find and highlight blank cells, create a pivot table to automatically calculate totals by category, and apply the =TEXT formula to convert data into more flexible formats. If you bring your own data set, we'll save the last 30 minutes to problem-solve and address specific issues to advance your data cleanup and analysis process. No prerequisites, though some basic Excel experience is recommended.