|
The files I used to have in my corporate job were pretty large. Like 40+ sheets. Some had more. I used to dread opening one of these during a presentation. Someone would ask me to pull up a specific sheet. And I'd be scrolling... checking... scrolling... It wasn't fun. Then someone showed me a simple click to see all the tabs in one place. I'd been using Excel for 10 years by that time and had NO CLUE this existed. That's just one of 4 methods I cover in this week's video, including one that makes your workbook look like an app. You'll be amazed how simple it is. ๐ฝ Download the file to get inspired. Turns out Excel can be pretty user-friendly when you want it to be. โ ๐ฒ Learn on the go (even offline)Did you know you can watch XelPlus courses on your phone using the Teachable mobile app? And here's the best part: you can download lessons and watch them completely offline. Flights. Long commutes. Or like Aneta, one of our members, shuttling kids around to after-school activities. How to get started:
Your progress syncs automatically across all your devices. Start a lesson on your computer, finish it on your phone. โ ๐ค Geeky News๐ค Agent Mode in Excel now on desktop (but not for us in the EU yet)Microsoft just made Agent Mode generally available on Windows and Mac. It was already on Excel for the web since December, but now it's in the desktop app too. At least outside EU and UK. What's new: you can now choose between OpenAI's GPT 5.2 and Anthropic's Claude Opus 4.5 models. Microsoft says different models handle different tasks better, so they're letting you pick. They've also added web search with source citations. Unlike the "standard" Copilot experience (Agent Mode also requires a Copilot license), Agent Mode is supposed to be self-sufficient. You describe the desired end result, it figures out how to get there. No chatting, just doing. My initial experiments (back when it was still in preview) didn't blow me away. Microsoft claims it's much more reliable now. We'll have to see... I'm a Claude fan, so I'm curious to test that option when it finally rolls out here. ๐ค Anthropic published Claude's constitution (promises not to destroy humanity)Speaking of... Anthropic just released Claude's constitution. It's the rule book for how their AI model should behave. The big priorities: be helpful, be honest, be safe. Don't help anyone build bioweapons. Don't undermine human oversight. Pretty standard "please don't go rogue" stuff. They also admit there's a gap between what they want Claude to do and what it actually does. Training is hard. They'll make mistakes and "hopefully correct them." Well, that's... reassuring? The constitution is released under Creative Commons, so anyone can use it. Check out the whole 80 pages if you're curious. Or ask Claude to summarize ๐ ๐ Google is killing Gmailify and POP email fetchingIn non-AI-related news... โGoogle's shutting down two email features this month: Gmailify and POP fetching. Gmailify let you connect non-Gmail accounts (Yahoo, Outlook, AOL) and get Gmail's spam filtering, smart inbox sorting, and search. Not anymore. You can still read non-Gmail accounts in the Gmail mobile app. But you lose the spam filtering and inbox organization that made Gmailify useful. POP fetching pulled emails from other accounts directly into your Gmail inbox on desktop. The alternative is to set up automatic forwarding with your other email provider. It works, but it's an extra step. โ ๐ "They ask for my help now"Big congrats to Francisco on completing Excel Essentials for the Real World. Years of Excel experience... But like most of us, he learned by copying whatever solution someone showed him once. That became the way. Forever. 30 years in, and he's still finding better ways. Well, same here. I'm still learning new things too. See you next week, Leila โ When you're ready, here are some ways we can help: ๐ Join 400,000+ members in our coursesโ ๐บ Get free tutorials on YouTubeโ ๐ฅ Train your whole team with our courses. Team pricing and progress tracking - reply for details. This newsletter contains affiliate links, which give us a small commission at no cost to you. Thank you for your support! |
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.
Your Power Query file works perfectly. On your machine. Then someone else tries to use it and suddenly nothing refreshes because the folder path points to your laptop. This is why people move files to SharePoint. Same folder, everyone can access it, no more path issues. Great. You'll just use the SharePoint Folder connector and... ๐ต๐ซ Ok, which path it's supposed to be? Here's the catch: Power Query shows you a giant list of URLs instead of folders. Well, there is a better way. And it takes...
Performance review season is coming up. Your boss wants numbers. Growth numbers. Specifically, year-over-year growth. When you can quickly show revenue grew 17% YOY and EBIT jumped 23%, you're telling a story. You're showing you understand what moved. I put together a step-by-step guide on calculating YOY growth in Excel. It covers: The exact formula to use (simpler than you think) How to format it so it actually looks professional A conditional formatting trick so trends are obvious at a...
I kept closing Copilot Chat the second it popped up. Every time I logged into Microsoft 365, there it was: I just wanted to get to my apps. This new interface felt like one more thing in the way. Well, finally I gave in. Started experimenting to see which prompts could actually reduce friction. For example, I don't look forward to going through unread emails on Monday morning. Especially when I see 47 emails waiting for me. That's friction. I also waste a lot of time looking for files. I...