•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Any point in using a no-code ETL tool to transform excel?
Our take
Transforming Excel data can be streamlined through a no-code ETL tool, which simplifies the process of joining and filtering spreadsheets without the steep learning curve of Power Query. While Power Query offers powerful capabilities, its complexity can be daunting for new users. Exploring a no-code solution may empower you to create efficient workflows that you can run regularly, enhancing your productivity with minimal hassle. If your goal is to simplify your data management, consider testing a no-code tool to see how it fits your needs.
I'm trying to understand whether I should be using a third party tool to do some data transformation to join/filter a few spreadsheets on a regular basis or simply try and learn Power Query (which I don't like to tbh, but maybe that's because I haven't used it enough).
What do you guys think? Should I go all in Power Query for a while, or maybe explore some other tool (no code, preferably) to create a "workflow" and run them from time to time? Have you guys experienced anything similar to this?
[link] [comments]
Read on the original site
Open the publisher's page for the full experience
Related Articles
- Do you use VBA regularly or have you moved entirely to Power Query and formulas?I have been using Excel for years and VBA was always my go to for automation. Lately I have been seeing more people say they barely touch VBA anymore because Power Query and dynamic arrays cover most of what they need. I still use VBA for things like automating reports across multiple files or generating custom email bodies from data. But I am wondering if I am behind the curve. For those of you who work in data heavy roles, what is your current workflow? Do you still use VBA regularly or have you replaced it with other tools? Curious if I should be spending more time learning Power Query and the newer formula features instead of maintaining my VBA skills. submitted by /u/ProfessionalOk4935 [link] [comments]
- Tools for exporting data from PDF to ExcelHi everyone! I started a new job a few weeks ago and a big part of my role involves extracting data from numerous PDFs (e.g., invoice numbers, amounts, total packages, etc.) and entering them into a massive Excel master file. This file acts as a registry and the foundation for other documents. I’m looking for something that saves me from doing 'copy-paste' all day, hundreds of times over. Browsing this group, I noticed some people suggest Power Query for similar tasks, but I’m not familiar with it and would have to learn it from scratch. Does anyone have any tools to recommend, perhaps something more user-friendly than Power Query? submitted by /u/BomboGanoush [link] [comments]
- I’ve been using Excel more lately and I’m trying to understand some of its more advanced features without making everything overly complicatedWhen working with data that has multiple conditions or needs to update automatically, what are the most efficient functions or tools to use? for example, is it better to rely on formulas like XLOOKUP and FILTER, or are there built in tools that handle this more cleanly? Also, how does excel handle performance when formulas start getting longer or more complex? Is there a point where using too many formulas slows things down significantly? What are the best built-in features in Excel for handling complex data in a simple way? submitted by /u/icepix [link] [comments]
- Get more from Power Query in Excel with these little-known capabilitiesIf you use Excel or Power BI to work with data, you’ve likely encountered Power Query - and may already rely on it regularly across desktop and web. It pulls data together, cleans it up, and prepares it for analysis. But beyond those familiar tasks, Power Query includes several capabilities that can make solutions more flexible, scalable, and easier to maintain. Get more from Power Query in Excel with these little-known capabilities submitted by /u/beyphy [link] [comments]