Extract previous - I didn't know that one. It could save quite a bit of work. I will have to watch the dependency window more often. It helped you make the differences clear. 👍
@CeliaAlvesSolveExcel
2 жыл бұрын
Thank you, Gráinne! I am glad you found value in the tutorial. ;-)
@GrainneDuggan_Excel
2 жыл бұрын
@@CeliaAlvesSolveExcel always do Celia
@martyc5674
2 жыл бұрын
Extract previous is new to me too 👍.. what I have used though is “copy” the query from the connections pane and pasted into new workbooks - that saves a pile of time if your source and clean strategy are going yo be the same in several files up to a point.
@CeliaAlvesSolveExcel
2 жыл бұрын
That's awesome, Martin! Glad that it helped. Yes, I also like to copy and paste queries from one file to another. :)
@notesfromleisa-land
Жыл бұрын
Wonderful presentation. I can immediately use the reference which is better than duplicate for my purpose. Now I know better
@CeliaAlvesSolveExcel
Жыл бұрын
Awesome! Glad that I helped. :)
@rpopecpa
Жыл бұрын
Hi Celia, Great video! This is my favorite video that I have seen from you. It is so good that I came back to watch it again. Thanks!!
@CeliaAlvesSolveExcel
Жыл бұрын
Thank you! :) I am glad that you found value in this tutorial. Thank you for your feedback.
@FRANKWHITE1996
Жыл бұрын
Thanks for sharing ❤
@CeliaAlvesSolveExcel
Жыл бұрын
You're welcome, Frank! My pleasure. :)
@wayneedmondson1065
2 жыл бұрын
Hi Celia. As always.. great tips from your channel! Thanks for sharing these time saving techniques :)) Thumbs up!!
@CeliaAlvesSolveExcel
2 жыл бұрын
Thank you, Wayne! Thank you also for always watching my videos and providing feedback. :)
@wayneedmondson1065
2 жыл бұрын
@@CeliaAlvesSolveExcel My pleasure! Thanks for so generously sharing your knowledge and insights!!
@uniearesende
2 жыл бұрын
Thanks. practical and inteligent
@CeliaAlvesSolveExcel
2 жыл бұрын
Glad you found the lesson valuable. :)
@Fruition10
2 жыл бұрын
Omg. Thank you.
@wisecatnoroboris
2 жыл бұрын
Thank you for this video
@CeliaAlvesSolveExcel
2 жыл бұрын
You're welcome, @Boris Noro! :)
@wisecatnoroboris
Жыл бұрын
@@CeliaAlvesSolveExcel haha i m watching it again one year later ^^
@CeliaAlvesSolveExcel
Жыл бұрын
@@wisecatnoroboris hey, Boris! Anytime you want! It is free and available 24/7! 😁 I am glad that you found it helpful.
@pardawala_Bhiwandi
2 жыл бұрын
This is very uses full
@CeliaAlvesSolveExcel
2 жыл бұрын
Hi, Santu. Thank you. Yes, you can use these features in many different scenarios.
@txreal2
2 жыл бұрын
Thanks for answering my question. You got a Subscriber. I also appreciate you providing several solutions with duplicate query, reference query, Extract Previous, and Delete Until End, and Query Dependencies (need to verify with this more often). From your expertise, if I want to routinely clean data with 400K rows or less (TRIM, CLEAN, data type, PROPER, and remove duplicates), SHOULD I use an Advanced Editor script (like VBA) with a little editing? Or open an existing query and change source in settings (don't have to add comma & change source of 2nd line)?
@CeliaAlvesSolveExcel
2 жыл бұрын
Glad that you found the tutorial helpful. I am not sure I follow your question. Is it always the same file, only with new/ updated data?
@txreal2
2 жыл бұрын
@@CeliaAlvesSolveExcel Yes, new file with updated data with same column names.
@CeliaAlvesSolveExcel
2 жыл бұрын
@@txreal2 from an Excel file create a query to that file with the data. Power Query does all that mentioned to clean the data. Save the query and load the data to the Excel file. Next time you have new data, replace the data file and in the Excel file with the query, hit refresh. That's it!
@tlee7028
2 жыл бұрын
Thank you!
@CeliaAlvesSolveExcel
2 жыл бұрын
You're welcome! :)
@txreal2
Жыл бұрын
Does it matter (connection & speed, 100K rows x 20 columns mainly Transactions numerical data) if I put Power Query table in a different workbook from the original data? If it does NOT affect speed that much, I can reuse the PQ table and point to a different data source. Thanks (Windows 10 x64, i7, 32GB RAM, OneDrive for Business)
@CeliaAlvesSolveExcel
Жыл бұрын
I am not sure how performance compares when we connect to a separate workbook versus getting the data from the current workbook. I expect that connecting to the current workbook is faster, then connecting to another workbook, specially when it is saved to OneDrive or SharePoint. But there are many other factors that will contribute to the query performance. Some examples are: - data source file type: importing data from a CSV file is faster than importing the same data from an Excel file. - columns data type: whole number requires less memory than currency data type. Currency takes less memory than decimal data type. Text data type requires more memory than the previous ones. - torres of transformations used in the query: some transformations require more time to process. Merging and Sorting are two of those transformations. I hope this helps.
@txreal2
Жыл бұрын
@@CeliaAlvesSolveExcel Thanks!
@lilyfullery4779
Жыл бұрын
Hi Celia, please tell us , what to do in same situation as u have shown in the video , but if their is more than 100 sheets
@CeliaAlvesSolveExcel
Жыл бұрын
Hi, Lily. I'm afraid you'll have to be more specific about your scenario. first thought, I don't understand your question in the context of this video.
@AnnaM77777
2 жыл бұрын
I have loaded a data set and applied over 20 steps to clean the data into a usable format. Every month I will receive a new raw data set that these same cleaning steps will need to be applied to. How do I save the query steps and apply them to a new data set. Eg. I will have to load a difference set of data and then clean it. I don't want multiple queries in the same file as they will need to be converted to their own set of pivot tables for each individual client.
@tubeampsrule1
Жыл бұрын
you can connect to the source data from a specific folder that'll do it or, my preference, just copy the queries themselves into a new file.
@krishnamanjunatha6183
2 жыл бұрын
unable to download exercise files
@CeliaAlvesSolveExcel
2 жыл бұрын
Did you register on the Telegram channel?
@krishnamanjunatha6183
2 жыл бұрын
@@CeliaAlvesSolveExcel page is not loading
@CeliaAlvesSolveExcel
2 жыл бұрын
@@krishnamanjunatha6183 sorry to hear that. Can you please maybe try another browser? It seems to be working well on my end: t.me/celiaalvessolveexcel
Пікірлер: 40