ICAEW.com works better with JavaScript enabled.

Getting the best from Copilot with Claude and ChatGPT

Author: ICAEW Insights

Published: 23 Apr 2026

Copilot now uses Anthropic’s Claude as well as OpenAI’s ChatGPT. Here’s what that means for finance professionals, and how to make the most of both platforms through Copilot.

Key takeaways

  • Copilot uses more than one large language model (LLM) to assist Microsoft users.
  • CoPilot now includes Claude alongside ChatGPT.
  • Users can choose which platform to use or let Copilot choose for them.
  • Claude is better for documents, ChatGPT works best with data.
  • New Copilot use cases include automating workflows and creating forecasting and budgeting tools.

For accountants who are unsure of assistive technology, such as Copilot, Ian Schnoor, Executive Director at the Financial Modeling Institute, offers simple advice: “All accountants and all finance professionals should start playing around and try to use Copilot in their spreadsheets.”

He describes embracing this technology as “kind of mandatory”: “I know it is new and it is scary and it's changing very quickly, but an accountant who refuses to start using Copilot today is similar to an accountant who refused to use a computer and a spreadsheet in the ‘80s or ‘90s.”

Prefer to listen?

Allow SoundCloud audio

This audio player is provided by Soundcloud, a third-party service. We ask for your permission before anything is loaded as SoundCloud places cookies on our site. For more information on how we handle cookies, please see our privacy policy and cookies policy. To listen to this content on the website, please accept Statistics cookies and continue. Alternatively, you can access ICAEW podcasts on Spotify, Apple podcasts or YouTube.

Disclaimer

This audio file was produced by AI and has been adapted from the original article for audio purposes.

What changed in the latest CoPilot update

Upgrades to Copilot that went live in February 2026 have enhanced the use cases for the generative AI chatbot solution. As well as spreadsheet functions, Schnoor says the main use cases for Copilot include building audit files, automating workflows, and creating forecasting and budgeting tools. He explains that it uses a multi-LLM strategy, incorporating Anthropic's Claude and OpenAI's ChatGPT, rather than being an LLM itself.

“Until recently, Copilot in Excel was essentially like having an AI agent right in your Excel, and it could give you ideas and check your work, but it wasn't building anything up until February,” Schnoor continues. “Now Copilot can be used to build and check things – it's pretty wild because you can give it an instruction and then watch it build a spreadsheet for you.

“It can actually create multiple Excel files simultaneously, which a human cannot do; it can work in more than one file.”

Rather than viewing Copilot as a general assistant, Schnoor urges accountants to treat it as a custom architect for your daily operations. By mapping out existing workflows, accountants can systematically replace tedious manual entry and data migration with streamlined, automated sequences.

“What I actually encourage people to do is think about their own workflows, the things people do all day, every day – you've just been doing them for so long, it's just second nature,” he says. “I encourage people to dissect and map out the particular processes they engage in, and then start experimenting with how they could automate some of these things using Copilot.”

How do you choose Claude or ChatGPT?

In terms of Claude and ChatGPT interacting with Copilot, Schnoor says it is important to understand that Copilot “sits on top” of the LLMs. Accountants have the option of choosing whether to use Claude or ChatGPT with Copilot or let Copilot choose, based on which one it “thinks” is better for the task. 

Just as Schnoor encourages accountants to experiment with different tasks on Copilot so they become accustomed to the technology and its benefits, he says it is important to try the latest versions of Copilot and test out whether Claude or ChatGPT works best for their needs.

“I don't want to say which one is better, because they're better for different things – and they're changing so quickly that whatever we talk about today could be very different in one week from now or a month from now,” says Schnoor. “I'm reading about more people deploying a multi-LLM strategy, whether they are writing something or designing a visual space or building a spreadsheet. A lot of people build with one LLM and get another one to check it.”

Use ChatGPT for data, Claude for documents

In general, ChatGPT is a solid Copilot partner for advanced data analysis, as well as having excellent vision capabilities for scanning and interpreting handwritten or unclear documents. Claude is known for offering strong writing skills, especially for sensitive documents and emails, as well as great capabilities with spotting discrepancies in large quantities of data.

While the possibilities for Copilot via Claude or ChatGPT are exciting, Schnoor says the technology still needs to be approached with a degree of caution while keeping expectations realistic.

“Copilot’s capabilities as a really effective tool are still quite new and you must start experimenting to stay sort of on the curve, but be cautious and be aware,” he says. “We’re seeing a lot of people experiencing AI burnout. There's a lot of hype all over LinkedIn and social media that says, ‘Hey, build your model in five minutes when it used to take you eight hours.’”.

While Copilot has great time-saving potential, “it's not going to give you quite the extreme savings in most cases that some of the hype sellers are selling,” Schnoor says.

Human oversight is key

Schnoor stresses the importance of human oversight, combined with continuously valuing human skills, with regards to solutions such as Copilot.

“I strongly believe human oversight is going to be mandatory [for AI technologies] and the other thing that is more important than ever is human skills,” he says. “I believe the only way to challenge and push when [AI solutions] hallucinate and make mistakes and go in the wrong direction. The only way to understand and validate the work of an AI agent is to fundamentally have the skills.”

Schnoor compares this need for accountants to still oversee and apply their skills when using AI to the changing role of computer programmers: “Good programmers are doing very little programming anymore, but they need to be able to read, check and audit everything AI is doing and the only reason they can do this is because they already have strong programming skills.”

“The exact same thing is true for accounting and finance professionals,” Schnoor continues. “You can use AI to build budgets, models and other tools, but you should only be doing that if you already have the skills and the knowledge, because otherwise it's going to generate work that you have no capacity to evaluate.”  

Join our webinar

ICAEW's Excel Community is hosting a webinar exploring how AI can be used to augment financial modelling in Excel.

Middle-aged white man studying laptop screen and taking notes

You may also be interested in

ICAEW Community
Abacus
Excel

Do you use Excel in your organisation? Are you using it to its maximum potential? Develop your skills and minimise spreadsheet risk with our Excel resources. Join the Excel Community

ICAEW Certificate
Analytics in Power BI

Gain essential data analytics skills and advanced reporting techniques to stay ahead of industry demands with this practical qualification from ICAEW.

Find out more
ICAEW support
A person holding  a tablet device displaying various graphs
Training and events

Browse upcoming and on-demand ICAEW events and webinars focused on making the most of the latest technologies.

Events and webinars CPD courses and more
Open AddCPD icon