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, Dave Langer illustrates 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 Dave 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 prior to the meetup via GitHub for attendees interested in following along during the talk.

GitHub Files:

https://github.com/datasciencedojo/meetup/tree/master/r_programming_excel_users

Find out more about David here:

https://www.meetup.com/data-science-dojo/events/239049571/

—

Learn more about Data Science Dojo here:

http://bit.ly/2nW7mVi

See what our past attendees are saying here:

http://bit.ly/2orT2HW

—

Like Us: https://www.facebook.com/datasciencedojo/

Follow Us: https://twitter.com/DataScienceDojo

Connect with Us: https://www.linkedin.com/company/data-science-dojo

Also find us on:

Google +: https://plus.google.com/+Datasciencedojo

Instagram: https://www.instagram.com/data_science_dojo/

Vimeo: https://vimeo.com/datasciencedojo

Amazon Auto Links: No products found.

Outstanding! Keep up the good work.

I’m still rooting for JavaScript!! I dream of the day where machine learning in JavaScript is viable.

Outstanding Dave, congratulations. I’m an telecommunications engineer and currently I work with Data Science. But 95% of the time I use VBA along with SQL Server and Access. Fortunately I can do good stuff using VBA/Excel and thinking out of the box and it’s really fast. But as long as I do not master any other language to work with data science, I feel that I’m still missing something. I didn’t know that R was biuld from the scratch to be a data science language and that make me consider to learn it. I’m gonna watch your other videos on this channel. Do you have any other R courses available?

Bravo! Great presentation. Is RStudio the best option to use? And what R packages are the best to use?

Hi DavidThanks for the wonderful presentation,I am trying to find the 12 Video series you posted but it seems they no longer exists. Have they been deleted. I was viewing Part II for installing ggplots. But was unable do so. Please advise

Hi, I have a question, and this is relevant for excel too. If you know about the existence of a function, you can learn to use it. But how do you find out about the existence of a function in R? For example, you want to do x, and want to know if there is a function or package which can do f(x). How do you search for this? There seems to be so much functionality in R, but nobody can possibly know all operations. If you know a function, you can get help on it, but how do you find a ‘new’ function?

This is by far the most helpful resource to helping me learn R. I use Excel for my current job and this coming semester, we will be using Stata for my master’s in economics. I picked up R to start working with a language before school begins and also because of my cousin who is a Data Scientist that highly recommended working with R. Thank you so much for the video and supplemental material!

CSV files are not working when I open it in excel

Thank you for sharing.

Good quality stream. Loved how you overlaid the slides/video, and repeated the questions the audience had.

Hi I like your lecture, I was only wondering why you used the funtion of LetterNumber like B2 and not the function [@column]. In my opinion the table functions wil still work much better when you starting to filter youre columns?

Many thanks for articulating so well how to transpose Excel to R. Great presentation.