Searching for "dare to excel"

In this task sheet you will learn how to import two common data file types into your R environment: comma seperated value (CSV) files and Microsoft Excel spreadsheets. The base R installation can read CSV files without any additional software; for Excel files you can use the package readxl. Both methods produce a data frame as the result. If you are new to programming in R, you may find useful the previous task sheets in the series: GISTP 0021 - Getting Started with R and RStudio, and GISTP 0023 - Installing Packages with RStudio.

Esri Maps for Office is a downloadable application available to all ArcGIS Online subscribers, paid or trial accounts. This application allows you to create dynamic maps of your Excel data without leaving the Excel environment. You can analyze your data in a location-based context by creating clustered point maps or heat maps to understand the density of point features. You can also share the maps that you create in Excel to ArcGIS Online or copy and paste them into your PowerPoint presentations or Word documents.

This task sheet will introduce you to the basics of using ESRI Maps for Office and demonstrate how to make a choropleth map within the Excel environment.