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 don’t need formulas to clean data
|
You know that feeling... …when someone sends you a DM and says, “Can you make a report out of this?” Empty rows. Inconsistent formats. Oh, and it's not in a pretty table. Plus you have values scattered across 17 different files. Of course. 🙃 No need to panic. You just need Power Query. You might be reading this and nodding because you already use Power Query. You know it's a lifesaver for: ✅ cleaning messy data ✅ combining files ✅ transforming dates, text, numbers - all without formulas! Plus it's super intuitive. Mostly click, click, click. In case you're not familiar with Power Query or just want a quick refresher, I made a very comprehensive beginner-friendly video. I cover all the three scenarios above. PQ is one of those things that, once you learn it, you wonder how you ever worked without it. Yep. Let Power Query do the boring stuff. You focus on the fun bits - like the actual analysis, dashboards… and coffee breaks ☕😉 Go deeper: Master Power QueryYou’ve seen what it can do. That’s just the surface. In our Master Excel Power Query course, you'll go from beginner to Pro, one hands-on lesson at a time. The wins range from saving hours (even days) of work... To becoming the go-to person for difficult data problems... To getting promotions and even "infecting" others like Julia shared: The biggest win for me is getting to share my new knowledge with my colleagues. Since starting the course there have been so many situations where I saw someone struggling to do something in Excel and could go "Let me help you with that." Most people were really relieved when I told them "Don't worry about how I did that; all you need to do is click refresh", but I also managed to 'infect' a few people with my new obsession and got them to learning too. It's our best-selling course for a reason. Power Query doesn't just transform your data. It upgrades the way you work. 🤓 Geeky News🕸️ Power Query in Excel for the Web gets betterNo, still no full data import in Excel Online 🙁 (we're waiting too! Last we heard, it is coming). Until now, you could only refresh anonymous data sources (local files, websites) on the web. Now, they've added the ability to refresh authenticated sources (SharePoint, SQL databases, APIs) as well. We like seeing movement there and hoping for full PQ support in Excel for the Web soon. Especially now, with Python relying on Power Query to bring over data. 🤖 ChatGPT Agent can run your computer for youOpenAI introduced a new agent that goes beyond chat. It can schedule meetings, prep research, even order lunch for you. You can kick off a task and come back to it later. It asks for permission before making any irreversible changes. (For now... 👀) Now rolling out to Pro, Plus, and Team users. Just type 🤔 Did You Know?There's a shortcut to quickly launch Power Query Editor: Alt + F12 Not a one-hander (unless you have a truly impressive hand span 🖖) but it saves you the extra clicks if you close the Queries & Connections pane. 👏 Take breaks. Keep building. Repeat.Shoutout to Liliya for completing Master Excel Power Query (Beginner to Pro)! Welcome to the Pro ranks! 🎊 Now that's a deserved summer break! Follow her advice: Don’t rush it. You’ve got lifetime access. Power Query builds on itself. The more you explore, the more confident you get. And yes, treat yourself after each section. Small wins = big motivation. Been there myself. Starting is difficult. Once you start it gets easier. But life happens and sticking with it can get hard. No need to force it. Take it one lesson at a time. Enjoy your holidays and 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...