How to Automate PowerPoint Slidedecks with R

Written by Matt Dancho



Your boss lives on PowerPoint decks. Do you need to create a Slide Deck every week? Let’s learn how to automate PowerPoint with R, using officer and tidyverse.

R-Tips Weekly Newsletter

This article is part of R-Tips Weekly, a weekly video tutorial that shows you step-by-step how to do common R coding tasks one R-tip at a time.

Here are the links to get set up. 👇

This Tutorial Is Available In Video

I have a companion video tutorial that shows even more secrets (plus mistakes to avoid). And, I’m finding that a lot of my students prefer the dialogue that goes along with coding. So check out this video to see me running the code in this tutorial. 👇

Automate PowerPoint with R

Here’s a common situation, you have to make a Monday Morning Slide Deck. It’s the same deck each week, just date ranges for your data change. Here’s how to automate this process with R!

First, here’s what you need to make - A weekly Stock Report.

Weekly Stock Report


Thinking like a programmer, you can collect your stock data using date ranges.

Stock Data Using Date Ranges

With a little bit of data wrangling with the tidyverse, you’ve got your table extracted & formatted!

Tidyverse Wrangling

Tidyverse Wrangling


Then you use timetk to make a sweet plot.

Timetk package


Plotting stock data


Then you use officer to add the table and plot to powerpoint.

Officer R package

You’ve just automated your Monday Morning PowerPoint in R. BOOM! 💥💥💥

Weekly Stock Report


💡 Conclusions

You learned how to automate PowerPoint with R. Great work! But, there’s a lot more to becoming a Business Scientist (my term for an incredibly valuable data scientist that has business skills).

If you’d like to become a Business Scientist (and have an awesome career, improve your quality of life, enjoy your job, and all the fun that comes along), then I can help with that.

Step 1: Watch My Free 40-Minute Webinar

Learning data science on your own is hard. I know because IT TOOK ME 5-YEARS to feel confident.

AND, I don’t want it to take that long for you.

So, I put together a FREE 40-minute webinar (a masterclass) that provides a roadmap for what worked for me.

Join My FREE 40-Minute R Webinar
(The Roadmap to a 6-Figure Data Scientist Career)

Literally 5-years of learning, consolidated into 40-minutes. It’s jammed packed with value. I wish I saw this when I was starting… It would have made a huge difference.

Step 2: Take Control Of Your Career

For my action-takers, if you are ready to become a Business Scientist, then read on.

If you need take your skills to the next level and DON’T want to wait 5-years to learn data science for business, AND you want a career you love that earns you $100,000+ salary (plus bonuses), AND you’d like someone to help guide you how to do this in UNDER 6-MONTHS or less….

Then I can help with that too.

I have a program that has helped over 3,000 students become data scientists in business with the R programming language. Don’t believe me? Read these testimonials.

My students have gotten:

  • 6-Figure Data Science Jobs ($100,000+)
  • Senior VP of Analytics ($200,000+)
  • Lead Data Scientist Jobs ($175,000+)
  • Raises and Career Promotions of 25% to 50%

All by learning data science for business with R. Get ready. The ride is wild. And the destination is AMAZING!

Join My 5-Course R-Track Program
(Become A 6-Figure Data Scientist)

P.S. 40% of my students are getting their work to pay for education. **Find out how they get their company to reimburse them for my courses. **