
In the dawn of this new age of AI, it is not only giving us fun new pictures to share with friends, but it’s massively changing the way we work and the use of Microsoft Excel is no exception. AI tools such as Microsoft Copilot and ChatGPT can now help us write formulas, analyse information, explain data and provide answers to complicated questions in seconds.
With all of this now available at our fingertip, it’s fair to ask whether traditional Excel skills will still be as important in the future. The short answer is yes, Excel skills still remain incredibly useful, although the way we use them is starting to change.
Rather than replacing Excel knowledge, AI can actually make those skills even more valuable, working alongside them. Knowing exactly how Excel works gives you a base and the confidence to use AI properly, have the knowledge behind its workings out and answers, check what is produced and get more from your data from this understanding.
Good AI Starts with Good Data
AI can do some impressive things with data, but it still needs to have good and the correct information to work from and provide correct and accurate answers.
If your spreadsheets are messy, inconsistent or poorly organised, AI can easily misunderstand what you are asking it to work with. Missing information, incorrect formatting and invalid formulas can all massively affect the results you get back, especially as AI may not even question them, assuming they are all correct and therefore read spreadsheets in the wrong manner.
This is where the knowledge of good Excel skills still makes a big and very important difference. Knowing how to organise your spreadsheets, structure your data correctly and have the right information makes it much easier to work with, whether you end up using the help of AI or not. AI might be able to analyse your spreadsheet quickly, but it can’t always fix poor data for you, so getting the basics right from the start will lead to the results that you actually desire, instead of confusing data that makes very little sense.
You Still Need to Spot Mistakes
AI can suggest formulas, summarise information and help you find answers quickly, however, as most of us already know, it won’t always get everything right! An AI-generated formula might look convincing but it could still be referencing the wrong cells, a calculation could be correct but based on the wrong data and it might even give you an answer that sounds perfectly accurate and reasonable, but it isn’t actually what you were looking for, therefore massively misleading you.
If you understand the workings of Excel, it becomes much easier to notice when something doesn’t look right and be able to correct it before the data gets muddled up amongst layers of incorrect AI workings. You can check the formula, look at the data behind the AI answer and work out whether the result genuinely makes sense and is correct.
The aspect of physical human review is still really important, AI can help you get to an answer faster, but you still need the knowledge and judgement to decide whether you can trust it.
Understanding Matters More Than Memorising
Learning Excel has often involved remembering formulas, shortcuts and different ways of completing a task, but AI is starting to change that and how we work. You might not always need to remember the exact formula for something if AI can help you, however you still need to understand what that formula is actually doing.
For example, if AI gives you a formula using an XLOOKUP, IF statement or SUMIFS, understanding how these functions work allows you to check, make changes and spot any problems before the spreadsheet goes too far and gets too complicated.
This also applies to Pivot Tables and charts. AI might help you create something, but having a good understanding of Excel means you know what you are looking at and why it has been displayed in that way.
AI can give you an answer, but it still takes human knowledge to understand whether that answer is genuinely right.
Everyday Excel Skills Will Always Save Time
Not every task needs AI, for plenty of straight forward everyday jobs, using Excel yourself will still be the quickest and easiest option. Filtering or sorting data, checking figures or making a small change to a report can often be done in seconds if you know your way around Excel. These are the type of tasks that come up regularly in lots of different types of job roles.
Being confident with Excel means you don’t have to rely on AI every time you need to make a change or find something in your data. Sometimes simply just doing it yourself is still the fastest way to get the job done. The stronger your basic Excel skills are, the easier it is to decide when AI will genuinely save you time and when it’s simpler to do something yourself.
Excel and AI Work Best Together
Rather than thinking of Excel and AI as competing with each other, it makes more sense to look at how they can work together and help each other.
AI can take away some of the more repetitive work, it can help you write formulas, explain functions or give you a starting point when you’re not sure how to approach something, but Excel gives you the structure, tools and understanding to actually work with that information.
If you are confident in using both, you can often work faster and get much more useful information from your data. The key is knowing when to use AI and when to use your own Excel skills and knowledge. AI can help speed things up for you, but your human knowledge, experience and judgement are still what brings it all together.
Things To Be Aware of When Using AI With Excel
There are a few things worth keeping in mind when bringing AI into your Excel work:
- Check AI-generated formulas and results carefully – Don’t automatically assume something is correct just because AI has given you an answer and it looks convincing.
- Be cautious with sensitive business data – Think about what information you are sharing with AI tools, particularly when working with customer, employee or confidential business information. Your data may not necessarily be safe and the last thing you want is to breach any sort of GDPR law, simply because you want a quick answer to save time.
- Keep your core Excel skills up to date – The better that you understand Excel, the easier it is to use AI effectively and more accurately.
- Use AI to support your judgement, not replace it – You still need know the context behind your data and what you are trying to achieve. It’s important to know how AI got to a result, so you know whether it is actually correct or not.
So, Does Learning Excel Still Matter?
Absolutely, yes!
AI will continue to change some of the ways we work and use software like Microsoft Excel and there will probably be more tasks that can be completed automatically in the future, but that doesn’t make Excel knowledge less useful.
If anything, understanding Excel is more important than ever, giving you a much stronger starting point for using AI well. You’ll know how your data should be structured, what questions to ask, how to check the answers and when something doesn’t quite add up.
The future isn’t really about choosing between Excel and AI. it’s about knowing how to use both together.
If you’d like to build your Excel or AI skills and become more confident working with your data, take a look at our range of courses at SquareOne Training.
https://squareonetraining.com/courses/data-and-analysis/microsoft-excel-courses/
https://squareonetraining.com/courses/ai-automation-courses/




