Data Skills: Data Wrangling with Excel I
Excel provides many powerful features that can assist you in managing your data and help to better understand small and large data sets. Before using SPSS, GIS, or data visualization software you will need your data to look a specific way. Often when you acquire or collect data for a research project the data needs to be massaged into a different format before it can be put into other analysis programs. Excel also provides a quick and easy way to perform one-time analysis or visualizations of your data. This workshop will focus on getting started in Excel including:
- Introduction to the Excel workspace
- Defining workbooks, worksheets, columns, rows, and cells
- Tips and tricks for data entry, navigation and formatting
- Importing data from other sources
- Introduction to formulas
Do you know how to use autolist or freeze panes? Can you use this function ∑ ? If you answered no to either of these questions this workshop is for you.
Location: This workshop will be hosted in the Stewart Building, room 2500.
This workshop is the first of two Excel workshops as part of the Data Skills series. If you are interested in learning about complicated formula construction, functions, charts, attend the Data Wrangling with Excel II workshop. This workshop uses Excel 2016 for Windows.
- Thursday, September 21, 2017
- 9:00am - 11:00am
- Other - See Description
- Maps, GIS & Data