Financial experts wish they had this AI tool sooner. 👩🏫 Learn more with my Excel courses: ⬇️ Download the sample file here and follow along: Reconciliations, variance analysis and debtor management are time-consuming tasks that financial professionals juggle on a regular basis. But the new Copilot for Finance add-in, available for Excel 2016 onwards or with a Microsoft 365 license, can do these boring tasks for you, so you can focus on driving business growth. In this video, I will show you how to install the add-on and use it. LEARN MORE =========== 📰 EXCEL NEWSLETTER – join 450K+ subscribers here: 🎯 FOLLOW me on LinkedIn: 💬 EXCEL QUESTIONS: Get help in our Excel Forum: ⏲ TIMESCOPE === ====== ===== 0:00 NEW Finance Tool…
❓What are your biggest challenges in financial reconciliations and data management that you hope this tool will address?
Learn more with my Excel courses: https://bit.ly/copilotf24course
Absolutely fantastic tutorial! The Co-pilot for Finance add-in is a true lifesaver for anyone in the finance sector.
Your step-by-step guide makes it so easy to follow along and implement.
I love how it simplifies reconciliations and variance analysis, turning what used to be hours of manual work into a streamlined process.
This tool is going to revolutionize the way we handle financial data, allowing us to focus more on driving business growth.
I’ve already started using it in my daily tasks, and the time saved is incredible.
For those still on the fence, I highly recommend downloading the example file and trying it out – you won’t regret it!
Has anyone else tried this add-in yet?
Would love to hear about your experiences and any tips you might have!
Hi I can't find the link for the worksheets.
💚
Hi Mynda, this does not work for me. I added the add in, and did a reconciliation on my small 5 item test case. I deliberately made 3 items to match, and left the other 2. Copilot found 1 match. On each of the other items, it saw the same figure in table 2. Meaning copilot assumes the matched figure as the figure for all other items in the 2nd table, though my original table has their own figure. I removed the addin, reinstalled, tried again, but still no joy
Oooh, I’m gonna win some brownie points on Monday. Thanks Mynda! ❤
As a finance professional, I am excited to use CoPilot. You mentioned that there is a 10,000 row limit for the table size. Are there plans to expand that limitation in the future?💵
thank you always I'm always impressed by your videos. For your information, what video editing software do you use?
Thank for giving us some fabulous insight into this feature. There is one question I have. Does this add-on upload any data to the copilot server or does all the work happen on the computer of the user? Uploading corporate data to a copilot server may be something that is prohibited by data handling policies. Thank you, cheers. 😊
Do you have courses totally focused on data analytics?
Isn't this always done in Xero (or whatever your accounting software is)? – not excel…
❤ good work 💯
Does the reconciliation copilot address the data formatting differences, eg text versus numbers in invoice id example? Thanks.
I have a complex workbook excel of 20 tabs P&L and would like to have your consultation in private – can you contact me ?
Wow, this new tool for finance professionals is a game-changer! Saving time on reconciliations and variance analysis is a dream come true. Great stuff!
You might be happy until you're not needed for any of this anymore 😂
Great material👍 I am also creating a Polish channel about data analysis on YouTube and I found a lot of inspiration from you. I really like your style and message. Good luck!😀
not worked even after following steps. Not sure why
But in your case, if there is little difference in amount it will go in unmatched even 0.10 … Please correct me if I misunderstood….
Thanks for the video. Actually a reconciliation can be made via a classic Pivot Table. Just push these two datasets to PQ, invert paid amounts, name both amounts' fields similarly and append both queries. Then load it to Pivot Table and place Invoice ID as the leftmost row field, Amount to data area, the rest of fields elsewhere .That's it. Just filter Invoice ID by values: the ones that equal to zero will mean matched. There can be more complex analysis scenario in such Pivot Table. I've been using this technique for various reconciliations and find it pretty flexible and powerful.
Super interesting.