There was a time when being really good at Excel meant knowing dozens of formulas by heart.

VLOOKUP. INDEX-MATCH. IF formulas. Pivot Tables. Conditional Formatting.

And if you could do all of that without asking anyone for help, you were probably the person everyone came to when an Excel sheet refused to behave.

That skill still matters.

But the way we use Excel is changing.

Today, the question isn’t just “Do you know Excel?”

It’s also:

“How quickly can you get the right result from your data?”

And this is where AI has started changing the game.

Manual Excel Still Has Its Place

Let’s be clear: AI hasn’t made Excel skills useless.

Far from it.

If your data is messy, you still need to understand what you’re looking at. If a formula gives you an unexpected result, you need to know why. If your dashboard suddenly shows numbers that don’t make sense, you can’t just blame Excel.

You need to understand the data.

Suppose you’re given a sales file with thousands of rows.

You may need to clean the data, remove duplicates, fix formatting, create formulas, use Pivot Tables, analyse sales and finally build a dashboard.

You can do all of this manually.

And sometimes, that’s exactly what you should do.

The problem starts when you’re spending most of your working day doing repetitive tasks that could have been handled much faster.

Now Add AI to the Same Excel Task

This is where things get interesting.

Instead of spending a long time figuring out every step yourself, you can use AI to speed up parts of the process.

Need a formula?

Tell AI what you’re trying to achieve and ask for a formula.

Not sure why your formula isn’t working?

Give AI the formula and explain the problem. It can help you identify what might be wrong.

Need to clean a large dataset?

AI can suggest formulas, steps or approaches that can make the process easier.

Want to understand a dataset?

You can use AI to help identify patterns, ask better questions and explore the information.

But there’s an important difference here.

AI can help you do the work faster. It doesn’t automatically understand what the work means.

That’s still your job.

The Real Difference: Time

This is probably where the biggest practical difference appears.

Imagine two employees are given the same Excel task.

Person A does everything manually.

Person B knows Excel well and also knows how to use AI effectively.

Person B may not necessarily know more Excel formulas than Person A.

But they might get to the first useful result much faster.

And that extra time matters.

Instead of spending the entire afternoon trying to fix a formula or clean hundreds of rows, they can spend more time checking the numbers, understanding what the data is saying and improving the final report.

That’s a much more valuable use of time.

A Simple Example From Everyday Work

Let’s say your manager sends you a customer sales file and says:

“Please find the top-performing products and prepare a quick report.”

The manual approach might look like this:

Open the file.
Check the columns.
Clean the data.
Create formulas.
Build a Pivot Table.
Sort the results.
Create a chart.
Format everything.

Nothing wrong with that.

But if you’ve done this type of work several times, you know how much of it is repetitive.

With AI, you can ask for help with formulas, analysis ideas, chart suggestions or even ways to structure the report.

You still check everything.

You still decide what matters.

But you’re not starting from a blank screen every time.

That’s the difference.

But There’s a Catch

AI can confidently give you a wrong formula.

It can misunderstand your requirement.

It can suggest a solution that looks correct but doesn’t actually work for your dataset.

And if you don’t understand Excel, you may not even realise there’s a problem.

This is why Excel + AI is more useful than AI alone.

If AI gives you a formula and you understand Excel, you can check it.

If AI suggests a particular analysis and you understand your data, you can question it.

If AI creates something that doesn’t look right, you have enough knowledge to investigate instead of simply accepting it.

That’s a big advantage.

What About Data Analysis?

The same shift is happening in data analysis.

Earlier, a lot of time went into preparing data before you could actually analyse it.

And anyone who has worked with real-world data knows that the data you receive isn’t always neat.

You may find missing values, duplicate records, inconsistent names, incorrect dates or numbers stored in the wrong format.

Sometimes the analysis itself isn’t the difficult part.

Getting the data ready is.

AI can help you work through parts of this process faster.

It can suggest ways to clean data, help explain formulas, assist with analysis and give you ideas about what to investigate.

For example, you might have a customer dataset and want to know:

• Which products are performing well?
• Where are sales dropping?
• Which customer segments need attention?
• Are there unusual patterns?
• Which areas deserve a closer look?

AI can help you explore these questions faster.

But there’s still something you need to bring to the table:

Knowing what is actually worth looking for.

That comes from understanding the data, the business and the problem you’re trying to solve.

AI Doesn’t Know Your Business Like You Do

This is something people sometimes forget.

You can give AI a spreadsheet and ask it to analyse the numbers.

But it doesn’t automatically know why sales dropped last month.

Maybe a product was out of stock.

Maybe there was a pricing change.

Maybe a major customer stopped ordering.

Maybe the company changed its sales strategy.

The numbers can show you what happened.

Understanding why it happened often requires context.

That’s why data skills still matter even when AI becomes better.

So, Should You Learn Excel Manually or With AI?

Honestly, both.

Don’t skip the basics just because AI can write a formula for you.

At the same time, don’t ignore AI just because you’ve been using Excel for years.

Learn how Excel works first.

Then figure out where AI can save you time.

Understand how data is cleaned and analysed.

Then use AI to help you explore it faster.

Know how dashboards are built.

Then let AI help with some of the repetitive parts.

You don’t have to choose between Excel and AI.

Learn Excel. Learn AI. Then learn where each one makes your work easier.

The Excel Expert Is Changing

The old idea of an Excel expert was someone who knew every formula and could finish a spreadsheet faster than everyone else.

That still matters.

But today, being good at Excel is also about knowing what needs to be done, what can be automated and when AI can help.

Sometimes you’ll write the formula yourself.

Sometimes you’ll ask AI for a starting point.

Sometimes AI will give you something that’s completely wrong—and you’ll know it because you understand Excel.

That’s the real advantage.

You aren’t handing your work over to AI.

You’re using AI without losing control of the work.

And This Applies Beyond Excel

The same thinking is showing up across data and office work.

Reports that used to take hours are becoming faster to prepare.

Routine data tasks can be simplified.

Ideas for dashboards, formulas and analysis can be generated much quicker.

But the people who benefit most aren’t necessarily the ones who know the most AI tools.

They’re the ones who understand the work and know where AI fits into it.

That’s an important distinction.

Knowing how to open an AI tool is easy.

Knowing what to ask it, checking its answer and using the result properly is a much more useful skill.

What Should Professionals Focus On?

Instead of trying to learn every new AI tool that appears, build a strong combination of skills.

Start with your core skill.

For Excel users, that could mean becoming comfortable with formulas, Pivot Tables, data cleaning, dashboards and reporting.

Then add AI.

Learn how to write useful prompts.

Learn how to ask better questions.

Learn how to check AI-generated results.

And most importantly, learn when not to use AI.

Sometimes the quickest solution is still a simple Excel formula you already know.

That’s perfectly fine.

The goal isn’t to use AI everywhere.

The goal is to work smarter where it actually helps.

Final Thought

Manual Excel isn’t going anywhere.

But spending hours doing something manually just because “that’s how we’ve always done it” doesn’t make much sense either.

The real question isn’t Manual vs AI.

It’s:

How can you use your Excel skills and AI together to do better work, in less time?

That’s probably the more useful skill to build.

The future isn’t about choosing one over the other.

It’s about knowing enough to use both properly.

Learn the Skill. Then Learn to Work Smarter.