Course icon

R for Excel Users

4 Topics • 4 Exercises • 1 Quizzes

Use R as a complementary tool to your current Excel workflow and learn how pivot tables and VLOOKUP can be implemented in R. Create reproducible transformations and use the power of RMarkdown reporting.

Beginner difficulty

Start learning for free

In this course...

  • 4 Topics
  • 4 Exercises
  • 1 Quizzes
  • Wide variety of topics
  • Unlock free course materials
  • Free quizzes and exercises
    • Key facts

    • Read data from Excel files efficiently using R
    • Write large Excel files with writexl.
    • Use openxlsx to create great looking Excel spreadsheets including features like custom styles and formulas.

    Contents

    4 Topics • 4 Exercises • 1 Quizzes

    Introduction

    Free

    Overview of ways to read and create Excel files using R including readxl, writexl, openxlsx, RODBC, ...

    Read Excel Files

    Read Excel files using readxl and learn strategies to deal with complex files and layouts.

    Write Excel Files

    Write data to Excel quickly using writexl. Create fully-featured Excel files including styles and formulas (and more) using openxlsx.

    Case Studies

    Team

    Create custom Excel files based on numerous case studies.

    Quantargo Certificate™

    The Quantargo certificate in “R for Excel Users” demonstrates that your are literate in the topics covered by this course. You have...

  • In-depth knowledge on important concepts
  • Hands-on experience with the tools covered
  • A good starting point for further topics
  • Quantargo CourseCockpit™

    We have built a complete online Learning Hub with hands-on quizzes, code exercises and viedeos and an online Workspace that lets you immediately apply learned skills by trying out code.

    Track progress and learn in your own pace with our interactive tutorials. In the CourseCockpit you’ll find all assets and course materials.

    A complete RStudio environment to try out new ideas and play around with different packages and features. All files are synced automatically.