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 visualisation 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 visualisations of your data. The functions and formulas that you need in order to wrangle you 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. This workshop is the second of two Excel workshops as part of the Data Wrangling 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 Excel 1 (register here).
Event will be held in the THINC Lab (second floor, library).
Please bring a laptop with Excel installed.