From the course: Excel and ChatGPT: Data Analysis Power Tips

Unlock the full course today

Join today to access over 23,100 courses taught by industry experts.

Generate formulas from sample data

Generate formulas from sample data

From the course: Excel and ChatGPT: Data Analysis Power Tips

Start my 1-month free trial Buy for my team

Generate formulas from sample data

“

- [Instructor] All right, so for our next demo, what we're going to practice doing is actually pasting data directly into ChatGPT and seeing if it can use that sample data to help produce Excel formulas. So this will be a little bit of a shortcut, so that we don't have to necessarily describe our data set perfectly in words. So in this case, we're working with a small sample of customer records. We've got about 25 customers listed here. First names, last names, city, state, date of birth, and email address. And what we're going to do is just copy and paste this entire sample into ChatGPT. We're going to ask it to write a formula for us, and then we're going to take it a step further and see if it can actually interpret and analyze the data that we've provided it. Now you can just simply copy and paste the data straight from Excel, but I found better results saving the data as a CSV, opening it in a tool like Notepad,…

Contents