Overview

Learn how to Automate every Office and Business task with R programming language and RStudio!This course will give you a complete overview of a set of tools and packages that can help you automate any office and business task with the R programming language.With Udemy's 30-day money-back guarantee in place, there's no need to worry if the class doesn't meet your expectations.The learning material does not contain any analytics or data science lessons. We will not study statistics or machine learning. We will not write complex algorithms and solve coding puzzles.Instead, we focus on how to make your life easier and save time for yourself and money for your company.This course is the most complete automation course you will find onlineAfter completing this course you will be able to schedule any repetitive task with R and RStudioread and write files dynamically from various sources (local drive, web, Google Sheets, dropbox, amazon)store results without complex SQL databases using various R packagesparse emails and attachments for further manipulations with R programmingproduce custom Excel, PowerPoint, and Word documents from R scriptssend results by email and files as attachmentsexport your scripts to the cloud, schedule automatic runs or on-demandcreate a cloud dashboard to control R automated tasksAutomation is a very dynamic skill and I am learning new skills every day. This course will be updated with new programming skills, packages and features.My experienceDuring my banking career, I had to program hundreds of automatic mailing reports to track stock market information and portfolio performance on daily basis. By automating these tasks I became very efficient with my time.Currently, as a consultant, I help dozens of companies to automate their recurring tasks. Often hundreds of hours of manual work per month are saved once a complex recurring task is automated. I teach R, C# and Excel/VBA on a daily basis and after 1,200 mentoring sessions, I know precisely which tools are necessary for most of the people who learn programming.As a consultant, you can very quickly acquire new clients who desperately need to improve their business.Why R, RStudio, and Posit?R is one of the simplest programming languages to learn and is very friendly with data manipulation.R is open source and is part of a large community of developers that create and maintain packages we will explore during this course.RStudio is probably the best IDE for programmers (also supports C++, Python, SQL, and other languages).As of the end of 2023, R is rocking it with these cool numbers:RStudio has an active user base of 3.5 million.Posit cloud has a 65,000 userbase.Over the year, an impressive 2 billion R packages were downloaded.Which Packages will be covered?Base R functions will be covered as much as possible however they are very limited. Therefore we will learn a set of packages necessary for the programming automation tasks.dplyr: R data manipulation with very user-friendly syntax tidyr: data clean-up, remove duplicates, NA's etc.stringr: string and regex manipulationlubridate: work with Date class objectspdftools: parse content from PDF fileshtmltab: parse html tables from webgsheet: download files from Google SheetsmRpostman: connect to email box and read data from Emailsemayili: connect to email box and send emailstableHTML: create custom format HTML tablesopenxlsxl: read and write Excel filesofficer: read and write Word and PowerPoint documentsflextable: create formated tables as content for officerrdrop2: connect to dropbox as cloud source using R and RStudio

Skills

Reviews