Get started with R programming and learn how to analyze data in Microsoft Excel. R programming is rapidly becoming a valuable skill for data professionals of all stripes and a must-have skill for aspiring data scientists. Adding R programming to your data analyst skillset allows you to leverage powerful data visualizations, statistical analyses, and even machine learning in your daily work.
In this presentation, we illustrate how your knowledge of performing data analyses in Microsoft Excel gives you a unique foundation for quickly learning how to apply R in your daily work.
No knowledge of R coding is required for this meetup as we will illustrate scenarios in Excel and then walk through how each Excel scenario is implemented in R.
Attendees will learn how:
• Fundamental concepts of Excel (e.g., working with tables, collections of cells, and functions) translate 100% to working with data in R.
• Excel pivot tables translate to R code.
• Creating charts in Excel is very similar to creating data visualizations in R.
• R offers visualizations not available in Excel out of the box.
An Excel spreadsheet and R code will be made available in our repository
Repository:
Table of Contents:
0:00 – Intro
9:25 – The data
12:50 – The scenario
1:22:16 – Questions
Learn more about R programming with this playlist:
—
At Data Science Dojo, we believe data science is for everyone. Our data science trainings have been attended by more than 10,000 employees from over 2,500 companies globally, including many leaders in tech like Microsoft, Google, and Facebook. For more information please visit:
💼 Learn to build LLM-powered apps in just 40 hours with our Large Language Models bootcamp:
💼 Get started in the world of data with our top-rated data science bootcamp:
💼 Master Python for data science, analytics, machine learning, and data engineering:
💼 Explore, analyze, and visualize your data with Power BI desktop:
—
Unleash your data science potential for FREE! Dive into our tutorials, events & courses today!
📚 Learn the essentials of data science and analytics with our data science tutorials:
📚 Stay ahead of the curve with the latest data science content, subscribe to our newsletter now:
📚 Connect with other data scientists and AI professionals at our community events:
📚 Checkout our free data science courses:
📚 Get your daily dose of data science with our trending blogs:
—
📱 Social media links
Connect with us:
Follow us:
Keep up with us:
Like us:
Find us:
—
Also, join our communities:
LinkedIn:
Twitter:
Facebook:
Vimeo:
Discord:
_
Want to share your data science knowledge? Boost your profile and share your knowledge with our community:
#rprogramming #microsoftexcel #dataanalytics
source
Learn more about R programming with this playlist: https://www.youtube.com/playlist?list=PL8eNk_zTBST8j2BU5HYFQogdCjtrHyQAx
I have subscribed. Been all over YouTube. This is the best beginner R content.
Can we do R programming in excel only
I just watched a this video , and I have to say, it was fantastic! The explanations were clear, concise, and incredibly easy to follow. The step-by-step approach made complex concepts feel approachable, and I feel much more confident in my R skills now. Thank you for making learning R so accessible and enjoyable!
Great video. Very informative and good snenario based learning.
Nice 1
👍👍👍👍
he's so microsoft trained to state perfectly obvious things as if they're revelations of the universe. clones. dumpy clones in cheap khakis and ugly tennis shirts.
The exascale guy at the end just wanted to show he knows a fancy buzzword 😂
Very insightful as a first time visitor to R
R, SAS and python which is better in 2023 for pharma healthcare and medical sector!?
This is the best introduction to R I have ever seen – as most of us know Excel. Now with the advent of Chat GPT, coding is becoming faster and more efficient. No limits!
Is this still valid?
my console is not showing no. of male observations
i.e 577
hey, dav. this is so amazing. This tutorial is very informative and educative. Thanks alot.
Great
The Repository link is pointing to a different Github folder. Thank you for the video!
Oh this a very wonderful video thank you so so much for it.
Strange, when I follow the talk with the same data, at 00:44:33 I get Chr in stead of Factor
This video is tremendous. The teaching approach is incredibly clear.
Thanks
Is there really something yo can do in R that you can't do in Excel?
Thanks, your very nice and excited presentation .I earn a lot.
I'm yet to watch the video! But I subscribed because I felt +ve vibes!
Hi Dave, I like to know the quote for this instance: male, surived, highest fare paid. how to go about it.
Hi, your lesson is very interesting and I really learnt alot.
Excellent speaker & tutor. Thanks 🙏
Please where do I download the course tool/material "r_programming_excel_users/titanic.R" . I only have that of csv
Amazing!!!
I have tried several times to install and use R, but I found it difficulties to start. After this presentation, I will definitely use R. so your goal is achieved. I raise my hand in front of the computer to respond to question in 1:23:00
Great tutorial. I enjoyed this a lot. I need to use R in predicting some soil properties that are difficult to analyze in the laboratory.
This is the first tutorial that I actually understood R even in the least bit.
Crying over those who died, including Jack.
Appreciate the video, but geez his tone is boring and he talks down to u as if u stupid.