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 24,900 courses taught by industry experts.
Use ChatGPT as a search engine for Excel skills
From the course: GPT with Excel: Leverage ChatGPT for Data Success by Microsoft Press
Use ChatGPT as a search engine for Excel skills
- [Instructor] Wow, this is exciting. We are now going to start writing some prompts in ChatGPT and completing some Excel tasks. So hopefully not only are we going to be learning some skills in ChatGPT and seeing what it's capable of in assisting us in Excel, but we're going to be learning some Excel techniques too. So many wins to come over the coming lessons of this course starting with this one. And in this first example we need ChatGPT's help. We have this spreadsheet and as you can probably notice, the column width of the Sydney column, column E is noticeably different to the other three city columns, B to D. Now, I don't know how that's happened. What I do know is that I need it the same as the others. And I'd like ChatGPT to hopefully give me a very fast solution. Let's see if there is one and if there is, ChatGPT knows it. So over in ChatGPT now and we've been made familiar with the interface and the different models available, so I think we're good to go. I'm going to show…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Contents
-
-
-
Learning objectives2m 22s
-
(Locked)
Outline ChatGPT and its applications in Excel2m 26s
-
(Locked)
Set up ChatGPT3m 49s
-
(Locked)
Understand the different ChatGPT models and their capabilities3m 34s
-
(Locked)
Learn the ChatGPT interface10m 50s
-
(Locked)
Use ChatGPT as a search engine for Excel skills15m 1s
-
(Locked)
Exercise: Excel problem solving with ChatGPT10m 53s
-
-
-
-
-