
Learn how to use the R language in R Studio and integrate it into your data processing workflow for Excel users.
Learn to import data from external files in R Studio, using Excel and CSV formats, install and load readxl for xlsx, and view the imported data.
Explore imported data in R Studio, inspect its structure and contents with fdr and sdr functions, and preview columns using summary, names, head, and tail.
Learn to cleanse numeric data in R Studio by importing Brazilian real estate data, removing meter square notation, converting to numeric, handling missing values, and validating results.
Import data with Excel package, set working directory, and manipulate data frame with deployer package; aggregate by region and year to summarise stores and 2019–2020 sales with sanity checks.
Learn to visualize sales data in R Studio using Plotly by filtering to the United Kingdom, aggregating yearly sales, and creating interactive bar charts, scatter plots, and line charts.
Learn to export cleansed data from R Studio to Excel and create charts: monthly sales by country, Germany vs UK, total sales by department, and top cities by sales.
Welcome to the Beginner RStudio Course For Excel Users
If you are only using Microsoft Excel to perform data processing, and now you want to have the knowledge and tools to make your tasks easier, then this is the course for you.
In this course, you will learn about R language and RStudio, how to get started, and how to incorporate these tools into your data processing workflow.
But more importantly, you will learn how using the R language will make you a hero in data processing.
By enrolling in this course, you will get the essential knowledge on how to become a data processing hero
You will learn how to extract the data from the Excel ecosystem and convert it into data frames in RStudio.
You will learn how to cleanse data in RStudio using methods that are faster than when you are cleansing the data in Microsoft Excel.
You will get the knowledge on how to manipulate and enrich the data
You will also learn how to visualize your data using rich and interactive charts
And last, you will learn how to export the results of your data processing back to the Microsoft Office ecosystem.
In this course, you will only get the essence of the data processing knowledge. Every step and lesson in this course is critical. There is no unnecessary lesson that will distract you from the true purpose of this course.
Having the skills to process a large amount of data and generate useful insight from that data is a highly in-demand skill. This is something that you can leverage to boost your career or provide you with additional income streams. This is also a good start if you are exploring the career in business intelligence field.
This is not a data science lesson
Only a few people outside the data science community that is able to recognize the advantage that they have if they leverage the R language in processing data in a common workplace environment. The intended audience for this course is anyone who is frequently working with data and want to learn a better and faster tool to explore and manipulate that data.