|
You know that moment when you buy something on sale and still feel ripped off? Yeah... percentages are sneaky little things. But Excel sees right through them. That “amazing” 30% off deal? Take the price, multiply by (1 - discount). Boom. Now you actually know what you're paying. Your internet bill went up again? (New ÷ Old) - 1. Time to switch providers - or just accept your fate. Wondering how much of your paycheck actually makes it to your pocket? Take what hits your bank account, divide by your gross salary (Part ÷ Whole), and format as a %. Hopefully, the number doesn’t shock you too much. And let’s be real - it’s hard to find a corporate report without percentages. With Excel, there’s no mental math (I’m really bad at that anyway!) Want to practice without risking your money? Check out our blog post and download the file we have for you. If you already feel like an Excel pro and craving something advanced but easy to learn... Guess what? I just started recording videos for a new course, introducing Python in Excel. I can't wait to share this because we're getting into some seriously cool examples. Things that Excel just can’t do on its own. Well... now it can, thanks to Python. Want to be the first to hear about it? Join the interest group and get updates straight from me.
🤓 Geeky News📒 Time to make the switch from OneNote for Windows to OneNoteThis was a long time coming. I said it two years ago: no rush to switch. But guess what? Time’s up. OneNote for Windows 10 is getting deprecated in October this year. If you're still using this version of OneNote, you have six months to say goodbye. From June, you'll notice syncing slow down. You'll start getting reminders about the phase-out. So you'll want to switch before it starts getting cranky. But don't panic! If you have Microsoft 365 or standalone Office, you probably already have the (surviving) OneNote app installed. If not, you can install it for free. Need some ideas on how to make the most of it? Check out my playlist for inspiration. ✏️ Snipping Tool got an upgradeYou know how drawing a shape with your mouse usually looks like a toddler’s first attempt at art? Well, the inking options of the Snipping Tool just got an upgrade. Now, when you hold the cursor after drawing a freehand shape, it magically evens it out. It's a nice addition to the existing Shape options. It's currently rolling out to Windows Insiders. Office Insiders might already know this functionality from the Draw tools in OneNote or Excel. 🤖 Warning: Don’t Trust AI Bots BlindlyHere’s the thing: AI chatbots can be confident, persuasive, and... completely wrong. A recent study from Columbia University found that over 60% of the answers from popular chatbots (including ChatGPT, Copilot, and Gemini) were making up false info - even with live search functionality. What's worse, they were "confidently wrong", stating the inaccurate information as fact. The most honest bot was Copilot. It declined more questions than it answered. At least it preferred to stay silent rather than guess. The lesson? If you're using AI bots for search, always cross-check the information. 👏 Power StoriesHave your ever wondered if improving your Excel skills actually makes a difference? It totally does. I get messages all the time from people who not only got better at spreadsheets but became the go-to expert in their office. Like Leslie and Don, who took our courses and came out on top:
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 😇 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! | ||||||||||
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.
You've built this cool visual using formulas. Dynamic, clean, exactly what the dashboard needs. For example, a waffle chart Now you want to add it to the main dashboard sheet. But there's a problem. If people start clicking around, they might accidentally delete a formula. Or overwrite a cell. And now your carefully crafted visual is broken. You could protect the sheet. Enter password every time you need to make changes. Or you could get creative. Take a snapshot instead. Linked Picture and...
Someone asked me recently about automation tricks in Excel. Fair question. Everyone's talking about AI agents right now. Microsoft's pushing them hard, every tech company's got one. But here's what they don't mention in the demos: AI agents cost extra. They work maybe half the time. You're basically hoping they get it right. Meanwhile, you already have a tool that does exactly what you tell it to. Every single time. Power Automate. You've probably got access already (comes with most Microsoft...
AI is everywhere. And I mean everywhere. Your email tool has it. Your spreadsheet has it. Even your coffee maker is probably marketing itself as "AI-powered" these days. The pitch is always the same: "This will do your work for you." "Build fully functional apps without knowing how to code." "10x your productivity." And yeah, sometimes AI actually delivers. It's genuinely impressive when it does. But here's what I've noticed: when it works, the work doesn't disappear. It just changes. You go...