Data Skills: Data Wrangling with Excel II
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 be clean and 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. The functions and formulas that you need in order to wrangle your data in preparation for analysis may require intermediate Excel skills. This workshop uses using Excel 2016 for Windows.
This workshop will explore:
- Cleaning and preparing data for analysis
- Charts – creating and getting control of your charts
- Formulas to allow you to extract or reformulate data
- Intermediate functions
- Can you construct and run a formula like this: =LEFT(C2,(FIND("@",C2,1)-1)) ? Can you decode what it will do? If you would like to this workshop is for you.
Location. This workshop will be hosted in Stewart Building, room 2500.
This workshop is the second of two Excel workshops as part of the Data Skills series. If you are just getting started in Excel or are self-taught and want to learn key tips and tricks we recommend you also sign up for the Data Wrangling with Excel I workshop. This workshop uses Excel 2016 for Windows.
- Thursday, September 28, 2017
- 9:00am - 11:00am
- Other - See Description
- Maps, GIS & Data