From the course: Generative AI Productivity Hacks with Miss Excel
Unlock this course with a free trial
Join today to access over 25,500 courses taught by industry experts.
Write complex spreadsheet functions with AI
From the course: Generative AI Productivity Hacks with Miss Excel
Write complex spreadsheet functions with AI
- Now, if you're looking at this one and you're like, "Kat, I thought this was an AI course, not an Excel course," I did want to give you some cool use cases of how you can use both together. And one use case is if you're doing some kind of really complex function and you're not super-strong in those areas of the Excel department and you're like, "Ugh, this is going to take me a lot of brain power right now to figure out how to put a function in a function and not mess up all these arguments," this could be a prime use case for using the AI chatbots to give you that Excel complex function. The key here is giving it as much information as possible so that it actually gets the function right on the first time, and you don't have to sit there and troubleshoot it because at that point, you might as well just kind of go in and write the function from scratch. So really, in terms of the prompting when you're using Excel is going…
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
-
-
-
-
-
-
-
-
-
(Locked)
Use AI to verify information4m 37s
-
(Locked)
Analyze sentiment with AI4m 16s
-
(Locked)
Get feedback from AI2m 42s
-
(Locked)
Write complex spreadsheet functions with AI4m 28s
-
Use AI for spreadsheet function support2m 2s
-
(Locked)
Use AI to write custom macros in VBA2m 1s
-
(Locked)
Use AI to rearrange a list1m 9s
-
(Locked)
Translate with AI1m 23s
-
(Locked)
-
-
-