Have you ever been working in Excel and suddenly forgotten which formula to use?
Maybe you wanted to calculate the total sales, find the average marks, or check whether a student passed or failed.
You know Excel can do it.
But you just can’t remember the formula.
Should you use SUM?
Or IF?
Maybe XLOOKUP?
If this has happened to you, don’t worry. Almost every Excel beginner faces this problem.
A few years ago, the only option was to search Google, watch YouTube videos, or ask someone who knew Excel better than you.
Today, things are much easier.
With AI tools like Microsoft Copilot and ChatGPT, you don’t have to remember every Excel formula.
Simply tell the AI what you want to do in normal English.
For example, you can ask:
“Create an Excel formula to calculate total sales.”
Or,
“Write a formula that shows Pass if marks are above 35, otherwise Fail.”
Within a few seconds, AI suggests the right formula and even explains how it works.
This not only saves time but also helps you learn Excel formulas step by step.
In this guide, you’ll learn how to generate Excel formulas using AI, the best AI tools you can use, and some practical examples that anyone can follow.
What Does It Mean to “Generate Excel Formulas Using AI”?
Let’s understand this with a simple example.
Suppose you have a list of monthly sales in Excel, and you want to find the total.
If you already know the SUM function, you can quickly type the formula yourself.
=SUM(B2:B10)
But what if you don’t remember the formula?
This is where AI becomes useful.
Instead of searching for the formula online, you simply tell the AI what you want.
For example, you can ask:
“Calculate the total sales from cells B2 to B10.”
The AI understands your request and suggests the correct Excel formula.
It’s really that simple.
You don’t need to remember every function or worry about the correct syntax.
Just describe your requirement in simple English, and AI does the hard work for you.
Why Do Many Beginners Find Excel Formulas Difficult?
Learning Excel formulas can feel confusing at first.
There are hundreds of functions, and each one has a different purpose.
Sometimes you know what you want to calculate, but you don’t know which formula to use.
Even after finding the correct function, you still have to remember things like:
- Brackets
- Cell references
- Commas
- Function names
- Arguments
Missing even a small detail can return an error instead of the result you expected.
That is why many beginners spend more time searching for formulas than actually working in Excel.
If you’ve ever copied a formula from Google without fully understanding it, you’re definitely not alone.
What Can AI Help You Do in Excel?
Generating formulas is just one of the many things AI can do.
It can also help you:
- Suggest the right formula for your task.
- Explain what a formula does.
- Find mistakes in your existing formulas.
- Convert your instructions into Excel formulas.
- Recommend a better formula if there’s an easier way.
- Help you learn new Excel functions.
Think of it as having a smart formula assistant beside you while working.
Instead of searching different websites every time you forget a formula, you can simply ask AI and get an answer within seconds.
This makes Excel much less stressful, especially if you’re still learning the basics.
Instead of opening several websites to search for answers, you can often get the information you need in just a few seconds.
That’s why many beginners now use AI as a learning partner while working in Excel.
Which AI Tools Can Generate Excel Formulas?
Today, there are several AI tools that can generate Excel formulas for you.
Some work directly inside Excel, while others work in your web browser.
The good news is that you don’t need to learn a different method for each one. You simply tell the AI what you want, and it suggests the formula.
Let’s look at the two most popular AI tools.
1. Generate Excel Formulas Using Microsoft Copilot:
If you use Microsoft 365, you may already have Microsoft Copilot in Excel.
Copilot is Microsoft’s built-in AI assistant. Since it works inside Excel, you don’t have to switch between different websites or applications.
You can simply open Copilot and ask your question.
For example, you can type:
“Create a formula to calculate the total sales.”
Or,
“Write a formula to find the average marks.”
Within a few seconds, Copilot suggests the formula and explains how it works.
Depending on your version of Excel, it may even insert the formula directly into your worksheet.
This makes your work faster because you don’t have to copy and paste anything manually.
How to Generate Formulas Using Copilot:
Using Copilot is simple.
Step 1: Open your Excel workbook.
Step 2: Select the table or the cells you want to work with.
Step 3: Click the Copilot button on the Home tab.
Step 4: Type your request in simple English.
For example:
“Create a formula to calculate the total sales.”
Step 5: Review the suggested formula.
Copilot usually explains the formula before giving you options like:
- Insert Formula
- Add to Cell
- Replace Existing Formula
- Explain Formula
If Allow Editing is enabled, Copilot can even place the formula directly into the selected cell.
Why Many People Prefer Copilot?
One of the biggest advantages of Copilot is that everything happens inside Excel.
You don’t have to leave your workbook or search for formulas on different websites.
If you use Excel every day, this can save a lot of time.
New to Copilot? Before using it, make sure it’s enabled in Excel.
Related Article: How to Enable Copilot in Excel
2. Generate Excel Formulas Using ChatGPT:
Another popular AI tool is ChatGPT.
Unlike Copilot, ChatGPT doesn’t work inside Excel. Instead, you open ChatGPT in your browser and ask your question there.
Even though it requires one extra step, many beginners like ChatGPT because it doesn’t just give the formula. It also explains why the formula works.
This makes it a great learning tool.
How to Generate Formulas Using ChatGPT:
The process is easy.
Step 1: Open your Excel worksheet.
Step 2: Copy the data you want to work with.
Step 3: Paste the data into ChatGPT.
Step 4: Describe what you want.
For example:
“Create an Excel formula to calculate the total sales.”
Or,
“Write an IF formula that returns Pass if marks are above 35.”
Step 5: Copy the suggested formula and paste it into Excel.
If needed, adjust the cell references to match your worksheet.
That’s it!
Why Beginners Like ChatGPT?
When you’re learning Excel, getting the correct formula is helpful.
But understanding why that formula works is even better.
That’s where ChatGPT stands out.
For example, if it suggests:
=SUM(B2:B10)
You can ask another question like:
“Can you explain this formula in simple English?”
ChatGPT will explain each part of the formula, making it much easier to understand.
Over time, you’ll start remembering the formulas yourself.
Copilot vs ChatGPT:
If you’re wondering which AI tool is better, the answer depends on how you work.
| Feature | Microsoft Copilot | ChatGPT |
| Works inside Excel | Yes | No |
| Generates Excel formulas | Yes | Yes |
| Explains formulas | Yes | Yes |
| Inserts formulas into Excel | Yes in Allow Ediitng mode | No |
| Beginner-friendly | Yes | Yes |
Both tools are excellent, and you can choose the one that suits your workflow.
If you’re already using Microsoft 365, Copilot offers a smoother experience because it works directly inside Excel.
If you don’t have Copilot, ChatGPT is a great alternative. It can generate formulas, explain them, and even help you understand Excel step by step.
Which One Should You Use?
If your main goal is to finish your work quickly inside Excel, Microsoft Copilot is a great choice.
If you’re still learning Excel and want detailed explanations along with the formulas, ChatGPT is an excellent option.
No matter which tool you choose, remember that AI is there to help you.
The more you practice, the more comfortable you’ll become with Excel formulas.
AI vs Manual Formula Writing:
Here is the biggest difference between traditional Excel and AI-assisted Excel:
| Traditional Excel | AI-Assisted Excel |
| Manual typing | Simple English instructions |
| Need formula knowledge | Easier for beginners |
| Time-consuming | Faster suggestions |
| Need to remember syntax | AI helps explain formulas |
AI does not replace formulas. It simply helps you create them faster.
Benefits of Using AI for Excel Formulas:
AI helps users:
- Save time
- Reduce formula errors
- Learn Excel faster
- Avoid searching online repeatedly
- Understand formulas more easily
For beginners, this makes Excel feel less stressful.
Common Mistakes When Using AI for Formulas:
AI is helpful, but not perfect.
Sometimes users:
- Trust formulas without checking
- Give unclear instructions
- Use wrong ranges
Example of Bad Prompt:
“Do formula”
AI may not understand what you need.
Better Prompt:
“Create an Excel formula to calculate average sales from B2 to B10.”
Clear instructions usually give better results.
Should You Still Learn Excel Formulas?
Yes, definitely.
AI makes your work easier, but learning the basics of Excel is still important.
For example, it’s useful to understand:
- Cell references
- Rows and columns
- Basic functions like SUM, AVERAGE, and IF
- How formulas work
The more you understand Excel, the easier it becomes to check AI’s suggestions and fix problems if something doesn’t look right.
Think of AI as a helpful assistant, not a replacement for learning Excel.
Things to Remember:
Before you use AI to generate Excel formulas, keep these points in mind:
- Give clear instructions.
- Review the suggested formula before using it.
- Check the cell references carefully.
- Learn the basic Excel functions.
- Use AI to understand formulas, not just to copy them.
These simple habits will help you get better results every time.
AI is changing the way people use Excel.
Instead of memorizing every formula manually, users can now generate formulas using simple instructions.
For beginners, this makes Excel:
- Easier to learn
- Faster to use
- Less stressful
But the smartest approach is not:
AI OR Excel formulas
It is:
AI + Excel formulas together
Because AI helps you work faster, while Excel knowledge helps you work accurately.
FAQ:
Can AI generate Excel formulas automatically?
Yes. AI tools like Copilot and ChatGPT can generate formulas based on simple text instructions.
Is AI better than learning formulas manually?
AI helps speed up work, but understanding basic formulas is still important.
Can ChatGPT create Excel formulas?
Yes. ChatGPT can generate and explain Excel formulas for many tasks.
Does Copilot insert formulas directly into Excel?
Sometimes. In Allow Editing mode, Copilot may insert formulas into cells automatically.
Discover more from
Subscribe to get the latest posts sent to your email.