September 22 - 25, 2019 | New Orleans, Louisiana

Exploring Excel Power Query And Flash Fill

Sep 24 2019
11:00 am - 12:15 pm

Exploring Excel Power Query And Flash Fill

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.

© Diversified Communications. All rights reserved.