Copilot for Finance in Excel Automates Financial Reconciliation, Done In Just Few Minutes

Microsoft released Copilot for Finance within Excel (preview) on 2/29/2024. In this video I demonstrated how to use this copilot tool to complete financial records reconciliation in just few minutes, instead of hours or days. I also demonstrated how you can install this free tool onto your Excel application now to take advantage of it.
Please use this link to download Copilot for Finance within Excel.
appsource.micr...
Alternatively, you can download it directly from your Excel application by going to Home tab, click on Add-ins, then search for Copilot for Finance. From the search result, click on the Add button
You can download the demo Excel file I used in the video from below link, so you can try it out.
www.superexcel...

[@SuperExcel.online]

I also did a similar demo of this for the Microsoft Copilot Learning Hub series, check it out here learn.microsoft.com/en-us/shows/copilot-learning-hub/revolutionize-your-budgeting-with-copilot-for-finance-in-excel

[@JeePeeYoto]

Thank you for sharing!

[@andyandrews2704]

Thank you for the great video and the clear, simple explanation. Excellent work.

[@VinodKumar-e7z5c]

Mate This is great new addition and your explanation was great. Thanks

[@SuperExcel.online]

Thank you, I’m glad you liked it.

[@amornratpetchwong5761]

Thank you for your sharing, this very helpful so much.

[@pauladepitan7516]

Great presentation. Thank you

[@SuperExcel.online]

I’m glad you liked it. Thank you.

[@Hae3ro]

At least one useful function in Copilot

[@Lil_penguin_doll]

Very helpful 😊

[@TinaNguyen-t8m]

Very helpful. I will try

[@brianivandertp]

Interesting. Thanks for sharing

[@SuperExcel.online]

Thanks for watching!

[@khan1989p]

Simple vlookup in both sheets

[@SuperExcel.online]

It’s actually more than just VLOOKUP. For those one-to-one matching records, VLOOKUP definitely could accomplish that. However, for those one-to-many, many-to-one, and many-to-many matching records, VLOOKUP simply could not do the job.

[@nathanpinotti]

Thank you so much for the explanation!! I just didn't manage to download the file used in the demo. It shows that the website if offline. Would you be so kind to re-upload it, pls?

[@SuperExcel.online]

Thank you for the feedback. I'm not sure why it shows being offline, as it is located on Microsoft OneDrive. I suspect, for you, sharing the file might be different from sharing the folder that contains the file. I have now changed the link to the folder instead of the file. Please try again to download it. Thanks.

[@Manel_Disney]

I have limitations in reconciling with Copilot in cases where the descriptions are different. How can I overcome this limitation?

[@SuperExcel.online]

That's the same challenge another person emailed me after watching this video and tried to reconcile. If the discrepancies follow a structure or rule, then we can use certain text manipulation functions to create the corresponding matching "description" text first, then put them into Copilot for reconciliation. If you like, you can email your Excel file with sample data and detail explanation, I will take a look to see if that could be handled with formulas first before putting into Copilot. You can find my email contact from my website. Thanks.

[@noellackey104]

Is there anything available to compile Profit and Loss and Ballance sheet?

[@SuperExcel.online]

Copilot for Finance will be able to provide AI-powered, role-based workflow automation, recommendations and guided actions in the flow of work for finance team. In the current preview, only reconciliation capability is available. As per Microsoft's announcement, variance analysis will become available later. Based on the way Microsoft has been going with all those various copilots, I would not be surprised down the road, it may be able to compile profit and loss and balance sheet. It might be difficult to predict when that could happen though.

[@jankolb9079]

Can I upload the sample data somewhere?

[@SuperExcel.online]

@jankolb9079, Do you mean to “download” the sample data used in the video? If that’s the case, you can use the link provided in the video description to download.

[@Manel_Disney]

Thank you for your sharing, but I can't download.

[@SuperExcel.online]

Thanks for letting me know. I'm not sure what you encountered when trying to download, there are all kinds of causes. If you like, you can email me with more details, I'm willing to explore with you together to find out the cause. You can find my email on my website. We may need to go back and forth multiple times to investigate.

[@yfsiah1939]

didnt work at all! this feature is a waste of time.

[@SuperExcel.online]

Mind to tell us more, so we know what didn’t work? It did work on my computer.

[@catpolcatpol1234]

Try SumMatch Excel add-in