|
Some tasks shouldn't still exist in 2026. Manually emailing PDF reports at end of month is one of them... but they do. Here's the drill: Open Excel. Save a few sheets as PDF. Email to Manager A. Save others as PDF. Email to Manager B. Repeat. I used to have a VBA macro that did that for me. It was great. Until companies started blocking macros. Until Excel Online became a thing. Now there's a solution built into Excel that works on desktop and the web. You decide who gets which sheets. The script does the rest. No AI agent needed. I walk you through it in this week's video. You can even schedule it to run while you sleep with a simple Power Automate setup. ๐ค Geeky News๐ค Excel's Copilot edits are now trackableWhen someone on your team uses Copilot to change a workbook, you can now see it clearly in the Show Changes pane. The edit gets flagged with a Copilot icon so you know exactly what a human changed versus what AI touched. Available now in Excel for the web, coming to other platforms soon (if you're on Beta, you may already see it on Desktop). If you want to learn how Show Changes helps you track the edits, here's our tutorial. ๐ Copilot's new place and new shortcutLike we mentioned last week, Microsoft is doubling down on making Copilot harder to ignore, with the floating Copilot button showing up in Word, Excel, and PowerPoint. The update simplifies Copilot down to two entry points and adds smarter contextual suggestions based on what you've selected. Select a word, get word-level suggestions. Select a section, get broader ones. And if you navigate with a keyboard, F6 now activates the Copilot button across all platforms. ๐ถ Windows 11 might be getting new system soundsMicrosoft is teasing a refresh of its Windows sound design. For anyone who's used Windows long enough, this is a bit of a nostalgia trigger. Those old startup sounds are a trip down memory lane. Nothing officially confirmed, but keep your ears peeled. ๐ Compound interest. But for your ExcelSteffi is a Senior Financial Analyst. She just finished Automate Excel: Power Query & Power Automate Recipes. I love how she used compounding interest here: Thanks for sharing, Steffi. And enjoy the compounding. I'm off to the Global Excel Summit next week. Looking forward to meeting some of you there. You can expect my highlights from the sessions in the next edition of "Between the Sheets." ๐ Until then, 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.
There's a person on almost every team that everyone respects technically. And nobody wants to work with. Maybe you've sat in a meeting with them and left feeling a little smaller than when you walked in. Early in my career, I think I was sometimes that person. You see, I went by the advice "work hard and you'll be noticed" for years. Turned out to be the worst advice I ever got. What I missed for a long time: doing my job well was expected. That's why I was hired. But it wasn't what was going...
You've got a long list like this that needs to go into separate columns. Copy-paste? Nope. From now on copy-paste is officially banned for this type of work ๐ซ There's a single function that does the whole thing in seconds. ๐ Here's how it works Imagine copy-pasting 500 contacts! My wrist cramps up even thinking about it. ๐ค Geeky News Copilot in Outlook now handles your calendar Microsoft just made Copilot in Outlook agentic. Meaning it doesn't wait for you to ask. It sorts through your inbox,...
Quick question. How many working days are left until your project deadline? Not calendar days. Working days. No weekends and no public holidays. And no that-week-everyone-takes-off-in-August. Most people subtract two dates and call it done. Then wonder why the timeline is slightly off. Excel has a function built for exactly this. Custom weekends, holidays, even non-standard working schedules. ๐ Watch how it works and grab the practice file ๐ ๐จ๏ธ Someone asked in the comments: what if you need...