R Programming for Excel Treningskurs

Last updated

Kurskode

rexcel

Varighet

21 timer (vanligvis 3 dag inkludert pauser)

Krav

  • Experience with Excel

Audience

  • Data Analysts

Oversikt

R er et programmeringsspråk og programvaremiljø for statistisk datamaskin. Sammen med R og Excel, kan brukere implementere R Tidyverse standarder og mer kraftige R-funksjoner for å forbedre dataanalyse i Excel.

Denne instruktørledede, live-trening (online eller på nett) er rettet mot dataanalytikere som ønsker å programmere i R for Excel.

Ved slutten av denne treningen vil deltakerne være i stand til å:

    Samle og flytte data mellom Excel og R. Bruk R Tidyverse og R funksjoner for dataanalyse løsninger i Excel. Oppdatere sine data vitenskap ferdigheter ved å lære R.

Format av kurset

    Interaktiv forelesning og diskusjon. Mange øvelser og praksis. Hands-on implementering i et live-lab miljø.

Kurs tilpassingsalternativer

    For å be om en tilpasset opplæring for dette kurset, vennligst kontakt oss for å arrangere.

Machine Translated

Kursplan

Introduction

Core Programming and Syntax in R

  • Variables
  • Loops
  • Conditional statements

Fundamentals of R

  • What are vectors?
  • Functions and packages in R

Preparing the Development Environment

  • Installing and configuring R

R and Excel

  • Moving data between R and Excel
  • Working with bivarite analysis in R and Excel

DescTools

  • Controlling output in R
  • Running DescTools functions on variables

R Tidyverse

  • Loading and filtering data
  • Pivoting with R
  • Using Power Query

Data Visualization with R

  • Creating static visualizations with GGPlot
  • Layering multiple charts
  • Transforming visualizations into HTML widgets with Plotly
  • Working with interactive tables
  • Using R Markdown

Summary and Conclusion

Testimonials

★★★★★
★★★★★

Related Categories

Relaterte kurs

Kursrabatter

Kursrabatter Nyhetsbrev

We respect the privacy of your email address. We will not pass on or sell your address to others.
You can always change your preferences or unsubscribe completely.

Some of our clients

is growing fast!

We are looking to expand our presence in Norway!

As a Business Development Manager you will:

  • expand business in Norway
  • recruit local talent (sales, agents, trainers, consultants)
  • recruit local trainers and consultants

We offer:

  • Artificial Intelligence and Big Data systems to support your local operation
  • high-tech automation
  • continuously upgraded course catalogue and content
  • good fun in international team

If you are interested in running a high-tech, high-quality training and consulting business.

Apply now!

This site in other countries/regions