ChatGPT makes Excel formulas obsolete.
With the Code interpreter of ChatGPT, you can :
→ Analyze data
→ Create graphs
It's like talking in natural language to a spreadsheet.
I'll show you how to do it with ChatGPT and export the result in Excel format:
With the Code interpreter of ChatGPT, you can :
→ Analyze data
→ Create graphs
It's like talking in natural language to a spreadsheet.
I'll show you how to do it with ChatGPT and export the result in Excel format:
As an example, I'm going to analyze and create a graph of laptop sales in the US.
Of course, this works with any data.
Let's start the short tutorial ↓
Of course, this works with any data.
Let's start the short tutorial ↓
1. Enter the prompt
→ Open a new conversation with the code interpreter
→ Write the prompt available in the tweet below, adapting it to your needs
→ ChatGPT will create a graph best suited to your data (save it as an image if you want)
→ Open a new conversation with the code interpreter
→ Write the prompt available in the tweet below, adapting it to your needs
→ ChatGPT will create a graph best suited to your data (save it as an image if you want)
Prompt (e.g.):
"Here's the evolution and sales figures for laptops in the USA by brand (in percent). Determine the type of chart best suited to visualize these data and create it.
[Paste your data]"
"Here's the evolution and sales figures for laptops in the USA by brand (in percent). Determine the type of chart best suited to visualize these data and create it.
[Paste your data]"
2. Export the result in Excel format
→ Write the prompt below to get a downloadable link
→ ChatGPT will create an Excel file with the data and an editable chart
→ Write the prompt below to get a downloadable link
→ ChatGPT will create an Excel file with the data and an editable chart
3. Edit in Excel (optional)
→ Click on the link provided by ChatGPT
→ The Excel file will save and be fully editable
→ Click on the link provided by ChatGPT
→ The Excel file will save and be fully editable
If you want to learn how to use AI, you'll love my newsletter.
I send out one e-mail a week with a tutorial, prompts and tools.
Subscribe for free:
paulai.cc
I send out one e-mail a week with a tutorial, prompts and tools.
Subscribe for free:
paulai.cc
I hope you find this guide useful and time-saving! If you enjoyed it, please:
1. Follow me @itsPaulAi for more content
2. Like & Retweet the first tweet below to share:
1. Follow me @itsPaulAi for more content
2. Like & Retweet the first tweet below to share:
Loading suggestions...