New Course Available Now: R For Excel Users


Excel is a very important tool to interactively work with data in corporate environments. Many data science projects therefore require to either use Excel files as a data source or write results to Excel files. With the openxlsx package you have also advanced features under your fingertips to create fully-featured Excel files including custom styling, formulas and images.

Advanced Data Transformation covers the most popular ways of transforming data into all kinds shapes and forms.

  • base R is already integrated into the R language itself
  • tidyverse provides many packages for data manipulation—-most importantly dplyr and tidyr
  • data.table is a highly optimized, in-memory transformation and query interface for tabular data

There is no on-size-fits-all solution to a problem, so in Advanced Data Transformation you will learn how to use the right tool for your data use cases. For each available package ecosystem it covers all essentials, including:

  • Data Filtering
  • Grouping and Aggregating
  • Pivoting
  • Joins
  • and more!

View Course: Advanced Data Transformation

Get Your Certificate with PRO

After completing Advanced Data Transformation you get a unique certificate, which you can download as PDF and include in your portfolio!

Learn more about PRO

Become a Data Science PRO

  • Access to all courses

    Including 15+ in-depth data science lessons

  • Real-world use cases

    Jump start your own projects with ease

  • Personal premium support

    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!

Liza Glesener, SICONA

More Posts

Keep Reading

We don't support your browser anymore

Please choose more modern alternatives, such as Google Chrome or Mozilla Firefox.