Interfacing R with Microsoft Excel (ADDED FEE) — Professional Development Computer Technology Workshop
ASA, XLSTAT
Thanks to its popularity and user-friendly environment, Microsoft Excel is widely used to gain data insights and make better decisions. On the other hand, R is a coding software known for its flexibility and data visualization capabilities. However, the latter is often associated with a steep learning curve. In order to interface the unlimited possibilities of R with the user-friendly environment of Excel, the statistical software XLSTAT offers you two powerful tools: 1) XLSTAT-R, which helps you develop user-friendly dialog boxes in Excel allowing the end-users to launch customized R procedures directly on data selected in Excel. 2) The XLSTAT-RNotebook, which allows calling R code directly from the Excel spreadsheet where your data are stored. This makes it possible to create complex dashboards or reports in Excel made from R code. The created procedures can then be used by colleagues, students or clients who don’t necessarily know how to code. This workshop shows a) how to make the pam{cluster} R function available in an Excel dialog box and b) how to develop a customized R-based dashboard in an Excel sheet. Basic coding skills are required (preferably R).
Instructor(s): Jean Paul Maalouf, XLSTAT; Efthalia Anagnostou, XLSTAT