Exploring Excel Power Query And Flash Fill (hands-on)
Tired of cleaning, merging and writing formulas for the data you received? Instead, use Power Query with its Query Editor, a powerful tool for shaping and transforming data so it’s ready for your models and visualizations. Or use Flash Fill to eliminate the RIGHT, LEFT, MID, and CONCATENATE formulas and clean your data in nanoseconds. Working with your data is now easy and quick. Attendees should be competent with Excel already; laptops are required. Preferred installations: Power Query in Microsoft Excel 2013 only. Flash Fill is not a function in Microsoft 2013. Flash Fill is part of Microsoft 2016.