Sub-Total: $0.00
Leveraging the Advanced Editor in Power Query to share cleaning routines
Learn how to share and reuse your data cleaning routines with the Advanced Editor in Power Query. Cleaning data in Excel is essential, but repeating the same steps across multiple files or platforms can be tedious. In this Data Survival Skills session, Robin demonstrates how to capture your cleaning steps in the Advanced Editor, copy the M code, and reuse it in other Excel files or even in Power BI. By highlighting and saving your transformations, you can quickly replicate data prep, maintain consistency, and streamline workflows. This technique goes beyond manual cleaning—giving you a reliable way to standardize data preparation and share processes across teams. The result: a repeatable, flexible system that turns one-time cleaning into reusable, trustworthy routines.
#PowerQuery #AdvancedEditor #MCode #DataCleaning #DataPreparation #Excel #PowerBI #BusinessIntelligence #DataWorkflow #ProcessAutomation
If you’re a data analyst, you’ve no doubt learned different skills, techniques, and tools pertaining to data. But sometimes it can be difficult to know when and why to apply these tools. In this weekly series, instructor Robin Hunt explains a new skill, secret, tip, technique, best practice, or golden piece of advice in each installment. Robin covers topics that can help you do your job better, such as joining data and data designs, privacy for data, transforming and cleaning data, and making data sets and visualizing data.
Note: Because this is an ongoing series, viewers will not receive a certificate of completion.