How to use the AI Function in Excel with Examples
2K views
Feb 9, 2025
Discover how to use the new AI function in Excel like a pro! This game-changing feature simplifies data analysis, automates tasks, and boosts productivity. Watch our step-by-step tutorial to master its capabilities and transform your workflow today. Perfect for beginners and experts alike! #Excel #AI #productivity Learn more: https://excelweez.com/
View Video Transcript
0:10
welcome to Exel wiiz today we are diving
0:13
into the exciting world of AI in Exel
0:16
specifically we'll explore how to use AI
0:18
table function to enhance your data
0:21
management transform your spreadsheets
0:24
and make your data analysis a breeze so
0:27
we have uh this sheet that's named a
0:30
table the first thing that you'd like to
0:32
do uh click on any empty cell and type
0:36
in a prompt on this particular example
0:39
we are going to use top productivity
0:42
Tools in 2025 so just type in
0:46
top Let's uh give it a number we would
0:49
like to have 10 so top
0:54
10
0:55
productivity Tools in 2025
1:01
that's the first thing that you need to
1:02
type in it's the prompt once you're done
1:05
with the TR with the prompt uh click on
1:08
Another Empty cell and now start typing
1:10
in this formula ai. table once you
1:13
startop typing a small drop down will
1:16
come up with a list of functions just
1:19
click on the one that says AI do table
1:21
and you'll get this formula down here
1:24
follow it for this particular example
1:28
the first The Prompt we've already
1:29
already uh start we started with the
1:32
prompt so the one thing that you will do
1:34
just go and select on the prompt and
1:37
close your parenes and then click on
1:40
okay and chart GPT will do its work see
1:43
this is what has been generated we got
1:46
our tool name description the platform
1:48
and the pricing so you may ask why would
1:52
you need all these type of information
1:54
so what you do you'd like you to specify
1:58
exactly the type of uh information that
2:00
you need and for this example let's say
2:03
we just only want to know or understand
2:07
the year that these tools were released
2:10
let's give it a
2:12
year year and then we'll also like to
2:15
know who is the current
2:17
CEO once you're done uh with that we can
2:20
also specify the tool because we also
2:22
need the tools name and click on enter
2:25
once you've done that uh chart GPT for
2:28
Excel will do its thing and as you can
2:30
see with the results we got we have tool
2:33
ear and notion so this is how you can
2:36
use the AI do table function in Excel to
2:39
be able to get specific information so
2:42
in this video I'm going to show you
2:44
another method that you can actually do
2:47
to get the same exact result so it will
2:50
be your choosing which this second
2:53
method the second method that I'm going
2:55
to show you you need to start by
2:59
creating the uh the names of everything
3:02
that you need that you need the data to
3:04
be a to fill for next example let's
3:06
we'll start with tool we move on to the
3:08
year we move on to the CEO sorry we move
3:14
on to the
3:15
CEO and that's it for now so the next
3:18
thing you need to do click on an empty
3:20
cell just below that uh uh key in your
3:24
equal sign and then type in AI do
3:27
table uh go down to the drop down list
3:30
and click on AI to table and type in
3:34
this uh formula but for this particular
3:37
example your prompt is going now to
3:40
be you have
3:43
to you have to put in the prompt like
3:46
like we did up up here so what we'll do
3:49
we just type in top productivity Tools
3:51
in 2025
4:02
and close it then key in your comma and
4:05
then now what we need to do is
4:08
highlight the data that we need to be
4:10
out of filled in our table and close
4:12
your parenthesis and then click on enter
4:16
and chpt will do its thing so you can
4:20
see here we have another table that has
4:23
the Tool uh the year and the CEO so this
4:28
is how you can actually use the AI do
4:30
table method and for those of you who do
4:34
not know if your Exel is not uh updated
4:38
to the latest model it may not work so
4:40
please ensure that you have your Exel
4:43
updated to the
4:45
new to the
4:48
current to the current and then we have
4:51
you also have to ensure that you have
4:53
chart GPT for Exel ex
4:56
uh installed if you do not know how to
5:00
do this please watch our previous video
5:03
you'll get to know how to uh insert chat
5:06
TPT for AI thank you very much for
5:09
watching and see you again in the next
5:11
video bye
#Intelligent Personal Assistants