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.
A German Controller Magazine recently said certain time series analysis techniques are "not realistically feasible with Excel." I read that and thought: challenge accepted. So that's what I opened with at the Global Excel Summit in London on Tuesday this past week. Three techniques. Python's data science libraries. Done right inside Excel, live on stage. (And no, the cape on the table isn’t mine. IYKYK) Because Python is in Excel now. The limits people keep assuming are there... a lot of them...
Some tasks shouldn't still exist in 2026. Manually emailing PDF reports at end of month is one of them... but they do. Here's the drill: Open Excel. Save a few sheets as PDF. Email to Manager A. Save others as PDF. Email to Manager B. Repeat. I used to have a VBA macro that did that for me. It was great. Until companies started blocking macros. Until Excel Online became a thing. Now there's a solution built into Excel that works on desktop and the web. You decide who gets which sheets. The...
There's a person on almost every team that everyone respects technically. And nobody wants to work with. Maybe you've sat in a meeting with them and left feeling a little smaller than when you walked in. Early in my career, I think I was sometimes that person. You see, I went by the advice "work hard and you'll be noticed" for years. Turned out to be the worst advice I ever got. What I missed for a long time: doing my job well was expected. That's why I was hired. But it wasn't what was going...