R is known for its complex modelling capabilities among statisticians and data scientists. However, in corporate environments MS Excel is the primary tool used which needs to be integrated into many data science workflows. Most often, Excel files need to be used as a data source or as a reporting tool. In this tutorial you will learn about the most important R packages to read, create and style Excel files so that you can seamlessly integrate them into end-to-end data science workflows.
Loved it! The interactive parts with the quizzes and exercises make it easy to get to know R in an entertaining and memorable way!
Overview of ways to read and create Excel files using R including readxl, writexl, openxlsx, RODBC, ...
Read Excel files using readxl and learn how to deal with workbooks containing multiple spreadsheets.
Write data to Excel quickly using writexl. Create files with a single sheet or workbooks with multiple sheets.
Read and write Excel files using openxlsx. Define the formatting of the columns, and create custom styling for the sheets.
Including 15+ in-depth data science lessons
Jump start your own projects with ease
Get help directly from our course writers
A great course set-up to get a first insight into the workings of R and to wet your appetite for more – the possibilities seem endless. A very enjoyable experience, thank you!
Yes, after finishing the course with all Quizzes and Exercises we will send you a certificate as PDF to your account.
Still have questions?
Contact us: firstname.lastname@example.org — Tweet @Quantargo — Facebook — LinkedIn
Please choose more modern alternatives, such as Google Chrome or Mozilla Firefox.