R Programming for Excel Training Course
R is a programming language and software environment for statistical computing. Together with R and Excel, users are able to implement R Tidyverse standards and more powerful R features for improving data analytics in Excel.
This instructor-led, live training (online or onsite) is aimed at data analysts who wish to program in R for Excel.
By the end of this training, participants will be able to:
- Toggle and move data between Excel and R.
- Use R Tidyverse and R features for data analytic solutions in Excel.
- Update their data science skills by learning R.
Format of the Course
- Interactive lecture and discussion.
- Lots of exercises and practice.
- Hands-on implementation in a live-lab environment.
Course Customization Options
- To request a customized training for this course, please contact us to arrange.
Course Outline
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
Requirements
- Experience with Excel
Audience
- Data Analysts
Open Training Courses require 5+ participants.
R Programming for Excel Training Course - Booking
R Programming for Excel Training Course - Enquiry
Testimonials (5)
it was informative and useful
Brenton - Lotterywest
Course - Building Web Applications in R with Shiny
Many examples and exercises related to the topic of the training.
Tomasz - Ministerstwo Zdrowia
Course - Advanced R Programming
Day 1 and Day 2 were really straight forward for me and really enjoyed that experience.
Mareca Sithole - Africa Health Research Institute
Course - R Fundamentals
The pace was just right and the relaxed atmosphere made candidates feel at ease to ask questions.
Rhian Hughes - Public Health Wales NHS Trust
Course - Introduction to Data Visualization with Tidyverse and R
It was very informative and professionally held. Wojteks knowledge level was so advanced that he could basically answer any question and he was willing to put effort into fitting the training to my personal needs.
Sonja Steiner - BearingPoint GmbH
Course - R Programming for Data Analysis
Upcoming Courses
Related Courses
Programming with Big Data in R
21 HoursBig Data is a term that refers to solutions destined for storing and processing large data sets. Developed by Google initially, these Big Data solutions have evolved and inspired other similar projects, many of which are available as open-source. R is a popular programming language in the financial industry.
R Fundamentals
21 HoursR is an open-source free programming language for statistical computing, data analysis, and graphics. R is used by a growing number of managers and data analysts inside corporations and academia. R has also found followers among statisticians, engineers and scientists without computer programming skills who find it easy to use. Its popularity is due to the increasing use of data mining for various goals such as set ad prices, find new drugs more quickly or fine-tune financial models. R has a wide variety of packages for data mining.
Data Analytics With R
21 HoursR is a very popular, open source environment for statistical computing, data analytics and graphics. This course introduces R programming language to students. It covers language fundamentals, libraries and advanced concepts. Advanced data analytics and graphing with real world data.
Audience
Developers / data analytics
Duration
3 days
Format
Lectures and Hands-on
Data Mining with R
14 HoursR is an open-source free programming language for statistical computing, data analysis, and graphics. R is used by a growing number of managers and data analysts inside corporations and academia. R has a wide variety of packages for data mining.
Forecasting with R
14 HoursThis instructor-led, live training in Sri Lanka (online or onsite) is aimed at intermediate-level data analysts and business professionals who wish to perform time series forecasting and automate data analysis workflows using R.
By the end of this training, participants will be able to:
- Understand the fundamentals of forecasting techniques in R.
- Apply exponential smoothing and ARIMA models for time series analysis.
- Utilize the ‘forecast’ package to generate accurate forecasting models.
- Automate forecasting workflows for business and research applications.
Marketing Analytics using R
21 HoursAudience
Business owners (marketing managers, product managers, customer base managers) and their teams; customer insights professionals.
Overview
The course follows the customer life cycle from acquiring new customers, managing the existing customers for profitability, retaining good customers, and finally understanding which customers are leaving us and why. We will be working with real (if anonymous) data from a variety of industries including telecommunications, insurance, media, and high tech.
Format
Instructor-led training over the course of five half-day sessions with in-class exercises as well as homework. It can be delivered as a classroom or distance (online) course.
R for Data Analysis and Research
7 HoursAudience
- managers
- developers
- scientists
- students
Format of the course
on-line instruction and discussion OR face-to-face workshops
Introduction to R
21 HoursR is an open-source free programming language for statistical computing, data analysis, and graphics. R is used by a growing number of managers and data analysts inside corporations and academia. R has also found followers among statisticians, engineers and scientists without computer programming skills who find it easy to use. Its popularity is due to the increasing use of data mining for various goals such as set ad prices, find new drugs more quickly or fine-tune financial models. R has a wide variety of packages for data mining.
This course covers the manipulation of objects in R including reading data, accessing R packages, writing R functions, and making informative graphs. It includes analyzing data using common statistical models. The course teaches how to use the R software (https://www.r-project.org) both on a command line and in a graphical user interface (GUI).
Introductory R for Biologists
28 HoursR is an open-source free programming language for statistical computing, data analysis, and graphics. R is used by a growing number of managers and data analysts inside corporations and academia. R has also found followers among statisticians, engineers and scientists without computer programming skills who find it easy to use. Its popularity is due to the increasing use of data mining for various goals such as set ad prices, find new drugs more quickly or fine-tune financial models. R has a wide variety of packages for data mining.
R
21 HoursR is an open-source free programming language for statistical computing, data analysis, and graphics. R is used by a growing number of managers and data analysts inside corporations and academia. R has also found followers among statisticians, engineers and scientists without computer programming skills who find it easy to use. Its popularity is due to the increasing use of data mining for various goals such as set ad prices, find new drugs more quickly or fine-tune financial models. R has a wide variety of packages for data mining.
Neural Network in R
14 HoursThis course is an introduction to applying neural networks in real world problems using R-project software.
Advanced R Programming
7 HoursThis course is for data scientists and statisticians that already have basic R & C++ coding skills and R code and need advanced R coding skills.
The purpose is to give a practical advanced R programming course to participants interested in applying the methods at work.
Sector specific examples are used to make the training relevant to the audience
R Programming for Data Analysis
14 HoursThis course is part of the Data Scientist skill set (Domain: Data and Technology)
Introduction to Data Visualization with Tidyverse and R
7 HoursThe Tidyverse is a collection of versatile R packages for cleaning, processing, modeling, and visualizing data. Some of the packages included are: ggplot2, dplyr, tidyr, readr, purrr, and tibble.
In this instructor-led, live training, participants will learn how to manipulate and visualize data using the tools included in the Tidyverse.
By the end of this training, participants will be able to:
- Perform data analysis and create appealing visualizations
- Draw useful conclusions from various datasets of sample data
- Filter, sort and summarize data to answer exploratory questions
- Turn processed data into informative line plots, bar plots, histograms
- Import and filter data from diverse data sources, including Excel, CSV, and SPSS files
Audience
- Beginners to the R language
- Beginners to data analysis and data visualization
Format of the course
- Part lecture, part discussion, exercises and heavy hands-on practice
Building Web Applications in R with Shiny
7 HoursDescription:
This is a course designed to teach R users how to create web apps without needing to learn cross-browser HTML, Javascript, and CSS.
Objective:
Covers the basics of how Shiny apps work.
Covers all commonly used input/output/rendering/paneling functions from the Shiny library.