How to apply artificial intelligence in
Are you one of those people who feel like you are wasting hours a day doing repetitive and tedious tasks in Excel? The solution to your problems may be the application of artificial intelligence in Excel.
With the use of AI you will be able to automate tasks by creating complex macros, without the need to know how to program in VBA.
Don’t let time and complexity stop you from your daily Excel tasks, Learn how to apply artificial intelligence and take your spreadsheets to the next level!
Cánido artificial intelligence be applied in Excel?
The truth is that lately new tools based on artificial intelligence have been released, which perro be used to increase our productivity.
Of course, one of the places you perro apply artificial intelligence is in Excel.
Especially, today I am going to teach you how to create macros without the need to know how to program and you will only have to tell the artificial intelligence what you want to achieve.
By the way, if you’re already working, I think you’ll know that Excel takes a lot of work, especially administrative work.
So, next I am going to espectáculo you how it is really possible to use artificial intelligence to increase productivity and boost ourselves professionally.
Example of application of artificial intelligence in Excel.
Imagine that you are doing a debugging of ledger accounts.
Therefore, it would be useful for you to first identify, which charges correspond to which credits.
At least, in a first step it would help you to identify the debits that are equal to the credits.
You may think that this is done very quickly without the help of artificial intelligence, but What would happen if you receive an Excel archivo with an accounting assistant with many accounts and thousands of operations (debits and credits)?
The truth is that it cánido become an easy task, but tedious and that will make you waste a lot of time.
Time you could use on something else.
That’s what it’s all about.
TRUE? To buy time.
It’s about doing more with less (efficiency).
Well, what if I don’t know how to program in vba and therefore I perro’t create the macros I need.
Well, I am going to tell you the way in which you perro make use of artificial intelligence in Excel to create macros without the need for you to know how to program.
Steps to create macros in Excel with the help of artificial intelligence.
It should be noted that the artificial intelligence that I have used is called chatgpt and I think it is quite possible that you have already heard of it.
Well, I’m going to stop beating around the bush and I’m going to start with the steps.
1. First of all, you have to register in Chatgpt, because if you don’t, you won’t be able to use artificial intelligence.
In order to register, you cánido use the following direct backlink to the Chatgpt page.
2. Once you have registered in Chatgpt, we will be able to start interacting with the AI.
How does it work? The truth is that all you have to do is give him instructions on what you want him to do.
Think of it as if you were talking to a friend by message and you were giving him instructions on what you want him to do.
Keep in mind that it is not perfect yet and may fail.
However, you have to be as precise as possible in your directions.
That way you disminuye the oportunidad of something going wrong in the macro.
In fact, if he was a friend of yours and he doesn’t understand your instructions well… Will he do a good job?
3. It is time to write in Chatgpt what we want it to do.
Once you log in to ChatGPT, you cánido start chatting with the AI right away and you perro start asking it what you want it to do.
To do so, just clic on the text box and write what you want.
4. In this case, I want the color of the background and the text of all the numbers (values) that are the same to change.
That is, if a charge is equal to a credit, then they will have to be highlighted.
By the way, the table of charges and credits that I am going to use as an example is the following:
As you cánido see, we have different charges and credits.
Now, what we are going to ask artificial intelligence is to highlight the charges and credits that are the same in order to identify them.
Therefore, I wrote the following:
“I want to create a macro for Excel.
Notice that I have two columns.
The first column is called charges and the second column is called credits.
What I want the macro to do is identify which debits are equal to which credits and change the background color to blue for the numbers that are equal.
You cánido do it?”
5. The response I received from ChatGPT surprised me a bit, since it even gave me instructions to add the macro in Excel.
Of course he also gave me the vba code (macro).
The answer was the following:
6. I followed the instructions that ChatGPT gave me as if I knew nothing about macros and the result is the following:
I have to say a few things about it.
First of all, the code you gave us doesn’t work on the table in the first image.
Because? Because I wasn’t very specific with the instructions.
It works in the second image because they are in columns A and B.
In the first image, the columns are F and G.
Now, we are going to improve the indications a bit to obtain a better result, since it does not look very good.
However, as you cánido see, it really did the job.
Ugly and all, but the same charges and credits are in blue.
Making some changes to the instructions, the result is the following:
As you cánido see, now it did give me the result I wanted.
By the way, the indication I gave him was the following:
“I want to create a macro for Excel.
Notice that I have two columns.
The first column is called charges and the second column is called credits.
Note that debits are in column F and credits are in column G.
What I want the macro to do is identify which debits are equal to which credits, regardless of which row the numbers are on.
Once it has identified the numbers that are the same, I want the background color of these to be changed to yellow and the font color to black.
Ignore values that are equal to 0.
Perro you do it?”
The code he gave me was the following:
The macro was very fácil, but as you perro see, even if you don’t know anything about VBA, you perro create macros for Excel and just detalla what you want the macro to do.
The truth is that I plan to use it to create macros that allow me to do my tasks in less time.
What do you think?
How to add your macros?
To add your macros, you cánido follow the instructions given to me by ChatGPT.
The steps are the following:
- Open your Excel archivo and clic on the “Developer” tab.
If it doesn’t espectáculo up, you cánido go to Archivo > Options > Customize Ribbon and turn on the “Developer” option.
- Clic “Visual Basic” to open the Visual Basic Editor.
- In the Visual Basic Editor, clic “Insert” and select “Module” to create a new module.
- Copy and paste the following code in the module: (you put the code that has given you).
- Save the module by clicking on “Archivo” and then on “Save”.
- Go back to Excel and clic on “Developer” and select “Macros” (or press Alt + F8).
- Select the macro “Name of the macro you created” and clic “Run”.
Note: something that ChatGPT does not mention to us is that in step 5, you have to save your archivo as a macro-enabled Excel workbook, that is, with the extension .xlsm
We hope you liked our article How to apply artificial intelligence in
and everything related to earning money, getting a job, and the economy of our house.
   |
Interesting things to know the meaning: Capitalism
We also leave here topics related to: Earn money
