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.
Analysis on another level with the tools you already have
|
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:
Just to name a few. Now, if you mainly use Excel for quick lists or basic calculations, this probably isn't something you'll need right now. But if you're in Excel daily, cleaning data, creating reports, analyzing performance... I'd say Python in Excel is going to open some exciting doors. We've had so many questions about this that I just recorded a YouTube video walking through real use cases and showing where Copilot and AI fit into the real picture. I'll be sharing more next week. And as you probably know, we’ve been working on a new course launching on June 25th: Python in Excel for the Real World. It's designed to answer: What gap does Python fill inside Excel... and when should you use it? More on that next week. 🤓 Geeky News🛜 Power Query goes onlineNot in Excel Online, though, but in Power BI Service. You can now use Power Query in the browser to import and transform data before you model it in Power BI. No Desktop needed. It’s finally possible to manage your entire semantic model end-to-end on the web. Of course, the advantage of the Desktop app is that it doesn't require an account... 🖼️ Compress images on Windows 11Windows 11 now lets you shrink image file size without changing resolution, right from the Share menu. You can choose between Low, Medium, or High compression levels. It works by lowering JPEG quality and creates a separate compressed copy when sharing. Bonus: you can also crop or edit the image before sharing. No need to open Paint or Photos. The new feature is rolling out gradually via the Windows Insider Program. 🎞️ Video trimming in Clipchamp - now even easierClipchamp, Microsoft's freemium video editor, lets you trim videos by editing the transcript. Just generate a transcript, highlight the parts you don’t want, and delete. The video timeline updates automatically. It’s a faster way to clean up meeting recordings, webinars, or podcasts without scrubbing through footage. Rolling out to work accounts in June, with personal accounts coming soon. ⌨️ Did You Know?Python in Excel introduced me to some handy shortcuts - beyond just the Python-specific ones. You probably know F2 puts you in edit mode (saves you that double-click). But if your formula’s getting cramped, you don’t need your mouse to jump to the formula bar: Ctrl + F2 lets you switch between typing in the cell and the formula bar. And when your formula starts spilling over multiple lines? Ctrl + Shift + U expands the formula bar for a clearer view. Works for Python cells and regular formulas. Super smooth. 👏 Power StoriesBernie took Automate with Power Query and found exactly what we hoped for: real examples that made things click.
That’s the goal. More clarity, more confidence, and smarter ways to solve real problems. See you next week (sooner than usual, even 😉) Leila P.S. Python in Excel for the Real World is almost here. Expect to hear from me on Wednesday, June 25th. |
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...