How to Create Excel Formulas with ChatGPT

You no longer have to be an Excel wizard to quickly create Excel formulas.

Hi!

Have you ever been in a situation where you have to work with a dataset but you only can use Excel? Maybe you need to send the Excel file to someone else or continue the work a coworker started. In any case, if you’re not an Excel wizard, you can use ChatGPT to quickly create Excel formulas no matter how rusty you’re in Excel. In this article, I’ll show you how to do it.

P.S. Next week, I’ll release a data analysis course that includes SQL, Python and ChatGPT for data analysis. Annual paid subscribers will be able to redeem it for free (if they haven’t redeemed any course yet), so subscribe today!

As a casual Excel user, I sometimes struggle to recall the names of formulas and how they work, so I end up wasting time trying to figure it out and searching on Google.

Fortunately, ChatGPT can now save time not only for casual Excel users like me but also for experts!

We only need to learn how to create effective prompts to make the most of ChatGPT. In this guide, we’ll use ChatGPT to generate Excel formulas. We’ll start with simple tasks and then challenge ChatGPT with more complex tasks in Excel.