LibGuides: Brown GIS and Data Tutorials: Data Processing with Excel

S4 GIS Institute Data Processing

This tutorial was written for S4's GIS Institute. It was designed to introduce GIS users to basic data processing functions in Excel, but is also applicable to general data users.

Basic Spreadsheet Data Processing
Introduces data processing techniques and formulas in MS Excel 2019, including: splitting values with text to columns, splitting text with formulas, importing CSV data, VLOOKUP, and pivot tables.
Data Processing Sample Data
Sample data used in the data processing tutorial; global locations of copper smelters and ISO country codes.