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.
Solve the cube every time
|
I've been teasing an unconventional project for a while... Well, it's finally here! Dive with me into the world of Rubik's cubes. And let's solve one together. If solving a Rubik’s cube feels impossible, this technique makes it easy for beginners. Promise. Then read on to learn how you can register for my upcoming webinar (on Excel, not cubes 😉). 🟨🟦🟥🟩🟧⬜ Solve Rubik's Cube in 7 StepsMy son got me hooked. You know I love a challenge and I love to learn new skills. But most tutorials out there were too technical and difficult to follow. Algorithm this, algorithm that... So I broke it down in a way that I was able to fully understand. This is the framework that worked for me. I tested it on my team when they were here in Vienna, and it worked on them too! So now it's your turn. Let's get cubing... Some cube facts:
I'm a long way from any record 😁 but it's still satisfying to solve it. As with any skill - whether it's Excel, or Rubik's cube - mastery is all about practice. So get practicing! 😁 To help you along, we also prepared a handy cheat sheet. Know someone with a cube collecting dust? Share this with them. Trust me, they’ll thank you. 🟨🟦🟥🟩🟧⬜ Join me for a Live WebinarAre you ready to work smarter in 2025? Next Thursday, January 16th, I'll be hosting a webinar showcasing the tools that transform how you use Excel. If you missed the webinar in December, this is your chance to get caught up. See how you can use AI and non-AI tools in Excel to save time and get ahead.
I'm planning more webinars this year. I'm excited about a lot of topics that I'd like to share with you. 🤓 Geeky News👨✈️ Improve your Copilot prompts with images in Word and PowerPointYou can now add images to your Copilot prompts in Word and PowerPoint. Simply paste or upload the picture and provide the instruction. For example:
By including images, you're making your prompts clearer. This should get you exactly what you need faster. 🌈 Generate AI images from other images using Google WhiskIn Google's latest AI experiment, you don't even need words. Whisk from Google Labs lets you create new images using only pictures as prompts. You provide (or randomly generate) pictures to represent the subject, scene and desired style. Whisk will then combine them in a new AI-generated image. You can provide more detail using text prompts, but it's not required. You can also refine the image with additional instructions. Whisk uses the latest version of Google's Imagen 3 image generation model and it's currently available in the US. 👥 Microsoft Teams updates for 2025Teams is getting some updates in early 2025. Keep your eyes out for:
(We've started using it in our team meetings and I must admit - Copilot is really good at cutting out the fluff and leaving only the action items. The AI summaries are quite useful. As long as we remember to enable meeting transcript at the start 😅)
👏 Power StoriesCongrats to Sophie for completing Fast Track to Power BI! I'm glad you enjoyed the journey 😊 Wishing you many exciting BI projects ahead! 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! |
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.
Remember this? =RIGHT(A2, LEN(A2) - SEARCH(" ",A2)) You just wanted the last name. Now you're doing math. Or this one: =OFFSET(A4, COUNTA(A5:$A$29) -12 +ROW(A1),0,1,1) All that... just to get the last 12 months of data? Well… not anymore. Compare that to: =TEXTAFTER(A2," ") Or =TAKE(A5:.B29,-12) These newer functions are easier to read, easier to write, and do exactly what you need. No nesting. No helper columns. A tiny part of me misses the struggle. Plus they were a good workout. 😅 But...
Copy-paste isn't a strategy. When your data is spread across multiple sheets, keeping it all in sync gets messy fast. Excel’s VSTACK gives you a smarter way. It lets you pull everything into one clean table with a single function. No macros. No Power Query. Just a formula. Add FILTER or SORT on top (or the new trimrefs), and suddenly you have a setup built to scale. ▶️ Watch the tutorial on our blog 📄 Download the practice file The video takes me back 😉 I had fun playing both roles. And yes,...
Since we started unpacking Python in Excel, one theme keeps popping up: “I get that Python's powerful… but what exactly does it do inside Excel?” “And do I really need to learn it?” Fair questions. Especially with all the AI buzz and Copilot updates. So let’s get clear. Python is the same language that powers Instagram algorithms and self-driving cars. But inside Excel, it’s your shortcut to deeper, smarter data analysis: Discover trends Excel charts can’t reveal Run complex forecasting...