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.
Recently, I spent an hour testing something. I copied data from a PDF into Excel. You might already know what happens when you do that manually: everything from the row jams into one cell. Complete mess. So I opened Copilot in Excel and asked it to split the data for me. It immediately went to formulas. Simple ones first, then increasingly complex combinations. I tested each one. None of them split the values correctly. Here's what I should have done: skipped the manual copy entirely and used...
Someone just joined your team. They got a quick walkthrough from IT. Maybe from you. Now they're staring at a spreadsheet trying not to look lost. You see, there are a few very simple features that would make the life of an Excel newbie a whole lot easier. I cover 8 of them in this video: #1 was shocking when I discovered it. And #7 saved me days when we had to update all our group reporting files after a rebrand. If you already know your way around Excel, be honest: did you know all 8?...
You've built this cool visual using formulas. Dynamic, clean, exactly what the dashboard needs. For example, a waffle chart Now you want to add it to the main dashboard sheet. But there's a problem. If people start clicking around, they might accidentally delete a formula. Or overwrite a cell. And now your carefully crafted visual is broken. You could protect the sheet. Enter password every time you need to make changes. Or you could get creative. Take a snapshot instead. Linked Picture and...