We use cookies, including third-party cookies from Google to serve personalized ads through AdSense, to operate this site and understand how it is used. By continuing to browse, you accept this use. See our Privacy Policy and Terms of Use for details, including how to opt out of personalized advertising.
Accept
SmartData CollectiveSmartData Collective
  • Analytics
    AnalyticsShow More
    What Kind of Problem-Solving Distinguishes Data Analysts From Software Engineers -- AI-generated illustration
    What Kind of Problem-Solving Distinguishes Data Analysts From Software Engineers
    7 Min Read
    chatgpt image jul 21, 2026, 04 34 30 pm
    4 Core Benefits of Predictive Maintenance after Vibration Analysis
    10 Min Read
    How Does Data Mining Boost Customer Satisfaction in Logistics? Harnessing Analytics for Results -- AI-generated illustration
    How Does Data Mining Boost Customer Satisfaction in Logistics? Harnessing Analytics for Results
    11 Min Read
    chatgpt image jul 13, 2026, 04 23 45 pm
    How Data Analytics Helps Companies Improve User Engagement
    19 Min Read
    chatgpt image jul 13, 2026, 03 59 46 pm
    How Data Analytics Improves Multi-Location Search Strategies
    10 Min Read
  • Big Data
  • BI
  • Exclusive
  • IT
  • Marketing
  • Software
Search
© 2008-25 SmartData Collective. All Rights Reserved.
Reading: A video introduction to R for Excel users
Share
Notification
Font ResizerAa
SmartData CollectiveSmartData Collective
Font ResizerAa
Search
  • About
  • Help
  • Privacy
Follow US
© 2008-23 SmartData Collective. All Rights Reserved.
SmartData Collective > Big Data > Data Mining > A video introduction to R for Excel users
Data MiningPredictive Analytics

A video introduction to R for Excel users

DavidMSmith
DavidMSmith
3 Min Read
A video introduction to R for Excel users
Photo by Alex Fu on Pexels (https://www.pexels.com/photo/adobe-premier-application-screengrab-1188751/)
SHARE

D Kelly O’Day has posted a great video introduction to R over at Charts and Graphs. At just nine minutes long it’s a short and sweet overview of R, and focuses on a practical example of writing a script in R to generate a chart.

This was an inspired choice of example for Excel users. One of the loudest defenses I hear from Excel users relates to the charting capabilities: it’s really hard to convince an experienced Excel user to give up the point-and-click capabilities to edit charts in Excel for a programming environment.  But what I like best about this video is that it shows the parallel process in R. You create a simple chart first (in this case, a scatterplot) and then add modifications incrementally: add a title, change a scatterplot to a line plot, change the color of the line, etc. The difference is that in R you do this by modifying a script rather than pointing and clicking. But unlike in Excel, you can then reuse those modifications to recreate your customized chart any time, or even just recycle parts of the script for your next custom chart.  For me, this is the real time-saver of using R instead of Excel for charting: the extra time it takes to write the script far outweighs the time saved the next time I need to to a similar chart.

The only downside is that the video is available in WMV format only.  Great for Excel users on Windows, but it made it tricky to view on my Mac. A high-def YouTube version would be most welcome.

D Kelly O’Day: Getting Familiar with R’s User Interface. (Windows Media File, 6.3Mb.)

More Read

2015: The Year of IoT Pioneers, Analytics and Data Privacy
2015: The Year of IoT Pioneers, Analytics and Data Privacy
7 Important Types of Big Data
Uncertainty Coefficients for Features Reduction – Comparison with LDA Technique
20 Twitter Monitoring and Analytics Tools: Legacy Features and Modern Options
How Big Data is Creating the Future of Science Fiction
From http://blog.revolution-computing.com/
TAGGED:excelrvideo
Share This Article
Facebook Pinterest LinkedIn
Share

Follow us on Facebook

Latest News

Flat editorial illustration: The article's core relationship is the engineering transition from an AI prototype to a production-r
From AI Prototype to Production: Observability and Scalability Requirements for Data-Heavy SaaS Applications
Artificial Intelligence Exclusive
Preparing Data Systems and Governance for a Scaling Global Gaming Brand -- AI-generated illustration
Preparing Data Systems and Governance for a Scaling Global Gaming Brand
Big Data Infographic
How Restaurant POS and Ordering Data Reveal Generational Customer Patterns -- AI-generated illustration
How Restaurant POS and Ordering Data Reveal Generational Customer Patterns
Exclusive Infographic
From Trucks To Data: How Telematics Can Improve Freight Transportation -- AI-generated illustration
From Trucks To Data: How Telematics Can Improve Freight Transportation
Big Data Exclusive Infographic

Stay Connected

1.2KFollowersLike
33.7KFollowersFollow
222FollowersPin

You Might also Like

5 Must-Watch YouTube Videos on Big Data
Big DataBusiness IntelligenceCommentaryData ManagementHadoopMapReduceSoftware

5 Must-Watch YouTube Videos on Big Data

1 Min Read
Interview with Anne Milley, SAS II
Data MiningPredictive Analytics

Interview with Anne Milley, SAS II

10 Min Read
Find yourself a safer place to swim or fish in the Bay Area
Data MiningData VisualizationPredictive Analytics

Find yourself a safer place to swim or fish in the Bay Area

4 Min Read
Big Data and Predictive Analytics in Video Games
AnalyticsPredictive Analytics

Big Data and Predictive Analytics in Video Games

2 Min Read

SmartData Collective is one of the largest & trusted community covering technical content about Big Data, BI, Cloud, Analytics, Artificial Intelligence, IoT & more.

How To Get An Award Winning Giveaway Bot
How To Get An Award Winning Giveaway Bot
Big Data Chatbots Exclusive
Chatbots and SEO: How Can Chatbots Improve Your SEO Ranking?
Chatbots and SEO: How Can Chatbots Improve Your SEO Ranking?
Artificial Intelligence Chatbots Exclusive

Quick Link

  • About
  • Contact
  • Privacy
Follow US
© 2008-26 SmartData Collective. All Rights Reserved.
Welcome Back!

Sign in to your account

Username or Email Address
Password

Lost your password?