ChatGPT: How to Make an Auto Excel Spreadsheet Analyzer in 15 Minutes (with R Shiny)

Hey guys, welcome back to my R-tips newsletter. In today's video, I'm sharing the cheat code to making an R shiny web app that automatically analyzes your company's Excel Files. Plus, I'm sharing exactly how I made it in under 15 minutes. AND how you can do it for ANY company. Let's go!

🌎 **LIVE** CHATGPT FOR DATA SCIENTIST WORKSHOP
HURRY, SEATS ARE LIMITED:
https://learn.business-science.io/reg...

GET THE CODE SHOWN IN THE VIDEO:
📰 Free R-Tips Newsletter (FREE R GitHub Code Access):
https://learn.business-science.io/r-t...

📺 SET UP YOUR R-TIPS CODE (GitHub Setup Video):
   • Setup R Project from GitHub (Business Scie...  

✨FREE R-TRACK MASTERCLASS (10-SECRETS THAT HELPED ME BECOME A DATA SCIENTIST):
https://learn.business-science.io/fre...

📚The 5-Course R-Track Program (Become The Data Scientist You Were Meant To Be)
https://university.business-science.i...

Table of Contents:
00:00 Automatic Excel Analyzer R Shiny App (ChatGPT)
00:26 Get the R Code
01:01 R Shiny: Auto Excel Analyzer App
01:43 Basic Shiny App with ChatGPT
03:10 Prompt 1: Excel Uploader
04:18 Prompt 2: Add Visualization
04:53 Prompt 3: Include Sample Data in App
05:32 Prompt 4: Preview Sample Data
07:04 Prompt 5: Skipped - ChatGPT took care of this!
07:15 Prompt 6: Adding an Optional Facet Column
07:37 Prompt 7: Skipped - ChatGPT took care of this!
08:45 Prompt 8: Skipped - ChatGPT took care of this!
08:53 Prompt 9: Professionalize the Plot Appearance
11:14 LIVE ChatGPT Workshop



#chatgpt #r #excel #shiny