I'll be honest. I wasn't impressed with Copilot when it first came out. It was pretty limited. Specially in Excel. But after the recent updates, things changed. On the agenda today:
🎬 The best of Copilot in ExcelNot that long ago, when I tried to use Copilot in Excel, it refused to cooperate. It wasn't a one time thing. It was constantly having trouble of some sort. But since then, it has moved from Preview to general availability. Before Microsoft decided on this move, they had to be sure that they had a good product. I gave it another go. I must admit, I was blown away. In this week's video, I'm sharing a few use cases where Copilot excels. With a straightforward prompt, you can: 📋 Save a ton of time summarizing text responses! (this is 🤯) 💡 Get insights on your data (just type that as a prompt and see what happens) 🔎 Look up values from another sheet. (Yep, no need to write a lookup from scratch) 🖍️ Highlight an entire row based on the value in one cell. Copilot proves to be a great time saver in all those cases. Remember, a tool like this can give us a productivity boost. But it's only as powerful as the knowledge you bring to the table. If Copilot doesn't give you the desired result the first time, you can course-correct as long as you know what to ask for. And if that gets frustrating, you can just do it yourself. 🤓 Geeky News👨✈️ Even more Copilot in Excel magicLet’s face it - messy data can drive anyone up the wall. Sometimes, it feels like you spend more time cleaning your data than actually analyzing it, right? Well, Copilot now promises to get it done in seconds, with the new Clean Data feature. Currently, it's only available in Excel Online but it's coming to Desktop as well. It can detect inconsistent text case, number format, as well as extra spaces. It shows the cleaning suggestions, and you choose how to correct them. How cool is that? BTW, if you don't see the automatic suggestion from Copilot, you'll find Clean Data under Data Tools. 👥 Teams gets a major revamp for streamlined navigationTeams brings chats, teams, and channels into one place under Chat. You no longer have to switch between the different tabs to keep track of your conversations. You'll get them in a single list, where you can cycle between different views using filters. You also get a single-list view of all the conversations where you're @mentioned. You can also organize your conversations into custom sections. In Favorites, you can pin important chats and channels for quick access. All these features - and more - are coming to Public Preview in November. 🎨 Generative AI in MS Paint & NotepadNew AI features were introduced to Windows Insiders. Paint now has "Generative Fill." Select an area of your image, describe what you want, and AI will fill it in. The generated object should blend into the existing image. If, on the other hand, you want to get rid of an object in an image, there's "Generative Erase". It removes the object and fills in the empty space to match the surrounding background. Notepad introduces "Rewrite." Highlight text and get three rephrased versions. You can adjust tone or length with ease. Both tools use cloud services, so you’ll need to sign in with a Microsoft account. 👏 Power StoriesA comment left in our Master Power Query course made me very happy. When you venture into a new topic, it's important to implement what you've learned early on. Don't wait until you're done with a course to start applying the new skills. Use the new knowledge to experiment and improve your processes. That's how the knowledge will stick. And you'll be making your work easier from day one. Hats off to Zulfiquar for doing just that! Leila P.S. Our Black Friday deals are almost here! 👀 If you've been thinking about leveling up your skills, this might be the perfect time. Stay tuned for something special… more to follow later this week. |
XelPlus is a leading online education company, providing training courses for Excel, Power BI, Finance, and Google Sheets. XelPlus’ bestselling courses are popular among financial analysts, CFO’s, and business owners. Technology is changing fast. We help our members turn confusion into confidence with every skill learnt.
I just love seeing all the cool ways you’re using the techniques from our courses. Watching you bring these ideas to life is what makes teaching so exciting for me! So, this week, I’m sharing a few tips and updates I think you’ll really enjoy: A simple DAX trick for interactive dashboards 📊 Handy updates to Excel’s mobile app 📱 And yes, Excel even showing up in a crime novel! 🔍 📊 Make Your Dashboards Interactive with This Slicer Trick Ever wish you could fit more KPIs (like profit, cost, or...
I’ve got exciting news! In February 2025, I’ll be back at the Excel Summit in London, and I’d love for you to join me. Last year, being there in person was something else. The sessions were great, but what I loved most was meeting people face-to-face. That’s what made it unforgettable. The energy, the connections - you just don’t get that online. I’m really excited to experience it all again, and I hope to see you there! 📅 When? February 4-6, 2025 📍 Where? Soho Place Theatre, London (UK) Get...
If you’re like me, you’ve probably faced this problem before: You open up a dataset, and it’s filled with blank rows. Ugh! Cleaning this data is like ironing a crumpled suit you found in the back of that long-neglected closet. (I’m not a fan of ironing - I always end up with creases in the wrong places. And honestly, if I try deleting hundreds of blank rows manually, I’d probably delete something important!) But don’t worry, fixing it is way easier than it seems. In today's Between the...