You can now analyze your data much easier by combining Python in Excel and ChatGPT o1. Works for charts and any type of datasets. Just generate the Python code using o1 and run it directly in Excel. How-to guide and template below:

1. Setup ChatGPT Click on the link below and copy/paste the initial prompt into a ChatGPT o1-preview conversation. Just add the task, paste a sample of your data and fill in the total number of lines. No need to change the instructions or documentation. Link:

2. Run the code in Excel Copy the code generated by o1 and return to Excel. Select an empty cell, then go to Formulas → Insert Python. Paste the code without the “=PY(” and the last “)”. Then execute with Ctrl + Enter. That's it! If it's a chart, you can view it by clicking on the cell again and adding it to the one next to it.

Get your hands on this free Powershell ebook and take the first step towards automating your daily tasks! Learn the basics, common administrative tasks, and scheduling scripts with ease. May the PowerShell be with you!

This seamless Python integration in Excel sounds like a great boost for data analysis efficiency!

@mushfiq_sajib It’s a change from long, incomprehensible formulas!

Excellent explanation

@arnill_dev Thanks for taking a look, Arnill!

This is a smart way of working to save more time! Thanks for the guide, Paul!

Appreciate the support! Definitely a way to make data processing more accessible in any case.

Analyzation is one of the best usecases overall for ChatGPT, in my opinion. I will make sure to give this combo a try, thanks Paul!

Business analysts would love using this