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.
The automation tool you already have (and probably forgot about
|
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 work accounts). Build the workflow once, set the logic, and it runs. No crossed fingers. No "let me rephrase that prompt." If you're not sure where to start, check out my Power Automate tutorials and YouTube playlist:
See how simple it can be. (Side note: The "New Designer" drives me crazy. If you're with me on this, just toggle it off in the top right corner.) There's something satisfying about automation you can actually count on. 🤓 Geeky News🔐 Google lets friends help you recover your accountGoogle's rolling out a new way to get back into your account when you're locked out: designated friends or family who can verify your identity. You can add up to ten Recovery Contacts. They have seven days to accept your invite, then another seven-day waiting period before they can help you. When you need them, Google gives you a number valid for 15 minutes. Share it with your contact, they match it from three options on their device, and you're back in. Rolling out now for personal Google accounts. 🗓️ Gmail will schedule meetings for youOnce you're in your Google account, Gmail has a new AI trick to save you time. When Gemini detects you're trying to schedule a meeting, a "Help me schedule" button appears. Click it, and it scans your Google Calendar for open slots that match the context. You can edit the suggested times, remove ones that don't work, or add your own. Then insert them into your reply with one click. If the recipient also uses Gmail, they just click their preferred time. Google Calendar automatically creates the event for both of you. Currently works for scheduling between two people only. 📝 Crop pictures in OneNoteIf you paste screenshots into OneNote, you've probably been annoyed by this: you're stuck with whatever you captured. You had to open another app if you wanted to crop your screenshots. Not anymore. OneNote now lets you crop images directly - with your mouse or with keyboard for more precision. No fancy crop-to-shape options, but honestly, this should've been there years ago. Windows only for now. 🤔 Did You Know?Two ways to copy conditional formatting to other parts of a worksheet without overwriting the cell contents:
Note: "All merging conditional formats" pastes the cell contents along with the conditional formatting rules. Unlike Paste Formats, it doesn't overwrite any conditional formatting rules already in the destination cell. 🙌 More Time for What Actually MattersWhen you work with smart people, the last thing you want is to bury them in repetitive tasks. Liliya gets it. She's a Senior Finance Controller. Her team is talented. And now they're spending less time on low-value work and more time on what actually moves the needle: That's the real win. Congrats on earning the Automate Excel certificate! 👏 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.
When I worked in finance, the reports I had to build almost always came from more than one sheet. A lot of copy-pasting. These days one formula can do that for you. It's called VSTACK. It stacks your sheets into one list. It stays live, works in Excel Online, and anyone who opens the file knows exactly what's happening. Most people who use VSTACK, use it to glue two ranges together, and think that's it. But that's barely scratching the surface. I put together my top 6 VSTACK tips in this new...
The most common way people mess up their own spreadsheets is a button sitting right there on the Home tab. Merge & Center. It's one of the first buttons anyone learns in Excel, and it does exactly what it says: centers a title, makes a header look tidy. The trouble starts the moment someone uses it inside the data instead of just the header row. Try to sort... yep, it doesn't work. Try to sum a column with a merged cell sitting in the middle of it. Column E, for example: Exactly. You'd have...
What do you do when your data goes wide? Picture a sales table with one row per rep, but then Sales_Jan, Units_Jan, Sales_Feb, Units_Feb, and so on, all the way to December. It just keeps growing wider with every month you add. Try to filter by month, or build a pivot table around it, and you're stuck. Month isn't a value in this table. It's baked into the column headers. You need a way to turn the wide into long so that it's ready for analysis. And there's a Python function that does exactly...