Josh Aharonoff, CPA's Linkedin Analytics

Excel’s Copilot just released some CRAZY new features So I spent the entire weekend testing it…and I'm pretty blown away. And today, I'm going to show you exactly what it can (and can't) do. 📽️ Watch the FULL video tutorial via the link at the end of this post ➡️ WHAT IS COPILOT? Think of Copilot as an AI chatbot right in your Excel file… only instead of just chatting with you, it can actually comprehend and interact with your data. ➡️ HOW TO GET STARTED I found this a bit tricky - you won't find it in your add-ins menu. Instead, head over to Microsoft's website and download + follow their installation process. Once installed, you'll see the Copilot button in your home tab and whenever you right click ➡️ 8 GAME-CHANGING THINGS YOU CAN DO WITH COPILOT 1. Create PivotTables in Seconds No more manual dragging and dropping. Just tell Copilot what you want to analyze, and it creates your PivotTable. 2. Generate Charts Looking to tell a Story? Want to visualize your data? Copilot will suggest the most appropriate chart type and create it instantly. 3. Filter & Sort This is pretty cool…copilot will actually filter / sort your table. 4. Write Complex Formulas This may be the most powerful piece of copilot - here you can get the syntax for a custom formula, learn how the formula works or even better…have copilot add it directly to your Excel file. 5. Custom Formatting Another really neat feature - I took the column in an AP ledger showing the days outstanding as a number and added “days” to it via custom formatting. 6. Read Through Text and Summarize What good is an LLM if it can’t read and analyze data? I took another column from an AP ledger…”Delivery feedback”, and summarized how well each shipment was delivered 7. Clean Messy Data From text-to-columns to proper casing, Copilot makes data cleaning a breeze. 8. Comprehend and Analyze Data Ask This may be the most important - an AI that actually has the context on your data. I was even able to get it to act like an FP&A analyst and forecast out 2024 salary by prorating start dates. ➡️ BUT WILL IT REPLACE US? Updates like these are equally exciting as well as terrifying. Will I still have a business if copilot can eventually replace what I do? Here's what I've learned after extensive testing: 1. Copilot excels with structured data but struggles with unstructured information 2. It can't handle complex visualizations like waterfall charts 3. It often gets "tired" during extended sessions (apparently, AI needs coffee breaks too) So, am I worried about being replaced? Not yet. While Copilot is impressive, it's still just a tool - albeit a powerful one. It's fantastic for those new to Excel, but experienced users will see it as an enhancer rather than a replacement. === Is Copilot part of your Excel workflow yet? Share your thoughts in the comments below 👇 PS: Watch the FULL tutorial here: https://lnkd.in/eAWE6mpV