From the course: GPT with Excel: Leverage ChatGPT for Data Success by Microsoft Press

Unlock this course with a free trial

Join today to access over 25,300 courses taught by industry experts.

Write simple formulas with ChatGPT

Write simple formulas with ChatGPT

From the course: GPT with Excel: Leverage ChatGPT for Data Success by Microsoft Press

Start my 1-month free trial Buy for my team

Write simple formulas with ChatGPT

“

- [Instructor] Welcome to this first lesson of seeing ChatGPT write Excel formulas for you. And in this lesson we're going to start with some quite simple but useful formulas. We'll learn about the effectiveness of your prompts before we progress to slightly more complex Excel formulas. Now we're going to start off with this table named tblData and the two columns named Client Code and Area Code. We would like to add a new formula column that combines the data from these two columns separated by a hyphen. So we're looking for these results. We know our way around ChatGPT now, so let's dive in and get this job done. In ChatGPT, I've provided the following prompt saying that I need a formula in Excel to join the content of two columns in a table, and I've provided the two table column names, Client Code and Area Code and told it to separate them by a hyphen. Type in the symbol to avoid any possible confusion. So sending this into ChatGPT and I've received an arguably perfect response…

Contents