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 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. 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.
This workshop is the first of two Excel workshops as part of the Data Wrangling series. If you are interested in learning about complicated formula construction, functions, charts, attend Excel 2 (register here). This workshop uses Excel 2016 for Windows.
Event will be held in the THINC Lab (second floor, library).
Please bring a laptop with Excel installed.