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.
Smarter checkboxes, no code required
|
Tick it off. Time it. Done. ✅ Excel’s new checkboxes aren’t just easier to use - they’re surprisingly powerful. No more manually adding the timestamp or guessing when a task got done. You can now tick off a task and have Excel log the exact time it was completed. Automatically. No VBA. No scripts. Just a clever formula and a cool little trick. And the timestamp won’t budge - even if your cat walks across the keyboard and triggers a full-sheet refresh. (But be careful - with great power comes great responsibility. The trick relies on enabling iterative calculations, so you don't want to use it in important files. Save it for the simpler trackers.) 👉 See how it works or try it for yourself with our demo file. Microsoft just pulled the plug on ActiveX controls so if you’ve been clinging to those checkbox setups from the early 2000s... it might be time for an upgrade. The standard Form Controls are still there. But the new checkboxes are better. Sleeker. More intuitive. Perfect for to-do lists, trackers, and dashboards that actually impress. 🤓 Geeky News👨🏫 Smoother workflows in PowerPointPowerPoint got some love and attention with a slew of enhancements announced recently: 🖼️ Content placeholders are now interactive - when you click on the buttons inside the placeholder, they immediately insert the chosen object, or open selection options. No more back and forth between the ribbon and the slide. Convenient - I like it! 🔗 You can now link to slides in PowerPoint for the web (yeah, I didn't know you couldn't either; shows you how often I use the web version 🙃). 💬 Comments are now linked to the content rather than slides (so when you move the text or object, the comment goes with instead of staying behind). 💡 If you have an Enterprise Copilot license, no more staring at blank slides for you. You can take advantage of slide starters for structured content, like timeline, agenda, table, etc. 👨✈️ Word's Copilot Summary Just Got... a Lot WordierMicrosoft 365 Copilot in Word now comes with a beefed-up Summary. It can handle up to 3,000 pages and lets you pick between brief, standard, or detailed summaries. It's rolling out to Enterprise users on Windows, Mac, and Word on the Web. Coming soon: new tabs for Insights, Activity, Discussion, and Coaching. These will let you pull key stats, track recent edits, catch up on comments, and even get writing tips. They'll be dropping between May and August - first on the Web, then Desktop. It’s a handy upgrade if you’re working on long reports or collaborative docs. If you don't want to see it (because, honestly, not every document deserves a full executive debrief...):
💚 Did You Know?Ever wished Excel had a color picker like the one in PowerPoint? Well - how about one that will work anywhere? Because that's what Color Picker from PowerToys does. 🎞️ See for yourself 🎞️ To download PowerToys, click here. 👏 Power StoriesPower Query can be powerful - but only if you know where the traps are. Mariano was running into the usual suspects. Queries that broke when the data changed. Fixes that had to be repeated again and again. Then he hit Module 7 of Automate with Power Query. That’s where it clicked. Not just how to use Power Query, but how to tame it. How to read the M code, spot the troublemakers, and set up queries that adapt. Now? No more manual patch jobs. No more fearing data refreshes. The pitfall and automation of the course was something that I was looking forward to, and of course it did not disappoint. I always had to manually correct my pitfalls and they occurred often, but now it can be corrected automatically. Also, I always had to check for updates but now it is automated. Thanks, Leila, and your super team at XelPlus.
Mariano Arruda, Aerospace Engineering Officer
👏 Big win, Mariano! Got a success story about using your XelPlus skills? I’d love to hear it! Hit reply to share the details, and inspire other students 😇 Let’s build a library of wins! See you next week, Leila Want more?▶️ Subscribe on YouTube 🖇️ Follow us on LinkedIn 🥇 Join 400,000+ students in our courses 📣 Want to sponsor Between the Sheets? Get in touch here. 📨 If you were forwarded this message, you can get the free weekly email here. This newsletter contains affiliate links, which give us a small commission on any purchase made at no cost to you. This helps us run Between the Sheets and bring you updates like this. Thank you for your support! |
Leila Gharani - XelPlus
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.
If you've ever had to spell out a number on an invoice (or vice versa, convert “seventy-five dollars” into digits) you know how painful it can be. It was always possible in Excel, but required either a macro, or a monster formula. Not for the faint of heart. Now, with Excel's newest function, it's suddenly ridiculously easy. Wanna see how it works? 🙋♀️ Ask me anything! I’m putting together an "Ask me Anything" type of YouTube video for October. Drop any questions 👉 here, and my team will sort...
I finally got my hands on Excel’s brand-new COPILOT() function. It brings the power of generative AI to your formulas. It’s only just rolling out to Insiders, so most people won’t see it yet. (Others won't see it because they don't have the Copilot license... 👀) Still, it already has the community buzzing. Some are calling it the “function that replaces all others” (spoiler: it doesn’t). Others say it’s pointless. As usual, the truth sits somewhere in between. In the right scenarios, it can...
You’ve probably seen the warnings (including from me): “Never use merged cells!” Is merging cells always bad? Like many things in Excel, the answer isn’t so black and white. There are situations where merging cells makes sense. And others where it completely wrecks your spreadsheet’s functionality. Here’s the simple rule I follow: ✔️ Top of the sheet for clean headers? Merge all you want. ❌ Middle of your data table? Absolutely not. (You can get the same effect with a smarter method... read...